Page 1 of 1
metadata mismatch while extracting double datatype oracle
Posted: Sat Apr 03, 2010 9:07 am
by Jagan617
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
Posted: Sat Apr 03, 2010 2:10 pm
by chulett
Post the actual error message.
Posted: Sat Apr 03, 2010 3:25 pm
by ray.wurlod
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?
Posted: Sat Apr 03, 2010 7:52 pm
by Jagan617
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