Symptom
- You experience a dump similar to the below;
Category Installation error
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 06/24/2024 09:20:08
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Short Text |
| SQL error "SQL code: 2" occurred while accessing table "/BI0/SREQUID". |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|What happened? |
| Database error text: "SQL message: general error: temp index not exists: [0] |
| No error" |
----------------------------------------------------------------------------------------------------
- You see the following within the index server traces on HANA;
indexserver_alert_<port number>.trc
[123676]\{411494\}[-1/-1] 2024-06-24 09:19:11.594704 e meta_cache DistDDLRequester.cpp(01059) : getIndexLocation fails. reason="table does not exist;SAPBWP:#_SYS_QO_COL_L:245_7e893abaf390:4020000000000267"
[123676]\{411494\}[-1/-1] 2024-06-24 09:19:11.594809 e meta_cache DistDDLRequester.cpp(01059) : getIndexLocation fails. reason="table does not exist;SAPBWP:#_SYS_QO_COL_L:245_7e893abaf390:4020000000000267"
[108491]\{411370\}[21/-1] 2024-06-24 09:20:08.418543 e tempindex trex_itab.cc(00160) : Failed to find temp table. Schema: SAPBWP, Name: #_SYS_QO_COL_L:35_7e3326553d30:4020000000017449, Host: sfiqbiwdb02, Port: 30003
[39963]\{415107\}[32/-1] 2024-06-24 09:22:36.312431 e tempindex trex_itab.cc(00160) : Failed to find temp table. Schema: SAPBWP, Name: #_SYS_QO_COL_L:176_7e8a8c03f2b0:40200000000001ee, Host: sfiqbiwdb02, Port: 30003
Read more...
Environment
HANA revision 2.00.052.00.1599235305 (fa/hana2sp05)
Product
Keywords
temp index not exists, Failed to find temp table , KBA , HAN-DB , SAP HANA Database , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.