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
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
SAP NetWeaver All Versions
- Database: ORACLE
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 pageThis 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.