Symptom
- You are executing an upgrade with SUM and it fails in the "Create the shadow database schema" step.
- When it fails it indicates a DMT.CREATE_SCHEMA.LOG log file, which contains error messages similar to the following:
<timestamp> [Info ]: Generating statements has finished.
<timestamp> [Info ]: Executes statement list:
<timestamp> [Info ]: Connection to SYSTEM has been established.
<timestamp> [Info ]: Error while executing statement.
<timestamp> [Info ]: ORA-01920: user name '<username>' conflicts with another user or role name<timestamp> [Error ]: Error while executing statement.<timestamp> [Info ]: Statement execution has finished.<timestamp> [Error ]: Error while executing statement list.<timestamp> [Info ]: Connection has been closed.<timestamp> [Info ]: Could not execute command execute.<timestamp> [Info ]: Could not execute command runhandler.<timestamp> [Info ]: Start time: <timestamp><timestamp> [Info ]: Stop time : <timestamp><timestamp> [Info ]: Duration : <duration><timestamp> [Error ]: Error during execution.<timestamp> [Error ]: java.sql.SQLException: ORA-01920: user name '<username>' conflicts with another user or role name<timestamp> [Error ]: SQL Exception code 1920: ORA-01920: user name '<username>' conflicts with another user or role name<timestamp> [Error ]: Could not execute the list of statements.<timestamp> [Error ]: Could not execute DMT command runhandler. See previous messages.
- The user mentioned in the ORA-01920 error does not own any database object:
Read more...
Environment
- SAP Systems based on SAP NetWeaver
- Oracle Database
Product
SAP NetWeaver all versions
Keywords
CREATE_SCHEMA, CREATE, SCHEMA, upgrade , KBA , 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.