SAP Knowledge Base Article - Preview

2330025 - Missing Primary indexes on BPC characteristic table

Symptom

You find in DBA Cockpit > Diagnostics > Missing Tables and Indexes that Primary Indexes (or Primary Keys) are missing in the database:

If you see primary indexes with the following names, this KBA applies to you:

Pattern Example
/B28/M<CHARACTERISTIC>~0 /B28/MLXD5F84~0
/B28/P<CHARACTERISTIC>~0 /B28/PLXD5F84~0
/B28/Q<CHARACTERISTIC>~0 /B28/QLXD8I5K~0
/B28/T<CHARACTERISTIC>~0 /B28/TLXD5F84~0
/B28/X<CHARACTERISTIC>~0 /B28/XLXD5F84~0
/B28/Y<CHARACTERISTIC>~0 /B28/YLXD8I5K~0


Read more...

Environment

  • SAP BPC for SAP NetWeaver;
  • SAP BW on SQL Server;
  • MS SQL Server 2008 and higher.

Product

SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

SAP BW, business wharehouse, business intelligence, BI, business planning and consolidation, nw, mssql, msql, ms_sql, microsoft, sqlserver, sqlsrv, ms sqlserver, ms sqlsrv, PK, clustered, nonclustered, index, miss, missing, is missing, can't find, can't create, error during , KBA , BW-SYS-DB-MSS , BW on Microsoft SQL Server , BW-SYS-DB , BW Database Platforms , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.