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: https://launchpad.support.sap.com/#/notes/2497296.
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.