Skip to Content
0

SAP Solman Upgrade Error in Pre-Processing SQL92

Apr 19, 2017 at 11:29 AM

103

avatar image
Former Member

Hi All,


We are facing issues while upgrading Solman to Solman 7.2. We are in preprocessing phase. SUM tool is not able to create shadow schema. Below is the error log.

===================================================================


Apr 19, 2017 3:34:47 AM [Info ]: Standard out: /usr/sap/put/SUM_<SID>/SUM/sdt/log/SUM/DMT.CREATE_SCHEMA_17_01.OUT
Apr 19, 2017 3:34:47 AM [Info ]: Process ID 440 has been started.
Apr 19, 2017 3:34:47 AM [Info ]: Waiting for process ID 440, name java to finish.
Apr 19, 2017 3:34:50 AM [Info ]: Process ID 440, name java has been finished, exit code 1.
Apr 19, 2017 3:34:50 AM [Info ]: Process ID 440, name java has been terminated.
Apr 19, 2017 3:34:50 AM [Error ]: Error while executing command runhandler.
Apr 19, 2017 3:34:50 AM [Error ]: Return code condition success evaluated to false for process java for action runhandler.
Apr 19, 2017 3:34:50 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/put/SUM_<SID>/SUM/sdt/config/DMT.CREATE_SCHEMA.xml.
Return code condition success evaluated to false for process java for action runhandler.
.
===================================================================


Execution failed: Program has finished with error. Exit code: 1
Execution has been terminated. More information can be found in the log file /usr/sap/put/SUM_<SID>/SUM/sdt/log/DMT.CREATE_SCHEMA_17.LOG.
Could not execute DMT command runhandler. See previous messages.
Could not execute the list of statements.
SQL Exception code 17034: Non supported SQL92 token at position: 48: Y8AqZyO5A
java.sql.SQLException: Non supported SQL92 token at position: 48: Y8AqZyO5A
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


Return code: 1

I changed SID to <SID> for security reasons.

Thanks,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

James Zhang
Apr 20, 2017 at 02:57 AM
0

Hi Nikhil,

This looks like a pretty new error, so first please make sure you are using the latest SWPM.

Also attach sapisnt_dev.log to this discussion.

Best regards,
James

Share
10 |10000 characters needed characters left characters exceeded