SAP Knowledge Base Article - Preview

2935109 - Some indexes are missing in the database of the target system after system copy

Symptom

DBACOCKPIT -> Diagnostics -> "Missing Tables and Indexes" shows BW-related indexes missing in the target database after system copy.

When you check the *.SQL files generated by SMIGR_CREATE_DDL report, the index statements like following:

ind: /BI0/E0BWVC_009~P

instead of:

ind: /BI0/E0BWVC_009~P
sql:  CREATE  UNIQUE
      INDEX [/BI0/E0BWVC_009~P] ON [/BI0/E0BWVC_009]
        ( [KEY_0BWVC_009P]  ,
          [KEY_0BWVC_009T]  ,
          [KEY_0BWVC_009U]  ,


Read more...

Keywords

System Copy, Missing Tables and Indexes, index missing, SMIGR_CREATE_DDL , KBA , BW-SYS-DB-MSS , BW on Microsoft SQL Server , 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.