Error Creating Stored Procedure -System copy migration

[#1]

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.

[cherry_tian · Accepted solution]

Hi, Peter

Based on past incidents, the current error on "Create SAP stored procedure" phase, is caused by some problem in stored procedure source table MSSSOURCE.

I suggest you create an incident and open the remote connection of target system in order to let SAP support engineer investigate the system directly.

Best regards,

Cherry