DSXchange

Posted: **Mon Nov 30, 2015 2:29 pm**

Hi all,

Would appreciate your expert advice on one of the issue I am facing.

While loading oracle table using oraoci stage I am getting the below error message in
DEV environment:(NLS not installed)
Error:
At row "ROW NUMBER" , link "LINK_NAME"
Inserted value too large for column, row rejected

(It does not give me any field name)

PROD environment: (NLS installed)
Error:
ORA-12899: value too large for column
FIELD NAME(actual: 11, maximun :10)

I know there is an issue but could not pinpoint where the issue exactly might be, could it be on the database side or on the datastage side. Will appreciate your help in troubleshooting the issue.

ORACLE version 11g running on both dev and prod environments.

Thanks,
gp

Posted: **Mon Nov 30, 2015 4:11 pm**

I'll skip the part where I shake a finger at the admin about not putting NLS in dev. Stuff happens...

Look at the metadata on that table you are extracting/loading in DEV and compare to PROD.

My guess is that the column definitions may differ.

Is this a job with RCP in it?

DSXchange

Error message diff between dev and prod environment

Error message diff between dev and prod environment