R/3 4.7 down after system copy

[Former Member]

Hello Experts

I have recently installed R/3 4.7 on MSSQL 2008 for UPGRADE to ECC 6.0 EHP5 . Referred note1476928.

System throws successful installation message. But system does not come up. SQL studio does not show to me any users created, What may have gone wrong ? Your urgent help required. Please find the attached trans and dev_w0 logs respectively

P.S:- sidadm and SAPServicesid created on domain to which i am able to login.

4 ETW000 R3trans version 6.13 (release 640 - 03.06.05 - 17:04:00).

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

4 ETW000

4 ETW000 date&time : 18.01.2012 - 12:52: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] Wed Jan 18 12:52:39 2012 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0.000000

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

4 ETW000 [dbcon.c ,00000] *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

4 ETW000 0.000000

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED.

-

---

trc file: "dev_w0", trc level: 1, release: "640"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Wed Jan 18 12:48:54 2012

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\SBX\SYS\exe\run\dbmssslib.dll' ...

B Library 'E:\usr\sap\SBX\SYS\exe\run\dbmssslib.dll' loaded

B Version of 'E:\usr\sap\SBX\SYS\exe\run\dbmssslib.dll' is "640.00", patchlevel (0.81)

B New connection 0 created

M sysno 00

M sid SBX

M systemid 562 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 80

M intno 20020600

M make: multithreaded, ASCII, 64 bit

M pid 4136

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 4136) [dpxxdisp.c 1158]

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: sizeof(wp_adm) 6624 (828)

M DpShMCreate: sizeof(tm_adm) 3021432 (15032)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 212000 (424)

M DpShMCreate: sizeof(vmc_adm) 0 (448)

M DpShMCreate: sizeof(wall_adm) (22440/36712/56/104)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000E2B0050, size: 3329520)

M DpShMCreate: allocated sys_adm at 000000000E2B0050

M DpShMCreate: allocated wp_adm at 000000000E2B1850

M DpShMCreate: allocated tm_adm_list at 000000000E2B3230

M DpShMCreate: allocated tm_adm at 000000000E2B3258

M DpShMCreate: allocated wp_ca_adm at 000000000E594CD0

M DpShMCreate: allocated appc_ca_adm at 000000000E599320

M DpShMCreate: allocated comm_adm_list at 000000000E59AA90

M DpShMCreate: allocated comm_adm at 000000000E59AAA8

M DpShMCreate: allocated vmc_adm_list at 000000000E5CE6C8

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000E5CE6F0

M DpShMCreate: allocated wall_adm at 000000000E5CE6F8

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Wed Jan 18 12:48:55 2012

M calling db_connect ...

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'E:\usr\sap\SBX\SYS\exe\run\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 81

C patchcomment MSSQL: No osql style options in DBCON (859579)

C np:(local) connection used on WINSANDBOXSVR

C CopyLocalParameters: dbuser is 'sbx'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 22560. hr: 0x8000ffff Login failed for user 'WIPRO-WIN\SAPServiceSBX'.

C sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 18456, sev 0), Login failed for user 'WIPRO-WIN\SAPServiceSBX'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 22560. hr: 0x8000ffff Login failed for user 'WIPRO-WIN\SAPServiceSBX'.

C sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 18456, sev 0), Login failed for user 'WIPRO-WIN\SAPServiceSBX'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 22560. hr: 0x8000ffff Login failed for user 'WIPRO-WIN\SAPServiceSBX'.

C sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 18456, sev 0), Login failed for user 'WIPRO-WIN\SAPServiceSBX'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn to np:(local).

C Retrying without protocol specifier: (local)

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Wed Jan 18 12:48:56 2012

C OpenOledbConnection: line 22560. hr: 0x8000ffff Login failed for user 'WIPRO-WIN\SAPServiceSBX'.

C sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 18456, sev 0), Login failed for user 'WIPRO-WIN\SAPServiceSBX'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 22560. hr: 0x8000ffff Login failed for user 'WIPRO-WIN\SAPServiceSBX'.

C sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 18456, sev 0), Login failed for user 'WIPRO-WIN\SAPServiceSBX'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 22560. hr: 0x8000ffff Login failed for user 'WIPRO-WIN\SAPServiceSBX'.

C sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 18456, sev 0), Login failed for user 'WIPRO-WIN\SAPServiceSBX'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn. 0

B ***LOG BY2=> sql error 0 performing CON [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY0=> <message text not available> [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY2=> sql error 0 performing CON [dblink#2 @ 419] [dblink 0419 ]

B ***LOG BY0=> <message text not available> [dblink#2 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1273]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9496]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server WINSANDBOXSVR_SBX_00 on host WINSANDBOXSVR (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Wed Jan 18 12:48:56 2012

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9672

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 252]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 4136) [dpnttool.c 357]

Best Regards

Pritish

[markus_doehr2]

> 4 ETW000 [dbcon.c ,00000] *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

What is the the content of the environment variable dbms_type of user SAPService<SID>?

Markus

[Former Member]

Hello Markus

Kindly find the content of the default profile

SAPSYSTEMNAME=SBX

SAPDBHOST=WINSANDBOXSVR

rdisp/mshost=WINSANDBOXSVR

rdisp/accept_remote_trace_level=0

rdisp/sna_gateway=WINSANDBOXSVR

rdisp/sna_gw_service=sapgw00

rslg/collect_daemon/listen_port=37

rslg/collect_daemon/talk_port=13

rdisp/bufrefmode=sendoff,exeauto

ms/server_port_0=PROT=HTTP, PORT=8100

dbms/type=mss

dbs/mss/server=WINSANDBOXSVR

dbs/mss/schema=sbx

dbs/mss/dbname=SBX

Best Regards

Pritish

[nicholas_chang]

Hi Pritish,

Please follow Note 151603 - Copying an SQL Server database - step 8: follow up procedure and see how it goes.

Thanks,

Nicholas Chang

Edited by: Nicholas Chang on Jan 18, 2012 4:54 PM

Edited by: Nicholas Chang on Jan 18, 2012 4:58 PM

[Former Member]

Hello Nicholas

If i log on to sidadm, the ENV variable has been set to mss. Please see the default profile parameters as well, in which the same has been mentioned.

The note you have mentioned talks about running STM tools. I had tried that eariler but got stuck as the GUI said the user does not exist. But i tried again and now i realized that i had mentioned "incorrect domain". I shall run the STM tool with "Database Copy" option.Thanks for the tip again.

Best Regards

Pritish

Edited by: Pritish Bajpai on Jan 18, 2012 10:38 AM

[Former Member]

If i try to run r3trans -d from sidadm. the output is

4 ETW000 R3trans version 6.13 (release 640 - 03.06.05 - 17:04:00).

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

4 ETW000

4 ETW000 date&time : 18.01.2012 - 13:48:25

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] Wed Jan 18 13:48:29 2012 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0.000000

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

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

4 ETW000 [dev trc ,00000] load shared library (dbmssslib.dll), hdl 0 0.000000

4 ETW000 [dev trc ,00000] using "E:\usr\sap\SBX\SYS\exe\run\dbmssslib.dll"

4 ETW000 0.000000

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

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

4 ETW000 0.000000

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

4 ETW000 67 0.000067

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

4 ETW000 25 0.000092

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

4 ETW000 27 0.000119

4 ETW000 [dev trc ,00000] New connection 0 created 35 0.000154

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 33 0.000187

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

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

4 ETW000 23 0.000228

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

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

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

4 ETW000 40 0.002468

4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 26 0.002494

4 ETW000 [dev trc ,00000] patchlevel 0 13 0.002507

4 ETW000 [dev trc ,00000] patchno 81 13 0.002520

4 ETW000 [dev trc ,00000] patchcomment MSSQL: No osql style options in DBCON (859579)

4 ETW000 22 0.002542

4 ETW000 [dev trc ,00000] np:(local) connection used on WINSANDBOXSVR 26 0.002568

4 ETW000 [dev trc ,00000] CopyLocalParameters: dbuser is 'sbx' 16 0.002584

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 7344 0.009928

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

4 ETW000 101 0.010029

4 ETW000 [dev trc ,00000] OpenOledbConnection: line 22560. hr: 0x8000ffff Login failed for user 'WIPRO-WIN\sbxadm'.

4 ETW000 9748 0.019777

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 18456, sev 0), Login failed for user 'WIPRO-WIN\sbxadm'.

