error on Oracle connector stage

ravipuli · Post by **ravipuli** » Mon Jul 23, 2012 8:13 am

Hi,

I have a problem with Oracle connector stage in job when it is reading the data from table. It is given below error please help me to resolve the error.

The OCI function OCIStmtFetch returned status -1. Error code: 1,406, Error message: ORA-01406: fetched column value was truncated. (CC_OraConnection::logOracleNlsSessionParameters, file CC_OraConnection.cpp, line 3,579)

ArndW · Post by **ArndW** » Mon Jul 23, 2012 8:27 am

It would seem that your job definition for one of the columns isn't big enough to fit the actual data. Compare your metadata in the actual table with what you have in the job.

When I see "nls" in the error message I wonder if you might have declared the table with "bytes" rather than "characters" in Oracle. That can cause this type of an error with multibyte characters.

ravipuli · Post by **ravipuli** » Mon Jul 23, 2012 8:41 am

thanks for reply me and can u tell error abut" nls"

ArndW · Post by **ArndW** » Mon Jul 23, 2012 9:11 am

I did explain, but perhaps that part of the message was in the premium content portion. When using NLS there is a difference between string size when the table is defined as character rather than byte sized.

ArndW · Post by **ArndW** » Tue Jul 24, 2012 5:34 am

How many characters have you defined in the string and how many are in the string causing the error message?

nani0907 · Post by **nani0907** » Tue Jul 24, 2012 5:36 am

How was the metadata imported

ravipuli · Post by **ravipuli** » Tue Jul 24, 2012 5:58 am

Stil iam facing same problem. I did what ever you have mentioned.
pls give me reply.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 24, 2012 6:04 am

Help us to help you. Answer our questions.

Otherwise we can only guess, and the answer is likely to be 42.

ravipuli · Post by **ravipuli** » Tue Jul 24, 2012 6:10 am

ok, actualy this error is not showing in perticuler field.I haved cheked data is not lager than datatype

ravipuli · Post by **ravipuli** » Tue Jul 24, 2012 6:36 am

one field having datatype in oracle 2 but data is 88 can it fit ?

chulett · Post by **chulett** » Tue Jul 24, 2012 6:48 am

2 what? 88 what?

You need to be more precise in your questions and replies so people can help you. Does your source table have an unbound number in it? Meaning one like NUMBER rather than NUMBER(15) or any other precision. Does it have a LOB column, like a CLOB or BLOB? Is your database set up with a multibyte characterset? As Arnd notes, the default is typically "byte semantics" in Oracle and thus a VARCHAR2(5) field holds five bytes rather than five characters. These can all cause that error.

If you are unsure about any of the answers, check with your DBA.

ravipuli · Post by **ravipuli** » Tue Jul 24, 2012 7:09 am

ok,Thank you very much for yours concerns. Iwill check with my DBA

ravipuli · Post by **ravipuli** » Tue Jul 24, 2012 7:13 am

Yes Creig one field having NUMBER rather than NUMBER(15) in my database

chulett · Post by **chulett** » Tue Jul 24, 2012 7:15 am

How did you define the column in DataStage?

ravipuli · Post by **ravipuli** » Tue Jul 24, 2012 7:19 am

Decimal (10) but ,Ihave given this somany days ago at that time thre is no errors are there yesturday onwonds only error is giving.