Skip to Content
0

Error When Open Bex Query from Bex Analyzer

Sep 29, 2017 at 07:53 AM

181

avatar image
Former Member

Can anyone help me about this error ? I got this error when i try to open my Query from Bex Analyzer.

Error reading data of Infoprovider ZMP00011$X
Error 2.981 has occurred in the BWA/SAP HANA server
0005PIM8OOYLLYFT4CBSEIAT8:0011/[Request Info: Object Name = "SAPABAP1"."0BW:BIA:ZODFI015", FM Name = TREX_DBS_AGGREGATE]
locations not supported in cube: SAPABAP1:0BW:BIA:ZODSKM21: calcEngine search on olapIndex failed.,QueryId: ...
function is not implemented (, yet);Query execution plan generation failed: Failed to create Search: Operation with two different index ...
Error Occured during parallel processing of query 11, RC: 3
Error While reading data, navigation is possible.

error-bex-query-analyzer-2.png

Thank you,

Edwin

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Loed Despuig Sep 30, 2017 at 03:57 AM
0

Hi,

Go to tcode RSRT.

Enter the tech name of your query then click PROPERTIES.

Select 0 both for OPERATIONS IN BWA and OPTIMIZATION MODE.

Regards,

Loed


delete.jpg (165.5 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Loed,

If i change Operation in BWA into 0 and Optimization into 0 too.

What is effect with my query ?

Thanks,

Edwin.

0

Hi,

First, I think it will fix your query. Second, not sure with the effect in the performance of the query. But if the query has good performance before the error occurred, then the setting I have suggested will not affect much the performance of it.

Regards,

Loed

0
Shwetha Bangera Sep 29, 2017 at 08:16 AM
0

It looks like an error related to aggregates or BWA server. Try reconstructing the BIA indexes or the aggregates and check if the issue occurs again

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Can you help me how i Can Reconstructing the BIA Indexes ?

0

https://blogs.sap.com/2013/03/17/rebuild-bia-index-on-cubes/

A word of caution : Removing BIA indexes causes reports to run slow. Also, if the cube has a high volume of data, it can take considerable time to rebuild indexes. So better to do it at a time when customers are not accessing the reports based on that cube

0
Former Member

I already check at RSRV, I can't found BI Accelator on my Menu.

0

Hi,

Maybe because you don't have BIA in your BW server?

Regards,

Loed

0

Can you run a general master data check in RSRV for all the InfoObjects in that particular cube? It looks like an error related to a particular InfoObject

0
Loed Despuig Oct 19, 2017 at 07:36 AM
0

Hi,

I got the solution for your issue..

You may use the program RSDDB_LOGINDEX_CREATE then just enter the source of your query..

No need to change any settings in the properties of your queries..

Regards,

Loed

Share
10 |10000 characters needed characters left characters exceeded