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

SQL Error while upgrading to Pega Platform 8.4



When upgrading to Pega Platform 8.4, SqlDataException occurs while running the Upgrade script.

Error Messages

     [java] (DB2UDFJarLoader)    INFO - Jar is not already loaded in schema DBRERULES
     [java] (DB2UDFJarLoader)    INFO - Encountered a database problem when attempting to load jar onto DB2: DB2 SQL Error: SQLCODE=-311, SQLSTATE=22501, SQLERRMC=1, DRIVER=4.19.26
     [java] (DB2UDFJarLoader)    INFO - 
     [java] Encountered database error attempting to load UDF library onto DB2, clean schema before running again.
     [java] Exception in thread "main" DB2 SQL Error: SQLCODE=-311, SQLSTATE=22501, SQLERRMC=1, DRIVER=4.19.26

Steps to Reproduce

Upgrade Pega Platform 8.2.1 to Pega Platform 8.4.

Root Cause

The User Defined Function (UDF) Permission error can bypass the UDF installation during the upgrade. After the upgrade, the user can install the UDF through the script.


Perform the following local-change:
  1. Bypass the UDF installation.
  2. Complete the upgrade.
  3. Rectify the Permission such that it is correct.
  4. Install the UDFs separately.

Published April 14, 2020 - Updated December 2, 2021

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