Support Article
Upgrade issues: SQLCODE=-551, SQLSTATE=42501
SA-2051
Summary
When doing a split schema upgrade from PRPC 5.3 to Pega 7.1.5, the data portion of the upgrade is failing with the below message :
[java] WARNING: Encountered a database problem when attempting to load jar onto DB2: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=PEGAAPP;INSTALL JAR;PEGAPP53.PRREADSTREAM, DRIVER=4.7.112
[java] com.ibm.db2.jcc.am.no: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=PEGAAPP;INSTALL JAR;PEGAPP53.PRREADSTREAM, DRIVER=4.7.112
Error Messages
[java] WARNING: Encountered a database problem when attempting to load jar onto DB2: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=PEGAAPP;INSTALL JAR;PEGAPP53.PRREADSTREAM, DRIVER=4.7.112
[java] com.ibm.db2.jcc.am.no: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=PEGAAPP;INSTALL JAR;PEGAPP53.PRREADSTREAM, DRIVER=4.7.112
Steps to Reproduce
Run the upgrade steps with the dataOnly option
Root Cause
The SQLCODE=-551 means that the user <username> does not have the correct authorization or privileges to perform this operation <OperationName>. You will need to grant this user the correct privileges. Are your DB2 permissions applied to user groups? Is this user a member of the group that has the -r-w-e permissions to INSTALL jar files? Please ensure that you have explicitly granted the CREATE_EXTERNAL_ROUTINE privileges to the database operator used to connect to the DB in order to create UDFs.
Resolution
Change/provide the correct privileges to this DB user and explicitly granted the CREAT_EXTERNAL_ROUTINE privileges.
Published January 31, 2016 - 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.