Error when converting column overflows decimal datatype

deesh · Post by **deesh** » Wed Apr 09, 2014 6:10 am

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)

anbu · Post by **anbu** » Wed Apr 09, 2014 6:48 am

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

deesh · Post by **deesh** » Wed Apr 09, 2014 6:51 am

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.

anbu · Post by **anbu** » Wed Apr 09, 2014 7:09 am

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

deesh · Post by **deesh** » Wed Apr 09, 2014 7:17 am

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

anbu · Post by **anbu** » Wed Apr 09, 2014 7:27 am

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

deesh · Post by **deesh** » Wed Apr 09, 2014 7:40 am

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

anbu · Post by **anbu** » Wed Apr 09, 2014 7:51 am

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