Description:
When I use Sybase XA connection, I get the following exception as soon as I call the SQL Script in the JDBC activity.

BW-XATM-100005 Job-12000 Error in [Process Definition (XA)
(1).process/Group/end]
Transaction commit error. The method 'commit' of the [TIBCO
BusinessWorks XA Transaction Manager] Transaction Manager raised
exception [javax.transaction.RollbackException].
javax.transaction.RollbackException
Symptoms:
When you check the Sybase connection by clicking the Test Connection, it says successfull. But when you try to call any SQL script with JDBC Activity, it throw an exception.
Cause:
This issue may be caused by misconfiguration in Sybase. The Sybase DB you are connecting to does not seem to have DTM enabled for XA transactions.sp_configure 'enable DTM' returns '0'.