Dialog Work Processes status "running" & action "Commit"

[zobair]

Hello,

We are running SAP R/3 4.7 with kernel 6.40 (patch 344) with Oracle 10.2.04 on Windows 2003.

Actually we are facing a strange performance problem.

We are finding situations where multiple dialog work processes are in status "running" & action "Commit" for several days.

Another side effect of the problem was that we are not able to cancel these processes from SM50 or SM04. We have to cancel them at OS level.

We haven't found any notes describing this issue.

Please provide us your help.

Thank you very much.

Best regards,

Zobair

[JamesZ]

Hi Zobair,

Please check what is the corresponding database session is doing from st04, session monitor.

Also if there is any lock from db01.

Best regards,
James

[zobair]

Hello James,

Thank you for your reply.

The corresponding Oracle sessions are in status "Inactive". There is no change on any of the number (Logical Reads, Phys. Reads ...) Only "Wait time" is increasing. Nothing else.

No lock in DB01:

Any idea?

Thank you.

Regards,

Zobair

[JamesZ]

Hi Zobair,

looks like something wrong with work process. Usually the root cause is hard to addressed.

In the past, we have similar issue happening on windows.

If you are SAP customer, you can reach to SAP support under BC-CST component, open system connection.

Best regards,
James

[Former Member]

Hello Zobair,

Check the following:

1. The developer trace of the work process.

2. SM13 and SM12

3. The Oracle trace file.

4. Windows event viewer.

Over and above that, as James suggested, open a support message.

KR,

Amerjit

[zobair]

Dear Friends,

Thank you for your reply.

Nothing in SM13 & SM12.

In the event viewer, we can see this error:

Event Type:    Error

Event Source:    Application Error

Event Category:    (100)

Event ID:    1000

Date:        6/6/2016

Time:        9:48:15 AM

User:        N/A

Computer:    SRV-R3P1

Description:

Faulting application disp+work.EXE, version 6400.344.18.5481, faulting module disp+work.EXE, version 6400.344.18.5481, fault address 0x000000000106c2c0.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Data:

0000: 41 70 70 6c 69 63 61 74   Applicat

0008: 69 6f 6e 20 46 61 69 6c   ion Fail

0010: 75 72 65 20 20 64 69 73   ure  dis

0018: 70 2b 77 6f 72 6b 2e 45   p+work.E

0020: 58 45 20 36 34 30 30 2e   XE 6400.

0028: 33 34 34 2e 31 38 2e 35   344.18.5

0030: 34 38 31 20 69 6e 20 64   481 in d

0038: 69 73 70 2b 77 6f 72 6b   isp+work

0040: 2e 45 58 45 20 36 34 30   .EXE 640

0048: 30 2e 33 34 34 2e 31 38   0.344.18

0050: 2e 35 34 38 31 20 61 74   .5481 at

0058: 20 6f 66 66 73 65 74 20    offset

0060: 30 30 30 30 30 30 30 30   00000000

0068: 30 31 30 36 63 32 63 30   0106c2c0

I suspect a Kernel problem.

What do you think?

Regards,

Zobair

[raviraj_sap]

Hi Lamarti

Please check the below mentioned thread:

Thanks

Ravi

[zobair]

Dear Friends,

We did a kernel upgrade but the problem persists.

In fact, we have also a SAP Portal 701 SP3 connected to this R/3 backend. Several BSP applications were developed. These pages are called from the portal.

Some sessions remain open after logoff from enterprise portal (not all sessions)

In SM04, that sessions are showed.

These sessions are linked to dialog processes that stay in status "running" & action "Commit" for several days.

We have set the parameter "rdisp/plugin_auto_logout" to "10 min" and it works correctly. Except for some sessions, there is no impact. Sessions are not killed.

Please provide us your help.

Thank you very much.

Best regards,

Zobair

FYI, I opened another message under: