Question
Schwab
IN
Last activity: 14 Nov 2017 10:11 EST
error while processing queue entry by Standard agent
Hi,
We have one background process which check status. If status is Not ready, request is queued and if status is ready request is processed.
Once request is queued, standard agent tries to process the request. Even if request is processed successfully, we are seeing request in Broken-Process status with below exception.
“There was a problem getting a list: code: 0 SQLState: 08S01 Message: Connection reset “
Any pointers to solve this?
Accepted Solution
Pegasystems Inc.
IN
Hi There,
Well it seems that your queue items might be partially processed.
For example If my Agent processes a queue Item to update couple of table sequentially and it is successful in doing so for one table and fails for other then we will get Items in broken-queue.
For verification you might be checking the only Update that happened correctly.
From your above error it is evident that there are sql errors and hence you see it in broken queue.
Please trace agent and check what has gone wrong.
Regards,
Ujjwal
Pegasystems Inc.
US
Hi Mandar,
Can you please copy and paste the complete server Error/Exception Stack covering the last "Caused by:" for review?
From the line, I presume the JDBC Connection to the database server was terminated in between the Agent processing transaction.
-Ankur