SAP Knowledge Base Article - Preview

2353737 - ORA-00959: tablespace 'PSAPTEMP' does not exist error in CREATE-SHADOW-SCHEMA phase of upgrade

Symptom

During the upgrade using Software update Manager (SUM), the tool stops in  CREATE-SHADOW-SCHEMA phase with following error in logs,

Directory: /SUM/sdt/log/SWITCH/CREATE-SHADOW-SCHEMA_XX.LOG:
=====================================
Aug 3, 2016 2:46:12 AM [Info  ]:   Standard out: /usr/sap/<SID>/SUM/sdt/log/SWITCH/DMT.CREATE_SCHEMA_XX_YY.OUT
Aug 3, 2016 2:46:12 AM [Info  ]: Process ID 342 has been started.
Aug 3, 2016 2:46:12 AM [Info  ]: Waiting for process ID 342, name java to finish.
Aug 3, 2016 2:46:15 AM [Info  ]: Process ID 342, name java has been finished, exit code 1.
Aug 3, 2016 2:46:15 AM [Info  ]: Process ID 342, name java has been terminated.
Aug 3, 2016 2:46:15 AM [Error ]: Error while executing command runhandler.
Aug 3, 2016 2:46:15 AM [Error ]: Return code condition success evaluated to false for process java for action runhandler.
Aug 3, 2016 2:46:15 AM [Error ]: The following problem has occurred during step execution: com.sap.sdt.db.dmtif.DMTProcessException: Could not complete DMT process. Check the DMT.CREATE_SCHEMA.LOG log file.
Could not execute DMT command runhandler with arguments /usr/sap/<SID>/SUM/sdt/config/DMT.CREATE_SCHEMA.xml.
Return code condition success evaluated to false for process java for action runhandler.
=====================================
Directory: /SUM/sdt/log/SWITCH/DMT.CREATE_SCHEMA_XX_YY.OUT:

===========================
DB object not found (code 959): ORA-00959: tablespace 'PSAPTEMP' does not exist
java.sql.SQLException: ORA-00959: tablespace 'PSAPTEMP' does not exist
SQL Exception code 1917: ORA-01917: user or role 'SAP<SID>SH' does not exist
java.sql.SQLException: ORA-01917: user or role 'SAP<SID>SH' does not exist
============================


Read more...

Environment

Performing release upgrade of JAVA stack using SUM.

Product

SAP NetWeaver 7.0

Keywords

ORA-00959, 959, PSAPTEMP, temporary, tablespace, create-shadow-schema, JAVA, upgrade, SUM, update, missing, role, user , KBA , BC-UPG-TLS-TLJ , Upgrade tools for Java , 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.