on 06-20-2016 1:09 PM
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.)
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
Hello Sairam,
I was referring other threads as well for resolution. I got through one of your ans to try
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
Hi Amarnatch,
Check if notes 2106205 - dipgntab failed with: ERROR in initialization (can't get R/3-version) and 2305826 - dipgntab - Initialization Error During Installation helps or not.
Regards,
Ning
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.