disp+work.exe - error ?

[Former Member]

Hi,

I have problem with SAP (Win 2003, SQL 2000, SAP ver 640). If i try start system from mmc then dispwork.exe it stops. This is my log, why dispwork.exe thats working ?

BR,

T.

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Fri Mar 28 14:57:45 2008

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\XXX\SYS\exe\run\dbmssslib.dll' ...

B Library 'D:\usr\sap\XXX\SYS\exe\run\dbmssslib.dll' loaded

B Version of 'D:\usr\sap\XXX\SYS\exe\run\dbmssslib.dll' is "640.00", patchlevel (0.100)

B New connection 0 created

M sysno 02

M sid XXX

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 101

M intno 20020600

M make: multithreaded, ASCII

M pid 2800

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: sizeof(wp_adm) 8280 (828)

M DpShMCreate: sizeof(tm_adm) 2379840 (11840)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 192000 (384)

M DpShMCreate: sizeof(vmc_adm) 0 (364)

M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 060B0040, size: 2667104)

M DpShMCreate: allocated sys_adm at 060B0040

M DpShMCreate: allocated wp_adm at 060B17D0

M DpShMCreate: allocated tm_adm_list at 060B3828

M DpShMCreate: allocated tm_adm at 060B3850

M DpShMCreate: allocated wp_ca_adm at 062F8890

M DpShMCreate: allocated appc_ca_adm at 062FCEE0

M DpShMCreate: allocated comm_adm_list at 062FE650

M DpShMCreate: allocated comm_adm at 062FE668

M DpShMCreate: allocated vmc_adm_list at 0632D468

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 0632D490

M DpShMCreate: allocated wall_adm at 0632D498

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 Fri Mar 28 14:57:46 2008

M calling db_connect ...

C Warning: Env(MSSQL_SCHEMA) [XXX] <> Prof(dbs/mss/schema) [XXX]. Profile value will be used.

C Thank You for using the SLOLEDB-interface

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

C dbmssslib.dll patch info

C patchlevel 0

C patchno 100

C patchcomment MSSQL: FormatIoBuffer correction (895509)

C Local connection used on server to named instance: np:server\XXX

C CopyLocalParameters: dbuser is 'XXX'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Fri Mar 28 14:58:02 2008

C OpenOledbConnection: line 22635. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), 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.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: 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

C Fri Mar 28 14:58:17 2008

C OpenOledbConnection: line 22635. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), 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.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: 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

C Fri Mar 28 14:58:33 2008

C OpenOledbConnection: line 22635. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), 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.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

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

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn to np:server\XXX.

C Retrying without protocol specifier: server\XXX

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Fri Mar 28 14:58:48 2008

C OpenOledbConnection: line 22635. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), 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.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: 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

C Fri Mar 28 14:59:04 2008

C OpenOledbConnection: line 22635. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), 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.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: 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

C Fri Mar 28 14:59:19 2008

C OpenOledbConnection: line 22635. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), 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.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: 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#3 @ 1204] [dbsh 1204 ]

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

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 1281]

M in_ThErrHandle: 1

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

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 server_XXX_02 on host server (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Fri Mar 28 14:59:19 2008

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9727

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 254]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\tsiedlecki>r3trans -d

This is r3trans version 6.13 (release 640 - 21.10.05 - 15:04:00).

2EETW169 no connect possible: "DBMS = MSSQL --- SERV

ER = 'MOPS-V5' DBNAME = 'RKU'"

r3trans finished (0012).

[Former Member]

Check if your listner is running?

Has any windows updates been recently applied to SQL Server or SAP Windows 2003 box?

Was this working earlier or is a new installation?

[Former Member]

Hi ,

It seems your database is down. Just check whether your databse is up and running.As it says it can not connect to server.Error/Message: (err -1, sev 0), An error has occurred while establishing a connection to the server

Regards,

Vamshi.

[Former Member]

Hi,

My database its working, i can connect to database by SQL Server Enterprise Manager, and i see db - XXX, all tables etc.

