Terminations on BEx Queries due to missing/inconsistent logical indexes on SAP HANA
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).
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
Bex Query going into debug mode in RSRT? Check here how to find the solution
Thank you, Eduardo. Very helpful!
Thanks Eduardo. We resolved the same issue using your blog. The tricky thing is we are getting this issue in only Quality box, but not in Dev and Sandbox.
Regards
Surendra
Nice post, Eduardo. Thank you for shared the blog.
Best Regards
Venkat...
You saved us a lot of time !
Thank you very much 🙂
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
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
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
Hi Eduardo,
Very helpful article.
Thanks,
Yuri
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
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
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
Thanks a lot 😀
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
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.