cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Error using SAP STM tool after a database copy

Former Member

on ‎11-06-2008 6:20 PM

0 Kudos

Dear all,

This issue appears during a system refresh. What I did:

Step 1: We are refreshing our quality system per the Production

database. The database has been restored and the database files renamed

(OK)

Step 2: To rename the pe1 schema to qe1 schema, we use the STM tool.

But the update finished with an error message (see joined document).

Step 3: I have used the SQL script user_change_sid.sql. This script

rename the old schema to the new one.

The result is the same. Some tables have been updated but not the totality.

Now, I am blocked and I cannot go further.

Thank you,

Fabrice CHAINE

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
‎02-02-2012 6:42 PM
0 Kudos

Hi Jeff

I faced the same issue during the refresh and solved it by following your note 1381061.

Thanks a lot for all your help

Regards

Uday

Show replies
Show replies
Former Member
‎02-05-2009 1:28 PM
0 Kudos

I have the same problem. how did you solve it?

sigal

Edited by: sigal dvorachek on Feb 5, 2009 2:30 PM

Show replies
Show replies
Former Member
‎02-05-2009 9:23 PM
0 Kudos

I did have some problems with STM and lots of strange errors.

This was due to the fact that STM expected itself to be on a CD or at the top of a drive

(E.g expecting the path D:\COMMON etc).

In order to solve the problem, I temporary, used the subst command to create an virtual disk.

Lets say you have unzipped STM under F:\install\STM and have not used disk X yet, then this commands helped me.

- start --> run

- cmd

- F:

- cd \install\STM

- subst X: . (<-- please note the "dot". its X:<space><dot>)

- X:

- cd \I386 (or X64 or IA64)

- sapinst

Former Member
‎02-12-2009 4:22 AM
0 Kudos

Were you able to get around this error? My STM folder is located on the root of the C drive.

Edited by: Tony Raimo on Feb 12, 2009 5:25 AM

Former Member
‎02-12-2009 5:12 AM
0 Kudos 
My STM folder is located on the root of the C drive

You're still need to move the folders "one step up".

Move all folders (COMMON,I386,X64...) under STM to C:\

or

open command prompt

c:

cd STM

subst X: .

start sapinst from X:

Former Member
‎03-31-2009 11:54 AM
0 Kudos

Did anyone find a fix to this issue? I'm having the exact same problem and can not figure this one out.

I tried the suggestion of creating the X: drive but that didn't work. I could really use a resoltuion to this.

Thanks,

Brian

Former Member
‎04-08-2009 2:47 PM
0 Kudos

Dear all,

This issue was caused by the transaction log file of MSSQL Server 2005. The error was appears when the STM tool delete a lot of stored procedures. This operation has filled completely the transactions log file.

The solution I found is to set the mode of the database to BULK-LOGGED before to lauch the STM tool.

Fabrice

Former Member
‎02-15-2010 8:51 AM
0 Kudos

See OSS Note 1381061 - this seems to fix this.

Former Member
‎11-06-2008 9:46 PM
0 Kudos

I know where are stored the log files. The copy of the above log come from this directory.

I have checked all the log file, but without success. Nothing explicit.

Show replies
Show replies
former_member204746
Active Contributor
‎11-06-2008 7:47 PM
0 Kudos

check logs:

Log files are written to C:\Program Files/sapinst_instdir/MSS/CPY

Show replies
Show replies
former_member204746
Active Contributor
‎11-06-2008 6:37 PM
0 Kudos

you forgot to join the document!

Show replies
Show replies
Former Member
‎11-06-2008 6:43 PM
0 Kudos

Sorry. It's the end of the file sapinst_dev.log

TRACE [iaxxejsexp.cpp:188]

EJS_Installer::writeTraceToLogBook()

tMSS_ScriptSubsts.insertRow(), inserting

TRACE [iaxxejsexp.cpp:188]

EJS_Installer::writeTraceToLogBook()

tMSS_ScriptSubsts.insertRow(), inserting

TRACE [iaxxejsbas.hpp:460]

EJS_Base::dispatchFunctionCall()

JS Callback has thrown unknown exception. Rethrowing.

ERROR 2008-11-06 17:09:31 [iaxxgenimp.cpp:728]

showDialog()

FCO-00011 The step MoveSchema with step key |SAPMSSTOOLS|ind|ind|ind|ind|0|0|MssSysCopy|ind|ind|ind|ind|4|0|MssSchemaMove|ind|ind|ind|ind|2|0|MoveSchema was executed with status ERROR .

TRACE [iaxxgenimp.cpp:657]

showDialog()

<html><head></head><body><p>An error occurred while processing service <b>SAP Toools for MS SQL Server > Database Copy</b>. You may now</p><ul> <li>press <I>Retry</I> to repeat the current step.</li> <li>press the <I>View Log</I> button to get more information about the error.</li> <li>stop the task and continue with it later.</li></ul><p>Log files are written to <b>C:\Program Files/sapinst_instdir/MSS/CPY</b>.</p></body></html>

TRACE [iaxxgenimp.cpp:1093]

showDialog()

waiting for an answer from gui

INFO 2008-11-06 17:09:48 [iaxxgenimp.cpp:779]

showDialog()

An error occured and the user decide to stop.\n Current step "|SAPMSSTOOLS|ind|ind|ind|ind|0|0|MssSysCopy|ind|ind|ind|ind|4|0|MssSchemaMove|ind|ind|ind|ind|2|0|MoveSchema".

ERROR 2008-11-06 17:09:31

lib=iamodmssql module=CIaNtMssDmo

MDB-05053 Errors when executing sql command: <p nr="0"/> If this message is displayed as a warning - it can be ignored. If this is an error - call your SAP support.

Ask a Question