BR,

T.

[Former Member]

Dear Tomasz Siedlecki,

1. Login to system as sidadm

2. Open cmd prompt and execute R3trans -d. It will create a trans.log file in the corresponding folder from where you run this command

3.Review the trans.log to find out the error

Rgds,

Mat.

[Former Member]

Hi,

Thanks for help, im login to system as xxxadm, and this is log from R3trans:

C:\Documents and Settings\xxxadm>r3trans -d

This is r3trans version 6.13 (release 640 - 21.10.05 - 15:04:00).

2EETW169 no connect possible: "DBMS = MSSQL --- SERV

ER = 'MOPS-V5' DBNAME = 'XXX'"

r3trans finished (0012).

XXX - db name

XXX - db_owner db XXX

and this is - trans.log

BR,

T.

4 ETW000 r3trans version 6.13 (release 640 - 21.10.05 - 15:04:00).

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

4 ETW000

4 ETW000 date&time : 31.03.2008 - 10:28:40

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 Mar 31 10:28:40 2008 7095 0.007095

4 ETW000 [dev trc ,00000] db_con_init called 112 0.007207

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

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

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

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

4 ETW000 44 0.060262

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

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

4 ETW000 22 0.060296

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

4 ETW000 10924 0.071220

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

4 ETW000 35 0.071255

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

4 ETW000 27 0.071282

4 ETW000 [dev trc ,00000] New connection 0 created 6322 0.077604

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 51 0.077655

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

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

4 ETW000 19 0.077705

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 21 0.077726

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

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

4 ETW000 111 0.087533

4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 98 0.087631

4 ETW000 [dev trc ,00000] patchlevel 0 86 0.087717

4 ETW000 [dev trc ,00000] patchno 100 75 0.087792

4 ETW000 [dev trc ,00000] patchcomment MSSQL: FormatIoBuffer correction (895509)

4 ETW000 65 0.087857

4 ETW000 [dev trc ,00000] np:(local) connection used on MOPS-V5 839 0.088696

4 ETW000 [dev trc ,00000] CopyLocalParameters: dbuser is 'xxx' 14 0.088710

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 38524 0.127234

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

4 ETW000 396 0.127630

4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'xxx' setuser 'xxx']

4 ETW000 78342 0.205972

4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 5850. hr: 0x80040e14 There is no such user or group 'xxx'.

4 ETW000 445 0.206417

4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 5850]: Error/Message: (err 4604, sev 0), There is no such user or group 'xxx'.

4 ETW000 50 0.206467

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 11 0.206478

4 ETW000 [dev trc ,00000] setuser 'xxx' failed -- connect terminated 36 0.206514

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 8725 0.215239

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

4 ETW000 224 0.215463

4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'xxx' setuser 'xxx']

4 ETW000 11312 0.226775

4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 5850. hr: 0x80040e14 There is no such user or group 'xxx'.

4 ETW000 78 0.226853

4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 5850]: Error/Message: (err 4604, sev 0), There is no such user or group 'xxx'.

4 ETW000 54 0.226907

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 12 0.226919

4 ETW000 [dev trc ,00000] setuser 'xxx' failed -- connect terminated 26 0.226945

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 2276 0.229221

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

4 ETW000 222 0.229443

4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'xxx' setuser 'xxx']

4 ETW000 8048 0.237491

4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 5850. hr: 0x80040e14 There is no such user or group 'xxx'.

4 ETW000 33 0.237524

4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 5850]: Error/Message: (err 4604, sev 0), There is no such user or group 'xxx'.

4 ETW000 33 0.237557

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 11 0.237568

4 ETW000 [dev trc ,00000] setuser 'xxx' failed -- connect terminated 17 0.237585

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

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

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 109 0.245825

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

4 ETW000 186 0.246011

4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'xxx' setuser 'xxx']

4 ETW000 20600 0.266611

4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 5850. hr: 0x80040e14 There is no such user or group 'xxx'.

4 ETW000 36 0.266647

