cancel
Showing results for 
Search instead for 
Did you mean: 

disp+work.exe stopped working

Former Member
0 Kudos

Hello all,

I am new to SAP, so please bear with me.

I have a ABAPJAVA test system, with the central instance and a dialog instance installed in the domain and the central service instance installed as a local installation. Before, all three instances were running perfectly. There has been some DNS problems in the network lately, and after I have corrected them, the dispwork process of the central and the dialog instances stop running (even as the central service instance still runs). Here is the trace log for the disp+work.exe for the central instance:

-


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

-


Wed May 16 15:59:59 2007

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

length of sys_adm_ext is 312 bytes

systemid 560 (PC with Windows NT)

relno 6400

patchlevel 0

patchno 43

intno 20020600

make: multithreaded, ASCII

pid 2976

***LOG Q00=> DpSapEnvInit, DPStart (10 2976) [dpxxdisp.c 1100]

shared lib "dw_xml.dll" version 43 successfully loaded

shared lib "dw_xtc.dll" version 43 successfully loaded

shared lib "dw_stl.dll" version 43 successfully loaded

shared lib "dw_gui.dll" version 43 successfully loaded

Wed May 16 16:00:05 2007

      • 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 3886]

MtxInit: -2 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: JAVA is not active

DpShMCreate: sizeof(wp_adm) 14080 (828)

DpShMCreate: sizeof(tm_adm) 2219848 (11044)

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 (320)

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

DpShMCreate: SHM_DP_ADM_KEY (addr: 04A10040, size: 2512872)

DpShMCreate: allocated sys_adm at 04A10040

DpShMCreate: allocated wp_adm at 04A117A8

DpShMCreate: allocated tm_adm_list at 04A14EA8

DpShMCreate: allocated tm_adm at 04A14ED0

DpShMCreate: allocated wp_ca_adm at 04C32E18

DpShMCreate: allocated appc_ca_adm at 04C37468

DpShMCreate: allocated comm_adm_list at 04C38BD8

DpShMCreate: allocated comm_adm at 04C38BF0

DpShMCreate: allocated vmc_adm_list at 04C679F0

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 04C67A18

DpShMCreate: allocated wall_adm at 04C67A20

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> 1999 blocks reserved for free list.

ES initialized.

J2EE server info

start = TRUE

state = STARTED

pid = 4148

argv[0] = C:\usr\sap\T10\DVEBMGS10/j2ee/os_libs/jcontrol.exe

argv[1] = C:\usr\sap\T10\DVEBMGS10/j2ee/os_libs/jcontrol.exe

argv[2] = pf=C:\usr\sap\T10\SYS\profile\T10_DVEBMGS10_saptest11

argv[3] = -DSAPSTART=1

argv[4] = -DCONNECT_PORT=1357

argv[5] = -DLISTEN_PORT=1358

argv[6] = -DSAPSYSTEM=10

argv[7] = -DSAPSYSTEMNAME=T10

argv[8] = -DSAPMYNAME=saptest11_T10_10

argv[9] = -DSAPPROFILE=C:\usr\sap\T10\SYS\profile\T10_DVEBMGS10_saptest11

argv[10] = -DFRFC_FALLBACK=ON

argv[11] = -DFRFC_FALLBACK_HOST=localhost

start_lazy = 0

start_control = SAP J2EE startup framework

DpJ2eeStart: j2ee state = STARTED

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG Q0K=> DpMsAttach, mscon ( saptest11) [dpxxdisp.c 9736]

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

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

DpMsgAdmin: Set release to 6400, patchlevel 0

DpJ2eeLogin: j2ee state = CONNECTED

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

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

DpMsgAdmin: Set patchno for this platform to 43

Release check o.K.

