cannot release transport request

[Former Member]

I want to copy transport request files from a to be dismantled SAP system to another SAP system and then add into STMS queue.

It's an SAP ECC 6.0 / SAP_BASIS 700 18 / MSSQL 9.00.3054 / Unicode / Windows server 2003 x64.

When releasing the transport request to a virtuel system this ends with return code 0232.

In the transport tool check the tp call give the message:

- DB connect: Link to database failed

- Offline call: connect failed

R3trans -x (version 6.14 release 700 - 12.06.09) on the server with <SID>adm ends "with2EETW169 no connect possible..." and "R3trans finished <0012>".

Expected cause is an issue in environment variable or profile parameter, but these seem to be correct.

In the windows registry, DEFAULT.PFL and environment variables is parameter "DBMS_TYPE = mss".

Do you have any suggestions ?

[Former Member · Accepted solution]

Hi ,

Please check using the command R3trans -d on command prompt and see if you are able to connect to the database.

If not then check the log file Trans.log created in the same directory from which this command is run to find out the cause of the problem.

Thanks

Amit

[Former Member · Accepted solution]

Here's the log file Trans.log:

4 ETW000 R3trans version 6.14 (release 700 - 12.06.09 - 15:20:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 01.02.2010 - 14:39:36

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000 [dev trc ,00000] Mon Feb 01 14:39:39 2010 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] DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 0000000187CA0000

4 ETW000 7166 0.007166

4 ETW000 [dev trc ,00000] using "D:\usr\sap\FFC\SYS\exe\uc\NTAMD64\dbmssslib.dll" 11 0.007177

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

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

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

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

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

4 ETW000 [dev trc ,00000] New connection 0 created 26 0.007931

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 36 0.007967

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

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

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 46 0.008044

4 ETW000 [dev trc ,00000] Thread ID:23204 1182 0.009226

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

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

4 ETW000 21 0.009262

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

4 ETW000 [dev trc ,00000] SAP patchlevel 0 11 0.009301

4 ETW000 [dev trc ,00000] SAP patchno 221 11 0.009312

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

4 ETW000 [dev trc ,00000] Last MSSQL DBSL patchno 216 13 0.009336

4 ETW000 [dev trc ,00000] Last MSSQL DBSL patchcomment Wrong table name in ST05 trace (1364307)

4 ETW000 18 0.009354

4 ETW000 [dev trc ,00000] Network connection used from SAP02 to DATABASE02\SAP using tcp:DATABASE02\SAP

4 ETW000 478 0.009832

4 ETW000 [dev trc ,00000] Network connection used from SAP02 to DATABASE02\SAP using tcp:DATABASE02\SAP

4 ETW000 56058 0.065890

4 ETW000 [dev trc ,00000] Network connection used from SAP02 to DATABASE02\SAP using tcp:DATABASE02\SAP

4 ETW000 5985 0.071875

4 ETW000 [dev trc ,00000] Driver: sqlncli10.dll Driver release: 10.00.1600 5892 0.077767

4 ETW000 [dev trc ,00000] GetDbRelease: 9.00.3054 409 0.078176

4 ETW000 [dev trc ,00000] GetDbRelease: Got DB release numbers (9,0,3054) 19 0.078195

4 ETW000 [dev trc ,00000] The 7.00 (or earlier) ODBC based DBSL library should not be used for SAP systems running on SQL Server 2005 (release 9.0) or earlier.

4 ETW000 29 0.078224

4 ETW000 [dev trc ,00000] Please uninstall SQLNCLI 10 (SNAC10) on this application server.or set environment variable MSSQL_FORCEOLEDB.

4 ETW000 24 0.078248

4 ETW000 [dev trc ,00000] For more information please refer to SAP note 1082356 15 0.078263

4 ETW000 [dblink ,00433] ***LOG BY2=>sql error 0 performing CON [dblink#8 @ 433] 62 0.078325

4 ETW000 [dblink ,00433] ***LOG BY0=><message text not available> [dblink#8 @ 433] 18 0.078343

2EETW169 no connect possible: "DBMS = MSSQL --- SERVER = 'DATABASE02\SAP' DBNAME = 'FFC'"

[Former Member · Accepted solution]

The environment variable MSSQL_FORCEOLEDB is set to 1 and now the R3trans -d is finished with status 0000.

Here is the new log:

4 ETW000 R3trans version 6.14 (release 700 - 12.06.09 - 15:20:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 01.02.2010 - 15:14:41

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000 [dev trc ,00000] Mon Feb 01 15:14:43 2010 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] DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 0000000187CA0000

4 ETW000 7036 0.007036

.

.

4 ETW000 [twdydbacc.c ,00728] buffer:'J' 541 0.089991

4 ETW000 [twdydbacc.c ,00733] i:0 12 0.090003

4 ETW000 [twdydbacc.c ,00734] tw_fd_p<i>.offset:0 10 0.090013

4 ETW000 [twdydbacc.c ,00733] i:1 9 0.090022

4 ETW000 [twdydbacc.c ,00734] tw_fd_p<i>.offset:4 9 0.090031

4 ETW000 [twdydbacc.c ,00733] i:2 9 0.090040

4 ETW000 [twdydbacc.c ,00734] tw_fd_p<i>.offset:8 9 0.090049

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TADIR' ) {twdbcall.c:717}

4 ETW000 31 0.090080

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_READ_ONLY', retcode = 0 ) 690 0.090770

4 ETW000 Connected to DBMS = MSSQL --- SERVER = 'DATABASE02\SAP' DBNAME = 'FFC' --- SYSTEM = 'FFC'.

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1321}

4 ETW000 342 0.091112

4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y4SAP02ffc00000013520000000003151443 351 0.091463

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 989 0.092452

4 ETW000 [dev trc ,00000] dsql_open (con_da=(0,R/3),stmt="SELECT EXECUTABLE,SAPRELEASE,H ...",#binds=0,name=UNKNOWN,#input=0)

4 ETW000 56 0.092508

4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4SAP02ffc00000013520000000007151443 74 0.092582

4 ETW000 [dev trc ,00000] dsql_fetch (con_da=(0,R/3),cu_id=1,#output=8) 477 0.093059

4 ETW000 [dev trc ,00000] dsql_close (con_da=(0,R/3),cu_id=1) 65 0.093124

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1433}

4 ETW000 35 0.093159

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_DELETE', retcode = 0 ) 534 0.093693

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) 39 0.093732

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 : 01.02.2010 - 15:14:43

4 ETW000 function : CONNECT

4 ETW000 buffersync : YES

4 ETW000 clients : default

4 ETW000 l.s.m. : VECTOR

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 129 0.000129

4 ETW000 [dev trc ,00000] Disconnected from connection 0 2653 0.002782

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1) 19 0.002801

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0) 16 0.002817

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 01.02.2010 - 15:14:43

[Former Member · Accepted solution]

Hi ,

Ok ,Now you have set the envrionment variable to 1.Did you also check the SAP note 1082356 .

Previously SAP was not able to connect to database ,now you are able to connect.Check your TP connection to database now,if its working,then you should be able to release the transport.

Check from STMS transaction or use the following command.

tp connect <SID> pf='/usr/sap/trans/bin/TP_DOMAIN_<SID>.PFL'

Thanks

Amit

Edited by: Amit Bangotra on Feb 2, 2010 3:45 PM