SA-13377

Summary

While running the installation wizard to install Pega 7.1.8 split schema on db2zos, user is getting the following exceptions and the process is getting terminated abruptly.

Error Messages

[java] Caused by: com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -725, SQLSTATE: 42721, SQLERRMC: CURRENT SQLID(*PRIOR FAILURE*);DB239
[java] at com.ibm.db2.jcc.a.tf.e(tf.java:1680)
[java] at com.ibm.db2.jcc.a.tf.a(tf.java:1239)
[java] at com.ibm.db2.jcc.a.tf.a(tf.java:1225)
[java] at com.ibm.db2.jcc.b.jb.h(jb.java:132)
[java] at com.ibm.db2.jcc.b.jb.a(jb.java:43)
[java] at com.ibm.db2.jcc.b.w.a(w.java:30)
[java] at com.ibm.db2.jcc.b.cc.f(cc.java:161)
[java] at com.ibm.db2.jcc.a.tf.n(tf.java:1219)
[java] at com.ibm.db2.jcc.a.tf.a(tf.java:1958)
[java] at com.ibm.db2.jcc.a.tf.a(tf.java:523)
[java] at com.ibm.db2.jcc.a.tf.executeQuery(tf.java:507)
[java] at com.pega.pegarules.data.internal.access.db2udb.SQLGeneratorDb2.getSchemaName(SQLGeneratorDb2.java:513)
[java] at com.pega.pegarules.data.internal.access.DatabaseInformationMapImpl.lookupDBInfo(DatabaseInformationMapImpl.java:408)
[java] ... 18 more

Steps to Reproduce

Run the installation wizard.

Root Cause

An error or omission in product documentation. The database username on the UI screen or in the setupDatabase.properties file as well as the properties in the DB2SiteDependentProperties file must be in all upper case. 

Resolution

Perform the following local-change: 

1. Change the DBOWNR and DBUSER in the DB2SiteDependentProperties file.
2. Ensure that the username entered on the UI screen is in upper case and then run installation.