Installation guide

TIBCO ActiveMatrix BPM Installation and Configuration
190
|
Chapter 10 Post-Installation Tasks
Set Transaction Verification Property for Microsoft SQL Server
Microsoft SQL Server currently 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.
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. Select the link JVM Arguments.
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 the BPMNode
There is a case open with Microsoft for this issue (Case Reference
112010377500682). You must set the following property until Microsoft provides a
fix for this issue. Once the fix is applied, this property must be removed.