Wed May 16 16:00:45 2007

      • ERROR => W0 (pid 376) died [dpxxdisp.c 12187]

      • ERROR => W1 (pid 4280) died [dpxxdisp.c 12187]

      • ERROR => W2 (pid 4104) died [dpxxdisp.c 12187]

      • ERROR => W3 (pid 3544) died [dpxxdisp.c 12187]

      • ERROR => W4 (pid 3208) died [dpxxdisp.c 12187]

      • ERROR => W5 (pid 4120) died [dpxxdisp.c 12187]

      • ERROR => W6 (pid 3084) died [dpxxdisp.c 12187]

      • ERROR => W7 (pid 4160) died [dpxxdisp.c 12187]

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

      • ERROR => W8 (pid 4224) died [dpxxdisp.c 12187]

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

      • ERROR => W9 (pid 5388) died [dpxxdisp.c 12187]

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

      • ERROR => W10 (pid 5596) died [dpxxdisp.c 12187]

      • ERROR => W11 (pid 4248) died [dpxxdisp.c 12187]

      • ERROR => W12 (pid 4328) died [dpxxdisp.c 12187]

      • ERROR => W13 (pid 4344) died [dpxxdisp.c 12187]

      • ERROR => W14 (pid 5564) died [dpxxdisp.c 12187]

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

      • ERROR => W15 (pid 4132) died [dpxxdisp.c 12187]

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

      • ERROR => W16 (pid 4144) died [dpxxdisp.c 12187]

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-376 (SIGUSR2)

      • ERROR => DpWpKill(376, SIGUSR2) failed [dpxxtool.c 2468]

killing W1-4280 (SIGUSR2)

      • ERROR => DpWpKill(4280, SIGUSR2) failed [dpxxtool.c 2468]

killing W2-4104 (SIGUSR2)

      • ERROR => DpWpKill(4104, SIGUSR2) failed [dpxxtool.c 2468]

killing W3-3544 (SIGUSR2)

      • ERROR => DpWpKill(3544, SIGUSR2) failed [dpxxtool.c 2468]

killing W4-3208 (SIGUSR2)

      • ERROR => DpWpKill(3208, SIGUSR2) failed [dpxxtool.c 2468]

killing W5-4120 (SIGUSR2)

      • ERROR => DpWpKill(4120, SIGUSR2) failed [dpxxtool.c 2468]

killing W6-3084 (SIGUSR2)

      • ERROR => DpWpKill(3084, SIGUSR2) failed [dpxxtool.c 2468]

killing W7-4160 (SIGUSR2)

      • ERROR => DpWpKill(4160, SIGUSR2) failed [dpxxtool.c 2468]

killing W8-4224 (SIGUSR2)

      • ERROR => DpWpKill(4224, SIGUSR2) failed [dpxxtool.c 2468]

killing W9-5388 (SIGUSR2)

      • ERROR => DpWpKill(5388, SIGUSR2) failed [dpxxtool.c 2468]

killing W10-5596 (SIGUSR2)

      • ERROR => DpWpKill(5596, SIGUSR2) failed [dpxxtool.c 2468]

killing W11-4248 (SIGUSR2)

      • ERROR => DpWpKill(4248, SIGUSR2) failed [dpxxtool.c 2468]

killing W12-4328 (SIGUSR2)

      • ERROR => DpWpKill(4328, SIGUSR2) failed [dpxxtool.c 2468]

killing W13-4344 (SIGUSR2)

      • ERROR => DpWpKill(4344, SIGUSR2) failed [dpxxtool.c 2468]

killing W14-5564 (SIGUSR2)

      • ERROR => DpWpKill(5564, SIGUSR2) failed [dpxxtool.c 2468]

killing W15-4132 (SIGUSR2)

      • ERROR => DpWpKill(4132, SIGUSR2) failed [dpxxtool.c 2468]

killing W16-4144 (SIGUSR2)

      • ERROR => DpWpKill(4144, SIGUSR2) failed [dpxxtool.c 2468]

NiWait: sleep (10000 msecs) ...

NiISelect: timeout 10000 ms

NiISelect: maximum fd=1565

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed May 16 16:00:55 2007

NiISelect: TIMEOUT occured (10000 ms)

dump system status

Workprocess Table (long) Wed May 16 20:00:55 2007

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

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

-


0 DIA 376 Ended no 1 0 0

1 DIA 4280 Ended no 1 0 0

2 DIA 4104 Ended no 1 0 0

3 DIA 3544 Ended no 1 0 0

4 DIA 3208 Ended no 1 0 0

5 DIA 4120 Ended no 1 0 0

6 DIA 3084 Ended no 1 0 0

7 DIA 4160 Ended no 1 0 0

8 UPD 4224 Ended no 1 0 0

9 ENQ 5388 Ended no 1 0 0

10 BTC 5596 Ended no 1 0 0

11 BTC 4248 Ended no 1 0 0

12 BTC 4328 Ended no 1 0 0

13 BTC 4344 Ended no 1 0 0

14 BTC 5564 Ended no 1 0 0

15 SPO 4132 Ended no 1 0 0

16 UP2 4144 Ended no 1 0 0

Dispatcher Queue Statistics Wed May 16 20:00:55 2007

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

--------


+
+

+

+
--


+

Typ

now

high

max

writes

reads

--------


+
+

+

+
--


+

NOWP

0

3

2000

9

9

--------


+
+

+

+
--


+

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 7 ( 77%), shm 2 ( 22%)

since last update total 9, udp 7 ( 77%), shm 2 ( 22%)

Dump of tm_adm structure: Wed May 16 20:00:55 2007

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

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

Workprocess Comm. Area Blocks Wed May 16 20:00:55 2007

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

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=1565

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed May 16 16:01:00 2007

NiISelect: TIMEOUT occured (5000 ms)

Shutdown server ...

DpJ2eeDisableRestart

DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=4148)

killing process (4148) (SOFT_KILL)

DpIJ2eeShutdown: j2ee state = SHUTDOWN

NiSelClear: removed hdl 7 from selectset

DpDelSocketInfo: del info for socket 7 (type=8)

NiBufClose: clear extensions for hdl 7

NiBufSetStat: bufstat of hdl 7 changed from OK to OFF

NiICloseHandle: shutdown and close hdl 7 / socket 1324

NiSelClear: removed hdl 4 from selectset

DpDelSocketInfo: del info for socket 4 (type=9)

NiBufClose: clear extensions for hdl 4

NiBufSetStat: bufstat of hdl 4 changed from OK to OFF

NiICloseHandle: shutdown and close hdl 4 / socket 1520

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 5, 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 (4340) (SOFT_KILL)

Stop icman

killing process (4388) (SOFT_KILL)

Terminate gui connections

[DpProcDied] Process lives (PID:4340 HANDLE:1536)

waiting for termination of gateway

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1565

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed May 16 16:01:01 2007

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process died (PID:4340 HANDLE:1536)

[DpProcDied] Process died (PID:4388 HANDLE:1528)

DpHalt: cancel all lcom connections

MPI CancelAll 2 -> 0

MPI DeleteAll 2 -> 0

[DpProcDied] Process died (PID:4148 HANDLE:1504)

NiIMyHostName: hostname = 'saptest11'

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 5, 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 9962]

NiBufSend starting

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

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiSelClear: removed hdl 5 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/17

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 5

NiBufSetStat: bufstat of hdl 5 changed from OK to OFF

NiICloseHandle: shutdown and close hdl 5 / socket 1512

MsIDetach: detach MS-system

EsCleanup ....

***LOG Q05=> DpHalt, DPStop ( 2976) [dpxxdisp.c 8495]

Good Bye .....

Any help is appreciated.. points guaranteed for those who can help

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Charles,

Looks like network issue.

Check the host files on all the instances.Check if the IP details/hostname are correctly mentioned. Also check if the database is up and running.

Regards.

Ruchit.

Former Member
0 Kudos

I have tried logging on to SAP via SAP Longon, here is the error dialog resulted:

partner not reached (host 192.168.1.104, service sapdp10)

Time Wed May 16 16:32:45 2007

Component NI (network interface)

Release 640

Version 37

Module nixxi_r.cpp

Line 8672

Method NiPConnect2

