Array size must be set to 1 while reading LOB's

aneesh5142 · Post by **aneesh5142** » Mon Oct 06, 2014 5:37 am

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.

qt_ky · Post by **qt_ky** » Mon Oct 06, 2014 6:48 am

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

aneesh5142 · Post by **aneesh5142** » Mon Oct 06, 2014 11:43 pm

Thank you.

Let me try that possibility

Mike · Post by **Mike** » Tue Oct 07, 2014 8:11 am

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

qt_ky · Post by **qt_ky** » Tue Oct 07, 2014 3:21 pm

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).

aneesh5142 · Post by **aneesh5142** » Wed Oct 08, 2014 1:30 am

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.

aneesh5142 · Post by **aneesh5142** » Wed Oct 08, 2014 1:33 am

Thanks mike for this idea ... it worked