ORA-24806: LOB form mismatch

Gen1715 · Post by **Gen1715** » Tue Jun 11, 2013 6:50 am

Hi Gurus,

Apologies to reopen the resolved topic.

My issue is very relavant to this topic - I have created a job which is having one CLOB column and using two oracle connector stage,
Properties
datatype - LongNVarChar for CLOB column in DS
Enable LOB reference - Yes
CLOB Column is in last in select clause and defined in last in Column defination.

Oracle Connector ----> Oracle Connector

When I am executing the job getting following error -

TABLE_XYZ,0: The OCI function OCILobRead returned status -1. Error code: 24,806, Error message: ORA-24806: LOB form mismatch. (CC_OraInputStream::read, file CC_OraInputStream.cpp, line 681)

My reasoning says - for Oracle and DS is having different character sets.
Can there be any other possibilities.

chulett · Post by **chulett** » Tue Jun 11, 2013 6:59 am

Don't apologize, just don't do it.

Split to your own topic.

Gen1715 · Post by **Gen1715** » Tue Jun 11, 2013 7:02 am

Thanks for doing that.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 11, 2013 2:29 pm

This is an Oracle error (-24806), not a DataStage error. The error is generated from stage TABLE_XYZ, so you can tell from that whether it's the source or target.

Gen1715 · Post by **Gen1715** » Wed Jun 12, 2013 9:39 pm

Hi Ray,

It is Source end problem. (Used Oracle Connector to read from Oracle)

When select sql is executed in Oracle, it executes properly and provides valid output, now when I try to do view data for Oracle Connector stage in DataStage, it gives error - LOB form mismatch.

I removed LOB column from select clause and column definition and tried view data from Oracle connector again, It was working.

Now I checked in oracle NLS_CHARACTER_SET it is WE8ISO8859P1.
and NLS support is not installed in DataStage.

Please let me know, Should I need to look into NLS settings or if you think otherwise.

chulett · Post by **chulett** » Wed Jun 12, 2013 9:59 pm

ORA-24806: LOB form mismatch

Cause: When reading from or writing into LOBs, the character set form of the user buffer should be same as that of the LOB.

Action: Make sure that the buffer you are using to read or write has the same form as that of the LOB.

I'm assuming "the user buffer" is essentially DataStage but without having NLS installed I'm not sure what the resolution for this might be...

Gen1715 · Post by **Gen1715** » Thu Jun 13, 2013 4:51 am

Thanks Craig for looking into, If I understood correct, you are implying that the issue is with DataStage NLS and need to reinstall DS with NLS reinstalled.

One thing I know is that - DS used NLS setting defined at Unix level in case there is no NLS defined at Project level.
Now, does this require NLS to be installed at time of DS installation or in else case as well above statement is true.

O

chulett · Post by **chulett** » Thu Jun 13, 2013 7:12 am

Gen1715 wrote:Thanks Craig for looking into, If I understood correct, you are implying that the issue is with DataStage NLS and need to reinstall DS with NLS reinstalled.

Well... I was specifically trying to not imply that need as basically I don't know if that is the solution. And yes that choice to 'install with NLS' needs to be done at installation time. Hoping someone else chimes in or that you open a case with your official support provider to find out for certain what the solution might be.

rsomiset · Post by **rsomiset** » Thu Jun 13, 2013 10:06 am

Gaurav,
Did you try viewing the data by defining it as either LONGVARCHAR? If not...Could you please try and let us know?

Gen1715 · Post by **Gen1715** » Mon Jun 17, 2013 9:13 am

It is not working for me.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 17, 2013 4:36 pm

"Unemployment" is "not working". Please clarify what you are expecting to happen and what is actually happening. Provide details of any error messages where relevant.

Gen1715 · Post by **Gen1715** » Wed Jun 19, 2013 5:48 am

Ray,

I was responding to rsomiset's suggestion that - with LONGVARCHAR as well I'm not able to view data in datastage. it is having same error -

Error code: 24,806, Error message: ORA-24806: LOB form mismatch. (CC_OraInputStream::read, file CC_OraInputStream.cpp, line 681)

ray.wurlod · Post by **ray.wurlod** » Wed Jun 19, 2013 5:24 pm

Do you get any useful advise from the command oerr -24806 ?

Gen1715 · Post by **Gen1715** » Sat Jul 20, 2013 4:51 am

This is an IBM program error.
Please refer - http://www-01.ibm.com/support/docview.w ... wg1JR43945