4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 5850]: Error/Message: (err 4604, sev 0), There is no such user or group 'xxx'.

4 ETW000 226 0.266873

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 12 0.266885

4 ETW000 [dev trc ,00000] setuser 'xxx' failed -- connect terminated 16 0.266901

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 10049 0.276950

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

4 ETW000 225 0.277175

4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'xxx' setuser 'xxx']

4 ETW000 8767 0.285942

4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 5850. hr: 0x80040e14 There is no such user or group 'xxx'.

4 ETW000 31 0.285973

4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 5850]: Error/Message: (err 4604, sev 0), There is no such user or group 'xxx'.

4 ETW000 32 0.286005

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 10 0.286015

4 ETW000 [dev trc ,00000] setuser 'xxx' failed -- connect terminated 17 0.286032

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 6573 0.292605

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

4 ETW000 205 0.292810

4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'xxx' setuser 'xxx']

4 ETW000 8807 0.301617

4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 5850. hr: 0x80040e14 There is no such user or group 'xxx'.

4 ETW000 43 0.301660

4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 5850]: Error/Message: (err 4604, sev 0), There is no such user or group 'xxx'.

4 ETW000 40 0.301700

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 12 0.301712

4 ETW000 [dev trc ,00000] setuser 'xxx' failed -- connect terminated 21 0.301733

4 ETW000 [dev trc ,00000] failed to establish conn. 0 6429 0.308162

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

4 ETW000 39029 0.347191

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

4 ETW000 21 0.347212

2EETW169 no connect possible: "DBMS = MSSQL --- SERVER = 'MOPS-V5' DBNAME = 'xxx'"

[Former Member]

Hi ,

Are you using <sid>adm user id to start the sap system.

It says connection could not be established or no connections are possible.

Regards,

Vamshi.

[Former Member]

Hi,

Yes im login to windows as xxxadm and start SAP, but if im look in to the trans.log then i see user - xxx, maybe there is a problem ? How changing in the SAP this users ? SAP it was transmited from other server, by somebody person. I dont now how, i want only start up him.

BR,

t.

Edited by: Tomasz Siedlecki on Mar 31, 2008 11:39 AM

[Former Member]

Hi,

Is your sap system name xxx?

Try using a administrator user.

Regards,

Vamshi.

[Former Member]

Hi Tom,

Try following steps

1. stop the DB

2. Stop all services

3. Restart the server.

4. Login as SIDadm.

5. start all services

6. start the DB

7. Start SAP from MMC

A simple restart can also solve the problem.

Hope this help

Regards,

Rajesh

[Former Member]

hi,

Yes, SAP system name its xxx, and im using users xxx or xxxadm for login to windows. This users haves full administrator privileges, but still not working.

BR,

T.

[Former Member]

hi Rajesh,

It has not helped, still not working, disp_work.exe working about one minute.

BR,

T.

[Former Member]

Hi Tom,

Check whether message server is running or not?

If running, then check dispatcher is connected to message server or not?

You can check both the things in SAP MMC.

Hope this help.

Regards,

Rajesh

[Former Member]

hi Rajesh,

Message server its running - (Running, Message Server connection ok, Dialog Queue dialog time: 0.00 sec) and dispatcher die. This is log from dev_disp.

-

---

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

-

---

Mon Mar 31 13:20:29 2008

kernel runs with dp version 130(ext=102) (@(#) DPLIB-INT-VERSION-130)

length of sys_adm_ext is 312 bytes

sysno 02

sid XXX

systemid 560 (PC with Windows NT)

relno 6400

patchlevel 0

patchno 101

intno 20020600

make: multithreaded, ASCII

pid 2508

***LOG Q00=> DpSapEnvInit, DPStart (02 2508) [dpxxdisp.c 1098]

shared lib "dw_xml.dll" version 101 successfully loaded

shared lib "dw_xtc.dll" version 101 successfully loaded

shared lib "dw_stl.dll" version 101 successfully loaded

shared lib "dw_gui.dll" version 101 successfully loaded

shared lib "dw_mdm.dll" version 101 successfully loaded

Mon Mar 31 13:20:34 2008

• WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 3887]

MtxInit: -2 0 0

DpSysAdmExtInit: ABAP is active

DpShMCreate: sizeof(wp_adm) 8280 (828)

DpShMCreate: sizeof(tm_adm) 2379840 (11840)

DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

DpShMCreate: sizeof(comm_adm) 192000 (384)

DpShMCreate: sizeof(vmc_adm) 0 (364)

DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

DpShMCreate: SHM_DP_ADM_KEY (addr: 058B0040, size: 2667104)

DpShMCreate: allocated sys_adm at 058B0040

DpShMCreate: allocated wp_adm at 058B17D0

DpShMCreate: allocated tm_adm_list at 058B3828

DpShMCreate: allocated tm_adm at 058B3850

DpShMCreate: allocated wp_ca_adm at 05AF8890

DpShMCreate: allocated appc_ca_adm at 05AFCEE0

DpShMCreate: allocated comm_adm_list at 05AFE650

DpShMCreate: allocated comm_adm at 05AFE668

DpShMCreate: allocated vmc_adm_list at 05B2D468

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 05B2D490

DpShMCreate: allocated wall_adm at 05B2D498

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 2263 blocks reserved for free list.

ES initialized.

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG Q0K=> DpMsAttach, mscon ( mops-v5) [dpxxdisp.c 9819]

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: Initalizing shared memory of size 40000000 for monitoring segment.

Mon Mar 31 13:20:35 2008

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 6400, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1025]

DpMsgAdmin: Set patchno for this platform to 101

Release check o.K.

Mon Mar 31 13:21:14 2008

• ERROR => W0 (pid 3992) died [dpxxdisp.c 12270]

• ERROR => W1 (pid 3476) died [dpxxdisp.c 12270]

• ERROR => W2 (pid 2728) died [dpxxdisp.c 12270]

• ERROR => W3 (pid 2736) died [dpxxdisp.c 12270]

my types changed after wp death/restart 0xbf --> 0xbe

• ERROR => W4 (pid 1060) died [dpxxdisp.c 12270]

my types changed after wp death/restart 0xbe --> 0xbc

• ERROR => W5 (pid 2744) died [dpxxdisp.c 12270]

my types changed after wp death/restart 0xbc --> 0xb8

• ERROR => W6 (pid 1704) died [dpxxdisp.c 12270]

• ERROR => W7 (pid 2772) died [dpxxdisp.c 12270]

my types changed after wp death/restart 0xb8 --> 0xb0

• ERROR => W8 (pid 2768) died [dpxxdisp.c 12270]

my types changed after wp death/restart 0xb0 --> 0xa0

• ERROR => W9 (pid 2124) died [dpxxdisp.c 12270]

my types changed after wp death/restart 0xa0 --> 0x80

• DP_FATAL_ERROR => DpWPCheck: no more work processes

• DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

killing W0-3992 (SIGUSR2)

• ERROR => DpWpKill(3992, SIGUSR2) failed [dpxxtool.c 2494]

killing W1-3476 (SIGUSR2)

• ERROR => DpWpKill(3476, SIGUSR2) failed [dpxxtool.c 2494]

killing W2-2728 (SIGUSR2)

• ERROR => DpWpKill(2728, SIGUSR2) failed [dpxxtool.c 2494]

killing W3-2736 (SIGUSR2)

• ERROR => DpWpKill(2736, SIGUSR2) failed [dpxxtool.c 2494]

killing W4-1060 (SIGUSR2)

• ERROR => DpWpKill(1060, SIGUSR2) failed [dpxxtool.c 2494]

killing W5-2744 (SIGUSR2)

• ERROR => DpWpKill(2744, SIGUSR2) failed [dpxxtool.c 2494]

killing W6-1704 (SIGUSR2)

• ERROR => DpWpKill(1704, SIGUSR2) failed [dpxxtool.c 2494]

killing W7-2772 (SIGUSR2)

• ERROR => DpWpKill(2772, SIGUSR2) failed [dpxxtool.c 2494]

killing W8-2768 (SIGUSR2)

• ERROR => DpWpKill(2768, SIGUSR2) failed [dpxxtool.c 2494]

killing W9-2124 (SIGUSR2)

• ERROR => DpWpKill(2124, SIGUSR2) failed [dpxxtool.c 2494]

NiWait: sleep (10000 msecs) ...

NiISelect: timeout 10000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:24 2008

NiISelect: TIMEOUT occured (10000 ms)

dump system status

Workprocess Table (long) Mon Mar 31 11:21:24 2008

========================

No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table

-

---

0 DIA 3992 Ended no 1 0 0

1 DIA 3476 Ended no 1 0 0

2 DIA 2728 Ended no 1 0 0

3 DIA 2736 Ended no 1 0 0

4 UPD 1060 Ended no 1 0 0

5 ENQ 2744 Ended no 1 0 0

6 BTC 1704 Ended no 1 0 0

7 BTC 2772 Ended no 1 0 0

8 SPO 2768 Ended no 1 0 0

9 UP2 2124 Ended no 1 0 0

Dispatcher Queue Statistics Mon Mar 31 11:21:24 2008

===========================

--------

---

+

---

+

---

+

---

+--

---

+

Typ

now

high

max

writes

reads

--------

---

+

---

+

---

+

---

+--

---

+

NOWP

0

3

2000

10

10

--------

---

+

---

+

---

+

---

+--

---

+

DIA

5

5

2000

5

0

--------

---

+

---

+

---

+

---

+--

---

+

UPD

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

ENQ

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

BTC

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

SPO

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

UP2

0

0

2000

0

0

--------

---

+

---

+

---

+

---

+--

---

+

max_rq_id 13

wake_evt_udp_now 0

wake events total 9, udp 8 ( 88%), shm 1 ( 11%)

since last update total 9, udp 8 ( 88%), shm 1 ( 11%)

Dump of tm_adm structure: Mon Mar 31 11:21:24 2008

=========================

Term uid man user term lastop mod wp ta a/i (modes)

Workprocess Comm. Area Blocks Mon Mar 31 11:21:24 2008

=============================

Slots: 300, Used: 1, Max: 0

--------

---

+

---

+--

---

+

id

owner

pid

eyecatcher

--------

---

+

---

+--

---

+

0

DISPATCHER

-1

WPCAAD000

NiWait: sleep (5000 msecs) ...

NiISelect: timeout 5000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:29 2008

NiISelect: TIMEOUT occured (5000 ms)

Shutdown server ...

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 110 bytes

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

Switch off Shared memory profiling

ShmProtect( 57, 3 )

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

Stop work processes...

Stop gateway

killing process (3980) (SOFT_KILL)

Stop icman

killing process (2092) (SOFT_KILL)

Terminate gui connections

[DpProcDied] Process lives (PID:3980 HANDLE:1624)

waiting for termination of gateway

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:30 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process died (PID:3980 HANDLE:1624)

[DpProcDied] Process lives (PID:2092 HANDLE:1628)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:31 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:2092 HANDLE:1628)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:32 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:2092 HANDLE:1628)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:33 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:2092 HANDLE:1628)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:34 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:2092 HANDLE:1628)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:35 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:2092 HANDLE:1628)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:36 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:2092 HANDLE:1628)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:37 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:2092 HANDLE:1628)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:38 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:2092 HANDLE:1628)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:39 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives (PID:2092 HANDLE:1628)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1645

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Mar 31 13:21:40 2008

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process died (PID:2092 HANDLE:1628)

DpHalt: cancel all lcom connections

MPI CancelAll 2 -> 0

MPI DeleteAll 2 -> 0

NiIMyHostName: hostname = 'mops-v5'

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0

DpConvertRequest: net size = 163 bytes

NiBufSend starting

NiIWrite: write 562, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 562 bytes

send msg (len 110+452) to name -, type 4, key -

detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 10045]

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiSelClear: removed hdl 3 from selectset

MBUF state OFF

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/10

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 19)

MBUF component DOWN

NiBufClose: clear extensions for hdl 3

NiBufSetStat: bufstat of hdl 3 changed from OK to OFF

NiICloseHandle: shutdown and close hdl 3 / socket 1576

MsIDetach: detach MS-system

EsCleanup ....

***LOG Q05=> DpHalt, DPStop ( 2508) [dpxxdisp.c 8547]

Good Bye .....

[JPReyes]

Hi Tomasz,

As per error

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

Check that SQL settings to see if you have enough sessions configured.

Regards

Juan

[Former Member]

hi Juan,

Thanks for help, but im using SQL Server 2000, check that in the SQL Server ? Remote connection from other computers with SQL Server working.

I have SQL Native Client for SQL Server 2005, delete it ?

BR,

T.

Edited by: Tomasz Siedlecki on Mar 31, 2008 2:02 PM

Edited by: Tomasz Siedlecki on Mar 31, 2008 2:18 PM

[JPReyes]

Well... something is very wrong then... if you instance is installed in SQL2000 and the system is pointing to 2005 then you have an issue...

Did you ever logon to this system successfully?

Regards

Juan

[Former Member]

hi,

Never, system was copied from other server (copy all files, backup and restore db, change sys files and schema DB). Im change in the DB password for user - SAP*, and if i try to logon then i have error - logon failed, connect to sap gateway failed etc.

BR,

T.

[Former Member]

hi,

One more time, im deleted SQL Native client and i dont see information about connection to SQL server 2005.

This is new log.

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Mon Mar 31 15:05:05 2008

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\xxx\SYS\exe\run\dbmssslib.dll' ...

B Library 'D:\usr\sap\xxx\SYS\exe\run\dbmssslib.dll' loaded

B Version of 'D:\usr\sap\xxx\SYS\exe\run\dbmssslib.dll' is "640.00", patchlevel (0.100)

B New connection 0 created

M sysno 02

M sid xxx

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 101

M intno 20020600

M make: multithreaded, ASCII

M pid 3208

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: sizeof(wp_adm) 8280 (828)

M DpShMCreate: sizeof(tm_adm) 2379840 (11840)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 192000 (384)

M DpShMCreate: sizeof(vmc_adm) 0 (364)

M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 060B0040, size: 2667104)

M DpShMCreate: allocated sys_adm at 060B0040

M DpShMCreate: allocated wp_adm at 060B17D0

M DpShMCreate: allocated tm_adm_list at 060B3828

M DpShMCreate: allocated tm_adm at 060B3850

M DpShMCreate: allocated wp_ca_adm at 062F8890

M DpShMCreate: allocated appc_ca_adm at 062FCEE0

M DpShMCreate: allocated comm_adm_list at 062FE650

M DpShMCreate: allocated comm_adm at 062FE668

M DpShMCreate: allocated vmc_adm_list at 0632D468

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 0632D490

M DpShMCreate: allocated wall_adm at 0632D498

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X

X Mon Mar 31 15:05:06 2008

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Mon Mar 31 15:05:07 2008

M calling db_connect ...

C Warning: Env(MSSQL_SCHEMA) [xxx] <> Prof(dbs/mss/schema) [xxx]. Profile value will be used.

C Thank You for using the SLOLEDB-interface

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

C dbmssslib.dll patch info

C patchlevel 0

C patchno 100

C patchcomment MSSQL: FormatIoBuffer correction (895509)

C np:(local) connection used on MOPS-V5

C CopyLocalParameters: dbuser is 'xxx'

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: MARS property was not set.

C Provider Release:08.10.1830

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C

C Mon Mar 31 15:05:09 2008

C Cache sizes: header 52 bytes, 20000 names (26720000 bytes), 1000 dynamic statements (5432000 bytes), total 32152052 bytes

C Using shared procedure name cache MOPS-V5_xxxxxx_xxx_MEM initialized by another process.

