IBM Support

DOM CDT java.lang.UnsupportedOperationException while deploying custom table which has multilingual characters sets.

Troubleshooting


Problem

DOM CDT java.lang.UnsupportedOperationException while deploying custom table which has multilingual characters sets.

Symptom

Problem Statement

java.lang.UnsupportedOperationException while deploying custom table which has multilingual characters sets

Running CDT and including the cdt_custom.xml MAIL_MAPPING file caused this because there are a lot different characters on this table.
Workaround was suggested as exporting the MAIL_MAPPING and then importing it until we found the root cause.

Error Message

java.lang.UnsupportedOperationException

<Errors>
<Error ErrorCode="YFC0003"
;
<Attribute Name="ErrorCode" Value="YFC0003"/>
<Attribute Name="ErrorDescription" Value="[CSCR2PMDS006\R2P]String or binary data would be truncated.">
<Attribute Name="SQLStatement" Value="INSERT INTO EMAIL_MAPPING/>

Resolving The Problem

SQL server database throws the error "String or binary data would be truncated", when the value being inserted in a column is larger than the column capacity. Verified the size of the columns of the custom table EMAIL_MAPPING because the data which is being inserted into this column is more than 4000 characters.

By increasing the text size to 5000 (Message text size was in fact set to 2000 in DB_Extns.xml and not 4000).

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Extensions","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Adapters","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

NFX5926

Product Synonym

[<p><b>]Function Area[</b><p>];CDT;[<p><b>]Severity[</b><p>];Normal

Document Information

Modified date:
16 June 2018

UID

swg21554060