Question
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?
Thanks. we were able to figure out the issue by tracing agent.
One of the RDB connector was failing and hence queue was marked as Broken
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
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