cancel
Showing results for 
Search instead for 
Did you mean: 

r3trans doesn't connect to database

Former Member
0 Kudos

Hello everybody,

we have installed IDES 4.7 x 200 ( Windows 2003 Server and oracle 9.2.0.4). Dispatcher and messager server are working. It is possible to work on SAP System. But if I try to execute r3trans -d, then I become the following error:

<i>This is r3trans version 6.09 (release 640 - 28.04.04 - 16:14:00).

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

r3trans finished (0012).</i>

the trans.log file looks like this:

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

4 ETW000 2286 0.045094

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."</i>

I thought that I have to set <i>dbms/type = ora</i> in profile. I did it, but it didn't help. I set also dbms_type = ora in environment variables, but it also didn't help.

Any ideas?

Thanks

regards from cologne.

Kutbettin Baran

Message was edited by: Kutbettin Baran

Accepted Solutions (0)

Answers (5)

Answers (5)

0 Kudos

Good morning I have a problem ... I'm running a system copy ... but the "disp + work.exe" not up, when up SAP services, manages to be green and then turns gray .. .

Your help please

Log:

---------------------------------------------------

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

---------------------------------------------------

sysno      00

sid        MHK

systemid   562 (PC with Windows NT)

relno      7210

patchlevel 0

patchno    500

intno      20020600

make       multithreaded, Unicode, 64 bit, optimized

profile    C:\usr\sap\MHK\SYS\profile\MHK_DVEBMGS00_MH-CPD-HSIGBD

pid        7880

kernel runs with dp version 140000(ext=121000) (@(#) DPLIB-INT-VERSION-140000-UC)

length of sys_adm_ext is 592 bytes

*** SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (00 7880) [dpxxdisp.c   1323]

  shared lib "dw_xml.dll" version 500 successfully loaded

  shared lib "dw_xtc.dll" version 500 successfully loaded

  shared lib "dw_stl.dll" version 500 successfully loaded

  shared lib "dw_gui.dll" version 500 successfully loaded

  shared lib "dw_mdm.dll" version 500 successfully loaded

  shared lib "dw_rndrt.dll" version 500 successfully loaded

  shared lib "dw_abp.dll" version 500 successfully loaded

  shared lib "dw_sym.dll" version 500 successfully loaded

  shared lib "dw_aci.dll" version 500 successfully loaded

rdisp/softcancel_sequence :  -> 0,5,-1

use internal message server connection to port 3900

rdisp/dynamic_wp_check : 1

rdisp/calculateLoadAverage : 1

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

display_tcp_ip: 0

Set Check Logoff Flags to 0x0

DpIPCInit2: write dp-profile-values into sys_adm_ext

DpIPCInit2: start server >MH-CPD-HSIGBD_MHK_00                    <

DpShMCreate: sizeof(wp_adm) 42864 (2256)

DpShMCreate: sizeof(tm_adm) 5790416 (28808)

DpShMCreate: sizeof(wp_ca_adm) 64000 (64)

DpShMCreate: sizeof(appc_ca_adm) 64000 (64)

DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1392064/1392080

DpShMCreate: sizeof(comm_adm) 1392080 (2768)

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

DpShMCreate: sizeof(slock_adm) 0 (296)

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

DpShMCreate: sizeof(file_adm) 0 (80)

DpShMCreate: sizeof(vmc_adm) 0 (2160)

DpShMCreate: sizeof(wall_adm) (41664/42896/64/192)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: sizeof(j2ee_adm) 3952

DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000003430050, size: 7456192)

DpShMCreate: allocated sys_adm at 0000000003430060

DpShMCreate: allocated wp_adm_list at 00000000034330B0

DpShMCreate: allocated wp_adm at 00000000034332A0

DpShMCreate: allocated tm_adm_list at 000000000343DA20

DpShMCreate: allocated tm_adm at 000000000343DA70

DpShMCreate: allocated wp_ca_adm at 00000000039C3550

DpShMCreate: allocated appc_ca_adm at 00000000039D2F60

DpShMCreate: allocated comm_adm at 00000000039E2970

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 0000000003B36750

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated gw_adm at 0000000003B36800

DpShMCreate: allocated j2ee_adm at 0000000003B36840

DpShMCreate: allocated ca_info at 0000000003B377C0

DpShMCreate: allocated wall_adm at 0000000003B37850

DpCommAttachTable: attached comm table (header=00000000039E2970/ft=00000000039E2980)

DpSysAdmIntInit: initialize sys_adm

rdisp/test_roll : roll strategy is DP_NORMAL_ROLL

dia token check not active (10 token)

MBUF state OFF

DpCommInitTable: init table for 500 entries

DpRqQInit: keep protect_queue / slots_per_queue 0 / 2001 in sys_adm

rdisp/queue_size_check_value :  -> on,50,30,40,500,50,500,80

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> EsILock: use Mutex for locking

<ES> InitFreeList

<ES> block size is 4096 kByte.

<ES> Info: em/initial_size_MB( 16383MB) not multiple of em/blocksize_KB( 4096KB)

<ES> Info: em/initial_size_MB rounded up to 16384MB

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

Wed Sep 28 11:05:46 2016

<ES> 4095 blocks reserved for free list.

ES initialized.

mm.dump: set maximum dump mem to 192 MB

mm.dump: set global maximum dump mem to 192 MB

EsRegisterEmCheck: Register EmGetEsHandles at 00007FF6E8C57560

DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE

MPI: dynamic quotas disabled.

MPI init: pipes=4000 buffers=1279 reserved=383 quota=10%

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 4.0.1 4.0.1 5.1) [dpxxdisp.c   1709]

