cancel
Showing results for 
Search instead for 
Did you mean: 

Deadlock error DBSQL_SQL_ERROR

0 Kudos

Hello Experts,

I have come accross one error which i am getting when i am executing the process chain.

Below is the exact error which i am getting:-

error.jpg

Could you please help me with the possible approach which i can try to resolve this error.

Thanks,

Prateek

Accepted Solutions (0)

Answers (2)

Answers (2)

FCI
Active Contributor
0 Kudos

Hi Prateek,

What kind of process raised this error ? If this is the loading of a cube, it generally happens when the indexes of the cube have not been deleted before loading it.

Regards,

Frederic

0 Kudos

Hey Frederic,

This error is coming while loading the infocube via Process chain.

Even though i have added the step of dropping index before the data load to it, still this error is coming.

And yes i also checked that there is no other process chain which is using this infocube at the same time.

Any suggestions?

Thanks,

Prateek

bhavinvyas
Active Contributor
0 Kudos

For now, Try to repeat the step after some time.

Check if the same data target is used some where or loading from the same target in same time.

you may need to adjust you data loads timing if its getting used while you are loading.

Thanks,

Bhavin Vyas

0 Kudos

Hello Bhavin,

This was the very first step that i checked when i saw the deadlock error, and surprisingly there is no other process chain that is using this infocube .

Thanks,

Pratss