SQL Error while upgrading to Pega Platform 8.4
When upgrading to Pega Platform 8.4, SqlDataException occurs while running the Upgrade script.
[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" 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.
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:
- Bypass the UDF installation.
- Complete the upgrade.
- Rectify the Permission such that it is correct.
- Install the UDFs separately.
0% found this useful