***LOG Q0K=> DpMsAttach, mscon ( MH-CPD-HSIGBD) [dpxxdisp.c   12944]

MBUF state LOADING

DpStartStopMsg: send start message (myname is >MH-CPD-HSIGBD_MHK_00                    <)

DpStartStopMsg: start msg sent

CCMS: SemInMgt: Semaphore Management initialized by AlAttachShm_Doublestack.

CCMS: SemInit: Semaphore 38 initialized by AlAttachShm_Doublestack.

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

DpMBufHwIdSet: set Hardware-ID

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

MBUF state ACTIVE

DpWpBlksLow: max wp blocks in queue is 800 (80 %)

MBUF component UP

DpMsgProcess: 1 server in MBUF

DpAppcBlksLow: max appc blocks in queue is 500 (50 %)

Wed Sep 28 11:06:26 2016

*** ERROR => DpHdlDeadWp: W0 (pid 8680) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W1 (pid 10140) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W2 (pid 9364) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W3 (pid 11232) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W4 (pid 11172) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W5 (pid 384) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W6 (pid 11068) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W7 (pid 4952) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W8 (pid 9956) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W9 (pid 9336) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W10 (pid 6976) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W11 (pid 3376) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W12 (pid 9160) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W13 (pid 6920) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W14 (pid 2128) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W15 (pid 9672) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W16 (pid 11580) died (severity=0, status=0) [dpxxwp.c     1746]

*** DP_FATAL_ERROR => DpWPCheck: no more work processes

*** DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:36 2016

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Wed Sep 28 17:06:36 2016

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

No Type  Pid    Status  Cause Start Rstr  Err Sem Time Program          Cl  User         Action                    Table

-------------------------------------------------------------------------------------------------------------------------------

0 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

1 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

2 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

3 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

4 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

5 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

6 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

7 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

8 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

9 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

10 UPD       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

11 ENQ       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

12 BTC       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

13 BTC       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

14 BTC       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

15 SPO       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

16 UP2       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

Dispatcher Queue Statistics Wed Sep 28 17:06:36 2016

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

+------+--------+--------+--------+------------+------------+

|  Typ |    now |   high |    max | writes     |  reads     |

+------+--------+--------+--------+------------+------------+

| NOWP |      0 |      2 |   2000 |          6 |          6 |

+------+--------+--------+--------+------------+------------+

|  DIA |      4 |      4 |   2000 |          4 |          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 9

wake_evt_udp_now 0

wake events       total     7,  udp     6 ( 85%),  shm     1 ( 14%)

since last update total     7,  udp     6 ( 85%),  shm     1 ( 14%)

DpGetLoadAverage: la1[1] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[1] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[1] = 0.044444 / -1.000000 %

Dispatcher Load Statistics

+------+---------+---------+---------+

|  Typ |     LA1 |     LA5 |    LA15 |

+------+---------+---------+---------+

|  DIA |   0.000 |   0.000 |   0.044 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[2] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[2] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[2] = 0.000000 / -1.000000 %

|  UPD |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[3] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[3] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[3] = 0.000000 / -1.000000 %

|  ENQ |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[4] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[4] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[4] = 0.000000 / -1.000000 %

|  BTC |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[5] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[5] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[5] = 0.000000 / -1.000000 %

|  SPO |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[6] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[6] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[6] = 0.000000 / -1.000000 %

|  UP2 |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