C Connected to db server : [MOPS-V5] server_used : [np:(local)], dbname: xxx, dbuser: xxx

C pn_id:MOPS-V5_xxxxxx_xxx

C Not using MARS (on sql 8.0)

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20080331 150507 MOPS-V5

C The IRow interface is supported by this OLEDB provider

C sloledb.cpp [ParamStmtExec,line 12367]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.

C Procname: [##Y3MOPS_V5xxx00000032720000000001150509]

C sloledb.cpp [ParamStmtExec,line 12367]: Error/Message: (err 208, sev 16), Invalid object name 'SVERS'.

C Procname: [##Y3MOPS_V5xxx00000032720000000001150509]

C ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt: [SELECT VERSION AS c FROM SVERS ]

C Conn_i:1 selection:1 singleton:1 flag_fupd:0 use_cursor:0 chksum: 112156

C DbSlRead - Error 103 (dbcode 208) on open

C DbSlRead - <##Y3MOPS_V5xxx00000032720000000001150509>

C DbSlRead - Error 103 (dbcode 208) on fetch

C DbSlRead - <##Y3MOPS_V5xxx00000032720000000001150509>

B ***LOG BZA=> table SVERS does not exist on database [dblink#2 @ 1281] [dblink 1281 ]

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

M in_ThErrHandle: 1

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

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 mops-v5_xxx_02 on host mops-v5 (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Mon Mar 31 15:05:09 2008

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9727

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 254]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

[JPReyes]

Hi Tomasz,

Read SAP note 351586, this might solve your problem

https://service.sap.com/sap/support/notes/351586

Regards

Juan

[Former Member]

Hi,

It has not helped, i dont now what now, thanks for help.

BR,

T.

[Former Member]

Hi Tomasz,

Did you also check the Note referenced in Note 351586, Note 116735? It says:

>Troubleshooting

>===============

>If there is a connection problem, you can set profile parameter

>

>dbs/oledb/verbose =1

>

>and you will see additional information in the dev_w?? files in the

>sapmnt\<SID>\dvebmgs00\work directory.

This may give more information as to why the DB connection is not working.

Best Regards,

Matt

[Former Member]

Hi,

Im checked all, and:

1. listener - is running, i can connect with DB from another computers.

2. updates - Microsoft Server 2003 R2 on VMWare and MS SQL Server 2000 (Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Computer working in the domain, but i added users on the local machine not in the domain and start SAP local, maybe there is a problem ?

3. Im reed SAP note 351586, 116735 and users server\<sid>adm server\SapService<SID> haves full privileges on DB and system.

4. dbs/oledb/verbose =1 - it has not helped.

5. Im install SQL Native client 2005 because i have read it technical documentation, but it has not helped.

6. All services(MS SQL Server, SQL Server Agent, SAPXXX_02, SAPOSCOL) working on account server\<sidadm>

BR,

T.

This is log - dev_w0

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Tue Apr 01 11:01:08 2008

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\XXX\SYS\exe\run\dbmssslib.dll' ...

B Library 'D:\usr\sap\XXX\SYS\exe\run\dbmssslib.dll' loaded

B Version of 'D:\usr\sap\XXX\SYS\exe\run\dbmssslib.dll' is "640.00", patchlevel (0.100)

B New connection 0 created

M sysno 02

M sid XXX

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 101

M intno 20020600

M make: multithreaded, ASCII

M pid 3020

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: sizeof(wp_adm) 8280 (828)

M DpShMCreate: sizeof(tm_adm) 2379840 (11840)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 192000 (384)

M DpShMCreate: sizeof(vmc_adm) 0 (364)

M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 060B0040, size: 2667104)

M DpShMCreate: allocated sys_adm at 060B0040

M DpShMCreate: allocated wp_adm at 060B17D0

M DpShMCreate: allocated tm_adm_list at 060B3828

M DpShMCreate: allocated tm_adm at 060B3850

M DpShMCreate: allocated wp_ca_adm at 062F8890

M DpShMCreate: allocated appc_ca_adm at 062FCEE0

M DpShMCreate: allocated comm_adm_list at 062FE650

M DpShMCreate: allocated comm_adm at 062FE668

M DpShMCreate: allocated vmc_adm_list at 0632D468

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 0632D490

M DpShMCreate: allocated wall_adm at 0632D498

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 Tue Apr 01 11:01:09 2008

M calling db_connect ...

C Warning: Env(MSSQL_SCHEMA) [XXX] <> Prof(dbs/mss/schema) [XXX]. Profile value will be used.

C Thank You for using the SLOLEDB-interface

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

C dbmssslib.dll patch info

C patchlevel 0

C patchno 100

C patchcomment MSSQL: FormatIoBuffer correction (895509)

C Local connection used on MOPS-V5 to named instance: np:Mops-v5\XXX

C CopyLocalParameters: dbuser is 'XXX'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Tue Apr 01 11:01:25 2008

C OpenOledbConnection: line 22635. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), 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.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: 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

C Tue Apr 01 11:01:41 2008

C OpenOledbConnection: line 22635. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), 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.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: 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

C Tue Apr 01 11:01:57 2008

C OpenOledbConnection: line 22635. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), 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.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

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

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn to np:Mops-v5\XXX.

