SAP Knowledge Base Article - Preview

2198923 - Tables of type <table_name>~~OLD are left in the database after the system switch upgrade

Symptom

After the system switch upgrade using Software Update Manager, tables with suffix ~~OLD are left in the database. Due to this, following symptoms can be seen,

  • Old tablespace cannot be deleted as it contains such objects
  • Objects of type ~~OLD can be seen in DB02 transaction under "Missing tables/indexes" > "Unknown objects in ABAP Dictionary"
  • DBcheck might return  IN_WRONG_TABLESPACE warnings for tables of type <table_name>~~OLD
  • ERROR in DBCLONE Phase: 1EETGCLN cannot use duplicate index name <Index name> because of existing objects with suffix ~~OLD

 


Read more...

Environment

Upgrade using Software Update Manager (SUM) tool

Product

SAP NetWeaver all versions

Keywords

IN_WRONG_TABLESPACE, BR0970W, Database administration alert - level: WARNING, rename, CHECKDB, DB13, ~~, OLD, shadow table, MAIN_POSTCLEAN/DBCLEAN_UPG, DROP TABLE, TABLE~~OLD, TABNAME~~OLD, SAPup , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , 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.