In OSB we are passing Data to SQL DB Server. Some times we are getting below Error :
" Exception Description: Error committing externally managed transaction
Internal Exception: javax.transaction.HeuristicMixedException: (jdbc/sqlserver_DEV_Domain, HeuristicHazard, (javax.transaction.xa.XAException: [FMWGEN][SQLServer JDBC Driver][SQLServer]The server failed to resume the transaction. Desc:7800000022.)) .
We are using WebLogic Server Version: 10.3.6.0 and for SQL data source driver is " weblogic.jdbc.sqlserver.SQLServerDriver " and Transaction Type is Support Global Transaction
Any idea on this error would help us.
Heuristic decision is taken by Weblogic Transaction manager when a XA resource participating in a transaction failed or transaction couldn't commit during 2nd phase.
Check the complete error stacktrace in the logs to understand the cause. Also check if the XA resource which is a db has any issues...
Check the logs at the db end and also check if there are any connectivity issues to resolve the heuristic issues.