Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed 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?)

  • Get RSS Feed

1 Answer

  • Nov 21, 2016 at 06:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded