E-AS: DBFlags=8 Sometimes Gives Intermittent ORA--00022 (Doc ID 1277904.1)

Last updated on MARCH 22, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.46 to 8.50 [Release 8.4]
Information in this document applies to any platform.

Symptoms


Sometimes a user may get the following intermittent error in his Application Server logfile when running a delivered AE, like below:

Intermittent "ORA-00022: Invalid Session ID; Access Denied"
Getting 8601 - Cursor entry has not been initialized (SQLSTATE PS055)



Others times, a user might receive an error like below :

Error Position: 0
Return: 8601 - Cursor entry has not been initialized (SQLSTATE PS055)
Original Statement: select EMPLID from PSOPRDEFN where OPRID = :1
PSAPPSRV.332 1-14072 11.29.11 9.995000 SamCreateSecondary ---- Fail to obtain Second DB connection


Other times, the customer may get a message that says:

SQL Error. Stmt #: 2 Error Position: 0 Return: 8603 - [IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003 (SQLSTATE 08003) -99999
Invalid cursor state.

 

Changes

The user had changed the DBFlags parameter in his psappsrv.cfg and/or the psprcs.cfg file from DBFlags=0 to DBFlags=8.

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