RSRHIEDIR_OLAP and multiple locks in SM12

[Former Member]

Hi SDN Community:

Yesterday we had a problem that happened a few months ago u2013 no resolution was found at the time, and the problem disappeared after a few days.

Symptoms :

1) Build-up of multiple locks visible in SM12. Lots (not all) of these have to do with Hierarhies.

2) When one tries to display Hierarchy Authorizations through RSSM, oneu2019s session just freezes up, and in SM12 one sees locks for table RSRHIEDIR_OLAP.

3) Multiple dataload failures with messages like the following (the object in question having no descernable relationship with 0ORGUNIT)

Thank you.

Simon

[Former Member]

Hi Andraes,

it seems that the issue has resolved itself. I have not had a reply from BASIS but it must be those intermittent locks during the hierarchy change run.

thank you.

Simon

[Former Member]

Hi Simon,

without knowing on which sp level you are take a look if this notes are relevant for you:

Lockwait on table RSRHIEDIR_OLAP

SAP Note Number: [912111|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bw_bex/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d393132313131%7d]

P21:Rebuilding:sm12 locks are no longer deleted

SAP Note Number: [725492 |https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bw_whm/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d373235343932%7d]

Deleting master data: lock (table RSMASD) remains

SAP Note Number: [613951|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bw_whm/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d363133393531%7d]

Regards

Andreas

[Former Member]

Hi Andreas,

thank you for your reply. My colleage will be investigating shortly, and we'll tell you how it resolves.

Regards,

Simon