Processes are stuck in error status
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.