Setting Transaction Verification Property (SQL Server Only)

Microsoft SQL Server cannot handle the scenario where commits return successfully (in XA mode) even when the transaction has not completed. Consequently, duplicate work items can occur when the BPM runtime is running against a Microsoft SQL Server. To work around this, you must set the transaction verification property.

Note: There is a case open with Microsoft for this issue (Case Reference 112010377500682). You must set the property until Microsoft provides a fix for this issue. Once the fix is applied, this property setting must be removed.

Procedure

  1. Open the pvm.properties file.
    This file is typically located in the following folder (it may be different in a distributed environment):

    CONFIG_HOME/bpm/bpm_app_name/configuration

    For more information about properties files, see "BPM Properties Files" in TIBCO ActiveMatrix BPM Administration.

  2. Locate the txVerificationEnable property and set its value to "true".
  3. Save and close the pvm.properties file.