SAP Knowledge Base Article - Preview

2772385 - After upgrading to SAP Dynamic Tiering 2.0, sp_iqrebuildindexforbp fails - SAP DT

Symptom

  • As part of the upgrade tasks on SAP Dynamic Tiering 2.0 (DT), indexes need to be rebuilt in DT.
  • There are two tables with the same name in different schemas.

Ex:

      • schema1.Table_abc
      • schema2.Table_abc

sp_iqrebuildindexforbp fails with error:

Cannot find index named 'ASIQ_IDX_T1234_C8.FP'
SQLCODE=-183, ODBC STATE "42S12"


Read more...

Environment

SAP Dynamic Tiering 2.0

Product

SAP HANA dynamic tiering 2.0

Keywords

"Cannot find index named";  SQLCOde=-183 ; ODBC STATE "42S12"; , KBA , HAN-DYT , SAP HANA Dynamic Tiering , Bug Filed

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.