Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

CURRENT SQLID(*PRIOR FAILURE*) during 7.1.8 db2zos install

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.
 

Published August 31, 2015 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us