Deadlock occured while infopackage executing

[former_member298288]

Hello,

every once in while i get the following error in ST22 due to infopackage error :

Database error text........: "ORA-00060: deadlock detected while waiting for
resource"
Internal call code.........: "[RSQL/178/RSODSACTUPDTYPE ]"
Please check the entries in the system log (Transaction SM21).

in my infopackage processing I have the parameter : PSA and then into data target (Package by package), knowing that contains 8 DSO as a cible .

its possible to set for instance Only PSA ( update subsequently in Data Targets) in order to avoid this issue? otherwise, what is the best scenario to fix it?

Thank you so much for your help.

[former_member298288]

Hello,

I cant find RSODSO_CLEANUP_RSODSACTUPDTYPE while executing SE38.

Any suggestion please?

Thank you.

[former_member298288]

Hi,

I have checked , this report not exist in our system!! our kernel version is 722

Thank you.

[FCI]

Well, it should be created by implementing the note 😉

[Former Member]

Hi!

Use report RSODSO_CLEANUP_RSODSACTUPDTYPE

Check this note and implement + follow the manual steps:

1987769 - RSODSACTUPDTYPE - deletion of unnecessary entries

Best regards, Andras

[FCI]

A similar note 1987769 seems valid for the 7.0.

[former_member298288]

Thank you Frédéric for your swift answer .

unforthnly this program not available in our BW system (7.0)

[FCI]

Hi,

Executing the program RSODSO_CLEANUP_RSODSACTUPDTYPE solved the issue in my case.

See note 1919867.

Regards,

Frederic