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
- Update properties file.
- Update WLM value.
- 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 24, 2017 - 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.