SAP Knowledge Base Article - Preview

2534603 - Primary index missing for DSO table

Symptom

The primary index of a DataStore Object table is missing on the database. This may happen after the execution of a BW process where the index had to be re-created. For instance after the Selective Deletion of data from a DSO. In the job log you can see the following:

CREATE UNIQUE INDEX "/BIC/A<DSOXYZ>00~0" ON
"/BIC/A<DSOXYZ>00" ("NOTIFICATN")

followed by the error

SQL Error: ORA-14039: partitioning columns must form a subset  of key columns of a U
System error: CRE_LOCAL_INDEX ORACLE 14,039 ORA-14039: partitioning columns must form a subset


Read more...

Environment

  • SAP NetWeaver All Versions
  • Database: ORACLE

Product

SAP NetWeaver all versions

Keywords

DB02, DBACOCKPIT, ST04 , KBA , BW-BEX-OT-DBIF , Interface to Database , BC-DB-ORA , Oracle , BW-SYS-DB-ORA , BW ORACLE , BW-WHM-DBA , Data Basis , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.