BW Bex Query, Filter on Hierarchy is disconnecting the system.

[Former Member]

Hi Gurus,

Recently my BW system upgraded to BW 7.5.

Gender Hierarchy. When we try to restrict the query by filtering in Bex Query the system is getting disconnected with below error message.

Error Message :

1) brain-299.jpg

capture.jpg

In Development is Filters working perfectly fine, but Quality and Prod is facing the issue.

Does any one faced the same kind of issue.

Regads,

SLS

[Former Member]

Additional Information.

Executed RSRV - except K table node warnings everything is fine for the Hierarchy

Bex Query Error Message : message brain 299 - system error in program SAPLRRSI and form RRSI_SID_VAL_CONVERT-1-

[Former Member]

Ohhh,,, No Luck

[Former Member · Accepted solution]

Hello;

Can you try this:

https://archive.sap.com/discussions/thread/1683369

Regards

[Former Member · Accepted solution]

Thank you for the reply... But the solution is different.

[Former Member]

When you get brain 299 error run rsrv - you will see the warning with Hierarchy SID Warning...

Go To Hierarchy maintainenance of object.

we can see M & A versions. this mean hierarchy got corrupted.

Activate the A version. Issue will be solved.

But need to clear your mind when you do in Production system :)...