SAP R/3 4.6C Migration errors

[Former Member]

Hi Guys,

I'm currently migrating a SAP 4.6C system from Windows NT/MS SQL 7 to Windows 2003/MS SQL Server 2005. I'm already done with the export and installation of CI. I am now using DBMIG.R3S to create and load the database and currently in DBPROCEDURES_NT_MSS InternalInstallationDo phase when the installation aborted.

Here are some of the errors that I found in the DBMIG.log.

Warning: DBPOSTBUILD_NT_MSS CmdNGo 2 694

sp_addumpdevice 'tape','R3DUMP0','\\.\tape0'

Msg 15026, Level 16, State 1, Server FR712WAPP172\TM3, Procedure sp_addumpdevice, Line 74

Logical device 'R3DUMP0' already exists.

Error: DBPOSTBUILD_NT_MSS InternalInstallationDo 2 694

Could not execute the bufferes SQL line on the database server!

Info: DBPOSTBUILD_NT_MSS SyCoprocessCreate 2 694

Creating coprocess osql.exe ...

Warning: DBPOSTBUILD_NT_MSS CmdNGo 2 694

sp_addumpdevice 'tape','R3DUMP1','\\.\tape1'

Msg 15026, Level 16, State 1, Server FR712WAPP172\TM3, Procedure sp_addumpdevice, Line 74

Logical device 'R3DUMP1' already exists.

Error: DBPOSTBUILD_NT_MSS InternalInstallationDo 2 694

Could not execute the bufferes SQL line on the database server!

Info: DBPOSTBUILD_NT_MSS SyCoprocessCreate 2 694

Creating coprocess osql.exe ...

Warning: DBPOSTBUILD_NT_MSS CmdNGo 2 694

sp_addumpdevice 'tape','R3DUMP2','\\.\tape2'

Msg 15026, Level 16, State 1, Server FR712WAPP172\TM3, Procedure sp_addumpdevice, Line 74

Logical device 'R3DUMP2' already exists.

Error: DBPOSTBUILD_NT_MSS InternalInstallationDo 2 694

Could not execute the bufferes SQL line on the database server!

Creating Stored Procedures in the Database

Error: DBPROCEDURES_NT_MSS InternalInstallationDo 2 703

Could not find the SQL script PR39.SQL!

Error: DBPROCEDURES_NT_MSS InstallationDo 2 703

Phase failed.

Error: Main {} 2 703

Installation aborted.

I have attached the DBMIG.log. Any help would be greatly appreciated. Thank you!

DBMIG.log.txt.zip

[luisdarui · Accepted solution]

Hi Krisel,

The following errors indicates that those devices already exists in the target database:

    Msg 15026, Level 16, State 1, Server FR712WAPP172\TM3, Procedure sp_addumpdevice, Line 74

    Logical device 'R3DUMP0' already exists.

    Msg 15026, Level 16, State 1, Server FR712WAPP172\TM3, Procedure sp_addumpdevice, Line 74

    Logical device 'R3DUMP1' already exists.

    Msg 15026, Level 16, State 1, Server FR712WAPP172\TM3, Procedure sp_addumpdevice, Line 74

    Logical device 'R3DUMP2' already exists.

Perform the following query:

SELECT 'sp_dropdevice  ''' +name +'';'
GO'
FROM     sys.backup_devices

It will create a script as a result that you should copy and run again:

sp_dropdevice  'R3DUMP0;'
GO
sp_dropdevice  'R3DUMP1;'
GO
sp_dropdevice  'R3DUMP2;'
GO

After this you may retry the operation.

Best Regards,

Luis Darui

[Former Member · Accepted solution]

Hi Luis,

I have fixed the issue by copying the PR39 SQL script from SAP note 965145 to my installation folder (C:\Users\<SID>adm\Install) then performed export again and restarted the DBMIG.

Thanks for the reply anyway!

Best Regards,

Krisel Pineda