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:<schema_name>:<table_name>".
[123676]\{411494\}[-1/-1] 2024-06-24 09:19:11.594809 e meta_cache DistDDLRequester.cpp(01059) : getIndexLocation fails. reason="table does not exist;<schema_name>:<table_name>".
[108491]\{411370\}[21/-1] 2024-06-24 09:20:08.418543 e tempindex trex_itab.cc(00160) : Failed to find temp table. Schema: <schema_name>, Name: <table_name>:, Host: <host_name>
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.