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.

[Former Member]

I have contacted SAP and they have requested to run few query in regards to this... Its very slow respond from sap. I will update once there is a solution from SAP in regards to this.

example i have ran this query from sap and the result is empty/no selection. Still waiting for their feedback.

SELECT PROCNAME,LINENR,count(*) from sid.MSSSOURCE

where DBRELEASE='B.0'and SRCLINE like '---%sap_%---' group by PROCNAME,LINENR having count(*)>1

Note: I have also patched the target system mssql 2012 with SP3CU4.

Is that anything i can do to fix this issue or we really needed sap's expertise to resolve the issue ? Wondering how come others dont have such issue ?