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 ONE Support launchpad (Login required).

Search for additional results

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