Delta Load Failure - All BW gurus please help me

[Former Member]

Hi, BW experts.

Can u please do the needful help.

delta is running from ods to cube but all the data packets are going fine but in Monitor Tab - for a particular data packet it is showing " Data Package 45 : arrived in BW, Processing Data Packet not yet processed."

When checked the dump anaysis. It is showing " The Database system detected a deadlock and avoided it by rolling back your transaction.

So, what should i do in this regard.

Thanks & Regards

Sagar

[Former Member · Accepted solution]

Do you any other info source loading to the same data target?

May be the system is deetcting a lock situation because of this.

Pl check this out,.

Ravi Thothadri

[Former Member · Accepted solution]

Thanks Ravi for your instant answer let me check that.

[Former Member · Accepted solution]

Hi Vidya,

If there is not any locks in SM12 you can load it in the monitor screen, Right click on the package and select manually update under details tab.

Regards.

[Former Member · Accepted solution]

Hi BW experts,

Thanks for your instant answer.

i found that the lock is there.

now should i release it.

Please tell me what to do next.

Thanks & Regards

Sagar...

[Former Member · Accepted solution]

Yes you remove the lock and just load the single package by manually update option. It should be fine.

Regards.

[Former Member · Accepted solution]

Hi Vidya,

check whether it is a Proper lock entry for the respective infosource or not ..

then select the entry --> Go to Lock Entry on menu bar --> click Delete..

Hope this helps,

Thanks,

Sudhakar..

[Former Member · Accepted solution]

Step 1 : If Data is there in PSA Do Manual Load.

By Making the Status Red, go to Details Tab and in that right click on the packet which is not loaded , say manul Load.

when system completed the manul load refresh the details. if we get any error ( STEP 2 )

Step 2: Delete the Request from the cube, and then in ODS un mark ( Data Mart Status of the Request )the request which you are loading in to cube as delta..

Re trigger the info pack.

Thanks

Sharp

Message was edited by:

sharp deep

[Former Member]

i got the answer with your help.. thanks for your great help.

[Former Member]

Remove the lock.

Reload. Bue make sure there is no other info source that loads to this ODS when you load.

Ravi Thothadri

[Former Member]

Thanks Everybody,

for helping me, my problem is solved.

thanks & Regards

sagar...

[Former Member]

Hi Vidya.

Hope you can assign good points to the valuable inputs and close this post as Answered..

Thanks,

Sudhakar.

[Former Member]

Hi Sagar,

Checks any locks still active in SM12 and unlock..

Try to load it manually if the data is available in PSA...

hope this helps,

Thanks,

Sudhakar

[Former Member]

Thanks Sudhakar for your instant answer, i will check it.