DSXchange

Hi,

Please some one tell to me how to solve below error issue.

Same job running fine in 8.5, but giving error in 9.1.2

I know this is conversion issue, but not getting the exact solvation idea.

The OCI function OCIStmtFetch2 returned status -1. Error code: 1,457, Error message: ORA-01457: converting column overflows decimal datatype. (CC_OraStatement::fetch, file CC_OraStatement.cpp, line 1,599)

Use Decimaltodecimal() to convert precision and scale to match column datatype on your target database

giving error at oracle connector stage, it is the source stage

Moreover working fine in 8.5 with oracle enterprise, after migrate to 9.1.2 it is giving error with oracle connector.

Change precision and scale on source connector stage to match column datatype on database

same datatype same data using for 8.5 even, but no fail in that, why only in 9.1.2 while extracting the data.

DS 9.1 is lot stricter on datatype. If your metadata in the job doesn't match your table then you will get these errors

ok, in this case how to identify the field which one is giving interruption among 20 decimal fields

Either verify it manually for all columns or import metadata through Orchestrate Schema definitions and reload metadata on source stage