BW 2.x gets the following error while checkpointing -java.sql.SQLException: ORA-00001: unique constraintviolated [ checkpoint , unique constraint ]
Article ID: KB0085719
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Resolution:
There is a known issue in BW2.x where in the same Job Id's can be used when multiple Engines are started.
This could lead to a "Unique Constraint" error while checkpointing.
This has been fixed in BW 5.x.
However, the customer using BW2.x can use the following property in deployed Engines .tra files -
Engine.StandAlone=false
This property ensures that the BW Engines gets a unique set of JobId's.
There is a known issue in BW2.x where in the same Job Id's can be used when multiple Engines are started.
This could lead to a "Unique Constraint" error while checkpointing.
This has been fixed in BW 5.x.
However, the customer using BW2.x can use the following property in deployed Engines .tra files -
Engine.StandAlone=false
This property ensures that the BW Engines gets a unique set of JobId's.
Issue/Introduction
BW 2.x gets the following error while checkpointing -java.sql.SQLException: ORA-00001: unique constraintviolated
[ checkpoint , unique constraint ]
Feedback
Yes
No
Powered by
