Solved: DISP+WORK Dies after start

Former Member · ‎03-25-2009

Hi All,

Familiar Issue but I couldn't solve it. I tried to start my system, immediately after the DB and message server started its giving errors.

DB: Oracle 10g

OS: Windows 2003

Oracle is up and running and in status open

All the SAP Services and oracle services are running fine.

R3trans is also connecting to the database with RC=0

Everything seems to be fine. After checking all these,I tried upgrading the kernel also. but to no avail.

I dont know what's causing the problem.

I am giving all the trace file details

dev_ms

-

trc file: "dev_ms", trc level: 1, release: "700"

-

[Thr 2004] Wed Mar 25 18:15:24 2009

[Thr 2004] MsSSetTrcLog: trc logging active, max size = 20971520 bytes

systemid 562 (PC with Windows NT)

relno 7000

patchlevel 0

patchno 163

intno 20050900

make: multithreaded, Unicode, 64 bit, optimized

pid 2008

[Thr 2004] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 2008) [msxxserv.c 1835]

[Thr 2004] Wed Mar 25 18:15:25 2009

[Thr 2004] load acl file = E:\usr\sap\SM7\SYS\global\ms_acl_info.DAT

[Thr 2004] MsGetOwnIpAddr: my host addresses are :

[Thr 2004] 1 : [172.16.3.50] solman (HOSTNAME)

[Thr 2004] 2 : [127.0.0.1] solman.arvindcorp.com (LOCALHOST)

[Thr 2004] MsHttpInit: full qualified hostname = solman

[Thr 2004] HTTP logging is switch off

[Thr 2004] set HTTP state to LISTEN

[Thr 2004] ms/icf_info_server : deleted

[Thr 2004] *** I listen to port sapmsSM7 (3600) ***

[Thr 2004] *** I listen to internal port 3900 (3900) ***

[Thr 2004] *** HTTP port 8100 state LISTEN ***

[Thr 2004] CUSTOMER KEY: >Y1711800842<

[Thr 2004] Wed Mar 25 18:25:59 2009

[Thr 2004] *** ERROR => MsSCheckConnections: no response from client C0 (172.16.3.50) after 300 secs received [msxxserv.c 3176]

[Thr 2004] *** ERROR => MsSCheckConnections: disconnect now [172.16.3.50] [msxxserv.c 3180]

dev_w0

-

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

-

*

ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ

*

B

B Tue Mar 24 15:28:55 2009

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\SM7\DVEBMGS00\exe\dboraslib.dll' ...

B Library 'E:\usr\sap\SM7\DVEBMGS00\exe\dboraslib.dll' loaded

B Version of 'E:\usr\sap\SM7\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.167)

B New connection 0 created

M sysno 00

M sid SM7

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 185

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 2524

M

M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)

M length of sys_adm_ext is 576 bytes

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

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 22784 (1752)

M DpShMCreate: sizeof(tm_adm) 5912704 (29416)

M DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 00000000110B0050, size: 6607008)

M DpShMCreate: allocated sys_adm at 00000000110B0050

M DpShMCreate: allocated wp_adm at 00000000110B21F0

M DpShMCreate: allocated tm_adm_list at 00000000110B7AF0

M DpShMCreate: allocated tm_adm at 00000000110B7B50

M DpShMCreate: allocated wp_ca_adm at 000000001165B3D0

M DpShMCreate: allocated appc_ca_adm at 00000000116611D0

M DpShMCreate: allocated comm_adm at 0000000011663110

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 00000000116E9DA0

M DpShMCreate: allocated gw_adm at 00000000116E9E20

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 00000000116E9E50

M DpShMCreate: allocated wall_adm at 00000000116E9E60

M rdisp/queue_size_check_value : -> off

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

X mm.dump: set maximum dump mem to 96 MB

M

M Tue Mar 24 15:28:56 2009

M ThInit: running on host solman

M calling db_connect ...

C Prepending E:\usr\sap\SM7\DVEBMGS00\exe to Path.

C

C Tue Mar 24 15:28:57 2009

C Oracle Client Version: '10.2.0.2.0'

C

C Tue Mar 24 15:28:58 2009

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@SM7 on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0000000012AB20C0 000000000A9B2330 000000000A9B7B58

C Attaching to DB Server SM7 (con_hdl=0,svchp=000000000A9B7A18,srvhp=0000000012AD1118)

