Status Hold in SM50 reason Private mode

[Former Member]

Dear all,

BIP PROD system , one of the work process got status shows hold (Reason private mode)

3 DIA 12699 On Hold PRIV Yes 1 11070 SAPMSSY1 400 MASOND

In SM04 i have checked that particular user , i got below details .

400 MASOND 0200-00020 SESSION_MANAGER 14.25.41 1 GUI 0

No Transaction Time

-

---

1 Session Manager Menu Tree Display 14:25:41

i have checked trace file in SM50 its shows below details log of that particular WP.

last few lines of Trace Data: dbcipwp_BWP_02dev_w3 :

M Mon May 2 09:31:56 2011

M

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

M *

M * LOCATION SAP-Server ap01jrp_JRP_20 on host ap01jrp (wp 6)

M * ERROR Warning: EM-Memory exhausted: Workprocess gets PRIV

M *

M * TIME Mon May 2 09:31:56 2011

M * RELEASE 700

M * COMPONENT EM

M * VERSION 37

M * RC 7

M * MODULE emxx.c

M * LINE 1897

M * COUNTER 274285

M *

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

M

S

S Mon May 2 09:34:25 2011

S found spool memory service RSPO-ACTIONS at c000000083446750

B table logging switched off for all clients

C build_stmt: reallocating stmt buffer: 2000 -> 3002 characters

B

B Mon May 2 09:41:26 2011

B create_con (con_name=R/3*TIMESTAMP)

B New connection 2 created

B Mon May 2 09:41:30 2011

B create_con (con_name=R/3*WB)

B New connection 3 created

B

B Mon May 2 09:41:39 2011

B create_con (con_name=R/3*)

B New connection 4 created

C

C Mon May 2 10:16:07 2011

C Disconnecting from connection 1 ...

C Closing user session (con_hdl=1,svchp=6000000002fbc578,usrhp=6000000002fbbfe8)

C Now I'm disconnected from ORACLE

B Disconnected from connection con_da={R/3*,1028657,4}

C

C Mon May 2 10:16:56 2011

C application info callback registered

C Client NLS setting (OCINlsGetInfo): connection handle 1 -> 'AMERICAN_AMERICA.WE8DEC'

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

C Connecting as /@BWP on connection 1 (nls_hdl 0) ... (dbsl 701 220409)

C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

[Former Member · Accepted solution]

Contiune of log details :

C 0 WE8DEC 60000000028940c0 600000000289ba40 600000000289f428

C Starting user session: OCISessionBegin(con_hdl=1, usr='/',svchp=60000000030a5a18, srvhp=60000000028a16a8, usrhp=6000000003ce5ae8)

C Now '/@BWP' is connected: con_hdl=1, nls_hdl=0, session_id=132.

C Got SAPR3's password from OPS$-user

C Disconnecting from connection 1 ...

C Closing user session (con_hdl=1,svchp=60000000030a5a18,usrhp=6000000003ce5ae8)

C Now I'm disconnected from ORACLE

C Connecting as SAPR3/<pwd>@BWP on connection 1 (nls_hdl 0) ... (dbsl 701 220409)

C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 60000000028940c0 600000000289ba40 600000000289f428

