Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos
995

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.

2 REPLIES 2

raymond_giuseppi
Active Contributor
0 Kudos
144

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

Sandra_Rossi
Active Contributor
0 Kudos
144

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