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]

Hello Folks,

After opening connection, SAP given a query to delete the entries which resolved the issue.The migration completed successfully.Below are the query given by SAP. Thank you all for the help and guidance.

-- Save a backup in table msssource_save

SELECT * into msssource_save from dev.MSSSOURCE

GO

-- Delete wrong lines from the scripts

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_atomic_defaultbind' AND DBRELEASE = 'B.0' AND LINENR > 72

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_atomic_defaultbind' AND DBRELEASE = 'B.0' AND LINENR > 95

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_atomic_drop_DF_constraint' AND DBRELEASE = 'B.0' AND LINENR > 71

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_atomic_drop_DF_constraint' AND DBRELEASE = 'B.0' AND LINENR > 79

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_check_ddl_allowed' AND DBRELEASE = 'B.0' AND LINENR > 92

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_check_ddl_allowed' AND DBRELEASE = 'B.0' AND LINENR > 98

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_all_objects' AND DBRELEASE = 'B.0' AND LINENR > 51

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_all_objects' AND DBRELEASE = 'B.0' AND LINENR > 57

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_dep_partobjs' AND DBRELEASE = 'B.0' AND LINENR > 55

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_dep_partobjs' AND DBRELEASE = 'B.0' AND LINENR > 64

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_index_id' AND DBRELEASE = 'B.0' AND LINENR > 68

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_index_id' AND DBRELEASE = 'B.0' AND LINENR > 74

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_index_storpars' AND DBRELEASE = 'B.0' AND LINENR > 139

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_index_storpars' AND DBRELEASE = 'B.0' AND LINENR > 145

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_index_storpars' AND DBRELEASE = 'B.0' AND LINENR > 167

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_index_type' AND DBRELEASE = 'B.0' AND LINENR > 115

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_index_type' AND DBRELEASE = 'B.0' AND LINENR > 120

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_index_type' AND DBRELEASE = 'B.0' AND LINENR > 134

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_locked_tables' AND DBRELEASE = 'B.0' AND LINENR > 65

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_locked_tables' AND DBRELEASE = 'B.0' AND LINENR > 69

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_object_type' AND DBRELEASE = 'B.0' AND LINENR > 61

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_object_type' AND DBRELEASE = 'B.0' AND LINENR > 68

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_pkc' AND DBRELEASE = 'B.0' AND LINENR > 79

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_pkc' AND DBRELEASE = 'B.0' AND LINENR > 85

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_single_table_of_index' AND DBRELEASE = 'B.0' AND LINENR > 64

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_single_table_of_index' AND DBRELEASE = 'B.0' AND LINENR > 70

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_sqltext' AND DBRELEASE = 'B.0' AND LINENR > 69

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_sqltext' AND DBRELEASE = 'B.0' AND LINENR > 92

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_table_columns' AND DBRELEASE = 'B.0' AND LINENR > 110

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_table_columns' AND DBRELEASE = 'B.0' AND LINENR > 120

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_table_storpars' AND DBRELEASE = 'B.0' AND LINENR > 115

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_table_storpars' AND DBRELEASE = 'B.0' AND LINENR > 119

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_tables_of_index' AND DBRELEASE = 'B.0' AND LINENR > 65

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_tables_of_index' AND DBRELEASE = 'B.0' AND LINENR > 72

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_triggers' AND DBRELEASE = 'B.0' AND LINENR > 52

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_get_triggers' AND DBRELEASE = 'B.0' AND LINENR > 58

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_helptext' AND DBRELEASE = 'B.0' AND LINENR > 72

DELETE FROM dev.MSSSOURCE  WHERE PROCNAME = 'sap_helptext' AND DBRELEASE = 'B.0' AND LINENR > 84