Set a limit for concurrent WFO sessions

To set a limit for the number of concurrent WFO sessions, you modify the BPCONFIG table in the BPMAIN database.

There are two parameters you can set:

  • MaxSessionLimitForWFO. Limits the number of active sessions that can be created for WFO on the server.

  • IncludeSystemUserForSessionLimit. Includes or excludes the WFO system user sessions in the total session count. Only used when MaxSessionLimitForWFO is greater than 0. Possible values are true and false. The default is false. (The system user is not included in the total session count.)

Procedure 

  1. In SQL Server Management Studio , open a query window in the BPMAINDB database.

  2. To limit the number of concurrent sessions, run the following query:

    DECLARE @MaxSessionCount varchar(50)
    SET @MaxSessionCount = '1000000' -- Update the Max session count here
    IF EXISTS(SELECT 1 FROM BPCONFIG WHERE NAME='system/MaxSessionLimitForWFO')
    BEGIN
    PRINT 'Setting system/MaxSessionLimitForWFO value to : ' + @MaxSessionCount
    UPDATE BPCONFIG SET VALUE=@MaxSessionCount WHERE NAME='system/MaxSessionLimitForWFO'
    END
    ELSE BEGIN --Get the next key for these new rows
    DECLARE @nextkey INT
    EXEC Bp_nextkey 'BPCONFIG',@nextkey output,1
    PRINT 'Setting system/MaxSessionLimitForWFO value to : ' + @MaxSessionCount
    INSERT INTO BPCONFIG(ID,NAME,VALUE) values (@nextkey,'system/MaxSessionLimitForWFO',@MaxSessionCount)
    END

  3. To include the system user sessions in the total session count, run the following query:

    DECLARE @IncludeSystemUser varchar(50)
    SET @IncludeSystemUser = 'false' -- Update the include System User in session count here
    IF EXISTS(SELECT 1 FROM BPCONFIG WHERE NAME='system/IncludeSystemUserForSessionLimit')
    BEGIN
    PRINT 'Setting system/IncludeSystemUserForSessionLimit value to : ' + @IncludeSystemUser
    UPDATE BPCONFIG SET VALUE=@IncludeSystemUser WHERE NAME='system/IncludeSystemUserForSessionLimit'
    END
    ELSE BEGIN --Get the next key for these new rows
    DECLARE @nextkey INT
    EXEC Bp_nextkey 'BPCONFIG',@nextkey output,1
    PRINT 'Setting system/IncludeSystemUserForSessionLimit value to : ' + @IncludeSystemUser
    INSERT INTO BPCONFIG(ID,NAME,VALUE) values(@nextkey,'system/IncludeSystemUserForSessionLimit',@IncludeSystemUser)
    END

  4. Restart the WFO_ProductionDomain_ProductionServer service.

Related topics 

Limiting the number of concurrent WFO sessions

Modify the limit on concurrent WFO sessions