SAP Knowledge Base Article - Preview

3527410 - Dump encountered after data source pull

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

SAP HANA, platform edition all versions

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.