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

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.
Suggest Edit

Published January 31, 2016 - 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