Error: "SAPBWP","0BW:BIA:".FM Name = TREX_DBS_AGGREGATE

[former_member785740]

Hi All,

We have upgraded our BW system from BW 7.50 SPS15 to BW 7.50 SPS18. After the Post Upgarde of BW system, when we are trying to execute few Bex Queries, we are encountering the below Issue:

• Failed to get filter node for predicate" BWX.900.00454577ED84899..."
• "SAPBWP","0BW:BIA:ZDX_C01".FM Name = TREX_DBS_AGGREGATE
• Error 2,999 has occurred in the BWA/SAP HANA server
• Error reading the data of Infoprovider ZDX_C01$X
• Error while reading data;navigation is possible.

I have tried checking the Dataflow for the mentioned Infoprovider: ZDX_C01 in the error message and the dataflow looks good ( I mean to say Infocube, Transformations and DTP.).

Also for a similar kind of issue,just gone through few of the blogs, and it was suggested to recreate index. So I have recreated the indexs through program: RSDDB_LOGINDEX_CREATE for the affected infoprovider: ZDX_C01. But still I am facing the same error while executing the BEx query.

Could anyone please advise.Thanks alot.

[lenastodal]

Thank you for visiting SAP Community to get answers to your questions. I am here to help you to get the most out of it.

First of all, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't done so already), as it provides tips for preparing questions that draw responses from our members.
For example you:
- can outline what steps you took to find answers (and why they weren't helpful)
- can share screenshots of what you've seen/done
- can use a descriptive subject line

Please also make sure you're using all appropriate tags, so the right experts can find your question. Overall, the more details you provide, the more likely it is that members will be able to assist you. Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question - but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Best,
Lena (SAP Community Moderator)

[former_member597406]

Hello,

reactivating hierarchy in RSA1 helps, but the problem could still occur in the future. We are still searching for a long-term solution. We assume that HANA DB has some inconsistencies after the hierarchy is changed. Somehow, it affects only some hierarchies and not all.