C Retrying without protocol specifier: Mops-v5\XXX

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C

C Tue Apr 01 11:02:12 2008

C OpenOledbConnection: line 22635. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), 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.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: 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

C Tue Apr 01 11:02:28 2008

C OpenOledbConnection: line 22635. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), 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.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: 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

C Tue Apr 01 11:02:43 2008

C OpenOledbConnection: line 22635. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), 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.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 22635]: 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#3 @ 1204] [dbsh 1204 ]

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

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 1281]

M in_ThErrHandle: 1

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

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 mops-v5_XXX_02 on host mops-v5 (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Tue Apr 01 11:02:43 2008

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9727

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 254]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

[Former Member]

Hi Tomasz,

Since this is a copied system, there must be something wrong with the connection settings. Please see Note 98678 about SQL Server Connection Issues. If this does not help, I suggest opening a message with SAP Support and have them debug the issue.

Best Regards,

Matt

[enginimaldb]

Hi Thomas,

you can deploy UME SDA´s again.oss 942050.

Regards

Eimal

[Former Member]

Hi Eimal,

That will not help in this case, as this is not a "user" problem, rather a database user connection problem, which is completeley different from UME.

Best Regards,

Matt

[Former Member]

Hi Matt

I don’t know if you have not find the solution to your problem but I had a similar problem with my system which I have just sorted out.

After extensive search on various forums I have learnt that this problem has a number of reasons to occur.

My solution was as follows:

All of the services that were created using the ADM user on installation must consistently have the correct password as set up in the installation.

If somewhere in the lifetime of your system these passwords change then it must be done in all the affected service.

To mention a few

The SAP(instance no) for sap service,

The Oscolecter service

The db MSSQLSERVER service

The db SQLSERVERAGENT service etc must be updated with the current password so your system does not fail to start these services.

I hope this information is helpful.

Please let me know.

regards

[Former Member]

Hi,

Thanks for help again, but i have next question. I have information about users in dev_w0:

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'xxx' setuser 'xxx']

C sloledb.cpp [ExecuteAndFlush,line 5850]: Error/Message: (err 4604, sev 0), There is no such user or group 'xxx'

Maybe user must be - "xxxadm" - instead of - "xxx", and there is a problem ?

All services (SAP & MS SQL) working on the local account - "xxxadm", but server working in the domain.

BR,

T.

[Former Member]

Hi,

Just dont use your domain users to start sap, use the <sid>adm to start the database and the sap system it would do.

Regards,

Vamshi.

[Former Member]

Hi.

Did any of the suggestions help you so far?

[Former Member]

Hi,

Please try the following step:

USE XXX

GO

EXEC sp_change_users_login 'update_one','xxx','xxx'

GO

may it can helps.

Best regards,

Sandy