You’re offline. This is a read only version of the page.
Announcements
411
Hi,
I am facing one error with the batch job.
I want this batch job to run for 1 month atleast.
But facing below error :
Cannot select a record in (). There is a temporary problem with the connection to the database. Please retry later.
Cannot execute a stored procedure. There is a temporary problem with the connection to the database. Please retry later.
Cannot select a record in KSM_UploadProcessorQueue (KSM_UploadProcessorQueue). There is a temporary problem with the connection to the database. Please retry later.
Batch task failed: Cannot select a record in KSM_UploadProcessorQueue (KSM_UploadProcessorQueue). There is a temporary problem with the connection to the database. Please retry later.
is there any way out where if selection of record does not happen for this batch job? It should not throw error message and stop.
Thanking you in anticipation..
Hi babalalex,
I have a few comments about sleep function.
If i understand correctly you want to implement some kind of retry function. In this case you can to take a look at ReliableAsynchronous execution mode.
For failed records you can create new ReliableAsynchronous batch job and put it to batch queue. In this case you can finish your main batch job without delays and later the rest of failed messages will be processed with one time jobs (ReliableAsynchronous).
this could very well be the reason
why and how you added sleep?
could you try to import in an env. without this custom code?
Hi Andre,
I have made changes in my piece of code.
Initially I have added sleep function.
Later to check performance, I have commented that code.
Can this be the reason for such error?
Hi Babalalex,
Can you tell if there was an update or deployment with customizations? Something should have changed which causes the error suddenly.
Thanks Sukrut for prompt reply.
We have not written any stored procedure but using the standard functionality of batch jobs in which we have written a custom batch job for performing route, bom and RAF posting .
To answer your question,
Basically, I want to handle any error coming out from this batch job, at the same time it should not stop the batch job directly.
In which environment you are facing this issue? Looks like you are executing a store procedure in a batch job which is trying to make connection with database and failing . By looking at table name seems like a custom process, where we cant help much. Was it working before ? if yes what changes have been made with permissions ?
#1
André Arnaud de Cal...
293,302
Super User 2025 Season 1
#2
Martin Dráb
232,114
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