Dump of tm_adm structure: Wed Sep 28 17:06:36 2016

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

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

Workprocess Comm. Area Blocks Wed Sep 28 17:06:36 2016

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

Slots: 1000, Used: 1, Max: 2

+------+--------------+----------+-------------+

|   id | owner        |   pid    | eyecatcher  |

+------+--------------+----------+-------------+

|    0 | DISPATCHER   |       -1 | 0xdeadbeef |

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:41 2016

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >MH-CPD-HSIGBD_MHK_00                    < (normal)

DpJ2eeDisableRestart

DpMBufRead: read server list from MBUF (1 entries)

DpMBufMod: name [MH-CPD-HSIGBD_MHK_00                    ], types 191 state 3 (0x0 0x0 0x0 0x0)

DpMBufMod: call hooks for event MBUF_DPEVT_DSTATE (5->3)

AdGetSelfIdentRecord: >                                                                           <

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

AdCallRegisteredCvtToExt: opcode 60

AdCallRegisteredCvtToExt: opcode 60 call 00007FF6E82B6680

AdCallRegisteredCvtToExt: opcode 60 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 00007FF6E88EA050

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 00007FF6E88EA050

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 00007FF6E88EA050

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 00007FF6E88EA050

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 00007FF6E88EA050

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 00007FF6E88EA050

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 00007FF6E88EA050

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 00007FF6E88EA050

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 00007FF6E88EA050

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 00007FF6E88EA050

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

DpWpBlksLow: wp_blks_in_queue/threshold/max = 1/800/1000

DpLockWpBlkEx: lock wp ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqIPutIntoQ: put elem in queue DIA, elems=5

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

MBUF server state SHUTDOWN

DpModState: change state STARTING -> SHUTDOWN

NiBufSend starting

NiIWrite: hdl 17 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

DpHalt: 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

DpHalt: stop work processes

DpHalt: stop gateway

killing process (10720) (SOFT_KILL)

DpHalt: stop icman

killing process (11372) (SOFT_KILL)

DpHalt: terminate gui connections

DpHalt: wait for end of work processes

DpHalt: wait for end of gateway

[DpProcDied] Process lives  (PID:10720  HANDLE:928)

DpHalt: waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:42 2016

NiISelect: TIMEOUT occured (1000ms)

*** ERROR => [DpProcDied] Process died  (PID:10720  HANDLE:928  rc:0x0) [dpnttool2.c  147]

DpHalt: wait for end of icman

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:43 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:44 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:45 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:46 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:47 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:48 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:49 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:50 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:51 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:52 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:53 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:54 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:55 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:56 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:57 2016

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives  (PID:11372  HANDLE:940)

DpHalt: waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1153

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Sep 28 11:06:58 2016

NiISelect: TIMEOUT occured (1000ms)

*** ERROR => [DpProcDied] Process died  (PID:11372  HANDLE:940  rc:0x0) [dpnttool2.c  147]

DpStartStopMsg: send stop message (myname is >MH-CPD-HSIGBD_MHK_00                    <)

DpStartStopMsg: Write AD_STARTSTOP message with type=  0, name=MH-CPD-HSIGBD_MHK_00, sapsysnr= 0, hostname=MH-CPD-HSIGBD                                                  

AdGetSelfIdentRecord: >                                                                           <

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

AdCallRegisteredCvtToExt: opcode 60

AdCallRegisteredCvtToExt: opcode 60 call 00007FF6E82B6680

AdCallRegisteredCvtToExt: opcode 60 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 4

AdCallRegisteredCvtToExt: opcode 4 call 00007FF6E82DF0F0

AdCallRegisteredCvtToExt: opcode 4 exit rc=SAP_O_K

DpConvertRequest: net size = 189 bytes

NiBufIAlloc: malloc MSLIB-BUF, to 32110 bytes

NiBufSend starting

NiIWrite: hdl 17 sent data (wrt=562,pac=1,MESG_IO)

MsINiWrite: sent 562 bytes

MsISnd2: send msg (ms hdr/msg 110/452 bytes) to name                    -, type 4, key -

DpStartStopMsg: stop msg sent

NiBufIAlloc: malloc MSLIB-BUF, to 32110 bytes

NiBufIAlloc: malloc NIBUF-IN, to 32110 bytes

NiIRead: hdl 17 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 17

NiBufReceive starting

MsINiRead: received 274 bytes

MsIReceive: received msg (ms hdr/msg 110/164 bytes), flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 17 recv would block (errno=EAGAIN)

