STOPSESSION Function (Sessions)

Stops a Microsoft Dynamics NAV session.

[OK :=] STOPSESSION(SessionID[,Comment]);


  • SessionID
    Type: Integer The ID of the session that you want to stop. The session can be any of the following:
    • Microsoft Dynamics NAV Windows client session

    • Microsoft Dynamics NAV Web client session

    • Microsoft Dynamics NAV SharePoint client session

    • NAS services session

    • SOAP web services client session

    • OData web services client session

    • Background session

  • Comment
    Type: Text An optional comment about the session event. The comment is stored in Table 2000000111, the Session Event table.

Property Value/Return Value

Type: Boolean

true if the session is stopped successfully and no errors occurred; otherwise false.

If you omit this optional return value and the session is not stopped successfully, then a run-time error occurs. If you include the return value, then you must handle any errors.


The session that you want to stop and the session that calls STOPSESSION must be running on the same instance of Microsoft Dynamics NAV Server. The session is stopped before the next C/AL statement executes. Open transactions are rolled back.


If the current executing statement is the SLEEP function, then the session is stopped immediately.

When a session is executing C/AL that does not interact with the server connection or the access lock used by the connection, STOPSESSION cannot terminate the connection. STOPSESSION can terminate connections that are inactive, idle, or using the database but not blocked.

You cannot stop the current, active session in which you are executing the STOPSESSION call.


This example requires that you create the following variables, and assumes that you have a table named CacheStressTest that you use for testing.

Variable name DataType Subtype



Not applicable




STARTSESSION(SessionId, CODEUNIT::"Cache Stress Test", COMPANYNAME, CacheStressTestRec);
STOPSESSION(SessionId, 'Logoff cache stress test session');