Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

System Copy of ECC 5.0 from MSSQL 2005 to MSSQL 2008R2

Dear SCN Collegues,

I am trying to perform system copy of ECC 5.0 from MSSQL 2005 to MSSQL 2008 R2 both on Windows 2008R2 using detach / attach method.

Steps performed

1) Installed ECC 5.0 on MSSQL 2008R2 on Windows Server 2008 R2.

2) Detached the database.

3) Moved the DATA and LOG file to a different location.

4)Copied the DATA and LOG file of ECC 5.0 on MSSQL 2005 to the respective location on Target Database installed on MSSQL 2008R2.

5) Attached the DATA files to the target database on MSSQL 2008R2.

6) Renamed the DBSID to the target DBSID (as Source DBSID and Target DBSID are different) using MSSQL Database Studio 2008R2.

7) Ran STM on Target to perform post System copy activities.

Getting error in performing STM post system Copy(attched DB and Renamed) > Database Copy Completion> in phase

Create SAP Stored procedure

MDB-05053  Errors when executing sql command: [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared
<p> SOLUTION: If this message is displayed as a warning, you can ignore it. If this is an error, contact SAP support.</p>

TRACE      2013-11-22 17:39:57.337 [iaxxejsbas.hpp:488]
           EJS_Base::dispatchFunctionCall()
JS Callback has thrown unknown exception. Rethrowing.

ERROR      2013-11-22 17:39:57.361 [sixxcstepexecute.cpp:971]
FCO-00011  The step ExeProcs with step key |SAPMSSTOOLS|ind|ind|ind|ind|0|0|MssSysCopy|ind|ind|ind|ind|4|0|MssProcs|ind|ind|ind|ind|5|0|ExeProcs was executed with status ERROR ( Last error reported by the step: Errors when executing sql command: [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared
<p> SOLUTION: If this message is displayed as a warning, you can ignore it. If this is an error, contact SAP support.</p>).

TRACE      2013-11-22 17:39:57.409
  Call block:CallBackInCaseOfAnErrorDuringStepExecution
    function:CallTheLogInquirer
is validator: true

WARNING    2013-11-22 17:39:57.410 [iaxxejshlp.cpp:150]
Could not get property IDs of the JavaScript object.

ERROR      2013-11-22 17:39:57.411 [iaxxejsctl.cpp:492]
FJS-00010  Could not get value for property .

TRACE      2013-11-22 17:39:57.452
A problem occurs during execution the inquirer callback. SAPinst will switch back to the standard behaiviour.

TRACE      2013-11-22 17:39:57.452 [iaxxgenimp.cpp:707]
            CGuiEngineImp::showMessageBox

<html> <head> </head> <body> <p> An error occurred while processing option SAP Toools for MS SQL Server > Database Copy Completion( Last error reported by the step: Errors when executing sql command: [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared
<p> SOLUTION: If this message is displayed as a warning, you can ignore it. If this is an error, contact SAP support.</p>). You can now: </p> <ul> <li> Choose <i>Retry</i> to repeat the current step. </li> <li> Choose <i>View Log</i> to get more information about the error. </li> <li> Stop the option and continue with it later. </li> </ul> <p> Log files are written to C:\Program Files/sapinst_instdir/MSS/CPY. </p> </body></html>

TRACE      2013-11-22 17:39:57.453 [iaxxgenimp.cpp:1245]
           CGuiEngineImp::acceptAnswerForBlockingRequest
Waiting for an answer from GUI

TRACE      2013-11-22 16:54:02.515

Using custom value flow_trace for property SAPINST_MESSAGE_CONSOLE_THRESHOLD.

I may please be guided.

Thanks and Regards

Asadul Haq

Former Member
Not what you were looking for? View more on this topic or Ask a question