Return
-
Title
Error creating SQL: Database type not supported, while creating archive set on DB2 -
Description
We have also tested the resolution from STAT knowledge base, but didn't work. We verify from PeopleSoft Connect window. Check the column 'Other Database Parameters' and make sure it looks like: currentSchema=..... instead of CURRENTSCHEMA=...... -
Cause
by the server.log:The SQLCODE -551 is returned from DB2 Server. The error indicates that PSUPGRD does not have SELECT authorization on INSPS.PSOBJGROUP. -
Resolution
Solution 1:To avoid this restriction by using roles instead of groups.Suggestion to try:- Grant the needed privileges to the user directly.- Create a role, grant the privilege to the role, grant the role to the user.Please, DB2 DBA has to check if the user has necessary privileges to select from the table. If not, please grant the permission to the user.ORSolution 2:From Stat point of view, as the install guide states the Central Agent does an internal check to the database querying the table PSOBJGROUP defined in the stat.properties, you can to replace that table that the user has access to.