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:<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

SAP HANA, platform edition 2.0

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.