SAP Knowledge Base Article - Preview

2270092 - MAIN_SHDIMP/SUBMOD_SHDDEL2/SHDUNINST_DB - Objects left in the Shadow Schema

Symptom

  • While performing an upgrade using the Software Update Manager (SUM)  an error occurs during the phase MAIN_SHDIMP/SUBMOD_SHDDEL2/SHDUNINST_DB
  • The SAP system uses Oracle as its database
  • The following error can be found in the SAPupConsole.log:
Checks after phase MAIN_SHDIMP/SUBMOD_SHDDEL2/SHDUNINST_DB were negative!

Last error code set:
brconnect exited with 5
Could not drop database shadow user 'SAPR3SHD', see logfile 'SHDUNINST.LOG'
  • When you check file SHDUNINST.LOG, you find that it failed as below:
BR0301E SQL error -1922 at location drown_main-1, SQL statement:
'/* BRCONNECT */ DROP USER "SAPR3SHD"'
ORA-01922: CASCADE must be specified to drop 'SAPR3SHD'
BR1338E Dropping database owner SAPR3SHD failed


Read more...

Environment

Oracle database.

Product

SAP ERP 6.0 ; SAP NetWeaver Application Server for ABAP all versions

Keywords

SHDUNINST, SHDUNIST_DB, SAPR3SHD, SAPSR3SHD, SAP<SID>SHD,  IOV, BR1338E, BR0301E, ORA-01922, error -1922, CASCADE, RTRIM2, CONCAT3, Shadow, Upgrade, SUM, ERP, EHP , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-DB-ORA , Oracle , 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.