Support Article

Prod executing DB call with invalid user ID

SA-38889

Summary



After upgrade the system is throwing errors executing some of the stored procedures.

Error Messages



Last SQL: {call PEGA.sppc_data_uniqueid (?,?,?,?)}
com.ibm.db2.jcc.am.SqlException: An error occurred during implicit system action type "3". Information returned for the error includes SQLCODE "-551", SQLSTATE "42501" and message tokens "ADMIN1|SELECT|PEGA.PC_DATA_UNIQUEID".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.69.49

Steps to Reproduce


Try to create a work object which will need to execute the pc_data_uniqueid stored procedure.

Root Cause



A defect or configuration issue in the operating environment.

The database user running the system was not granted all of the necessary privileges to execute the stored procedure.

Within the stored procedure there is a query of a database table that the user did not have privileges on.

Resolution



Make the following change to the operating environment:

Grant required privileges to database user who is processing the system.

Published June 2, 2017 - Updated July 26, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.