Return Code -10

System Call SiPeekPendConn

Error No 10061

Error Text WSAECONNREFUSED: Connection refused

Counter 1

I have two LAN connection, thus, my host is identified by two ip addr: 192.168.1.104 and 192.168.1.201

I've checked that the database is up and running.

hmm.. where are the host files and the IP details of the instances located? (sorry I am a student, and a SAP newbie)

Thanks for your help !

Former Member
0 Kudos

I have checked the dev_rfc.trc.log in the C:\usr\sap\<SAPID>\<instance #>\work and I discovered some lines such as:

T:628 ======> CPIC-CALL: 'SAP_CMACCPTP'

ERROR internal error

TIME Tue May 15 12:43:19 2007

RELEASE 640

COMPONENT NI (network interface)

VERSION 37

RC -1

COUNTER 5

T:628 ======> CPIC-CALL: 'SAP_CMACCPTP'

ERROR illegal parameter value ( function=SAP_CMACCPTP /

parameter=handle / value=256 )

TIME Tue May 15 12:43:19 2007

RELEASE 640

COMPONENT CPIC (TCP/IP)

VERSION 3

RC 769

MODULE r3cpic.c

LINE 9069

COUNTER 7

T:628 Error RFCIO_ERROR_MESSAGE in abrfcio.c : 1584

T:628 <* RfcGetNameEx [8] : returns 1:RFC_FAILURE

T:628 Error RFCIO_ERROR_NOHANDLE in abrfcio.c : 3086

>TS> Tue May 15 12:44:26 2007

Former Member
0 Kudos

Hello Charles,

Host file in windows is at :

C:\WINDOWS\system32\drivers\etc.

Check the contents.

Also try to find if the IP addresses are correct using IPCONFIG from command prompt.

Regards.

Ruchit

Message was edited by:

Ruchit Khushu

Former Member
0 Kudos

hmm.. everything looks fine...

saptest11 is mapped to one of the addr of the host (192.168.104), and the ipconfig looks ok. Here is the dev_w7 file.. maybe someone could help me see what the problem is? Thanks!

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, M

*

B

B Thu May 17 09:37:59 2007

B create_con (con_name=R/3)

B *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

[dbcon.c 4442]

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 43

M intno 20020600

M make: multithreaded, ASCII

M pid 2024

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 7 2024) [dpxxdisp.c 1160]

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: JAVA is not active

M DpShMCreate: sizeof(wp_adm) 14080 (828)

M DpShMCreate: sizeof(tm_adm) 2219848 (11044)

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 (320)

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

M DpShMCreate: SHM_DP_ADM_KEY (addr: 05210040, size: 2512872)

M DpShMCreate: allocated sys_adm at 05210040

M DpShMCreate: allocated wp_adm at 052117A8

M DpShMCreate: allocated tm_adm_list at 05214EA8

M DpShMCreate: allocated tm_adm at 05214ED0

M DpShMCreate: allocated wp_ca_adm at 05432E18

M DpShMCreate: allocated appc_ca_adm at 05437468

M DpShMCreate: allocated comm_adm_list at 05438BD8

M DpShMCreate: allocated comm_adm at 05438BF0

M DpShMCreate: allocated vmc_adm_list at 054679F0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 05467A18

M DpShMCreate: allocated wall_adm at 05467A20

X EmInit: MmSetImplementation( 2 ).

X <ES> client 7 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Thu May 17 09:38:00 2007

M calling db_connect ...

B create_con (con_name=R/3)

B *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

[dbcon.c 4442]

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

M in_ThErrHandle: 1

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

M

M Info for wp 7

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 saptest11_T10_10 on host saptest11 (wp 7)

M * ERROR tskh_init: db_connect

M *

M * TIME Thu May 17 09:38:00 2007

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9589

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 7 2024) [dpnttool.c 357]

JPReyes
Active Contributor
0 Kudos

Hi Charles,

<b>*** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library</b>

Check parameter dbms/type in the default profile or in the enviromental variables... the value should depend on the DB your using, ORA for oracle, MSS for MSSQL, DB2, DB6, etc...

