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. Log in to TIBCO ActiveMatrix Administrator as root user and select Infrastructure > Nodes.
  2. Select the node BPMNode and click the Configuration tab.
  3. Click JVM Configuration.
  4. Under the Properties heading, click Add to add a new JVM property.
  5. Enter the property name as com.tibco.pvm.txVerification.enable and value as true.
  6. Click Save to save the changes.
  7. Stop and restart BPMNode.