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

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

 

Suggest Edit

Published January 24, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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