Solved: system copy crm 7.01 - r3load -testconnect fails

Hey together,

i like to make a system copy, with crm 7.01 (kernel 7.21 UC64) on a windows sv 2003 r2 with sql 2005.

my problem is on "Export ABAP" step "testing database connection"

r3load -testconnect exists with error code 2

if i try via comand line

r3load -testcibbect

(DB) ERROR: db_connect rc = 256

DbSlErrorMsg rc = 99

r3trans -d

2EETW169 no connect possbile "DBMS = MSSQL --- SERVER = 'MSSQLSERVER' DBNAME ='<sid>'"

no more information in the logs..

following environment settings

dbms_type = mss

MSSQL_DBNAME = <sid>

MSSQL_SCHEMA = dbo

MSSQL_SERVER = MSSQLSERVER

i have no clue i read much notes and forum entries but there is no solution.. pls help me

SAP Managed Tags:
Microsoft SQL Server

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

hi steffen

Please set environmental variable MSSQL_FORCEOLEDB=1 in your database instance.

source = http://scn.sap.com/thread/1639404

best regards

marius

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

thanks for your answer.

i set this environment variable as user and system environment, restarted but the same problem as before

Hi,

is this really set like this

MSSQL_DBNAME = <sid>

It should point to the uppercase name of your SID e.g. PRD or DEV.

Regards

Clas

hi steffen

as which user are you doing the export ?

please have a look at http://scn.sap.com/message/8020583#8020583

best regards

marius

its written in uppercase

MSSQL_DBNAME = NGC

logged in / run as <SID>adm

the Remote connections was set as "Using both TCP/IP and named pipes"

on the surface area , i enabled "OLE Automation"

still no changes ..

can you please run R3trans -d and post trans.log

have you also updated the r3load to the latest version ?

also after setting the env did you restart the OS ?

4 ETW000 R3trans.exe version 6.23 (release 721 - 31.10.12 - 20:12:06).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 17.04.2013 - 17:02:21

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans.exe -x

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

4 ETW000 [ dev trc,00000] Wed Apr 17 17:02:21 2013 83 0.000083

4 ETW000 [ dev trc,00000] db_con_init called 17 0.000100

4 ETW000 [ dev trc,00000] set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used 36 0.000136

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 26 0.000162

4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 11 0.000173

4 ETW000 [ dev trc,00000] Loading DB library 'dbmssslib.dll' ... 35 0.000208

4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 0000000186EC0000

4 ETW000 2687 0.002895

4 ETW000 [ dev trc,00000] using "D:\usr\sap\NGC\DVEBMGS11\exe\dbmssslib.dll" 12 0.002907

4 ETW000 [ dev trc,00000] Library 'dbmssslib.dll' loaded 12 0.002919

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

4 ETW000 [ dev trc,00000] Version of 'dbmssslib.dll' is "721.02", patchlevel (0.33) 40 0.002974

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

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

4 ETW000 [ dev trc,00000] New connection 0 created 20 0.003019

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 28 0.003047

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

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 17 0.003077

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 11 0.003088

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 24 0.003112

4 ETW000 [ dev trc,00000] Thread ID:3284 1087 0.004199

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

4 ETW000 [ dev trc,00000] Using dynamic link library 'D:\usr\sap\NGC\DVEBMGS11\exe\dbmssslib.dll'

4 ETW000 22 0.004234

4 ETW000 [ dev trc,00000] dbmssslib.dll patch info 17 0.004251

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

4 ETW000 [ dev trc,00000] SAP patchno 40 57 0.004319

4 ETW000 [ dev trc,00000] Last MSSQL DBSL patchlevel 0 12 0.004331

4 ETW000 [ dev trc,00000] Last MSSQL DBSL patchno 33 12 0.004343

4 ETW000 [ dev trc,00000] Last MSSQL DBSL patchcomment Local connection to a named instance does not use LPC (1782171)

4 ETW000 20 0.004363

4 ETW000 [ dev trc,00000] ODBC Driver chosen: SQL Native Client native 461 0.004824

4 ETW000 [ dev trc,00000] Network connection used from SV-SAP-5 to MSSQLSERVER using tcp:MSSQLSERVER

4 ETW000 91 0.004915

4 ETW000 [ dev trc,00000] Wed Apr 17 17:02:38 2013 17009246 17.014161