XMLReader

[leifabak]

Hi,

I am using the XmlReader stage to load data into an oracle 9.0.2 database. This works just fine when the files are less than 110 Mb in size. When the files get larger DataStage aborts with no proper error message. Anyone with the same experience and hopefully a solution to this problem?

regards
Leif-Arne Bakker

[1stpoint]

This sounds like a Memory Leak issue. You should open a case with support and they can walk you through the debugging process. If you're on unix you might want to do a ps -aux while the job is running and watch the process memory to see if it is causing the job to crash.

[rwierdsm]

Hi,

I am using the XmlReader stage to load data into an oracle 9.0.2 database. This works just fine when the files are less than 110 Mb in size. When the files get larger DataStage aborts with no proper error message. Anyone with the same experience and hopefully a solution to this problem?

regards
Leif-Arne Bakker

The recommendation we had from Ascential support on this problem was to split the processing into two jobs. The first job reads the XML into a sequential file, the second processes the sequential file. All our XML reads are done this way now.
For some reason (memory leak as suggested above?) if the XML reader has to pause to do lookups, write to DB, etc, memory gets swapped out ( or whatever!) and the reader gets unhappy.

Regards,
Rob Wierdsma