Modify the limit on concurrent WFO sessions

To modify the limit for the number of concurrent WFO sessions, update the session limit keys in the BPCONFIG table in the BPMAIN database.

Update the values

You can change the value configured for MaxSessionLimitForWFO. A value of 0 sets the maximum number of sessions to "unlimited."

Update the value of IncludeSystemUserForSessionLimit to include (true) or exclude (false) the system user sessions in the total session count. If MaxSessionLimitForWFO is 0, the value for this parameter is ignored.

Procedure 

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

2. To update the maximum 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 change the tracking to include (or exclude) 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 

Set a limit for concurrent WFO sessions

Limiting the number of concurrent WFO sessions