on 11-19-2014 8:33 AM
Hi Shashank,
Paste the log file SAPKK-707BHINBICONT.SL7
Also do check the sapnote 556232 - Environment settings for R/3/Oracle on Windows
With Regards
Ashutosh Chaturvedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I dont see that file in tmp folder :S
here is log for r3trans.out
SAPup> Starting subprocess in phase 'PREIMP' at 20141118124733
ENV: DBMS_TYPE=mss
ENV: JAVA_HOME=C:\usr\sap\SL7\DVEBMGS01\exe\sapjvm_4
ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
ENV: PATH=C:\usr\sap\SL7\SYS\exe\uc\NTAMD64;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\
ENV: SAPSYSTEMNAME=SL7
ENV: rsdb_ssfs_connect=0
EXECUTING C:\usr\sap\SL7\SYS\exe\uc\NTAMD64\R3trans.EXE -w F:\sum\SUM\abap\tmp\R710VPE.SL7 -u 1 F:\sum\SUM\abap\tmp\PREIMPTRANS.CTL
This is C:\usr\sap\SL7\SYS\exe\uc\NTAMD64\R3trans.EXE version 6.24 (release 721 - 26.09.13 - 20:13:07 ).
unicode enabled version
C:\usr\sap\SL7\SYS\exe\uc\NTAMD64\R3trans.EXE finished (0000).
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
SAPup> Starting subprocess in phase 'DBCONNCHK_INI' at 20141118180402
ENV: DBMS_TYPE=mss
ENV: JAVA_HOME=C:\usr\sap\SL7\DVEBMGS01\exe\sapjvm_4
ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
ENV: PATH=F:\sum\SUM\abap\exe;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\usr\sap\SL7\SYS\exe\uc\NTAMD64
ENV: SAPSYSTEMNAME=SL7
ENV: dbs_mss_schema=sl7
ENV: rsdb_ssfs_connect=0
EXECUTING F:\sum\SUM\abap\exe\R3trans.EXE -d -w F:\sum\SUM\abap\log\DBCONNCHK.LOG
This is F:\sum\SUM\abap\exe\R3trans.EXE version 6.24 (release 721 - 26.09.13 - 20:13:07 ).
unicode enabled version
F:\sum\SUM\abap\exe\R3trans.EXE finished (0000).
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
4 ETW000 F:\sum\SUM\abap\exe\R3trans.EXE version 6.24 (release 721 - 26.09.13 - 20:13:07 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 18.11.2014 - 18:04:02
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: F:\sum\SUM\abap\exe\R3trans.EXE -d -w F:\sum\SUM\abap\log\DBCONNCHK.LOG
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [ dev trc,00000] Tue Nov 18 18:04:02 2014 153 0.000153
4 ETW000 [ dev trc,00000] db_con_init called 91 0.000244
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0)
4 ETW000 189 0.000433
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 43 0.000476
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 21 0.000497
4 ETW000 [ dev trc,00000] Loading DB library 'dbmssslib.dll' ... 440 0.000937
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 000007FBEB270000
4 ETW000 1275 0.002212
4 ETW000 [ dev trc,00000] using "F:\sum\SUM\abap\exe\dbmssslib.dll" 23 0.002235
4 ETW000 [ dev trc,00000] Library 'dbmssslib.dll' loaded 25 0.002260
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbmssslib.dll 35 0.002295
4 ETW000 [ dev trc,00000] Version of 'dbmssslib.dll' is "721.02", patchlevel (0.136) 453 0.002748
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbmssslib.dll 68 0.002816
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbmssslib.dll 25 0.002841
4 ETW000 [ dev trc,00000] New connection 0 created 42 0.002883
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 54 0.002937
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 27 0.002964
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 31 0.002995
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 21 0.003016
4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 46 0.003062
4 ETW000 [ dev trc,00000] Tue Nov 18 18:04:03 2014 152756 0.155818
4 ETW000 [ dev trc,00000] Thread ID:13244 117 0.155935
4 ETW000 [ dev trc,00000] Thank You for using the SLODBC-interface 49 0.155984
4 ETW000 [ dev trc,00000] Using dynamic link library 'F:\sum\SUM\abap\exe\dbmssslib.dll' 31 0.156015
4 ETW000 [ dev trc,00000] dbmssslib.dll patch info 93 0.156108
4 ETW000 [ dev trc,00000] SAP patchlevel 0 132 0.156240
4 ETW000 [ dev trc,00000] SAP patchno 201 27 0.156267
4 ETW000 [ dev trc,00000] Last MSSQL DBSL patchlevel 0 44 0.156311
4 ETW000 [ dev trc,00000] Last MSSQL DBSL patchno 136 44 0.156355
4 ETW000 [ dev trc,00000] Last MSSQL DBSL patchcomment Prevent function sequence error in DSQL (1880067)
4 ETW000 35 0.156390
4 ETW000 [ dev trc,00000] ODBC Driver chosen: SQL Server Native Client 10.0 native 32040 0.188430
4 ETW000 [ dev trc,00000] lpc:(local) connection used on VMSAPECCEHP6 208 0.188638
4 ETW000 [ dev trc,00000] lpc:(local) connection used on VMSAPECCEHP6 88761 0.277399
4 ETW000 [ dev trc,00000] lpc:(local) connection used on VMSAPECCEHP6 7162 0.284561
4 ETW000 [ dev trc,00000] Driver: sqlncli10.dll Driver release: 10.50.1702 11771 0.296332
4 ETW000 [ dev trc,00000] GetDbRelease: 10.50.1702.00 22794 0.319126
4 ETW000 [ dev trc,00000] GetDbRelease: Got DB release numbers (10,50,1702,0) 59 0.319185
4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0) 40080 0.359265
4 ETW000 [ dev trc,00000] NTAB: Structure of NTAB on DB is VERS_B 264176 0.623441
4 ETW000 [ dev trc,00000] NTAB: unicodelg of executable is 2 50 0.623491
4 ETW000 [ dev trc,00000] NTAB: unicodelg of SVERS in nametab is 2 26 0.623517
4 ETW000 [ dev trc,00000] NTAB: standalone processing 164 0.623681
4 ETW000 [ dev trc,00000] NTAB: ntprofile(), read profile 28 0.623709
4 ETW000 [ dev trc,00000] NTAB: rsdb/ntab/entrycount 1000. 24 0.623733
4 ETW000 [ dev trc,00000] NTAB: rsdb/ntab/ftabsize 500. 23 0.623756
4 ETW000 [ dev trc,00000] NTAB: rsdb/ntab/irbdsize 100. 23 0.623779
4 ETW000 [ dev trc,00000] NTAB: rsdb/ntab/sntabsize 100. 23 0.623802
4 ETW000 [ dev trc,00000] NTAB: compute_hash_card: 2003. 60 0.623862
4 ETW000 [ dev trc,00000] NTAB: maxcnt 1000. 53 0.623915
4 ETW000 [ dev trc,00000] NTAB: hfactor 2003. 28 0.623943
4 ETW000 [ dev trc,00000] NTAB: mem_protocol_size 112 24 0.623967
4 ETW000 [ dev trc,00000] NTAB: hdr_backpack_offset 0 23 0.623990
4 ETW000 [ dev trc,00000] NTAB: hdr_backpack_size 0 23 0.624013
4 ETW000 [ dev trc,00000] NTAB: FTAB: header_size 88. 23 0.624036
4 ETW000 [ dev trc,00000] NTAB: FTAB: item_size 64. 23 0.624059
4 ETW000 [ dev trc,00000] NTAB: FTAB: item_cnt 1000. 23 0.624082
4 ETW000 [ dev trc,00000] NTAB: FTAB: unit_size 4 22 0.624104
4 ETW000 [ dev trc,00000] NTAB: FTAB: unit_cnt 128000. 23 0.624127
4 ETW000 [ dev trc,00000] NTAB: FTAB: data_size 512000. 99 0.624226
4 ETW000 [ dev trc,00000] NTAB: IREC: header_size 88. 29 0.624255
4 ETW000 [ dev trc,00000] NTAB: IREC: item_size 64. 23 0.624278
4 ETW000 [ dev trc,00000] NTAB: IREC: item_cnt 250. 23 0.624301
4 ETW000 [ dev trc,00000] NTAB: IREC: unit_size 16 23 0.624324
4 ETW000 [ dev trc,00000] NTAB: IREC: unit_cnt 6400. 22 0.624346
4 ETW000 [ dev trc,00000] NTAB: IREC: data_size 102400. 23 0.624369
4 ETW000 [ dev trc,00000] NTAB: STAB: header_size 88. 22 0.624391
4 ETW000 [ dev trc,00000] NTAB: STAB: item_size 64. 23 0.624414
4 ETW000 [ dev trc,00000] NTAB: STAB: item_cnt 250. 22 0.624436
4 ETW000 [ dev trc,00000] NTAB: STAB: unit_size 4 23 0.624459
4 ETW000 [ dev trc,00000] NTAB: STAB: unit_cnt 25600. 22 0.624481
4 ETW000 [ dev trc,00000] NTAB: STAB: data_size 102400. 23 0.624504
4 ETW000 [ dev trc,00000] NTAB: TTAB: header_size 200. 23 0.624527
4 ETW000 [ dev trc,00000] NTAB: TTAB: item_size 40. 23 0.624550
4 ETW000 [ dev trc,00000] NTAB: TTAB: item_cnt 1000. 22 0.624572
4 ETW000 [ dev trc,00000] NTAB: TTAB: unit_size 256 23 0.624595
4 ETW000 [ dev trc,00000] NTAB: TTAB: unit_cnt 1000. 22 0.624617
4 ETW000 [ dev trc,00000] NTAB: TTAB: data_size 256000. 23 0.624640
4 ETW000 [ dev trc,00000] NTAB: FTAB: hh_p 286ef70, hh_len 88 1035 0.625675
4 ETW000 [ dev trc,00000] NTAB: FTAB: aa_p 65f6a20, aa_len 16024 33 0.625708
4 ETW000 [ dev trc,00000] NTAB: FTAB: ia_p 65fa8c0, ia_len 64000 25 0.625733
4 ETW000 [ dev trc,00000] NTAB: FTAB: dat_p 660a2d0, dat_len 512000 24 0.625757
4 ETW000 [ dev trc,00000] NTAB: IREC: hh_p 65ebf50, hh_len 88 28 0.625785
4 ETW000 [ dev trc,00000] NTAB: IREC: aa_p 65ec150, aa_len 16024 24 0.625809
4 ETW000 [ dev trc,00000] NTAB: IREC: ia_p 65efff0, ia_len 16000 24 0.625833
4 ETW000 [ dev trc,00000] NTAB: IREC: dat_p b8b0080, dat_len 102400 114 0.625947
4 ETW000 [ dev trc,00000] NTAB: STAB: hh_p 65ebfb0, hh_len 88 25 0.625972
4 ETW000 [ dev trc,00000] NTAB: STAB: aa_p 66872e0, aa_len 16024 21 0.625993
4 ETW000 [ dev trc,00000] NTAB: STAB: ia_p b8c9090, ia_len 16000 23 0.626016
4 ETW000 [ dev trc,00000] NTAB: STAB: dat_p b8ccf20, dat_len 102400 26 0.626042
4 ETW000 [ dev trc,00000] NTAB: TTAB: hh_p 65ec010, hh_len 200 24 0.626066
4 ETW000 [ dev trc,00000] NTAB: TTAB: aa_p b8e5f30, aa_len 16024 24 0.626090
4 ETW000 [ dev trc,00000] NTAB: TTAB: ia_p b8e9dd0, ia_len 40000 24 0.626114
4 ETW000 [ dev trc,00000] NTAB: TTAB: dat_p b8f3a20, dat_len 256000 30 0.626144
4 ETW000 [ dev trc,00000] NTAB: ntab_mem_protocol 65ec010, ntab_mp_p 65ec010, ntab_proc_id 0 55 0.626199
4 ETW000 [ dev trc,00000] NTAB: FTAB: hh_p 286ef70, ha_list 65f6a20, hi_list 65fa8c0, buffer 660a2d0
4 ETW000 99 0.626298
4 ETW000 [ dev trc,00000] NTAB: IREC: hh_p 65ebf50, ha_list 65ec150, hi_list 65efff0, buffer b8b0080
4 ETW000 40 0.626338
4 ETW000 [ dev trc,00000] NTAB: STAB: hh_p 65ebfb0, ha_list 66872e0, hi_list b8c9090, buffer b8ccf20
4 ETW000 40 0.626378
4 ETW000 [ dev trc,00000] NTAB: TTAB: hh_p 65ec080, ha_list b8e5f30, hi_list b8e9dd0, buffer b8f3a20
4 ETW000 39 0.626417
4 ETW000 [ dev trc,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 0 39 0.626456
4 ETW000 [ dev trc,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 1 48 0.626504
4 ETW000 [ dev trc,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2 45 0.626549
4 ETW000 [ dev trc,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3 37 0.626586
4 ETW000 [ dev trc,00000] { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TADIR' ) {twdbcall.c:767}
4 ETW000 6704 0.633290
4 ETW000 [ dev trc,00000] } db_rtab( fcode = 'RT_READ_ONLY', retcode = 0 ) 4819 0.638109
4 ETW000 [ dev trc,00000] { db_rtab( fcode = 'RT_READ_ONLY', tname = 'MTSETTINGS' ) {twdbcall.c:767}
4 ETW000 155 0.638264
4 ETW000 [ dbcrtab ,00000] ***LOG BZ9=>table MTSETTINGS does not exist in nametab 413 0.638677
4 ETW000 [ dev trc,00000] } db_rtab( fcode = 'RT_READ_ONLY', retcode = 32 ) 35 0.638712
4 ETW000 Connected to DBMS = MSSQL --- SERVER = 'VMSAPECCEHP6' DBNAME = 'SL7' --- SYSTEM = 'SL7'.
4 ETW000 [ dev trc,00000] { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1491}
4 ETW000 332 0.639044
4 ETW000 [ dev trc,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 3162 0.642206
4 ETW000 [ dev trc,00000] { dsql_open (con_da=(0,R/3),#binds=0,#input=0, 98 0.642304
4 ETW000 name=UNKNOWN, stmtid=NULL,
4 ETW000 stmt="SELECT EXECUTABLE,SAPRELEASE,HOSTNAME,PLATFORM,DBVENDOR,TIMESTAMP,PATCHNO,DBSLPATCHN FROM ...")
4 ETW000 [ dev trc,00000] } dsql_open()=0, *cu_id_p=1 7361 0.649665
4 ETW000 [ dev trc,00000] { dsql_fetch (con_da=(0,R/3),cu_id=1,#output=8) 61 0.649726
4 ETW000 [ dev trc,00000] } dsql_fetch()=0, rec_cnt=1, mod_cnt=1 143 0.649869
4 ETW000 [ dev trc,00000] { dsql_close (con_da=(0,R/3),cu_id=1) 84 0.649953
4 ETW000 [ dev trc,00000] } dsql_close()=0 47 0.650000
4 ETW000 [ dev trc,00000] { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1603}
4 ETW000 43 0.650043
4 ETW000 [ dev trc,00000] } db_rtab( fcode = 'RT_DELETE', retcode = 0 ) 2963 0.653006
4 ETW690 COMMIT "0" "0"
4 ETW000 [ dev trc,00000] db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=0) 235 0.653241
4 ETW000 [ dev trc,00000] dbsync[db_syflush]: to_be_committed = 1 62 0.653303
4 ETW000 trace to file pointer closed
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000
4 ETW000 ================== STEP 1 =====================
4 ETW000 date&time : 18.11.2014 - 18:04:03
4 ETW000 function : CONNECT
4 ETW000 buffersync : YES
4 ETW000 clients : default
4 ETW000 commit : 100000
4 ETW000 table cache : dynamic
4 ETW000
4 ETW000 [ dev trc,00000] Disconnecting from ALL connections: 444 0.000444
4 ETW000 [ dev trc,00000] Disconnected from connection 0 1264 0.001708
4 ETW000 [ dev trc,00000] statistics db_con_commit (com_total=1, com_tx=1) 30 0.001738
4 ETW000 [ dev trc,00000] statistics db_con_rollback (roll_total=0, roll_tx=0) 21 0.001759
4 ETW000 Disconnected from database.
4 ETW000 End of Transport (0000).
4 ETW000 date&time: 18.11.2014 - 18:04:03
SAPup> Starting subprocess in phase 'DBCHK_INI' at 20141119060923
ENV: DBMS_TYPE=mss
ENV: JAVA_HOME=C:\usr\sap\SL7\DVEBMGS01\exe\sapjvm_4
ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
ENV: PATH=C:\usr\sap\SL7\DVEBMGS01\exe;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\usr\sap\SL7\SYS\exe\uc\NTAMD64
ENV: SAPSYSTEMNAME=SL7
ENV: dbs_mss_schema=sl7
ENV: rsdb_ssfs_connect=0
EXECUTING C:\usr\sap\SL7\DVEBMGS01\exe\tp.EXE "pf=F:\sum\SUM\abap\var\DEFAULT.TPP" getdbinfo SL7
KERNVER=702
SAPVERS=702
DOKVERS=702
COMPVERS=BBPCRM 701 0000000006
COMPVERS=BI_CONT 706 0000000002
COMPVERS=CPRXRPM 500_702 0000000005
COMPVERS=PI_BASIS 702 0000000009
COMPVERS=SAP_ABA 702 0000000009
COMPVERS=SAP_AP 700 0000000026
COMPVERS=SAP_BASIS 702 0000000009
COMPVERS=SAP_BS_FND 702 0000000007
COMPVERS=SAP_BW 702 0000000009
COMPVERS=SOCO 101 0000000001
COMPVERS=ST 710 0000000004
COMPVERS=ST-A/PI 01N_700SOL0000000001
COMPVERS=ST-BCO 710 0000000002
COMPVERS=ST-ICO 150_700 0000000031
COMPVERS=ST-PI 2008_1_7000000000005
COMPVERS=ST-SER 701_2010_10000000010
COMPVERS=WEBCUIF 701 0000000006
DBAHOME=NOTFOUND
DBACONN=
DBAVERS=10.50.1702.00
DBASUBTYPE=STANDARD
tp=>sapparam(1c): No Profile used.
tp=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
F:\sum\SUM\abap\exe>R3trans.exe -d
This is R3trans.exe version 6.24 (release 720 - 14.10.14 - 20:14:08).
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.exe finished (0012).
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.