What are dead locks in BW

[Former Member]

hI,

What are dead locks in BW

[Former Member]

Hi ,

The concept of dead lock is as similar as in Oracle. If Process P1 is using resource A (locked by P1)) and waiting for B and Process P2is using resouce B(locked by P2) and waiting for resouceA. This creates dead lock as both can not proceed further.

In BW deadlock usually occur in delta load. As, far as my observance deadlock usually occurs during processing of update rules. This may be because more than one package will be processing same record as in delta load, data moves from changelog of below level to next level.

Regards

Sushma

[Former Member]

a

[Former Member]

Dead locks could be when delta requests in the cube is deleted and the PSA data is also deleted

When the scheduler does not run for V3 update in R/3 to fill the delta queue

wrong dates in selection in infopack and delta queue deleted. etc...

I suggest you post these questions in BI forum not here. You get better answers and more attention there.