NiIRead: read for hdl 17 timed out (0ms)

DpHalt: more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: hdl 17 sent data (wrt=114,pac=1,MESG_IO)

MsINiWrite: sent 114 bytes

MsISnd2: send msg (ms hdr/msg 110/4 bytes) to name           MSG_SERVER, type 0, key -

MsSndName: MS_NOOP ok

Send 4 bytes to MSG_SERVER

NiBufIAlloc: malloc MSLIB-BUF, to 32110 bytes

NiIRead: hdl 17 recv would block (errno=EAGAIN)

NiIPeek: peek successful for hdl 17 (r)

NiBufIAlloc: malloc NIBUF-IN, to 32110 bytes

NiIRead: hdl 17 received data (rcd=114,pac=1,MESG_IO)

NiBufIIn: NIBUF len=114

NiBufIIn: packet complete for hdl 17

NiBufReceive starting

MsINiRead: received 114 bytes

MsIReceive: received msg (ms hdr/msg 110/4 bytes), flag 3, from MSG_SERVER          , typ 0, key -

Received 4 bytes from MSG_SERVER                             

Received opcode MS_NOOP from msg_server, reply MSOP_OK

MsOpReceive: ok

MsISendKeepalive : keepalive sent to message server

NiIRead: hdl 17 recv would block (errno=EAGAIN)

Wed Sep 28 11:06:59 2016

NiIPeek: peek for hdl 17 timed out (r; 1000ms)

NiIRead: read for hdl 17 timed out (1000ms)

DpHalt: no more messages from the message server

DpHalt: sync with message server o.k.

DpHalt: detach from message server

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

NiBufSend starting

NiIWrite: hdl 17 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server (MH-CPD-HSIGBD / 3900)

MsIDetach: call exit function

DpMsShutdownHook called

NiBufISelUpdate: new MODE -- (r-) for hdl 17 in set0

SiSelNSet: set events of sock 1060 to: ---

NiBufISelRemove: remove hdl 17 from set0

SiSelNRemove: removed sock 1060 (pos=2)

SiSelNRemove: removed sock 1060

NiSelIRemove: removed hdl 17

DpDelSocketInfo: del info for nihdl 17 (pos/type=2/4)

MBUF state OFF

AdGetSelfIdentRecord: >                                                                           <

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

AdCallRegisteredCvtToExt: opcode 60

AdCallRegisteredCvtToExt: opcode 60 call 00007FF6E82B6680

AdCallRegisteredCvtToExt: opcode 60 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 00007FF6E88EA050

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

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

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 00007FF6E88EA050

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

DpWpBlksLow: wp_blks_in_queue/threshold/max = 2/800/1000

DpLockWpBlkEx: lock wp ca_blk 2

make DISP owner of wp_ca_blk 2

DpRqIPutIntoQ: put elem in queue DIA, elems=6

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

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 17/sock 1060

NiBufIClose: clear extension for hdl 17

MsIDetach: detach MS-system (MH-CPD-HSIGBD / 3900)

DpHalt: cleanup EM

EsCleanup( )

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 7880) [dpxxdisp.c   11819]

DpHalt: Good Bye .....

raquel_gomez
Employee
Employee
0 Kudos

Hi,

Dispatcher trace file shows all work processes dyning, causing the server to be stopped.

Wed Sep 28 11:06:26 2016

*** ERROR => DpHdlDeadWp: W0 (pid 8680) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W1 (pid 10140) died (severity=0, status=0) [dpxxwp.c     1746]

   ..........

*** ERROR => DpHdlDeadWp: W15 (pid 9672) died (severity=0, status=0) [dpxxwp.c     1746]

*** ERROR => DpHdlDeadWp: W16 (pid 11580) died (severity=0, status=0) [dpxxwp.c     1746]

*** DP_FATAL_ERROR => DpWPCheck: no more work processes

*** DISPATCHER EMERGENCY SHUTDOWN ***


You need to check dev_w* trace files at that timestamp to anlyze why work processes died:

Regards,
Raquel

0 Kudos

Thanks restore the database and sorted

Former Member
0 Kudos

please try this in the future...

I have received this error before and it was because the user password mapping between the DB and AS was different.  If using HANA reset the schema user password in HANA Studio if locked:

ALTER USER <SCHEMA USER> RESET CONNECT ATTEMPTS;

then change the schema user password so it matches with the same schema user password the AS was assigned in the installation.

I hope this helps someone in the future

Former Member
0 Kudos