4 ETW000 64 0.019841

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 15 0.019856

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 0, sev 0), Invalid connection string attribute

4 ETW000 49 0.019905

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 14 0.019919

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 10219 0.030138

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

4 ETW000 50 0.030188

4 ETW000 [dev trc ,00000] OpenOledbConnection: line 22560. hr: 0x8000ffff Login failed for user 'WIPRO-WIN\sbxadm'.

4 ETW000 2332 0.032520

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 18456, sev 0), Login failed for user 'WIPRO-WIN\sbxadm'.

4 ETW000 48 0.032568

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 14 0.032582

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 0, sev 0), Invalid connection string attribute

4 ETW000 46 0.032628

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 14 0.032642

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 13118 0.045760

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

4 ETW000 48 0.045808

4 ETW000 [dev trc ,00000] OpenOledbConnection: line 22560. hr: 0x8000ffff Login failed for user 'WIPRO-WIN\sbxadm'.

4 ETW000 2285 0.048093

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 18456, sev 0), Login failed for user 'WIPRO-WIN\sbxadm'.

4 ETW000 48 0.048141

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 14 0.048155

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 0, sev 0), Invalid connection string attribute

4 ETW000 46 0.048201

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 13 0.048214

4 ETW000 [dev trc ,00000] failed to establish conn to np:(local). 13145 0.061359

4 ETW000 [dev trc ,00000] Retrying without protocol specifier: (local) 27 0.061386

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 43 0.061429

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

4 ETW000 41 0.061470

4 ETW000 [dev trc ,00000] OpenOledbConnection: line 22560. hr: 0x8000ffff Login failed for user 'WIPRO-WIN\sbxadm'.

4 ETW000 4895 0.066365

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 18456, sev 0), Login failed for user 'WIPRO-WIN\sbxadm'.

4 ETW000 51 0.066416

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 16 0.066432

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 0, sev 0), Invalid connection string attribute

4 ETW000 46 0.066478

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 14 0.066492

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 10423 0.076915

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

4 ETW000 50 0.076965

4 ETW000 [dev trc ,00000] OpenOledbConnection: line 22560. hr: 0x8000ffff Login failed for user 'WIPRO-WIN\sbxadm'.

4 ETW000 2409 0.079374

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 18456, sev 0), Login failed for user 'WIPRO-WIN\sbxadm'.

4 ETW000 48 0.079422

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 15 0.079437

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 0, sev 0), Invalid connection string attribute

4 ETW000 51 0.079488

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 14 0.079502

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 13059 0.092561

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

4 ETW000 50 0.092611

4 ETW000 [dev trc ,00000] OpenOledbConnection: line 22560. hr: 0x8000ffff Login failed for user 'WIPRO-WIN\sbxadm'.

4 ETW000 2368 0.094979

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 18456, sev 0), Login failed for user 'WIPRO-WIN\sbxadm'.

4 ETW000 48 0.095027

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 14 0.095041

4 ETW000 [dev trc ,00000] sloledb.cpp [OpenOledbConnection,line 22560]: Error/Message: (err 0, sev 0), Invalid connection string attribute

4 ETW000 46 0.095087

4 ETW000 [dev trc ,00000] Procname: [OpenOledbConnection - no proc] 13 0.095100

4 ETW000 [dev trc ,00000] failed to establish conn. 0 13043 0.108143

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 0 performing CON [dblink#2 @ 419]

4 ETW000 110 0.108253

4 ETW000 [dblink ,00419] ***LOG BY0=><message text not available> [dblink#2 @ 419]

4 ETW000 23 0.108276

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

[nicholas_chang]

Hi Pritish,

Have you check PAM? Please have a look on PAM as i don't think R/3 4.7 is supported on MSSQL2008.

Thanks,

Nicholas Chang

[Former Member]

Hello Nicholas

R/3 is supported for upgrade purpose as per note which i have mentioned above.

Regards

Pritish