Peoplesoft agent error: table or view does not exist error

[Anon Anon]

All,

 

We have a Unix box and are changing the ps.db.accessId  value from sysadm to a more restricted one.

 

We granted access to the process scheduler tables as requested in the implementation guide.  However, we are getting the following error:

 

1. Monitor.PsDbHandler.runSimpleQuery[:440] - Query: select RUNSTATUS from PSPRCSRQST where PRCSINSTANCE = 2355006

10/21/2015 17:59:21.560 MDT-0600 1 main.PS request Monitor.PsRequestManager.checkOutstandingJobs[:409] - Problem checking job status ORA-00942: table or view does not exist

 

Has anyone else experienced this issue?  Is it necessary to create synomyms for the sysadm tables?

Any help would be appreciated.

[Chandru.Venkataraman]

"Is it necessary to create synomyms for the sysadm tables?",

 

Yes, if you are wanting to use a different user than SYSADM.

 

http://learnpsdba.blogspot.com.au/2010/04/creating-public-synonym-of-all-tables.html?_sm_au_=iVV5k6NtWTjnrRNV

[Anon Anon]

Chandu,

 

My dba is concerned about the number of synonyms that need to be maintained.  What is the minimum number of tables needed to create synonyms?

 

Thanks and have a nice day,

 

Silvia

 

 

[Chandru.Venkataraman]

Hi Silvia,

Please check these scripts part of standard Peopletools installation (by default under, $PS_HOME/scripts on UNIX)

createlocalsynonyms.sql

createremotesynonyms.sql