topic Re: SQL error "SQL code: 2391" occurred while accessing table "SWFCNTBUF". in Application Development and Automation Discussions

SQL error "SQL code: 2391" occurred while accessing table "SWFCNTBUF".

Former Member — Mon, 21 Nov 2016 06:08:25 GMT

When I try to go in and approve journal entries in SAP at the Business Workplace Inbox I am getting a ABAP run time error

Short Text SQL error "SQL code: 2391" occurred while accessing table "SWFCNTBUF". What happened? Database error text: "SQL message: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit"

An exception has occurred which is explained in more detail below. The exception is assigned to class 'CX_SY_OPEN_SQL_DB' and was not caught in procedure "ADD_INSTANCE" "(METHOD)", nor was it propagated by a RAISING clause. Since the caller of the procedure could not have anticipated this exception, the current program was terminated. The reason for the exception is: Database error text: SQL message: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit Return value of the database layer: "SQL dbsl rc: 99"

Can someone please let me know why this error is coming.

Re: SQL error "SQL code: 2391" occurred while accessing table "SWFCNTBUF".

RaymondGiuseppi — Mon, 21 Nov 2016 06:47:09 GMT

Too many simultaneous update request to Oracle Server, check with your Oracle admin.

ORA-02391 exceeded simultaneous SESSIONS_PER_USER limit

Cause: An attempt was made to exceed the maximum number of concurrent sessions allowed by the SESSIONS_PER_USER clause of the user profile.

Action: End one or more concurrent sessions or ask the database administrator to increase the SESSIONS_PER_USER limit of the user profile. For more information about SESSIONS_PER_USER and the database administrator's specific tasks of adjusting concurrent sessions, ...

Regards,
Raymond

Re: SQL error "SQL code: 2391" occurred while accessing table "SWFCNTBUF".

Sandra_Rossi — Mon, 21 Nov 2016 07:26:59 GMT

"approve journal entries" : as there seems to be an issue with a limit, how many workitems do you approve at the same time? Secondly, this is primarily an Oracle error, did you search the web? (and lastly, did you search SAP notes?)