Question
3
Replies
554
Views
Schwab
Posted: November 13, 2017
Last activity: November 14, 2017
Closed
Solved
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?
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