E-AS: DBFlags=8 Sometimes Gives Intermittent ORA--00022
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.
Sometimes a user may get the following intermittent error in his Application Server logfile when running a delivered AE, like below:
Getting 8601 - Cursor entry has not been initialized (SQLSTATE PS055)
Others times, a user might receive an error like below :
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:
Invalid cursor state.
The user had changed the DBFlags parameter in his psappsrv.cfg and/or the psprcs.cfg file from DBFlags=0 to DBFlags=8.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms