Support Article
Upgrade database error DB2 linux
SA-100239
Summary
PRPC 6.3 upgrade to Pega Platform 8.1.7 fails with an error.
Error Messages
_callDDLUtilityUpgrade:
[echo] Call DDL Generation Upgrade Utility...
[echo] /home/pega/116577_Pega8.17/scripts/lib/xercesImpl.jar;/home/pega/116577_Pega8.17/scripts/lib/xml-apis.jar;/home/pega/116577_Pega8.17/scripts/lib/resolver.jar;
[echo] archive_dir: /home/pega/116577_Pega8.17/scripts/lib
[java] (install) INFO - Initializing properties with default values
[java] (install) INFO - Setting default Entity Value for pega_enable_nologging = true
[java] (install) INFO - Getting database metadata
[java] Exception in thread "main" java.lang.RuntimeException: Error during execution of upgrade on platform udb using schemas PEGAPRD, PEGAPRD, PEGAPRD
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1580)
[java] Caused by: com.pega.pegarules.data.ddl.DatabaseException: com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][4.19.66] Caught java.io.CharConversionException. ERRORCODE=-4220, SQLSTATE=null
[java] at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:439)
[java] at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:480)
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.saveCurrentSchemaState(SchemaGenerator.java:496)
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1395)
[java] Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][4.19.66] Caught java.io.CharConversionException. ERRORCODE=-4220, SQLSTATE=null
[java] at com.ibm.db2.jcc.am.kd.a(kd.java:731)
[java] at com.ibm.db2.jcc.am.kd.a(kd.java:66)
[java] at com.ibm.db2.jcc.am.kd.a(kd.java:120)
[java] at com.ibm.db2.jcc.am.mc.a(mc.java:2960)
[java] at com.ibm.db2.jcc.am.mc.p(mc.java:574)
[java] at com.ibm.db2.jcc.am.mc.P(mc.java:1656)
[java] at com.ibm.db2.jcc.am.ResultSet.getStringX(ResultSet.java:1214)
[java] at com.ibm.db2.jcc.am.ResultSet.getString(ResultSet.java:1183)
[java] at com.ibm.db2.jcc.am.ResultSet.getString(ResultSet.java:1773)
[java] at com.pega.pegarules.data.ddl.JDBCIntrospector.readColumnsForTable(JDBCIntrospector.java:770)
[java] at com.pega.pegarules.data.ddl.JDBCIntrospector.readTables(JDBCIntrospector.java:1467)
[java] at com.pega.pegarules.data.ddl.JDBCIntrospector.createDatabaseJaxbObjectByIntrospection(JDBCIntrospector.java:110)
[java] at com.pega.pegarules.data.ddl.SchemaManager.createDomDocumentFromDbIntrospection(SchemaManager.java:2039)
[java] at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:435)
[java] ... 3 more
[java] Caused by: java.nio.charset.MalformedInputException: Input length = 1
[java] at java.nio.charset.CoderResult.throwException(CoderResult.java:292)
[java] at com.ibm.db2.jcc.am.r.a(r.java:51)
[java] at com.ibm.db2.jcc.am.mc.a(mc.java:2952)
[java] ... 13 more
Steps to Reproduce
Upgrade PRPC 6.3 to Pega Platform 8.1.7.
Root Cause
A third-party product issue.
The table in the PegaDATA schema was corrupt.
Resolution
Make the following change to the operating environment:
Drop the table. The Generate DDL step completes.
Published February 10, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.