Hi BEx Community,

When consuming a BEx Query (or even a BW Infoprovider directly) or reading characteristic values (F4 value help) you might face error messages like the ones below. These terminations are propagated to all front-ends that consume the services described above, such as Web Intelligence (WebI) and other BO tools, Bex Analyzer, Analysis for Office (AO), Business Planning and Consolidation (BPC), Java Portal and many others.

Sometimes the error message received can differ a little from the ones below or, depending on the front-end message handling, the error message is not displayed very clearly. In the second case I recommend you to test the corresponding query on RSRT transaction (HTML mode) to get a clear view of the error message.

PS.: If you are using an InfoProvider instead of a BEx Query, you can execute the InfoProvider default query on RSRT by using the schema <infoprovider>/!<infoprovider>. E.g.: For a infoprovider called ZTEST, enter ZTEST/!ZTEST as query technical name.

PS2.: If transaction RSRT cannot be used for any reason, I recommend you to collect a RSTT trace. Then play the trace afterwards and you should get clear messages. More information at: 1925924 – How to enable RSTT Trace in SAP BW for Frontend Tool(SAP BI & 3rd-party Tools)

Some of the error messages that indicate this sort of issue are the following ones:

“Error(#99) TREX_DBS_AGGREGATE”

“Error (#901) Error 2,949 has occurred in the BW/SAP HANA server”

“Error initializing joins: Could not handle join condition..”

“Error 2.999 has occurred in the BWA/SAP HANA server”

“Error 2.991 has occurred in the BWA/SAP HANA server”

“table config for index …en is not valid”

“Error reading the data of InfoProvider …$X”

These errors are due to missing or inconsistent column views (also known as a “logical index”) in SAP Hana database.

In the SAP HANA database, each InfoCube has a corresponding column view for the performance-optimized reading of data records. The same applies to DataStores with “SID Flag” (SID generation during activation), to master data providers, and to InfoObject value helps.

In most cases, the symptoms described occur because the relevant column views are missing in the database. However, you do not know or you cannot reproduce why the column view is missing or was deleted.

The solution for most of these cases is to execute report RSDDB_LOGINDEX_CREATE in order to (re)create the logical index for affected object. In below image you can see objects types you can run this program (taken from a SAP BW 7.4 system).

01-08-2015 14-07-35.jpg

Please find full details on SAP note:

1656582 – Query terminations – InfoCubes, DSOs, master data in HANA DB

Hope this helps.

Cheers,
Eduardo Provenzano

See other posts:

How to verify a Workbook last used date

Unexpected values in Bex Query? Check out SAP collective notes for incorrect/wrong data in BW queries

Bex Query going into debug mode in RSRT? Check here how to find the solution

To report this post you need to login first.

14 Comments

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

  1. Aparajit Banik

    Hi Eduado,

    Not able to run this program for Composite Provider.
    It says:

    Object OBJ_TYPE HCPR not found

    Message No. RS_EXCEPTION111

    Were you able to run it for CP? Or did you come across such message?
    All reagards
    Aparajit

    (0) 
    1. Eduardo Provenzano Post author

      Hi Aparajit,

      I tested in my system and it went fine.

      I’m not quite sure but SAP note 1967624 might help.

      If you test it, let us know the result you get.

      Regards,

      Eduardo

      (0) 
    2. Yuri Hristov

      Hi Aparajit,

      You can run the program for every object which form the Composite Provider.

      In my case 5 DSOs and 2 Infocubes.

      In this way the issue was fixed.

      Best regards,

      Yuri

      (0) 
  2. Dominik Kacprzak

    Hi,

    I have not seen any explanation WHY it happens.I have not seen any confirmation that it fix issue permanently.

    Program mentioned is part of post migration step, i believe it is started after migration DB to HANA. Why to run this one again and again and…?

    Regards,

    Dominik

    (0) 
    1. Eduardo Provenzano Post author

      Hi Dominik,

      the idea is not to run this program again and again.

      If you are facing this issue quite often, please report an incident on HAN-DB-ENG-BW component.

      Regards,

      Eduardo

      (0) 
      1. Dominik Kacprzak

        Hi,

        Ticket is registered (or will be soon), but I already see reponse from SAP 1. line.: How can I recreated error? Which obviously lead to question how long should I (or rather my customers) have to wait for fixing it? I am pretty sure it is visible in HANA Logs, EWA? Is it hardware specific? Only related to migrated systems (from other DBs) ? Any system parameters?

        Regards,

        Dominik

        (0) 
  3. Alejandro Miralles

    When running it for an FBPA Open ODS View, get following error:

    If run query, gives error:

    Inconsistent calculation model;calculationNode (W1):ColumnTable SAPBWP:/BIC/ETSDOO48 not found (cannot get catalog object)/[Request Info: Object …

    Error Name = “SAPBWP”.”0BW:BIA:TSDOO48″, FM Name = TREX_DBS_AGGREGATE]

    Error Error 34.011 has occurred in the BWA/SAP HANA server

    Error Error reading the data of InfoProvider TSDOO48$X

    Error Error while reading data; navigation is possible

    Information CL_RSDRH_TREX_STORAGE >> Row: Inc: 79 Prog: MAP_TREX_EXCEPTION


    looking into notes and SDN but withou luck so far.

    BI 740 SP14

    Many thanks

    (0) 
  4. Jack Chow

    Any one have found the permanence solution? To run RSDDB_LOGINDEX_CREATE only fixed one, ย when i try to add a new InfoObject in the same Infoprovide, issue will be occur again.

    Many Thanks.

     

    (0) 

Leave a Reply