Tuesday

Application Server issues.

Application Server issues-

How to fix  ***/peopletools/src/pssys/stmget.cppSQL error.

File: ***\peopletools\src\pssys\stmget.cppSQL error. Stmt #: 2509  Error Position: 70  Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt:SELECT VERSION, OPERPSWD, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1

1- Check if public synonym exists for PS.PSDBOWNER. If not then create one.
        
CREATE PUBLIC SYNONYM PSDBOWNER FOR PS.PSDBOWNER;

2- Now, check if it is granted PUBLIC access.
        
GRANT SELECT ON PS.PSDBOWNER TO PUBLIC;

To reproduce the above error, issue below statement and boot the application server-
    
REVOKE SELECT ON PS.PSDBOWNER FROM PUBLIC;



No comments:

Post a Comment

Followers