Try updating the kernel. We tried all solutions found in different forums, whcih were similar to the one above, but nothing worked. Only when we updated the kernel, the problem was gone.

Regards,

Juan-Carlos Garcia

Former Member
0 Kudos

Hello,

Have you checked if the listener is running?

Plus, you say the SAP system is running, but a new connection to the database doesn't work. This indicates that it did work in the past (SAP doesn't start when "R3trans -d" fails during startup)

Kind regards,

Pascal Ottens

Former Member
0 Kudos

Hello Pascal,

the listener is running. I can work and execute transactions on SAP System (IDES 4.7 ). It is still running, but r3trans -d fails.

Thanks.

Best regards

Baran

former_member185954
Active Contributor
0 Kudos

Hi,

can you paste the output of R3trans -d here in this post.

Regards,

Siddhesh

former_member185954
Active Contributor
0 Kudos

Hi,

Please check if you have set the parameters as specified in this link

http://help.sap.com/saphelp_46c/helpdata/en/3d/ad5bc24ebc11d182bf0000e829fbfe/frameset.htm

Hope that helps.

Regards,

Siddhesh

Former Member
0 Kudos

Hi,

r3trans is running again correct. We had executed r3trans -d by accident not with <sid>adm. We have other users with admin rights on this server. We have forgotten to start r3trans -d with <sid>adm.

Thanks everybody for the answers.

Best regards

Baran

former_member182709
Contributor
0 Kudos

Thanks, Baran. This info helped me.

Former Member
0 Kudos

Hi,

Go to RZ10, import the profiles into the SAP system. Check the parameter dbms/type is there in instance profile. Retry.

Check the DB connectivity?

The dbms_type environment variable is user variable you should login with that user only. Then only it will be effected. After the Evironment variable setup please logoff and login.

Still problem please paste the trans.log

regards

Anand.M

Former Member
0 Kudos

Hello Ananda,

I added the parameter dbms/type = ora only to the instance profile. I retried, but it is like before. dbms_type = ora is already available in registry files.

Here is the trans.log file.

4<i> ETW000 r3trans version 6.09 (release 640 - 28.04.04 - 16:14:00).

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

4 ETW000

4 ETW000 date&time : 04.07.2005 - 16:17:50

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 Jul 04 16:17:50 2005 38345 0.038345

4 ETW000 [dev trc ,00000] db_con_init called 1894 0.040239

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

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

4 ETW000 1351 0.042735

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."</i>

when I insert the entries dbms/type = ora in the instance profile and dbms_type = ora in environment variables (dbms_type = ora is available in registry, l didn't delete it from registry), then i have this trans.log file

<i>4 ETW000 r3trans version 6.09 (release 640 - 28.04.04 - 16:14:00).

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

4 ETW000

4 ETW000 date&time : 04.07.2005 - 16:37:43

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 Jul 04 16:37:44 2005 16874 0.016874

4 ETW000 [dev trc ,00000] db_con_init called 1869 0.018743

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

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 940 0.020611

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 17203 0.037814

4 ETW000 [dev trc ,00000] using "D:\usr\sap\C12\SYS\exe\run\dboraslib.dll"

4 ETW000 1943 0.039757

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 946 0.040703

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

4 ETW000 1873 0.042576

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

4 ETW000 8482 0.051058

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

4 ETW000 2432 0.053490

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

4 ETW000 2258 0.055748

4 ETW000 [dev trc ,00000] New connection 0 created 781 0.056529

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , con_max = 255, con_opt = 255, occ = NO

4 ETW000 2041 0.058570

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

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

4 ETW000 1849 0.071190

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , con_max = 255, con_opt = 255, occ = NO

4 ETW000 2808 0.073998

4 ETW000 [dev trc ,00000] Found ORACLE_HOME=D:\oracle\C12\920 in Registry 6212 0.080210

4 ETW000 [dev trc ,00000] -->oci_initialize 1174 0.081384

4 ETW000 [dev trc ,00000] Client NLS settings: GERMAN_GERMANY.WE8MSWIN1252

4 ETW000 <b> 73773 0.155157

4 ETW000 [dbsloci. ,00000] *** ERROR => Cannot connect: TNS-name missing 713 0.155870

2EETW169 no connect possible: "DBMS = ORACLE --- TWO_TASK = ''"</i></b>

I think, the parameter TWO_TASK should be set in UNIX, not in WINDOWS, shouldn't it?

Thanks.

best regards

Kutbettin Baran

Message was edited by: Kutbettin Baran

Message was edited by: Kutbettin Baran

Message was edited by: Kutbettin Baran