Support Article
SQL Error while upgrading to Pega Platform 8.4
SA-105715
Summary
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]
[java]
[java] Encountered database error attempting to load UDF library onto DB2, clean schema before running again.
[java]
[java]
[java] Exception in thread "main" com.m.db2.jcc.am.SqlDataException: 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.
Resolution
Perform the following local-change:
- Bypass the UDF installation.
- Complete the upgrade.
- Rectify the Permission such that it is correct.
- Install the UDFs separately.
Published April 14, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.