Focal Point
[CASE OPENED] DataMigrator XML Extraction issue

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/4797021686

April 12, 2017, 04:40 PM
Rajesh T
[CASE OPENED] DataMigrator XML Extraction issue
I have a table with a column defined as CLOB. This column contain XML data.

I am able to extract this column and parse successfully. But when I do a join with another table while extracting, I am getting following error.

(ICM18440) Request will process data via NON-Pass Through (NON-APT)
(ICM18451) HOLD file will be created for output file named: SQLIN.
(FOC214) NUMBER OF SEGMENTS OR SEGMENTS+INDEXES EXCEEDS THE MAXIMUM:
(FOC214) NUMBER OF SEGMENTS OR SEGMENTS+INDEXES EXCEEDS THE MAXIMUM:
BYPASSING TO END OF COMMAND
(ICM18040) Return Code = 214


Note: XML Synonym contain 16000 elements fields.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs