Failed to enable a cartridge - ERROR: "Transaction is not active..." (4257588)

When trying to enable a cartridge the following error appears:

"Could not complete the requested operation, with the following messages:

Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=MyServerName/123456, BranchQual=, LocalId=123456"

In the Foglight log files the following error appears:

"2014-02-13 16:05:56.922 WARN    [Timeouts(2)-2] org.jboss.tm.TransactionImpl - Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=MyServerName/123456, BranchQual=, localId=123456] timed out. status=STATUS_ACTIVE
2014-02-13 16:05:57.222 ERROR   [ctwbsyqmmc:990971993139230364481111] com.quest.nitro.service.config.model.common.PersistableConfigModel - An unexpected error occurred which may cause undesired behavior. You may want to contact customer support if you see this error again: Fail to load encoded data for 8a7f637e40073ee001400766571102e2
org.hibernate.exception.GenericJDBCException: Cannot open connection
[...]
Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=MyServerName/123456, BranchQual=, localId=123456]; "

For Foglight 5.7.5.8 and below:

Increase the database connection timeout by following the steps below:

1. Open the JMX console: http://FoglightServer:port/jmx-console
2. Use a Foglight administrator to log in
3. Under headline "jboss" find the link: "service=TransactionManager"
4. Click on it and find the parameter "TransactionTimeout"
5. Per default the parameter is set to 1200. Increase it to 2400.
6. Below the table click on the button "Apply Changes"

Now try to enable the cartridge again.

This "Transaction Timeout" value can be increased further. However, please ensure to change it back to the default value as there could be impacts with a higher time out value.

For Foglight 5.9.1 and above:

Start the FMS with the following switch to increase the database connection timeout, and then try to enable the cartridge.  See KB article 257594 for more details.

For Windows:

   fms -Dcom.arjuna.ats.arjuna.coordinator.defaultTimeout=2400

For Unix/Linux:

   ./fms -d -Dcom.arjuna.ats.arjuna.coordinator.defaultTimeout=2400

For Foglight 5.7.5.8 and below:

Increase the database connection timeout by following the steps below:

1. Open the JMX console: http://FoglightServer:port/jmx-console
2. Use a Foglight administrator to log in
3. Under headline "jboss" find the link: "service=TransactionManager"
4. Click on it and find the parameter "TransactionTimeout"
5. Per default the parameter is set to 1200. Increase it to 2400.
6. Below the table click on the button "Apply Changes"

Now try to enable the cartridge again.

This "Transaction Timeout" value can be increased further. However, please ensure to change it back to the default value as there could be impacts with a higher time out value.

For Foglight 5.9.1 and above:

Start the FMS with the following switch to increase the database connection timeout, and then try to enable the cartridge.  See KB article 257594 for more details.

For Windows:
   fms -Dcom.arjuna.ats.arjuna.coordinator.defaultTimeout=2400

For Unix/Linux:
   ./fms -d -Dcom.arjuna.ats.arjuna.coordinator.defaultTimeout=2400