cancel
Showing results for 
Search instead for 
Did you mean: 

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

Amarnath
Participant
0 Kudos

Hi Experts,

We are doing migration from Linux/Oracle to Windows 2008 R2/MSSQL 2008 SP3. Previous SAP version is N/W 7.00 SP14, ECC 6.0  and old kernel 700 with 600 patch. We are only doing OS/DB migration without upgrade.

We have installed MSSQL 2008 and applied SP3 Patch.

We took Kernel 721 REL with 600 patch along with SL Controller  700 (51039102_13  (Earlier system has 700 release).

SWPM has run up to execution phase.

After this we stuck with an error in Phase “post load”

Notes verified:

http://service.sap.com/sap/support/notes/1817692

http://service.sap.com/sap/support/notes/1480785

SCN Thread:

https://scn.sap.com/thread/3686626

Please advice we are executing these with local OS administrator not SIDADM. Is this something related to MSSQL Authorization issue?

SWPM ERROR:

An error occurred while processing option SAP Business Suite 2005 > 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( Last error reported by the step: Process call 'D:\usr\sap\IVP\SYS\exe\uc\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.)

  1. Dipgntab.log

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

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

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

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

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

rslgwr1(11): rstrbopen cannot open SysLog file.

SysLog:iE1020160616124458000000000000 this TTY           

: 0000

:SCSA 4096

SysLog:hBZA20160616124458000000000000 this TTY           

: 0000

:SVERS dblink  1327

Best Regards,

Amarnath.

Accepted Solutions (0)

Answers (2)

Answers (2)

Sriram2009
Active Contributor
0 Kudos

Hi Amarnath.

I think you have to upgrade the latest kernel 7.21 in target system. Download the latest kernel and update and then retry the same phase.

Kindly check this SAP notes

2106205 - dipgntab failed with: ERROR in initialization (can't get R/3-version)


2305826 - dipgntab - Initialization Error During Installation


BR

SS

Amarnath
Participant
0 Kudos

Hi Ning/SaiRam,

As per note 206205 I have checked R3trans -d result.

Trans.log

4 ETW000 r3trans version 6.24 (release 721 - 12.04.16 - 20:16:02).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 21.06.2016 - 08:01:50

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

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

4 ETW000  [     dev trc,00000]  Tue Jun 21 08:01:51 2016

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

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

4 ETW000  [     dev trc,00000]  Version of 'dbmssslib.dll' is "721.02", patchlevel (0.700)

4 ETW000  [     dev trc,00000]  Thread ID:5512

4 ETW000  [     dev trc,00000]  Thank You for using the SLODBC-interface

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

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

4 ETW000  [     dev trc,00000]    SAP patchlevel  0

4 ETW000  [     dev trc,00000]    SAP patchno  700

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchno         700

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchcomment Support Package Stack Kernel 721 (EXT) Patch Level 700 (2316471)

4 ETW000  [     dev trc,00000]  ODBC Driver chosen: SQL Server Native Client 10.0 native

4 ETW000  [     dev trc,00000]  Local connection used on hostname to named instance: lpc:hostname\SID

4 ETW000  [     dev trc,00000]  Local connection used on hostname to named instance: lpc:hostname\SID

4 ETW000  [     dev trc,00000]  Local connection used on hostname to named instance: lpc:hostname\SID

4 ETW000  [     dev trc,00000]  Driver: sqlncli10.dll Driver release: 10.50.6000

4 ETW000  [     dev trc,00000]  GetDbRelease: 10.50.6000.34

4 ETW000  [     dev trc,00000]  GetDbRelease: Got DB release numbers (10,50,6000,34)

4 ETW000  [     dev trc,00000]  ERROR: expected dbuser(SID) is not the same as the actual dbuser (dbo).

4 ETW000  [     dev trc,00000]  ERROR: schema user SID has administrator fixed server role (user_name() is 'dbo').

4 ETW000  [     dev trc,00000]         This is not allowed.  Please check the Server Roles of user SID.

2EETW169 no connect possible: "DBMS = MSSQL                            ---  SERVER = 'hostname\SID' DBNAME = 'SID'"

Above is the result. Please tell me how to proceed with this.

Best Regards,

Amarnath

Sriram2009
Active Contributor
0 Kudos

Hi Amarnath.

1.  On Windows SIDADM & SAPServiceSID user id's as part of local administrator group?

2. Have you executed the R3trans -d on SIDADM user id?

BR

SS

Amarnath
Participant
0 Kudos

HI Sairam,

Yes I have executed R3trans -d with SIDADM. Yes both the users you have specified are part of local administrators group.

Best Regards,

Amarnath

Amarnath
Participant
0 Kudos

Hi Sairam,

If I execute R3trans -d with the user I am installing I am getting below result,

D:\usr\sap\SID\SYS\exe\uc\NTAMD64>R3trans -d

This is R3trans version 6.24 (release 721 - 12.04.16 - 20:16:02).

unicode enabled version

R3trans=>sapparam(1c): No Profile used.

R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

R3trans finished (0012).

D:\usr\sap\SID\SYS\exe\uc\NTAMD64>dipgntab.exe -rwr40 -srctt DDNTT -srctf DDNTF

-dsttt DDNTT -dsttf DDNTF -ttonly TT

unknown parameter " -rwr40"ERROR in initialization (can't get SVERS-version)

D:\usr\sap\SID\SYS\exe\uc\NTAMD64>dipgntab.exe -rwr40 -srctt DDNTT -srctf DDNTF

-dsttt DDNTT -dsttf DDNTF -ttonly TT

ERROR in initialization (can't get SVERS-version)

ERROR in initialization (can't get SVERS-version)

Best Regards,

Amarnath

Sriram2009
Active Contributor
0 Kudos

Hi Amarnath

Check this two settings

1. "dbms_type=MSS" is properly set in the instance profiles.

2. OS environment variable "dbms_type=MSS" is properly set for OS user <sid>adm

BR

SS

Amarnath
Participant
0 Kudos

Hello Sairam,

We only have default profile and we have "dbms/type = mss" in it.

For SIDADM we have "DBMS_TYPE mss"  set.

Best Regards,

Amarnath

Sriram2009
Active Contributor
0 Kudos

Hi Amarnath.

1. Check the r3trans -d are you getting same error message? if it is ok you can retry the

2.  Refer the SAP note 98678 - SQL Server Connection Issues


BR

SS

Amarnath
Participant
0 Kudos

Hello Sairam,

I was referring other threads as well for resolution. I got through one of your ans to try

1294762 - SCHEMA4SAP.VBS


Even above script did not work for me. Below is the output of r3trans -d executed with SIDADM.


Also just to give a try I have searched for SVERS in SQL as


use SID

go

select * from SID.sid.SVERS

go


Output: Invalid object name SID.sid.SVERS


Tried the same like select * from SID.SVERS ,,, sid.SVERS,,, SVERS etc but the result was same.


4 ETW000 R3trans version 6.24 (release 721 - 12.04.16 - 20:16:02).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 23.06.2016 - 01:44:12

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000  [     dev trc,00000]  Thu Jun 23 01:44:12 2016

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

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

4 ETW000  [     dev trc,00000]  Version of 'dbmssslib.dll' is "721.02", patchlevel (0.700)

4 ETW000  [     dev trc,00000]  Thread ID:4008

4 ETW000  [     dev trc,00000]  Thank You for using the SLODBC-interface

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

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

4 ETW000  [     dev trc,00000]    SAP patchlevel  0

4 ETW000  [     dev trc,00000]    SAP patchno  700

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchno         700

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchcomment Support Package Stack Kernel 721 (EXT) Patch Level 700 (2316471)

4 ETW000  [     dev trc,00000]  ODBC Driver chosen: SQL Server Native Client 10.0 native

4 ETW000  [     dev trc,00000]  Local connection used on HOSTNAME to named instance: lpc:HOSTNAME\SID

4 ETW000  [     dev trc,00000]  Thu Jun 23 01:44:13 2016

4 ETW000  [     dev trc,00000]  Local connection used on HOSTNAME to named instance: lpc:HOSTNAME\SID

4 ETW000  [     dev trc,00000]  Local connection used on HOSTNAME to named instance: lpc:HOSTNAME\SID

4 ETW000  [     dev trc,00000]  Driver: sqlncli10.dll Driver release: 10.50.6000

4 ETW000  [     dev trc,00000]  GetDbRelease: 10.50.6000.34

4 ETW000  [     dev trc,00000]  GetDbRelease: Got DB release numbers (10,50,6000,34)

4 ETW000  [     dev trc,00000]  ERROR: -1 in function CheckCodepageType (SQLExecDirect failed) [line 22233]

4 ETW000  [     dev trc,00000]  (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'DBPROPERTIES'.

4 ETW000  [     dev trc,00000]  comm. rd. spid 53

4 ETW000  [     dev trc,00000]  unc. rd. spid 54

4 ETW000  [     dev trc,00000]  Connection 0 opened (DBSL handle 0)

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 15183]

4 ETW000  [     dev trc,00000]  (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'SVERS'.

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 15183]

4 ETW000  [     dev trc,00000]  (8180) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.

4 ETW000  [     dev trc,00000]  Error 103 (dbcode 208) in StartSelect

4 ETW000  [     dev trc,00000]  StartSelect: stmt of NULL_STMTID

4 ETW000  [     dev trc,00000]  SELECT VERSION FROM SVERS

4 ETW000                        /* R3::0 T:SVERS */

4 ETW000  [    dblink  ,00000]  ***LOG BZA=>table SVERS does not exist on database

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 15183]

4 ETW000  [     dev trc,00000]  (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'DDNTT'.

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 15183]

4 ETW000  [     dev trc,00000]  (8180) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.

4 ETW000  [     dev trc,00000]  Error 103 (dbcode 208) in StartSelect

4 ETW000  [     dev trc,00000]  StartSelect: stmt of NULL_STMTID

4 ETW000  [     dev trc,00000]  SELECT COMPCNT, UNICODELG FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:DDNTT

4 ETW000  [     dev trc,00000]   */

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 15183]

4 ETW000  [     dev trc,00000]  (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'DDNTT'.

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 15183]

4 ETW000  [     dev trc,00000]  (8180) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.

4 ETW000  [     dev trc,00000]  Error 103 (dbcode 208) in StartSelect

4 ETW000  [     dev trc,00000]  StartSelect: stmt of NULL_STMTID

4 ETW000  [     dev trc,00000]  SELECT VERSION FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:DDNTT */

4 ETW000  [dbntab.c    ,00000]  *** ERROR => NTAB: SELECT VERSION FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc=103

4 ETW000  [    dbntab  ,00000]  ***LOG BZY=>unexpected return code 103 calling NTAB

4 ETW000  [     dev trc,00000]  NTAB: db_ntab(): init_ntab failed, returning 2

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 15183]

4 ETW000  [     dev trc,00000]  (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'XXXXT'.

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 15183]

4 ETW000  [     dev trc,00000]  (8180) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.

4 ETW000  [     dev trc,00000]  Error 103 (dbcode 208) in StartSelect

4 ETW000  [     dev trc,00000]  StartSelect: stmt of NULL_STMTID

4 ETW000  [     dev trc,00000]  SELECT COMPCNT, UNICODELG FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:XXXXT

4 ETW000  [     dev trc,00000]   */

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 15183]

4 ETW000  [     dev trc,00000]  (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'XXXXT'.

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 15183]

4 ETW000  [     dev trc,00000]  (8180) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.

4 ETW000  [     dev trc,00000]  Error 103 (dbcode 208) in StartSelect

4 ETW000  [     dev trc,00000]  StartSelect: stmt of NULL_STMTID

4 ETW000  [     dev trc,00000]  SELECT VERSION FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:XXXXT */

4 ETW000  [dbntab.c    ,00000]  *** ERROR => NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc=103

4 ETW000  [    dbntab  ,00000]  ***LOG BZY=>unexpected return code 103 calling NTAB

4 ETW000  [     dev trc,00000]  NTAB: db_ntab(): init_ntab failed, returning 2

2EETW000 sap_dext called with msgnr "2":

2EETW000 ---- db call info ----

2EETW000 function:   db_ntab

2EETW000 fcode:      NT_RDTDESCR

2EETW000 tabname:    TADIR

2EETW000 len (char): 5

2EETW000 key:        TADIR

2EETW000 retcode:    2

4 ETW690 ROLLBACK "0" "0"

Can you guide me from this?

Best Regards,

Amarnath

former_member182967
Active Contributor
0 Kudos