U_TRUNCATED_CHAR_FOUND Oracle Load

pavankvk · Post by **pavankvk** » Thu Mar 13, 2008 10:03 am

Hi,

I am using a Oracle Enterprise Edition Stage with Load/Append option and my jobs are aborting with this specific message

U_TRUNCATED_CHAR_FOUND encountered

My default NLS map is UTF-8

How to fix this error?

kumar_s · Post by **kumar_s** » Thu Mar 13, 2008 3:14 pm

Check for the input data, if you have any string, whose length is more than the specified metadata.

pavankvk · Post by **pavankvk** » Thu Mar 13, 2008 5:01 pm

kumar_s wrote:Check for the input data, if you have any string, whose length is more than the specified metadata. ...

When the dataset reads the data, will it not read according to the metadata length?

if i specify a column as 50, though the input is 100, its supposed to read only 50..so why do you think its a inssue?

kumar_s · Post by **kumar_s** » Thu Mar 13, 2008 5:30 pm

But the metedata of the target table could be different from the Metedata specified Datastage.

pavankvk · Post by **pavankvk** » Thu Mar 13, 2008 5:36 pm

kumar_s wrote:But the metedata of the target table could be different from the Metedata specified Datastage. ...

I verified that,they are the same.

kumar_s · Post by **kumar_s** » Thu Mar 13, 2008 5:47 pm

There is a ecase 92389 already open for this.
"If a partial mutibyte character is at end of string, U_TRUNCATED_CHAR_FOUND
error and string is nulled. Customer requires replacement character and
a warning."
So check you data. Try using Trim.
Is that datatype ustring?

pavankvk · Post by **pavankvk** » Thu Mar 13, 2008 6:01 pm

kumar_s wrote:There is a ecase 92389 already open for this.
"If a partial mutibyte character is at end of string, U_TRUNCATED_CHAR_FOUND
error and string is nulled. Customer requires replacement character and
a ...

Hmm i cant see it.

Since its already a case error and not the knowledge of a premium member,can i see the exact message

kumar_s · Post by **kumar_s** » Thu Mar 13, 2008 6:02 pm

Dsxchange helps you. And so you got to help Dsxchange by paying Membership fee.

pavankvk · Post by **pavankvk** » Thu Mar 13, 2008 6:11 pm

kumar_s wrote:Dsxchange helps you. And so you got to help Dsxchange by paying Membership fee. ...

thanks, i tried taking the membership for 50$, there was some error when i actually tried to pay, after that the fee was hiked.

anyway the datatype is varchar

pavankvk · Post by **pavankvk** » Thu Mar 13, 2008 6:12 pm

kumar_s wrote:Dsxchange helps you. And so you got to help Dsxchange by paying Membership fee. ...

A regular insert worked fine with the same data,but the load fails