IBM Support

Encountering the java.sql.SQLException: ORA-17056 when upgrading IBM Business Automation Workflow

Troubleshooting


Problem

Referring to instruction to upgrade database during IBM Business Automation Workflow upgrade procedure, the DBUpgrade command failed with java.sql.SQLException.

Symptom

You can see the error in logs when you execute DBUpgrade.sh.

00000001 SEVERE: com.lombardisoftware.tools.dbupgrade.utils.RetrieveTransactions.handleError - SQL statement that failed: select transactionid from dbupgrade_progress

 00000001 FINE: com.lombardisoftware.tools.dbupgrade.utils.RetrieveTransactions.handleError - ORA-17056:  ): KO16MSWIN949

https://docs.oracle.com/error-help/db/ora-17056/

java.sql.SQLException: ORA-17056:  orai18n.jar ): KO16MSWIN949

ORA-17056 is non supported character set .

The translation of this error is that the jar file referenced orai18n.jar referenced needs to be added to the classpath.

..

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"ARM Category":[{"code":"a8m50000000CcbhAAC","label":"Install and Deployment Environments-\u003EDB related-\u003Edatasource \u0026 driver"}],"ARM Case Number":"TS016907700","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"21.0.3"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 October 2024

UID

ibm17167034