Skip to Content
avatar image
Former Member

Error When Open Bex Query from Bex Analyzer

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 30, 2017 at 03:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Sep 29, 2017 at 08:16 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2017 at 07:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded