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 , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB , BW Database Platforms , 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.