metadata mismatch while extracting double datatype oracle

Jagan617 · Post by **Jagan617** » Sat Apr 03, 2010 9:07 am

We have upgraded datastage server 7.5.1a to 7.5.3. while running job which extracts data from oracle with columns defined as double, we were facing the metadata mismatch issue. Its happening for all the jobs which extracts the double datatype columns. Can anybody help in resolving this. Do we need to set user-defined environmental variable at project level? if so please advise what needs to be done to resolve this. I checked the same jobs in 7.5.1a and its working fine. Its throwing issue only in 7.5.3 version

chulett · Post by **chulett** » Sat Apr 03, 2010 2:10 pm

Post the actual error message.

ray.wurlod · Post by **ray.wurlod** » Sat Apr 03, 2010 3:25 pm

And please post the column definition from Oracle describe and the column definition used in DataStage. Have you tried re-importing the table definition to see whether it's the same?

Jagan617 · Post by **Jagan617** » Sat Apr 03, 2010 7:52 pm

column definition from oracle is number and metadata defined in datastage job is double with 15 length. Its working fine in 7.5.1a and it throwing error only when we run the same job in 7.5.3. I tried re-importing as well and no success, it showing same error.

Error: DSD.BCiOpenR results of SQLCOLattributes(column) gave metadata mismatch column.precision expected =15 and actual=53