This variable when set to "true", will let the system automatically execute a SQL command when a database timeout occurs on an UPDATE command. The default value for this variable is "false".

When set to true, the default SQL that is executed will insert records into a table named TEMP_LOCK_LIST and this table needs to exist prior to setting the variable to "true". You can create this table in the process Director installation by running this SQL command:

CREATE TABLE TEMP_LOCK_LIST (SPID int, BLOCKED int, BATCH nvarchar(max))

Once this table exists, this variable will insert records in to the table when locks are found. You can use the table to pull out any lock conditions via SQL query.

Example

public override void SetSystemVars(BPLogix.WorkflowDirector.SDK.bp bp)
{
    bp.Vars.fDebugInsertLockData = true;
}

These variables when set to "false", will alter certain aspects of CSRF protection. Occasionally errors may occur on the system in rare circumstances that can be addressed by changing these variable settings.

Example

public override void SetSystemVars(BPLogix.WorkflowDirector.SDK.bp bp)
{
    Vars.fEnableCSRF1Protection = false;
    Vars.fEnableCSRF2Protection = false;
}

This variable when set to "true", will disabled the Navigator UI used in v6.1.X and higher.

Example

public override void SetSystemVars(BPLogix.WorkflowDirector.SDK.bp bp)
{
    Vars.fEnableNavigator2 = true;
}

This variable when set to "true", will reopen the Database in the event of an activity going into an error from something like a Custom Task.

Example

public override void SetSystemVars(BPLogix.WorkflowDirector.SDK.bp bp)
{
    bp.Vars.fEnableReOpenOnError = true;
}

This variable enables you to change the number of times the system will allow a process instance activity check to start processing from the top again. The default is 10 times.

Example

public override void SetSystemVars(BPLogix.WorkflowDirector.SDK.bp bp)
{
    // Allow 15 restarts
    bp.Vars.nTimelineUnwindLoopCount = 15;
}