SAP Knowledge Base Article - Preview

2594139 - SQL0669N A system required index cannot be dropped

Symptom

 Upgrade fails with the below error
===========================
2WETP000 08:55:03: Retcode 1: error in DDL statement for "RSDMCHNTAB " - repeat
2EETP345 08:55:15: Retcode 1: SQL-error "-669-SQL0669N A system required index cannot be dropped explicitly. SQLSTATE=42917" in DDL statement for "RSDMCHNTAB "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 08:55:15: error in DDL, nametab for "RSDMCHNTAB" not activated
2 ETP301 ----------------------------------------------------------------------
3 ETP361 "0" Shadow-Nametabs activated, DDL executed
2 ETP362 "1" Shadow-Nametab activations failed
2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2017/12/19 08:55:03")
2 ETP363 End : Act. of Shadow-Nametabs with DDL ("2017/12/19 08:55:15")


Read more...

Environment

  • Db2 LUW 10.5
  • SAP Netweaver 7.4/740

Product

SAP NetWeaver 7.4

Keywords

UNIQUE, PRIMARY, RSDMCHNTAB , KBA , BW-SYS-DB-DB6 , BW DB2 Universal Database , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.