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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.