R3trans issue

[Shival Tailor]

Dear All,

When I run R3trans -d, I get the following outcome. Any idea what could be the reason and why wouldn't it get DBNAME in the outcome? I tried using latest R3trans but didn't work.


H:\usr\sap\C7Q\DVEBMGS00\exe>r3trans -d
This is r3trans version 6.14 (release 701 - 17.11.08 - 18:00:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = MSSQL --- SERV
ER = 'UT1VC7Q01' DBNAME = ''"
r3trans finished (0012).

Using one of the older versions give another result, which is:

K:\Downloads\R3Trans\701\44>r3trans -x
This is r3trans version 6.14 (release 701 - 20.04.09 - 13:27:00).
unicode enabled version
2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."
r3trans finished (0012).

The above one was originally solved by replacing another R3trans, which was eventually replaced by upgraded kernel.

Following is disp+work outcome:

H:\usr\sap\C7Q\DVEBMGS00\exe>disp+work

--------------------
disp+work information
--------------------

kernel release 701

kernel make variant 701_REL

compiled on NT 5.2 3790 Service Pack 1 x86 MS VC++ 14.00

compiled for 64 BIT

compilation mode UNICODE

compile time Dec 7 2008 23:32:32

update level 0

patch number 23

source id 0.023


---------------------
supported environment
---------------------

database (SAP, table SVERS) 700
701

operating system
Windows NT 5.0
Windows NT 5.1
Windows NT 5.2
Windows NT 6.0


Any help is much appreciated as always.

Thank you,

Shival

[Shival Tailor]

Following is latest trans.log:

 

Any ideas???

 

4 ETW000 r3trans version 6.14 (release 701 - 17.11.08 - 18:00:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time   : 18.06.2009 - 11:14:21
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: r3trans -i H:\connect.log
4 ETW000 TRACE-INFO: 1:  [dev trc     ,00000]  Thu Jun 18 11:14:24 2009                                    20778  0.020778
4 ETW000 TRACE-INFO: 2:  [dev trc     ,00000]  db_con_init called                                             46  0.020824
4 ETW000 TRACE-INFO: 3:  [dev trc     ,00000]  create_con (con_name=R/3)                                     399  0.021223
4 ETW000 TRACE-INFO: 4:  [dev trc     ,00000]  Loading DB library 'dbmssslib.dll' ...                        410  0.021633
4 ETW000 TRACE-INFO: 5:  [dev trc     ,00000]  load shared library (dbmssslib.dll), hdl 0, addr 00000001865E0000
4 ETW000 TRACE-INFO: 6:                                                                                   136013  0.157646
4 ETW000 TRACE-INFO: 7:  [dev trc     ,00000]      using "H:\usr\sap\C7Q\DVEBMGS00\exe\dbmssslib.dll"         34  0.157680
4 ETW000 TRACE-INFO: 8:  [dev trc     ,00000]  Library 'dbmssslib.dll' loaded                                 94  0.157774
4 ETW000 TRACE-INFO: 9:  [dev trc     ,00000]  function DbSlExpFuns loaded from library dbmssslib.dll        120  0.157894
4 ETW000 TRACE-INFO: 10:  [dev trc     ,00000]  Version of 'dbmssslib.dll' is "700.08", patchlevel (0.23)
4 ETW000 TRACE-INFO: 11:                                                                                     3247  0.161141
4 ETW000 TRACE-INFO: 12:  [dev trc     ,00000]  function dsql_db_init loaded from library dbmssslib.dll        44  0.161185
4 ETW000 TRACE-INFO: 13:  [dev trc     ,00000]  function dbdd_exp_funs loaded from library dbmssslib.dll       56  0.161241
4 ETW000 TRACE-INFO: 14:  [dev trc     ,00000]  New connection 0 created                                      465  0.161706
4 ETW000 TRACE-INFO: 15:  [dev trc     ,00000]  0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 TRACE-INFO: 16:                                                                                      135  0.161841
4 ETW000 TRACE-INFO: 17:  [dev trc     ,00000]  db_con_connect (con_name=R/3)                                 312  0.162153
4 ETW000 TRACE-INFO: 18:  [dev trc     ,00000]  find_con_by_name found the following connection for reuse:
4 ETW000 TRACE-INFO: 19:                                                                                       77  0.162230
4 ETW000 TRACE-INFO: 20:  [dev trc     ,00000]  0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 TRACE-INFO: 21:                                                                                       63  0.162293
4 ETW000 TRACE-INFO: 22:  [dev trc     ,00000]  Thread ID:6460                                              10128  0.172421
4 ETW000 TRACE-INFO: 23:  [dev trc     ,00000]  Thank You for using the SLOLEDB-interface                      77  0.172498
4 ETW000 TRACE-INFO: 24:  [dev trc     ,00000]  Using dynamic link library 'H:\usr\sap\C7Q\DVEBMGS00\exe\dbmssslib.dll'
4 ETW000 TRACE-INFO: 25:                                                                                       70  0.172568
4 ETW000 TRACE-INFO: 26:  [dev trc     ,00000]  dbmssslib.dll patch info                                       41  0.172609
4 ETW000 TRACE-INFO: 27:  [dev trc     ,00000]    patchlevel   0                                               28  0.172637
4 ETW000 TRACE-INFO: 28:  [dev trc     ,00000]    patchno      23                                              37  0.172674
4 ETW000 TRACE-INFO: 29:  [dev trc     ,00000]    patchcomment MSSQL: R3load fastload import distorts special characters (1279882)
4 ETW000 TRACE-INFO: 30:                                                                                       69  0.172743
4 ETW000 TRACE-INFO: 31:  [dev trc     ,00000]  np:(local) connection used on UT1VC7Q01                       628  0.173371
4 ETW000 TRACE-INFO: 32:  [dev trc     ,00000]  CopyLocalParameters: dbuser is 'dbo'                           55  0.173426
4 ETW000 TRACE-INFO: 33:  [dev trc     ,00000]  Using Provider SQLNCLI                                     103034  0.276460
4 ETW000 TRACE-INFO: 34:  [dev trc     ,00000]  OpenOledbConnection: MARS property was set successfully.     1352  0.277812
4 ETW000 TRACE-INFO: 35:  [dev trc     ,00000]  Provider Release:9.00.4035.00                              376461  0.654273
4 ETW000 TRACE-INFO: 36:  [dev trc     ,00000]  Using Provider SQLNCLI                                       3821  0.658094
4 ETW000 TRACE-INFO: 37:  [dev trc     ,00000]  OpenOledbConnection: MARS property was set successfully.      459  0.658553
4 ETW000 TRACE-INFO: 38:  [dev trc     ,00000]  i'm dbo but there exists 1 users <> dbo with tables SVERS ==> connect terminated
4 ETW000 TRACE-INFO: 39:                                                                                   138173  0.796726

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

Shival

[Rabindra Das]

this may be due to userid and password problem at databse level

 

else put the same error message http://service.sap.com to tell you exact problem

 

-Thanks

-Das

--
With best regards
Rabindra Kumar Das
Asst. Proj. Manager-SAP Basis
Cognizant Technology Solutions,USA

[Shival Tailor]

Closing the thread...it was environment variable related issue.

Shival