E-SEC: What Should be Done When the PS.PSDBOWNER Table is Dropped? (Doc ID 620128.1)

Last updated on JANUARY 15, 2014

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.1 and later
Information in this document applies to any platform.
***Checked for Relevance 05/02/2013***

Symptoms

Still have questions after reading this document? Please post a question to our community: PeopleTools Community



App server will not boot up and user cannot logon in 2-tier. Upon investigation in the trace we see in the app server log, it shows

PSAPPSRV.52392 [09/02/03 22:16:18](1) GenMessageBox(200, 0, M): /local_home/build84/pt84206-retailr_o/src/pssys/stmget.cpp: SQL error. Stmt #: 2289  Error Position: 23  Return: 942 - ORA-00942: table or view does not exist

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms