Supply chain | Supply Chain Management, Commerce

Batch Job Error - Cannot select a record .There is a temporary problem with the connection to the database.

(0) Share

Report

Posted on by babalalex

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..

I have the same question (0)

All responses (7)

Answers (0)

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
babalalex 411 on at

Like (0)

Report
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,

Envrionment - Production

It was working before nicely

no any change with permissions

We are trying to update the records which are failed and if can not find to be processed records I am putting System in sleep mode for 5 seconds through coding only.Recently I have commented that for experimental purpose.

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Babalalex,

Can you tell if there was an update or deployment with customizations? Something should have changed which causes the error suddenly.

Was this reply helpful? Yes No
babalalex 411 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
babalalex 411 on at

Like (0)

Report

Adding sleep function was requirement of our process.

I could not understand importing it in an environtment.

Can you be specific about this ?

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

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).

Was this reply helpful? Yes No