Skip to Content
Aug 26, 2019 at 08:52 AM

0ORGUNIT hierarchy DBSQL_DUPLICATE_KEY_ERROR during activation



We just did an upgrade of our SP from SP16->SP17 in BW 7.4.
After doing this upgrade we noticed that our hierarchy of 0ORGUNIT was failing in the process chains.
When checking the messages we get following: Internal session terminated with a runtime error DBSQL_DUPLICATE_KEY_ERROR (see ST22).

When checking ST22 in the debugger I saw that the code is trying to insert /BI0/IORGUNIT (SID hierarchy structure) in the method _SAVE_INCL.
And here it crashes. When I check this table I see nothing out of the ordinary.

I read a lot of posts about this and tried following:
Activation the M version of the hierarchy in RSH1 -> throws the error.
Deleting the hierarchy and reloading it -> throws the error.
Ran all possible tests in RSRV for master data and hierarchy -> all passed without errors.
Activating the hierarchy through a program -> throws the error.

I found following SAP NOTE:
Which just says hey you have to go to SP18 which we like to avoid.

Any other ideas on how to solve this problem? I also like to avoid to manually search the hierarchy since it is time dependant and has over 5000 entries.

Kind regards