DSXchange

I am getting the error message : Array size must be set to 1 while reading LOB's.

My job is a generic job which runs on different metadata using schema file.

Job structure is oracle table - transformer - sequential file .

Currently array size is 2000 I changed to 1 and executed, it ran successfully.

Since it is an generic job if we make change it may affect other jobs.

How to handle this situation.

Please give your valuable suggestions.

Keep the generic job as is. Create a separate job for the table with the LOB column(s).

Thank you.

Let me try that possibility

I would change the generic job so that array size is a job parameter. Use a parameter set with a value set for each table so that array size can be set on a per table basis.

Mike

That may work. Just keep in mind the LOB settings in Connector stages. Sometimes you have to name or choose which columns are the LOB columns. It means having separate jobs unless you can parameterize that setting too (haven't tried it).

qt_ky wrote:That may work. Just keep in mind the LOB settings in Connector stages. Sometimes you have to name or choose which columns are the LOB columns. It means having separate jobs unless you can parameterize that setting too (haven't tried it).

It worked ..Thanks a lot.

Thanks mike for this idea ... it worked