Service Manager / Service Center Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Caracter set problem between SM9.30 and Oracle

Highlighted
Frequent Advisor

Caracter set problem between SM9.30 and Oracle

[ Edited ]

Hi,

We have a problem with several truncated error.

We think it's due to caracter set but the caracter set seem ok.

 

Previously in SC, SC only supported ISO caracter set. We use few accents (à, è,é ,...) sometime, this caused few problem in SC. Those special caracter count as 2 char in SC but 1 char in Oracle causing a small mismatch. A small warning appeared. No big deal.

 

Those mismatch seem to still occur in SM and this should not be the case with a caracter set UTF-8 or 16.

 

In sm.ini, language is set to utf-8 but seem to ignore it (language:utf-8)

 

In SM log, I can see AL16UTF16 VS UTF16. I don't think there is a problem here.

 16514( 16659) 08/08/2013 10:28:13  RTE I Oracle server settings for language, territory and character set: AMERICAN_AMERICA.WE8ISO8859P1 (AL16UTF16)
 16514( 16659) 08/08/2013 10:28:13  RTE I OCI Client settings for language, territory and character set: AMERICAN_AMERICA.AL32UTF8 (UTF16)

 

And for the truncate error, the message become this in SM:

API=OCIStmtExecute [in sqociSelect], Statement=SELECT * FROM ocmom1 WHERE "NUMBERPRGN"=:Y (display,show.rio)
SQL code=1406 message=ORA-01406: fetched column value was truncated  (display,show.rio)
API=OCIStmtFetch [in sqociSelectSome], Statement=SELECT * FROM ocmom1 WHERE "NUMBERPRGN" IN (:Y,:Y,:Y,:Y)  (display,show.rio)
SQL code=1406 message=ORA-01406: fetched column value was truncated  (display,show.rio)
API=OCIStmtExecute [in sqociSelect], Statement=SELECT * FROM ocmom1 WHERE "NUMBERPRGN"=:Y (format.cque,calc.queries.2.select)
SQL code=1406 message=ORA-01406: fetched column value was truncated  (format.cque,calc.queries.2.select)
API=OCIStmtExecute [in sqociSelect], Statement=SELECT * FROM ocmom1 WHERE "NUMBERPRGN"=:Y (format.cque,calc.queries.2.select)
SQL code=1406 message=ORA-01406: fetched column value was truncated  (format.cque,calc.queries.2.select)

 

No way to figure out what record or which fields are wrong.

We also get those error on any VJ files linked... so it's become really hard to just debug or fix mismatch fields in the data.

 

Did someone have an idea how to fix this?

 

Thank you,

2 REPLIES
Advisor

Re: Caracter set problem between SM9.30 and Oracle

were you ever able to get resolution to this?  i am seeing the same issue.  thanks.

HPE Expert

Re: Caracter set problem between SM9.30 and Oracle

Hi

 

Can you post part of your log  that seeing the error in ?

 

Thank you

 

 

"HP Support
If you find that this post or any post resolves your issue, please make sure to mark it as an accepted solution."