Support Article

Error on UDF installation for first time

SA-32794

Summary



 UDF installation.System fails with the following errors
 

Error Messages



[java] WARNING: Encountered a database problem when attempting to load jar
onto DB2: DB2 SQL Error: SQLCODE=-471, SQLSTATE=55023, SQLERRMC= ;00E79008, DRIV
ER=4.15.82
[java] com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-471, SQLSTA
TE=55023, SQLERRMC= ;00E79008, DRIVER=4.15.82
[java] at com.ibm.db2.jcc.am.fd.a(fd.java:701)
[java] at com.ibm.db2.jcc.am.fd.a(fd.java:60)
[java] at com.ibm.db2.jcc.am.fd.a(fd.java:127)
[java] at com.ibm.db2.jcc.am.po.b(po.java:2412)
[java] at com.ibm.db2.jcc.am.po.c(po.java:2395)
[java] at com.ibm.db2.jcc.t4.ab.l(ab.java:370)
[java] at com.ibm.db2.jcc.t4.ab.f(ab.java:98)
[java] at com.ibm.db2.jcc.t4.p.e(p.java:81)
[java] at com.ibm.db2.jcc.t4.qb.k(qb.java:160)
[java] at com.ibm.db2.jcc.am.po.lb(po.java:2361)
[java] at com.ibm.db2.jcc.am.qo.b(qo.java:4530)
[java] at com.ibm.db2.jcc.am.CallableStatement.kc(CallableStatement.jav
a:123)
[java] at com.ibm.db2.jcc.am.CallableStatement.execute(CallableStatemen
t.java:97)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.loadJarIntoD
B2(DatabaseLibraryLoader.java:813)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.installJarOn
DB2(DatabaseLibraryLoader.java:422)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.main(Databas
eLibraryLoader.java:209)
[java]
[java] Jan 12, 2017 3:00:38 PM com.pega.pegarules.install.DatabaseLibraryLo
ader writeMessage
[java] INFO:
[java] 
[java]
[java] Encountered database error attempting to load UDF library onto DB2,
clean schema before running again.
[java]
[java]

BUILD FAILED
C:\PRPC_7.1.6\scripts\setupDatabase.xml:1378: The following error occurred while
executing this line:
C:\PRPC_7.1.6\scripts\setupUDF.xml:66: Java returned: 1

Total time: 44 seconds
Exiting with Error


Steps to Reproduce

  1. Update properties file.
  2. Update WLM value.
  3. Run generateUDF.bat script.


Root Cause



An issue in the custom application code or rules The database was not zOS.


Resolution



Perform the following local-change:

Edit the setupDatabase.propertieds as instructed in the Installation guide and the file for DB2 UDB LUW

 

Published January 23, 2017

Have a question? Get answers now.

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