Skip to Content

After BWA upgrade we suddenly started facing multiple errors, I will try briefing my experience and learning from the first one.

 

Error:

 

While running the Analysis Process Designer (APD) it failed giving the error message as below.

image

 

Short Dump with MESSAGE_TYPE_X

image

 

When running the query from Analyzer we were getting the error:

image

 

When running the query from RSRT

image

 

Analysis and Solution 

 

But shockingly we were getting this error for a selective set of queries, with no pattern.

 

Then with the help of SAP we were able to solve this problem by switching off the FEMS compression.

 

Thanks to the BIA Series blog link below this became very useful for us.

 

BIA BLOG Series, Part VIII: Improvements and major parameter changes for BI Accelerator

 

On doing more digging we found that as we were at a support package SAPKW70015 and FEMS functionality is available only from SAPKW70016 onwards.

 

But this was not the end to my curiosity. I still wanted to know, WHY?? Why only few queries got impacted then.

 

Then I got my answer from note 1118425.

 

FEMS-compression reduces the result set of queries which select the same data in different structure restrictions (FEMS-restrictions) by only returning it once and after- wards sorting it to create the query-result. This feature doesn’t affect each query; it depends on the query design.E.g. if you only use a global filter it will not be used.

 

Finally got rid of this problem, but this was not the only problem we faced. There are some more interesting issues which I would like to share with my future blogs.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Witalij Rudnicki
    Right, you are not the first one facing this issue. Seems SAP developers assumed that there are no customers on BW 7.0 SP below 16.

    There was OSS Note 1148111 “BIA Revision / BI Support Package – Compatibility” in the past that provided information what are compatible BWA Revisions and BW SPs. But for some reason SAP discontinued that note.

    Btw, you should include this weblog into BWA category as well: http://www.sdn.sap.com/irj/scn/weblogs?blog=/weblogs/topic/103

    Thanks for sharing,
    -Vitaliy

    (0) 

Leave a Reply