Support Article
PRPC 7.1.8 installation fails due to UDF jars
SA-11525
Summary
User is installing Pega 7.1.8 on DB2. Below error is encountered.
Encountered database error attempting to load UDF library onto DB2, clean schema before running again.
Error Messages
[java] Jun 4, 2015 4:06:35 PM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] WARNING: Encountered a database problem when attempting to load jar onto DB2: 1
[java] Throwable occurred: com.ibm.db2.jcc.am.eo: 1
[java] at com.ibm.db2.jcc.am.bd.a(bd.java:668)
[java] at com.ibm.db2.jcc.am.bd.a(bd.java:60)
[java] at com.ibm.db2.jcc.am.bd.a(bd.java:127)
[java] at com.ibm.db2.jcc.am.lm.b(lm.java:2164)
[java] at com.ibm.db2.jcc.am.lm.c(lm.java:2147)
[java] at com.ibm.db2.jcc.t4.db.k(db.java:354)
[java] at com.ibm.db2.jcc.t4.db.e(db.java:96)
[java] at com.ibm.db2.jcc.t4.t.e(t.java:81)
[java] at com.ibm.db2.jcc.t4.sb.k(sb.java:160)
[java] at com.ibm.db2.jcc.am.lm.hb(lm.java:2113)
[java] at com.ibm.db2.jcc.am.mm.b(mm.java:3594)
[java] at com.ibm.db2.jcc.am.nm.Zb(nm.java:113)
[java] at com.ibm.db2.jcc.am.nm.execute(nm.java:96)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.replaceJarOnDB2(DatabaseLibraryLoader.java:1012)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.installJarOnDB2(DatabaseLibraryLoader.java:482)
Steps to Reproduce
Install Pega 7.1.8 on DB2.
Root Cause
The root cause of this problem is in a third-party product. The IBM JVM on AIX has an issue with the UDF jar files.
Resolution
This issue is resolved through the following local-change:
Perform the installation by using command line scripts to load the UDF jar files prior to installation and then bypassing this process during the install itself. This is documented in PDN article: http://pdn.pega.com/node/279611
The property for bypassing is, 'bypass.udf.generation' in the setupDatabase.properties file.
Published July 13, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.