No Return Code for R3Trans

[Former Member]

Hi

We are using ECC 6.0 on Windows x64 with MS SQL 2005. When we try to execute the command R3trans, we get no error code.

The R3 trans log file is as follows.

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

4 ETW000 R3trans version 6.14 (release 700 - 23.11.07 - 14:31:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 11.01.2008 - 01:51:34

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -D -w log1.txt

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

4 ETW000 [dev trc ,00000] Fri Jan 11 01:51:36 2008 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] load shared library (dbmssslib.dll), hdl 0 121 0.000121

4 ETW000 [dev trc ,00000] using "E:\usr\sap\ARD\DVEBMGS00\exe\dbmssslib.dll"

4 ETW000 20 0.000141

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

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

4 ETW000 18 0.000170

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

4 ETW000 213 0.000383

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

4 ETW000 17 0.000400

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

4 ETW000 19 0.000419

4 ETW000 [dev trc ,00000] New connection 0 created 27 0.000446

4 ETW000 [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 31 0.000477

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

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

4 ETW000 16 0.000509

4 ETW000 [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 24 0.000533

4 ETW000 [dev trc ,00000] Thread ID:15700 2738 0.003271

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

4 ETW000 [dev trc ,00000] Using dynamic link library 'E:\usr\sap\ARD\DVEBMGS00\exe\dbmssslib.dll'

4 ETW000 22 0.003307

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

4 ETW000 [dev trc ,00000] patchlevel 0 10 0.003341

4 ETW000 [dev trc ,00000] patchno 110 9 0.003350

4 ETW000 [dev trc ,00000] patchcomment MSSQL: Connect error handling (1053754)

4 ETW000 16 0.003366

4 ETW000 [dev trc ,00000] np:(local) connection used on USMELAS300 61 0.003427

4 ETW000 [dev trc ,00000] CopyLocalParameters: dbuser is 'dbo' 12 0.003439

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 11321 0.014760

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully.

4 ETW000 175 0.014935

4 ETW000 [dev trc ,00000] Provider Release:9.00.1399.06 40288 0.055223

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 464 0.055687

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully.

4 ETW000 74 0.055761

4 ETW000 [dev trc ,00000] CheckCodepageType: line 24375. hr: 0x80040e37 Invalid object name 'DBPROPERTIES'.

4 ETW000 3979 0.059740

4 ETW000 [dev trc ,00000] sloledb.cpp [CheckCodepageType,line 24375]: Error/Message: (err 208, sev 16), Invalid object name 'DBPROPERTIES'.

4 ETW000 39 0.059779

4 ETW000 [dev trc ,00000] Procname: [CheckCodepageType -- no proc] 11 0.059790

4 ETW000 [dev trc ,00000] Cache sizes: header 104 bytes, 100 names (164800 bytes), 100 dynamic statements (575200 bytes), total 740104 bytes

4 ETW000 52 0.059842

4 ETW000 [dev trc ,00000] Initializing private procedure name cache. 10 0.059852

4 ETW000 [dev trc ,00000] procedure cache created/attached 18 0.059870

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

4 ETW000 20 0.059890

4 ETW000 [dev trc ,00000] pn_id:USMELAS300_*** 9 0.059899

4 ETW000 [dev trc ,00000] Using MARS (on sql 9.0) 12 0.059911

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

4 ETW000 [dev trc ,00000] The IRow interface is supported by this OLEDB provider

4 ETW000 7180 0.067110

4 ETW000 [dev trc ,00000] ParamStmtExec: line 13027. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 27 0.067137

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13027]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 29 0.067166

4 ETW000 [dev trc ,00000] Procname: [##Y4USMELAS3***00000158360000000001015136]

4 ETW000 14 0.067180

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13027]: Error/Message: (err 208, sev 16), Invalid object name 'SVERS'.

4 ETW000 62 0.067242

4 ETW000 [dev trc ,00000] Procname: [##Y4USMELAS3***00000158360000000001015136]

4 ETW000 15 0.067257

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TOP 1 VERSION FROM SVERS ]

4 ETW000 73 0.067330

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:1 flag_fupd:0 use_cursor:0 chksum: 1112312

4 ETW000 18 0.067348

4 ETW000 [dev trc ,00000] DbSlRead - Error 103 (dbcode 208) on open 22 0.067370

4 ETW000 [dev trc ,00000] DbSlRead - <##Y4USMELAS3***00000158360000000001015136>

4 ETW000 16 0.067386

4 ETW000 [dev trc ,00000] DbSlRead - Error 103 (dbcode 208) on fetch 11 0.067397

4 ETW000 [dev trc ,00000] DbSlRead - <##Y4USMELAS3***00000158360000000001015136>

4 ETW000 87 0.067484

4 ETW000 [dblink ,01299] ***LOG BZA=>table SVERS does not exist on database [dblink#5 @ 1299]

4 ETW000 65 0.067549

4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4USMELAS3***00000158360000000002015136

4 ETW000 234 0.067783

4 ETW000 [dev trc ,00000] ParamStmtExec: line 13027. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 540 0.068323

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13027]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 26 0.068349

4 ETW000 [dev trc ,00000] Procname: [##Y4USMELAS3***00000158360000000002015136]

4 ETW000 14 0.068363

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13027]: Error/Message: (err 208, sev 16), Invalid object name 'DDNTT'.

4 ETW000 57 0.068420

4 ETW000 [dev trc ,00000] Procname: [##Y4USMELAS3***00000158360000000002015136]

4 ETW000 15 0.068435

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TOP 1 COMPCNT FROM "DDNTT" ]

4 ETW000 24 0.068459

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 1122000

4 ETW000 17 0.068476

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT FROM DDNTT FAILED 22 0.068498

4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4USMELAS3***00000158360000000003015136

4 ETW000 30 0.068528

4 ETW000 [dev trc ,00000] ParamStmtExec: line 13027. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 426 0.068954

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13027]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 25 0.068979

