Page 1 of 1
U_TRUNCATED_CHAR_FOUND Oracle Load
Posted: Thu Mar 13, 2008 10:03 am
by pavankvk
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?
Posted: Thu Mar 13, 2008 3:14 pm
by kumar_s
Check for the input data, if you have any string, whose length is more than the specified metadata.
Posted: Thu Mar 13, 2008 5:01 pm
by pavankvk
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?
Posted: Thu Mar 13, 2008 5:30 pm
by kumar_s
But the metedata of the target table could be different from the Metedata specified Datastage.
Posted: Thu Mar 13, 2008 5:36 pm
by pavankvk
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.
Posted: Thu Mar 13, 2008 5:47 pm
by kumar_s
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?
Posted: Thu Mar 13, 2008 6:01 pm
by pavankvk
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
Posted: Thu Mar 13, 2008 6:02 pm
by kumar_s
Dsxchange helps you. And so you got to help Dsxchange by paying Membership fee.
Posted: Thu Mar 13, 2008 6:11 pm
by pavankvk
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
Posted: Thu Mar 13, 2008 6:12 pm
by pavankvk
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