C Starting user session (con_hdl=0,svchp=000000000A9B7A18,srvhp=0000000012AD1118,usrhp=000000000A9B2B48)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

[dboci.c 4532]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 11145]

C Try to connect with default password

C Connecting as SAPSR3/<pwd>@SM7 on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C

C Tue Mar 24 15:28:59 2009

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0000000012AB20C0 000000000A9B2330 000000000A9B7B58

C Starting user session (con_hdl=0,svchp=000000000A9B7A18,srvhp=0000000012AD1118,usrhp=000000000A9B2B48)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

[dboci.c 4532]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 11145]

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

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#5 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#5 @ 431] [dblink 0431 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M pid = 2524

M severity = 0

M status = 0

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 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 attachedVm = no VM

M

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

M *

M * LOCATION SAP-Server solman_SM7_00 on host solman (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Tue Mar 24 15:28:59 2009

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10744

M * COUNTER 1

M *

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

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

Hope this log information helps.

Please let me know if you need any more details.

Thanks

Kasi

Former Member · ‎03-25-2009

Hi,

Hope the error due to either SAPSR3 user locked or the password changed in the database. Please use the BRTools to change the password for the user SAPSR3 and check it. You can do in BRTools as below...

BRTOOLS -> 8 - Additional functions -> 4 - Change password of database user

You can also check in the database whether the user is locked or not with the below sql statement...

select username,account_status from dba_users;

Regards,

JP.

Former Member · ‎04-16-2009

Check the famous 400241 note. Take your time and check step by step. Verify everything in place.

If you found any issues solve it.

Try login thru remote desktop with your SAPService<SID>. I had issues with that and I solved it with the help of ITS. I dont think you will be having the same issues. If your login is successful then, no help needed from the ITS.

Also check the Listener status in SAPService<SID>. in my case listener was working in <SID>adm and not in SAPService<SID>. lsnrctl status.

Also try to start the SAP system thru service user.

Good luck

~Kasi

Former Member · ‎03-30-2009

As Juan said, this is nothing to do with the password. But with the windows.

Finally I solved the issue with the r3trans execution. The issue is, in windows there is some policy settings in the domain controller. Something with NTservice login. It was not accepting any connection through the network. I talked to my ITS people and they solved it.

And there is a biggest blunder one could make. there is a typo in the DBA_SID environment variable. How stupid? Good lesson for me though!!!!

Once i set that it was not giving any errors and its trying to start.

Thanks for all the brains out there

Regards

Kasi

tim_buchholz · ‎03-30-2009

Since this is Windows, check r3trans -d for both the <SID>adm and the SAPService<SID> account.

Former Member · ‎03-30-2009

One final push for some solution!

I will explain it step by step:

The R3trans -d was not connecting properly with the database.

So I unlocked the user SAPSR3 in the database level by alter user SAPSR3 account unlock;

Then I reset the password of SAPSR3 in the table .SAPUSER by brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

Now r3trans is connecting properly. When I start my SAP thru MMC, the user SAPSR3 is getting locked again.

I checked the Environment variable and all. everything is proper.

Any help?????

Former Member · ‎03-30-2009

Yes I changed the password through BRTools after I unlocked that user ID.

I tried everything I could.,

Former Member · ‎03-25-2009

Hi,

Did you check the network connectivity?

Manoj

Former Member · ‎03-25-2009

Hi

Can you please throw some light on the memory sizing of your system

What is the size of the Page file, Instance Parameter abap/buffersize, and PHYS_MEMSIZE.

In addition , also check SAP notes:

Note 551915 - R/3 won't start after database restore or database copy

You will have to run the script contained in the user_restore.zip attachment.

Note 734034

I hope it helps

Regards

Chen

Former Member · ‎03-25-2009

Hi,

dev_ms.log is showing license check error. check you SAP license. Was there any h/w change on your server.

Regards,

Sachin Rane.

Former Member · ‎03-25-2009

Hi

Check SAP note number 400241.

Rahul

DISP+WORK Dies after start

Accepted Solutions (1)

Accepted Solutions (1)

Answers (9)

Answers (9)

Re: How to get the FIRST Date in a date column

Re: SAP Cloud ALM - Granular Authorization to Scop...

Delete Class assignment Button Not Visible

Re: SAP Analytics Cloud for planning - Inverse For...

EML action - passing all fields of a selected row ...