DSXchange

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)

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.

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

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.

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

How was the metadata imported

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

Help us to help you. Answer our questions.

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

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

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

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.

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

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

How did you define the column in DataStage?

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