cancel
Showing results for 
Search instead for 
Did you mean: 

system copy crm 7.01 - r3load -testconnect fails

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member206552
Active Contributor
0 Kudos

hi steffen

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

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

best regards

marius

0 Kudos

thanks for your answer.

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

clas_hortien
Advisor
Advisor
0 Kudos

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

former_member206552
Active Contributor
0 Kudos

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

0 Kudos

its written in uppercase

MSSQL_DBNAME = NGC

0 Kudos

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 ..

former_member206552
Active Contributor
0 Kudos

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 ?

0 Kudos

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

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  36  17.014197

4 ETW000  [     dev trc,00000]  (11001) [08001] [Microsoft][SQL Native Client]TCP Provider: Der angegebene Host ist unbekannt.

4 ETW000                                                                                                  20  17.014217

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  43  17.014260

4 ETW000  [     dev trc,00000]  (0) [HYT00] [Microsoft][SQL Native Client]Login timeout expired           13  17.014273

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  20  17.014293

4 ETW000  [     dev trc,00000]  (11001) [08001] [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

4 ETW000                                                                                                  32  17.014325

4 ETW000  [     dev trc,00000]  Wed Apr 17 17:02:55 2013                                             17001148  34.015473

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  43  34.015516

4 ETW000  [     dev trc,00000]  (11001) [08001] [Microsoft][SQL Native Client]TCP Provider: Der angegebene Host ist unbekannt.

4 ETW000                                                                                                  21  34.015537

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  24  34.015561

4 ETW000  [     dev trc,00000]  (0) [HYT00] [Microsoft][SQL Native Client]Login timeout expired           13  34.015574

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  20  34.015594

4 ETW000  [     dev trc,00000]  (11001) [08001] [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

4 ETW000                                                                                                  31  34.015625

4 ETW000  [     dev trc,00000]  Wed Apr 17 17:03:12 2013                                             17001176  51.016801

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  37  51.016838

4 ETW000  [     dev trc,00000]  (11001) [08001] [Microsoft][SQL Native Client]TCP Provider: Der angegebene Host ist unbekannt.

4 ETW000                                                                                                  20  51.016858

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  22  51.016880

4 ETW000  [     dev trc,00000]  (0) [HYT00] [Microsoft][SQL Native Client]Login timeout expired           13  51.016893

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  29  51.016922

4 ETW000  [     dev trc,00000]  (11001) [08001] [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

4 ETW000                                                                                                  31  51.016953

4 ETW000  [     dev trc,00000]  Wed Apr 17 17:03:31 2013                                             18251153  69.268106

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  38  69.268144

4 ETW000  [     dev trc,00000]  (53) [08001] [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].

4 ETW000                                                                                                  22  69.268166

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  22  69.268188

4 ETW000  [     dev trc,00000]  (0) [HYT00] [Microsoft][SQL Native Client]Login timeout expired           13  69.268201

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  20  69.268221

4 ETW000  [     dev trc,00000]  (53) [08001] [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

4 ETW000                                                                                                  30  69.268251

former_member184473
Active Contributor
0 Kudos

Hello Steffen,

Checking the trans.log we can see:

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2373]

4 ETW000                                                                                                  36  17.014197

4 ETW000  [     dev trc,00000]  (11001) [08001] [Microsoft][SQL Native Client]TCP Provider: Der angegebene Host ist unbekannt.

And from your description:

following environment settings

dbms_type = mss

MSSQL_DBNAME = <sid>

MSSQL_SCHEMA = dbo

MSSQL_SERVER = MSSQLSERVER

For the 7.01 systems I would expect something like:

dbms_type = mss

MSSQL_DBNAME = <SID>

MSSQL_SCHEMA = <sid>

MSSQL_SERVER = <sql_instance>

The <sql_instance> can be:

  1. <machine_name> = default instance
  2. <machine_name>\<instance_name> = named instance

So, my first suggestion is to check the environment variables.

Regards,

Eduardo Rezende

0 Kudos

thank you all for your replies,

i have modified to

MSSQL_SERVER = HOSTNAME

MSSQL_SCHEMA = <sid>

now system copy runs

former_member184473
Active Contributor
0 Kudos

Hi Steffen,

Good to know you could proceed with the system copy!

Regards,

Eduardo

Answers (0)