Skip to Content
0

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

Nov 21, 2016 at 06:08 AM

211

avatar image

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.

10 |10000 characters needed characters left characters exceeded

"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?)

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Raymond Giuseppi
Nov 21, 2016 at 06:47 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded