Unable to extract XML column from database

[divya_ascential]

Hi all

I need to do a job which extract a col(which is and XML column of length > 72000) from a table and place it in a sequential file.
There are more than 35000 records in that table.

The job structure is:

ODBC stage -> Transformer stage -> Seq File stage

The issue is the job gets aborted after getting 4000 records.
giving a single warning:
Abnormal termination of stage Sample_Job..Transformer_Sample detected
i.e. the transformer stage.

So i tried using rowcount as 4000 in the query at input ODBC stage, yes...then all the 4000 are extracted.

i have checked the 4001st record its all fine.
I guess the issue with the size.

Plz suggest any possible solution..

Thanks
Divya

[Kirtikumar]

Is this the only message or are you getting any more warnins messages or info in the logs pertaining to this?

Try the following while extracting, run the job in sequntial mode, and sort the data while extracting.
Then check the message at which row number the job is aborting. Export the data from the table to sequntial file again in the order of the column. For the row which is causing the job to abort, check for any special characters. In unix, the command to check the special chars is cat -v. I do not know the equ windows command.