C Starting user session: OCISessionBegin(con_hdl=1, usr=SAPR3/<pwd>, svchp=60000000030a5a18, srvhp=60000000028a16a8, usrhp=60000000

C Now 'SAPR3/<pwd>@BWP' is connected: con_hdl=1, nls_hdl=0, session_id=132.

C DB instance BWP is running on dee with ORACLE version 10.2.0.4.0 since DEC 12, 2010, 19:35:29

B Connection 1 opened (DBSL handle 1)

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

B 003 000 R/3 000000000 ACTIVE NO NO YES NO NO 000 255 255 20110502 091949 dee

B 003 001 R/3*BWMON 003014083 ACTIVE NO NO NO NO NO 004 255 255 20110502 101656 dee

B 003 002 R/3*TIMESTAMP 003014075 DISCONNECTED NO NO NO NO NO 004 255 255 20110502 095141 dee

B 003 003 R/3*WB 003014076 DISCONNECTED NO NO NO NO NO 004 255 255 20110502 095212 dee

B 003 004 R/3* 001028657 DISCONNECTED NO NO NO NO NO 000 255 255 20110502 101607 dee

C

C Mon May 2 10:16:58 2011

C build_stmt: reallocating stmt buffer: 3328 -> 4329 characters

C build_stmt: reallocating stmt buffer: 4329 -> 5331 characters

C

C Mon May 2 10:17:06 2011

C build_stmt: reallocating stmt buffer: 1792 -> 2798 characters

C build_stmt: reallocating stmt buffer: 2798 -> 3800 characters

M

M Mon May 2 10:18:17 2011

M *** WARNING => PfSetGuiTime: gui time too large, discard (gui=1319609000/resptime=0)

A

A Mon May 2 10:25:35 2011

A WP has reached abap/heaplimit = 40000000 bytes

C

C Mon May 2 10:41:07 2011

C Disconnecting from connection 1 ...

C Closing user session (con_hdl=1,svchp=60000000030a5a18,usrhp=6000000003ce5ae8)

C Now I'm disconnected from ORACLE

B Disconnected from connection con_da={R/3*,3014086,4}

C

C Mon May 2 14:23:21 2011

C application info callback registered

C Client NLS setting (OCINlsGetInfo): connection handle 1 -> 'AMERICAN_AMERICA.WE8DEC'

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

[Former Member · Accepted solution]

C Connecting as /@BWP on connection 1 (nls_hdl 0) ... (dbsl 701 220409)

C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 60000000028940c0 600000000289ba40 600000000289f428

C Starting user session: OCISessionBegin(con_hdl=1, usr='/',svchp=60000000030a5a18, srvhp=60000000028a16a8, usrhp=6000000003025108)

C Now '/@BWP' is connected: con_hdl=1, nls_hdl=0, session_id=139.

C Got SAPR3's password from OPS$-user

C Disconnecting from connection 1 ...

C Closing user session (con_hdl=1,svchp=60000000030a5a18,usrhp=6000000003025108)

C Now I'm disconnected from ORACLE

C Connecting as SAPR3/<pwd>@BWP on connection 1 (nls_hdl 0) ... (dbsl 701 220409)

C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 60000000028940c0 600000000289ba40 600000000289f428

C Starting user session: OCISessionBegin(con_hdl=1, usr=SAPR3/<pwd>, svchp=60000000030a5a18, srvhp=60000000028a16a8, usrhp=60000000

C Now 'SAPR3/<pwd>@BWP' is connected: con_hdl=1, nls_hdl=0, session_id=139.

C DB instance BWP is running on dee with ORACLE version 10.2.0.4.0 since DEC 12, 2010, 19:35:29

B Connection 2 opened (DBSL handle 1)

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

B 003 000 R/3 000000000 ACTIVE YES YES YES NO NO 000 255 255 20110502 091949 dee

B 003 001 R/3*BWMON 003014083 DISCONNECTED NO NO NO NO NO 004 255 255 20110502 101802 dee

B 003 002 R/3*TIMESTAMP 003014084 ACTIVE NO NO NO NO NO 004 255 255 20110502 142321 dee

B 003 003 R/3*WB 003014085 DISCONNECTED NO NO NO NO NO 004 255 255 20110502 102525 dee

B 003 004 R/3* 003014086 DISCONNECTED NO NO NO NO NO 000 255 255 20110502 104107 dee

C

C Mon May 2 14:41:07 2011

C Disconnecting from connection 1 ...

C Closing user session (con_hdl=1,svchp=60000000030a5a18,usrhp=6000000003025108)

C Now I'm disconnected from ORACLE

B Disconnected from connection con_da={R/3*,3014086,4}

Let me know what reason its goes private mode and i have found one error and warning from the above trace log details :

M * ERROR Warning: EM-Memory exhausted: Workprocess gets PRIV

M *** WARNING => PfSetGuiTime: gui time too large, discard (gui=1319609000/resptime=0)

let me know how should i close my ticket and what reason i have say to resolving my issue .

Kindly advise.

[sivakumar_kilari3 · Accepted solution]

This is your error.

> A WP has reached abap/heaplimit = 40000000 bytes

Work process memory its reaching maximum heaplimit.

Solution: you have to increase this parameter value or you have to find out root cause of this problem.

Check in sm50 which report is executing?

Thanks

Siva

[Former Member · Accepted solution]

Hello Sateesh

This happens when Extended memory utilization is done.

Is this happening every time or once in while when a particular job or program runs.

If its a custom program you need to work with your developer on this if not

http://help.sap.com/saphelp_nw04/helpdata/en/02/96253c538111d1891b0000e8322f96/frameset.htm

Regards

Vivek

[Former Member · Accepted solution]

Dear All,

I have checked in SM50 and SM50 during private mode and i got below details..

Its shows program SAPMSSY1in SM50 and i have checked SM04 for the particular user session_manager as tracsaction.

pls check bewlow detials.

3 DIA 12699 On Hold PRIV Yes 1 11070 SAPMSSY1 400 MASOND

In SM04 i have checked that particular user , i got below details .

400 MASOND 0200-00020 SESSION_MANAGER 14.25.41 1 GUI 0

No Transaction Time

1 Session Manager Menu Tree Display 14:25:41

Kindly advise , i have convey exact reason to my reporting person.

Thanks

[former_member524429 · Accepted solution]

Hi,

A Mon May 2 10:25:35 2011
A WP has reached abap/heaplimit = 40000000 bytes

First of all, the above mentioned statement is not an error. This parameter sets the limit of heap memory usage, after which the work process will be marked/flagged for restart, so that the allocated heap/local memory can be reclaimed .

Setting of Parameter abap/heaplimit is useful in UNIX OS environment to reclaim such inactive memory areas, where the allocated heap/loacal memory still gt occupied even though the SAP work-process had completed/left the Transactions. Refer [SAP Note 1571845|https://websmp230.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3135373138343526].

In Windows OS, the OS can re-claim such occupied heap/page memory once the SAP work-process complete/leave the running transactions. So such abap/heaplimit parameter setting is not required in Windows environment.

You should monitor such "PRIV MOD" occurrences and analyze the responsible transactions in affected SAP systems. It may be chances that the memory parameters are not set correctly in affected system.

Please provide all the memory parameters of extended memory/ roll extensions, heap memory parameters of the affected SAP System(s).

There is memory allocation sequence for " Allocating Memory for User Contexts" in SAP. You can[ read this link|http://help.sap.com/saphelp_nw04s/helpdata/en/34/d9c8b9c23c11d188b40000e83539c3/content.htm] to get more information.

Also you can refer this [SAP 103747|https://service.sap.com/sap/support/notes/103747] to get more information on Memory Parameter settings.

Regards,

Bhavik G. Shroff

[former_member838162 · Accepted solution]

Hello,

some background for the parameter abap/heaplimit: When a process allocates memory in the heap the operating system assigns physical memory to the virtual address space of the process. This works in the same way on all operating system (UNIX and Windows). When the process frees the memory again the assignment is still kept and the memory can be reused. There is no disclaim of the memory. It is possible that the process does not need the memory in the heap again and the operating system pages it out but it is still reserved in the swap space. Only a restart of the process can destroy the mapping between physical memory and virtual memory. This means abap/heaplimit is also needed on Windows platforms.

The PRIV mode is set when the extended memory (em/initial_size_MB) is exhausted or the quota in the extended memory is reached (ztta/roll_extension). To change the memory settings it is important to know the operating system, the current profile settings and the SAP release.

Best regards,

Klaus

[former_member208104]

Hi,

Check St02 for your extended memory and heap memory utilization.

-Sanjay