Solved: Error Creating Stored Procedure -System copy migra...

Hello All,

I have performing migration using R3load.

SAP Netweaver 7.0

Source System

Windows 2003,MSSQL 2005,32bit enviroment.

SAP NETWEAVER 7.0 Patch Level:SP30

Target System

Windows Server 2012R2,MSSQL2012 64bit enviroment

i have checked the sap product matrix and its supported. i also have checked the sap note 1651862 - Release planning for Microsoft SQL Server 2012

for minimum patch level which already in place. The mssql 2012 is up and running.

The import abap phase is completed.There is error during SAP stored procedure creation. Kindly help resolve the issue.

Error message in sapinst.log : Errors when executing sql command:Microsoft ODBC SQL Server Driver SQL Server incorrect syntax near the keyword else.Microsoft ODBC SQL Server Drive SQL Server must Declare the scalar variable@cmd.

Former Member · ‎2016 Aug 16

This would be the right logs from sapinst_dev.log

Kindly advise.

TRACE 2016-08-16 11:59:43.514 (DEVSVR\Administrator) [csistepexecute.cpp:1589]

SAPInst calls the LogInquirer. The output of the LogInquirer can be found in file sapinst_loginquirer.log.

TRACE 2016-08-16 11:59:43.515 (DEVSVR\Administrator) [csistepexecute.cpp:1596]

SAPInst calls the LogInquirer because of an error in execution of step |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_Postload|ind|ind|ind|ind|postload|0|NW_Postload_MSS|ind|ind|ind|ind|mss|0|MssProcs|ind|ind|ind|ind|mssProcs|0|ExeProcs.

TRACE 2016-08-16 11:59:43.521 (DEVSVR\Administrator) [syxxcfile.cpp:76] CSyFileImpl::decideIfMoveCopyNode(const CopyMoveDestinationInfo & {m_nodeTypeForCombiCheck: ..., m_path: C:/Program Files/sapinst_instdir/NW700/LM/COPY/MSS/SYSTEM/CENTRAL/AS-ABAP/sapinst_loginquirer.3.log, m_realNodeType: 8}, ISyNode::CopyMoveMode_t 0x3, PSyNode &) const

Target node does not exist and (mode & ISyNode::MISSING) ==> I will copy/move.

TRACE 2016-08-16 11:59:43.522 (DEVSVR\Administrator) [syxxcnode.cpp:430] CSyNodeImpl::move(const CSyPath & C:/Program Files/sapinst_instdir/NW700/LM/COPY/MSS/SYSTEM/CENTRAL/AS-ABAP/sapinst_loginquirer.3.log, ISyNode::CopyMoveMode_t 0x3)

Moved C:/Program Files/sapinst_instdir/NW700/LM/COPY/MSS/SYSTEM/CENTRAL/AS-ABAP/sapinst_loginquirer.log to C:/Program Files/sapinst_instdir/NW700/LM/COPY/MSS/SYSTEM/CENTRAL/AS-ABAP/sapinst_loginquirer.3.log

TRACE 2016-08-16 11:59:43.569 (DEVSVR\Administrator) [cguiengineimp.cpp:553] CGuiEngineImp::showMessageBox()

<html> <head> </head> <body> An error occurred while processing option SAP NetWeaver 7.0 Support Release 3 > Software Life-Cycle Options > System Copy > MS SQL Server > Target System Installation > Central System > Based on AS ABAP > Central System( Last error reported by the step: Errors when executing sql command: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'else'.

[Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@cmd".

SOLUTION: If this message is displayed as a warning, you can ignore it. If this is an error, contact SAP support. ). You can now: <ul> <li> Choose Retry to repeat the current step. </li> <li> Choose Log Files to get more information about the error. </li> <li> Stop the option and continue later. </li> </ul> Log files are written to C:\Program Files/sapinst_instdir/NW700/LM/COPY/MSS/SYSTEM/CENTRAL/AS-ABAP/. </body></html>

TRACE 2016-08-16 11:59:43.569 (DEVSVR\Administrator) [cguiengineimp.cpp:908] CGuiEngineImp::acceptAnswerForBlockingRequest

Waiting for an answer from GUI

INFO 2016-08-16 16:46:07.126 (DEVSVR\Administrator) [csistepexecute.cpp:1192] id=controller.userDecideToContine

An error occurred and the user decided to retry the current step: "|NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_Postload|ind|ind|ind|ind|postload|0|NW_Postload_MSS|ind|ind|ind|ind|mss|0|MssProcs|ind|ind|ind|ind|mssProcs|0|ExeProcs".

INFO 2016-08-16 16:46:07.129 (DEVSVR\Administrator) [synxccuren.cpp:881] id=syslib.process.currentProcessEnv.cwdSuccessful CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(const CSyPath & C:/Program Files/sapinst_instdir/NW700/LM/COPY/MSS/SYSTEM/CENTRAL/AS-ABAP)

Working directory changed to C:/Program Files/sapinst_instdir/NW700/LM/COPY/MSS/SYSTEM/CENTRAL/AS-ABAP.

TRACE 2016-08-16 16:46:07.148 (DEVSVR\Administrator) [syxxcfile.cpp:76] CSyFileImpl::decideIfMoveCopyNode(const CopyMoveDestinationInfo & {m_nodeTypeForCombiCheck: ..., m_path: C:/Program Files/sapinst_instdir/NW700/LM/COPY/MSS/SYSTEM/CENTRAL/AS-ABAP/stepLogMessages.4.xml, m_realNodeType: 8}, ISyNode::CopyMoveMode_t 0x3, PSyNode &) const

Target node does not exist and (mode & ISyNode::MISSING) ==> I will copy/move.

TRACE 2016-08-16 16:46:07.150 (DEVSVR\Administrator) [syxxcnode.cpp:430] CSyNodeImpl::move(const CSyPath & C:/Program Files/sapinst_instdir/NW700/LM/COPY/MSS/SYSTEM/CENTRAL/AS-ABAP/stepLogMessages.4.xml, ISyNode::CopyMoveMode_t 0x3)

Moved C:/Program Files/sapinst_instdir/NW700/LM/COPY/MSS/SYSTEM/CENTRAL/AS-ABAP/stepLogMessages.xml to C:/Program Files/sapinst_instdir/NW700/LM/COPY/MSS/SYSTEM/CENTRAL/AS-ABAP/stepLogMessages.4.xml

TRACE 2016-08-16 16:46:07.237 (DEVSVR\Administrator) [csistepexecute.cpp:1029]

Execution of preprocess block of |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_Postload|ind|ind|ind|ind|postload|0|NW_Postload_MSS|ind|ind|ind|ind|mss|0|MssProcs|ind|ind|ind|ind|mssProcs|0|ExeProcs returns TRUE

TRACE 2016-08-16 16:46:07.254 (DEVSVR\Administrator)

tMSS_ScriptSubsts.remove(WHERE 1=1)

TRACE 2016-08-16 16:46:07.261 (DEVSVR\Administrator)