System Copy Problem

[Former Member]

Dear SAP Experts,

am planning to upgrade our ECC 6.0 System from

Windows Server 2003 X32

MS SQL 2005

Non Unicode

to

Windows Server 2008

MS SQL 2013

non Unicode

in the next month. I will do it with a System Copy (Backup & Restore). At the moment i make first tests with a sandbox server. The System Copy stops at phase "Post Load activities"

R3Trans -d:

*******************************

This is D:\usr\sap\XX1\SYS\exe\nuc\NTAMD64\R3trans.exe version 6.14 (release 700

- 24.07.12 - 20:12:04 ).

2EETW169 no connect possible: "DBMS = MSSQL                            ---  SERV

ER = 'SAPSERVER' DBNAME = 'XX1'"

D:\usr\sap\XX1\SYS\exe\nuc\NTAMD64\R3trans.exe finished (0012).

*******************************

sapinst.log

********************************

INFO 2013-09-19 15:30:16.714

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

INFO 2013-09-19 15:30:17.113

Creating file C:\Program Files\sapinst_instdir\ERP\LM\COPY\MSS\SYSTEM\CENTRAL\AS-ABAP\dipgntab.log.

INFO 2013-09-19 15:30:17.136

Output of D:\usr\sap\XX1\SYS\exe\nuc\NTAMD64\dipgntab.exe -rwr40 -srctt DDNTT -srctf DDNTF -dsttt DDNTT -dsttf DDNTF -ttonly TT is written to the logfile dipgntab.log.

WARNING 2013-09-19 15:30:17.584

Execution of the command "D:\usr\sap\XX1\SYS\exe\nuc\NTAMD64\dipgntab.exe -rwr40 -srctt DDNTT -srctf DDNTF -dsttt DDNTT -dsttf DDNTF -ttonly TT" finished with return code -1. Output:

D:\usr\sap\\D00\log\SLOG00.LOG: No such file or directory

D:\usr\sap\\D00\log\SLOG00.LOG: No such file or directory