Also check that the kernel installed is for the right Database

Regards

Juan

Please reward with pointd if helpful

Former Member
0 Kudos

if you system is on oracle with windows OS

check this note

Note 556232 - Environment settings for R/3/Oracle on Windows

Former Member
0 Kudos

hi,

I can sucessfully log in to the (oracle) dbase manually (via connect / as sysdba with sqlplus)

Maybe it has something to do with DNS? Because this error occurs after I fixed a DNS problem....

JPReyes
Active Contributor
0 Kudos

Hi Charles,

Presuming that the DB is not in the same server as the CI

Have you tried to ping the DB from the CI Server?? can you call it with the hostname and the FQDN?, Have you done an R3trans -d to see if the DB can be reached?

Regards

Juan

Please reward with points if helpful

Former Member
0 Kudos

No, the database is on the same server as the CI..

thank you for all of your patience guys!

Former Member
0 Kudos

hmm.. the parameter dbms/type does not exist in DEFAULT.PFL in C:\usr\sap\<SAPID>\SYS\profile

Where do I change the environmental variables by the way, at Contrl Panel> System> Advanced--> Environment Variables? Sorry, I am really a newbie...

Thanks!

Former Member
0 Kudos

desktop -> mycomputer -> right click propertise -> advanced -> select environmental variables define this parameter in system variables

Samrat

Former Member
0 Kudos

Thanks for your help: Now I connected to the DB, and new errors crop up:

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, M

*

B

B Thu May 17 14:09:22 2007

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\T10\SYS\exe\run\dboraslib.dll' ...

B Library 'C:\usr\sap\T10\SYS\exe\run\dboraslib.dll' loaded

B Version of 'C:\usr\sap\T10\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.39)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 43

M intno 20020600

M make: multithreaded, ASCII

M pid 7872

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: JAVA is not active

M

M Thu May 17 14:09:23 2007

M DpShMCreate: sizeof(wp_adm) 14080 (828)

M DpShMCreate: sizeof(tm_adm) 2219848 (11044)

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 (320)

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

M DpShMCreate: SHM_DP_ADM_KEY (addr: 052B0040, size: 2512872)

M DpShMCreate: allocated sys_adm at 052B0040

M DpShMCreate: allocated wp_adm at 052B17A8

M DpShMCreate: allocated tm_adm_list at 052B4EA8

M DpShMCreate: allocated tm_adm at 052B4ED0

M DpShMCreate: allocated wp_ca_adm at 054D2E18

M DpShMCreate: allocated appc_ca_adm at 054D7468

M DpShMCreate: allocated comm_adm_list at 054D8BD8

M DpShMCreate: allocated comm_adm at 054D8BF0

M DpShMCreate: allocated vmc_adm_list at 055079F0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 05507A18

M DpShMCreate: allocated wall_adm at 05507A20

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 Thu May 17 14:09:24 2007

M calling db_connect ...

C Got ORACLE_HOME=C:\oracle\C11\920 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8MSWIN1252

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

C Connecting as /@C11 on connection 0 ...

C Attaching to DB Server C11 (con_hdl=0,svchp=06FD4ADC,svrhp=039136C4)

C Starting user session (con_hdl=0,svchp=06FD4ADC,srvhp=039136C4,usrhp=0391BE9C)

C Now I'm connected to ORACLE

C *** ERROR => ORA-1403 when accessing table SAPUSER

[dbsloci.c 10114]

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=06FD4ADC,usrhp=0391BE9C)

C Now I'm disconnected from ORACLE

C Try to connect with default password

C Connecting as SAPR3/<pwd>@C11 on connection 0 ...

C Starting user session (con_hdl=0,svchp=06FD4ADC,srvhp=039136C4,usrhp=0391BE9C)

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

[dboci.c 3720]

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

[dbsloci.c 9750]

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

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

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

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

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 saptest11_T10_10 on host saptest11 (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Thu May 17 14:09:24 2007

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9589

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 7872) [dpnttool.c 357]

