PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Processes are stuck in error status

edited May 16, 2019 7:50PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered

Hi,

Few custom processes are stuck in error status and getting below error.

This is not Happening for every time occasionally, remaining times processes are went to success status.

File: E:\pt85517b-retail\peopletools\src\psschdlr\schedulerdispatcher.cppSQL error. Stmt #: 2538  Er ror Position: 0  Return: 8602 - [Microsoft][SQL Server Native Client 11.0]Function sequence error (S QLSTATE S1010) 0 Failed SQL stmt: SELECT PRCSINSTANCE,RUNSTATUS,DISTSTATUS,SRVRTYPE FROM PSPRCSJOBSTATUS  WITH (READU NCOMMITTED)  WHERE RECEIVED = 1 ORDER BY PRCSINSTANCE DESC

Request to help on this to fix this issue.

Thanks,

Ashok.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center