ERROR in initialization (can't get R/3-version)

ERROR in initialization (can't get R/3-version)

rslgwr1(20): rstrbopen cannot open pre-existing SysLog file.

rslgwr1(11): rstrbopen cannot open SysLog file.

SysLog:iE1020130919153017000000000000  this TTY           

      :                                                            0000

      :SCSA         4096                                              

SysLog:gBY220130919153017000000000000  this TTY           

      :                                                            0000

           CON                                           dblink  433

SysLog: BY020130919153017000000000000  this TTY           

      :                                                            0000

      :

ERROR 2013-09-19 15:30:17.589

CJS-30023  Process call 'D:\usr\sap\XX1\SYS\exe\nuc\NTAMD64\dipgntab.exe -rwr40 -srctt DDNTT -srctf DDNTF -dsttt DDNTT -dsttf DDNTF -ttonly TT' exits with error code -1. For details see log file(s) dipgntab.log.

ERROR 2013-09-19 15:30:17.618

FCO-00011  The step adjustNametab with step key |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|2|0|adjustNametab was executed with status ERROR ( Last error reported by the step: Process call 'D:\usr\sap\XX1\SYS\exe\nuc\NTAMD64\dipgntab.exe -rwr40 -srctt DDNTT -srctf DDNTF -dsttt DDNTT -dsttf DDNTF -ttonly TT' exits with error code -1. For details see log file(s) dipgntab.log.).

INFO 2013-09-19 15:30:17.878

Creating file C:\Program Files\sapinst_instdir\ERP\LM\COPY\MSS\SYSTEM\CENTRAL\AS-ABAP\__instana_tmp.xml.

*******************************************

I tried to use the latest kernel and set the enviroment variable MSSQL_FORCEOLEDB = 1 but it wasn´t helpful.

Any Idea what i can try?

Best regards,

Klaus

[Former Member · Accepted solution]

Hi Experts,

thanks a lot for the answers.

1. I tried 'schema repair script' as per note 1294762. Restarted the macine and continued the installation --> No effect

2. There is no Directory "D:\usr\sap\\D00\" I created it, restarted the macine and continued the installation

--> No effect

3. The installation is EHP0. Basic Patchlevel SAPKB70028

4. It is a domain installation SIDadm and SAPServiceSID are local Administrators. I tried the installation with SIDadm and Domain Administrator user.

5. trans.log

******************************************

4 ETW000 D:\usr\sap\XX1\SYS\exe\nuc\NTAMD64\R3trans.exe version 6.14 (release 700 - 24.07.12 - 20:12:04 ).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 19.09.2013 - 16:00:32

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: D:\usr\sap\XX1\SYS\exe\nuc\NTAMD64\R3trans.exe -d

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Thu Sep 19 16:00:32 2013                                                   0  0.000000

4 ETW000  [     dev trc,00000]  db_con_init called                                                         0  0.000000

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                  0  0.000000

4 ETW000  [     dev trc,00000]  Loading DB library 'dbmssslib.dll' ...                                     0  0.000000

4 ETW000  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 0000000187740000

4 ETW000                                                                                                3374  0.003374

4 ETW000  [     dev trc,00000]      using "D:\usr\sap\XX1\SYS\exe\nuc\NTAMD64\dbmssslib.dll"              17  0.003391

4 ETW000  [     dev trc,00000]  Library 'dbmssslib.dll' loaded                                            17  0.003408

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library dbmssslib.dll                    20  0.003428

4 ETW000  [     dev trc,00000]  Version of 'dbmssslib.dll' is "700.08", patchlevel (0.350)                45  0.003473

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library dbmssslib.dll                  375  0.003848

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library dbmssslib.dll                  21  0.003869

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  30  0.003899

4 ETW000  [     dev trc,00000]  000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                                                  41  0.003940

4 ETW000  [     dev trc,00000]  db_con_connect (con_name=R/3)                                             21  0.003961

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection for reuse:                14  0.003975

4 ETW000  [     dev trc,00000]  000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                                                  36  0.004011

4 ETW000  [     dev trc,00000]  Thread ID:5896                                                          2605  0.006616

4 ETW000  [     dev trc,00000]  Thank You for using the SLOLEDB-interface                                 28  0.006644

4 ETW000  [     dev trc,00000]  Using dynamic link library 'D:\usr\sap\XX1\SYS\exe\nuc\NTAMD64\dbmssslib.dll'

4 ETW000                                                                                                  39  0.006683

4 ETW000  [     dev trc,00000]  dbmssslib.dll patch info                                                  77  0.006760

4 ETW000  [     dev trc,00000]    patchlevel   0                                                          17  0.006777

4 ETW000  [     dev trc,00000]    patchno      350                                                        55  0.006832

4 ETW000  [     dev trc,00000]    patchcomment Work process can not be cancelled (1740162)                20  0.006852

4 ETW000  [     dev trc,00000]  np:(local) connection used on Server1                               27  0.006879

4 ETW000  [     dev trc,00000]  CopyLocalParameters: dbuser is 'XX1'                                      16  0.006895

4 ETW000  [     dev trc,00000]  Provider SQLNCLI could not be initialized. See note #734034 for more information.

4 ETW000                                                                                               14477  0.021372

4 ETW000  [     dev trc,00000]  Using provider SQLOLEDB instead.                                          19  0.021391

4 ETW000  [     dev trc,00000]  OpenOledbConnection: MARS property was not set.                          260  0.021651

4 ETW000  [     dev trc,00000]  Provider Release:06.01.7601                                            25324  0.046975

4 ETW000  [     dev trc,00000]  Provider SQLNCLI could not be initialized. See note #734034 for more information.

4 ETW000                                                                                                1669  0.048644

4 ETW000  [     dev trc,00000]  Using provider SQLOLEDB instead.                                          17  0.048661

4 ETW000  [     dev trc,00000]  Cache sizes: header 88 bytes, 100 names (140800 bytes), 100 dynamic statements (551200 bytes), total 692088 bytes

4 ETW000                                                                                                9289  0.057950

4 ETW000  [     dev trc,00000]  Initializing private procedure name cache.                                21  0.057971

4 ETW000  [     dev trc,00000]  procedure cache created/attached                                          22  0.057993

4 ETW000  [     dev trc,00000]  Connected to db server : [Server1] server_used : [np:(local)], dbname: XX1, dbuser: XX1

4 ETW000                                                                                                  27  0.058020

4 ETW000  [     dev trc,00000]  pn_id:Server1_XX1XX1_XX1                                            14  0.058034

4 ETW000  [     dev trc,00000]  You must use SNAC to access SQL 9.0 or later.  See note #734034           17  0.058051

4 ETW000  [    dblink  ,00433]  ***LOG BY2=>sql error 0      performing CON [dblink#8 @ 433]              54  0.058105

4 ETW000  [    dblink  ,00433]  ***LOG BY0=><message text not available> [dblink#8 @ 433]                 19  0.058124

2EETW169 no connect possible: "DBMS = MSSQL                            ---  SERVER = 'Server1' DBNAME = 'XX1'"

******************************************

6. dipgntab.log

******************************************

D:\usr\sap\\D00\log\SLOG00.LOG: No such file or directory

D:\usr\sap\\D00\log\SLOG00.LOG: No such file or directory

ERROR in initialization (can't get R/3-version)

ERROR in initialization (can't get R/3-version)

rslgwr1(20): rstrbopen cannot open pre-existing SysLog file.

rslgwr1(11): rstrbopen cannot open SysLog file.

SysLog:iE1020130919153017000000000000  this TTY           

      :                                                            0000

      :SCSA         4096                                              

SysLog:gBY220130919153017000000000000  this TTY           

      :                                                            0000

           CON                                           dblink  433

SysLog: BY020130919153017000000000000  this TTY           

      :                                                            0000   :                                                      

******************************************

I hope i answered all questions 🙂

Best regards,

Klaus

[JPReyes · Accepted solution]

D:\usr\sap\\D00\log\SLOG00.LOG: No such file or directory

Ok, this is odd, if you are doing a System Copy then this should be a Central Instance, so path should be something like D:\usr\sap\DVEBMSG00...  Are you using the right installation master /SWPM?

For the R3trans issue, read

SAP Note 734034 - Native OLEDB provider SQLNCLI

Regards,

Juan

[Former Member · Accepted solution]

I am using this Master:

--> 51043738_2 NW 7.0 SR3 Inst.Mast WIN Svr x86 64 bit-BR MSS 2012

Option:

SAP ERP 6.0 Support Release 3 > Software Life-Cycle Options > System Copy > MS SQL Server > Target System Installation > Central System > Based on AS ABAP > Central System

The path of the Installation is D:\usr\sap\XX11\SYS

I read note 734034 . So i deleted enviroment variable MSSQL_FORCEOLEDB because i am using SQL 2012.

SQL Server Native Client 2012 is already installed.

[JPReyes · Accepted solution]

Try using SWPM instead,

This is a good guide written by Akshay Gupta

http://scn.sap.com/community/netweaver-administrator/blog/2013/08/21/swpm-variants-70swpm-or-swpm

Regards, Juan

[former_member183107]

Hi,

As you have used db backup restore method,have you used the VB Script attached in the sap note 1294762 as it refers to the Schema repair and schema move scripts.
The zip file Schema4SAP.zip is attached to this note.

Also please find the below link as it contains all the imp. notes on sql server:-
  http://scn.sap.com/docs/DOC-8286

Regards,

Himanshu

[Former Member]

Problem is solved. Thanks Juan Reyes. I switched to SWPM and everything is fine now.

[chris_johnson3]

Which version are you running for ECC6? (i.e. EHP1/2/3/4 ...)

Look at note 1651862  which talks about minimum SP Levels

[Reagan]

 For details see log file(s) dipgntab.log.)

Regards

RB

[Former Member]

Hi,

Can you please check whether log directory exists  in D:\usr\sap\\D00\ location?

If not, try to create and retry the sapinst...

I believe you are using either user with local administrator access. if not, try to do that.

Thanks and Regards,

Vimal

[hugo_amo]

Hi Klaus,

Can you run the 'schema repair script' as per note 1294762? You must be logged on as domain administrator.

After that, check if it works. If so, restart sapinst (again with domain administrator user) and retry the current step.

Hope it helps.

Regards,

Hugo

[paul_power]

Hi Klaus,

Please post the contents of

C:\Program Files\sapinst_instdir\ERP\LM\COPY\MSS\SYSTEM\CENTRAL\AS-ABAP\dipgntab.log

as it could give further clues as to the cause of the error.

regards,

Paul

[JPReyes]

R3trans.exe finished (0012).

Can you post the trans.log?

written to the logfile dipgntab.log

Also post  dipgntab.log

Regards, Juan