Is ORA-1403 when accessing table SAPUSER my problem?

That is strange, because everything was working fine before!

Former Member
0 Kudos

HI,

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

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]

This is the problem.Did u changed any password <SID>ADM before

Soln :

use brtools to change the password of SAPUSER.<SID>ADM

regards

Umesh K

Former Member
0 Kudos

yes, I've changed those passwords before... I've looked at my oradbusr.log file and I found out that OPS$<domain_name>\<SID>ADM and OPS$<domain_name>\SAPSERVICE<SID> already exist. Do I log in the the dbase with these users to change it? Or will the brtools suffice?

Thanks for your reply and your patience!

Former Member
0 Kudos

I have successfully changed the password. Thanks! But now, it is telling me that I cannot login with SAPR3:

M calling db_connect ...

C Got ORACLE_HOME=C:\oracle\C11\920 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8MSWIN1252

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

C Connecting as /@C11 on connection 0 ...

C Attaching to DB Server C11 (con_hdl=0,svchp=06FD4ADC,svrhp=039136C4)

C Starting user session (con_hdl=0,svchp=06FD4ADC,srvhp=039136C4,usrhp=0391BE9C)

C Now I'm connected to ORACLE

C Got SAPR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=06FD4ADC,usrhp=0391BE9C)

C Now I'm disconnected from ORACLE

C Connecting as SAPR3/<pwd>@C11 on connection 0 ...

C Starting user session (con_hdl=0,svchp=06FD4ADC,srvhp=039136C4,usrhp=0391BE9C)

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

[dboci.c 3720]

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

[dbsloci.c 9750]

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

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

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

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

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

I have tried to use brtools again, a la:

brconnect -u system/<syspasswd> -f chpass -o SAPR3 -p <password>

and it comes up with the messages:

BR08024E: Owner 'SAPR3' not found in database or not SAP owner

BR0182E: Checking parameter/option 'chpass_owner/-o' failed

Do I have to directly insert a SAPR3 owner to OPS$<sid>ADM".SAPUSER?

Thanks for all your help!

Former Member
0 Kudos

Hi,

check the following link

Regards

Ben

Former Member
0 Kudos

Check your environment variable first set the correct path for system variables.Many a times this is the main culprit .

Also have a look to OSS Note 623242

Regards,

Jafer

Answers (5)

Answers (5)

Former Member
0 Kudos

Pleae also update us how did you solve your problem. Your experience will help to other users who are suffering to seek the solution.

REgards

Former Member
0 Kudos

Hi

Please explain me what you did to troubleshoot the DNS Problem. How the DNS Probelm arise ? Did you do any other other troubleshooting in last week ?

Did you remember when you start the SAP instances lately ?

Pleaes do the following task on commond prompt on Domain Server & SAP Server..

1) try to ping the IP addresses and hostname including the DNS server from the both server

2) Did you update any policy on the OS & server ?

3) If your problem are solved by the above steps please update the latest kernel to resolved your problem.

REgards

Anwer Waseem

Former Member
0 Kudos

OK.. all my problems are solved now.. I've got the dispatcher running again. Thanks everyone for their patience and their help!

Charles

Former Member
0 Kudos

Hi Charles,

I am also facing the same problem. I am not able to connect to DB.

Can you suggest me? I am also new to BASIS.

Thanks in Advance!!

Regards,

Santhosh.P

Former Member
0 Kudos

Hi guys, thanks for all your help, now it is able to log in successfully:

but now this is what I encounter:

C *** ERROR => NLS_LANG not set appropriately (DB installation requires AMERICAN_AMERICA.WE8DEC) ==> connection refused

[dbsloci.c 9881]

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

M in_ThErrHandle: 1

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

M

any pointers/links on how to modify this setting?

Thanks!

Former Member
0 Kudos

Looks like the user SAPR3 has not been created..

Can anyone tell me where to get the script to create the SAPR3 user in the oradbusr.sql? Or how to do it manually in sql? Much appreciated!

Charles