Skip to Content
0
Mar 26, 2019 at 10:11 AM

RS_EXCEPTION109 at Hierarchy Activation

76 Views

Hello Experts,

I have a self-loop to change a hierarchy's structure. In the DTP, I select the hierarchy I want to use for the load and change its structure using some custom logic in the End Routine. The result is a modified version of the same hierarchy that contains the new structure, but cannot be activated - I get RS_EXCEPTION109. The strange thing is that I get:

Error while accessing H0000000047_2_HHLI Message no. RS_EXCEPTION109

When I try to activate it multiple times, I get the same error except for the fact that the value X in H0000000047_X_HHLI goes up in consecutive order. Once the digits run out, it starts to use alphabet letters until all possible characters are used up after which I get a dump for insertion with duplicate keys. After some more investigating, I found out that X is the version field (SVER) in the /BIC/I<object>.

Here are a few screenshots:

The starting state of the hierarchy:

After the DTP execution (the new hierarchy structure load in version M)

The new hierarchy structure (version M)

p3.png

The error that I get.

p4.png

It used to work before and the active hierarchy contained the new structure as soon as the DTP finished. Now, it no longer does and I'm not sure what is causing this issue. Any ideas?

I'm using running SAP BW 7.5 on HANA

Thanks,

Dimitar

Attachments

p1.png (13.7 kB)
p2.png (20.2 kB)
p3.png (42.4 kB)
p4.png (9.5 kB)