4 ETW000 [dev trc ,00000] Procname: [##Y4USMELAS3***00000158360000000003015136]

4 ETW000 15 0.068994

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13027]: Error/Message: (err 208, sev 16), Invalid object name 'DDNTT'.

4 ETW000 55 0.069049

4 ETW000 [dev trc ,00000] Procname: [##Y4USMELAS3***00000158360000000003015136]

4 ETW000 15 0.069064

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TOP 1 VERSION FROM "DDNTT" ]

4 ETW000 23 0.069087

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 1122000

4 ETW000 18 0.069105

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT FAILED 15 0.069120

4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4USMELAS3***00000158360000000004015136

4 ETW000 31 0.069151

4 ETW000 [dev trc ,00000] ParamStmtExec: line 13027. hr: 0x80040e14 Statement(s) could not be prepared.

4 ETW000 417 0.069568

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13027]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

4 ETW000 25 0.069593

4 ETW000 [dev trc ,00000] Procname: [##Y4USMELAS3***00000158360000000004015136]

4 ETW000 14 0.069607

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13027]: Error/Message: (err 208, sev 16), Invalid object name 'DDNTT'.

4 ETW000 56 0.069663

4 ETW000 [dev trc ,00000] Procname: [##Y4USMELAS3***00000158360000000004015136]

4 ETW000 14 0.069677

4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT TOP 1 DBASE FROM "DDNTT" ]

4 ETW000 24 0.069701

4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:0 flag_fupd:0 use_cursor:0 chksum: 1122000

4 ETW000 17 0.069718

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED

4 ETW000 27 0.069745

4 ETW000 [dbntab ,01276] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#4 @ 12761]

4 ETW000 26 0.069771

4 ETW000 [twdydbacc.c ,00571] i:0 37 0.069808

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.fname: PGMID 10 0.069818

4 ETW000 [twdydbacc.c ,00573] db_fd_p<i>.is_key: 0 8 0.069826

4 ETW000 [twdydbacc.c ,00574] db_fd_p<i>.offset: 0 9 0.069835

4 ETW000 [twdydbacc.c ,00575] db_fd_p<i>.db_length: 0 8 0.069843

4 ETW000 [twdydbacc.c ,00576] db_fd_p<i>.fixed_length:4 8 0.069851

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

FYi the environment variables are set properly. This is a show stopper to our Support pack Import. Kindly help!

[Former Member]

Hi Alankar,

Please check the below note.

Note 969699 - 6.20/6.40 Patch Collection Inst.: MS SQL Server

Hope it helps.

Award points if helpful.

Rgds,

Sri