6 Replies Latest reply on Jan 13, 2012 12:23 AM by harikrishnas

java.lang.RuntimeException: Error obtaining connection: org.jboss.util.NestedSQLException

harikrishnas Jan 10, 2012 2:04 AM

Hi ,

We are experiencing production down with the below error. Its happening on Jboss 4.2.2 cluster. However other node is unaffected.

[thread: ajp-0.0.0.0-8009-34] January 9, 2012 2:32:07 PM IST java.lang.RuntimeException: Error obtaining connection: org.jboss.util.NestedSQLException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: a620b96:c0f:4f0a7b1f:4f10ba status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: a620b96:c0f:4f0a7b1f:4f10ba status: ActionStatus.ABORT_ONLY >))

Regards,

Hari

1. Re: java.lang.RuntimeException: Error obtaining connection: org.jboss.util.NestedSQLException

wdfink Jan 10, 2012 12:02 PM (in response to harikrishnas)

Is it possible that the transaction is timed-out or in an abort state before?
Actions
2. Re: java.lang.RuntimeException: Error obtaining connection: org.jboss.util.NestedSQLException

harikrishnas Jan 11, 2012 1:44 AM (in response to wdfink)

No the transaction is not timed out or abort state

They tried the below option as well

<property name=”com.arjuna.ats.jta.allowMultipleLastResources” value=”true”/>
Actions
3. Re: java.lang.RuntimeException: Error obtaining connection: org.jboss.util.NestedSQLException

wdfink Jan 11, 2012 2:47 AM (in response to harikrishnas)

I suppose you use more than one party for the transaction, could you describe/attatch the environment, code and error a bit more detailed?

At least your other node is not affected, if it works you might have a difference there in *-ds.xml, DB driver or use-case?
Actions
4. Re: java.lang.RuntimeException: Error obtaining connection: org.jboss.util.NestedSQLException

harikrishnas Jan 12, 2012 5:27 AM (in response to wdfink)

I am getting the following error

[thread: ajp-0.0.0.0-8009-15] January 12, 2012 11:08:46 AM IST com.saba.exception.SabaException : (99999) An unknown error occurred. Please try again. If the situation persists, please contact the site administrator. (@001)
java.rmi.ServerException: RuntimeException; nested exception is:
          java.lang.RuntimeException: Error obtaining connection: org.jboss.util.NestedSQLException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: a620b95:9c2:4f0dd128:250359 status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: a620b95:9c2:4f0dd128:250359 status: ActionStatus.ABORT_ONLY >))
          at com.saba.util.SabaSecurityUtil.doHasPrivilege(SabaSecurityUtil.java:374)
          at com.saba.util.SabaSecurityUtil.hasPrivilege(SabaSecurityUtil.java:131)
          at com.saba.client.common.GranularPrivCheckCommand.canAssessOthersCompetency(GranularPrivCheckCommand.java:197)
          at com.saba.client.mra.AssessCompetenciesFilter.filter(AssessCompetenciesFilter.java:42)
          at com.saba.menutree.business.MenuManagerDelegate.runFilter(MenuManagerDelegate.java:1063)
          at com.saba.menutree.business.MenuManagerDelegate.getCachedUserMenu(MenuManagerDelegate.java:959)
          at com.saba.menutree.business.MenuManagerDelegate.getMenu(MenuManagerDelegate.java:225)
          at com.saba.web.uiframework.MenuItemTreeHelper.getMenu(MenuItemTreeHelper.java:279)
          at com.saba.web.uiframework.MenuItemTreeHelper.getMenu(MenuItemTreeHelper.java:333)
          at com.saba.client.uiframework.MenuStateUtil.getMenuState(MenuStateUtil.java:72)
          at com.saba.client.uiframework.MenuCommand.doExecute(MenuCommand.java:99)
          at com.saba.web.dk.AbstractCommand.execute(AbstractCommand.java:165)

This is running on JBoss AS 4.2.2
Actions
5. Re: java.lang.RuntimeException: Error obtaining connection: org.jboss.util.NestedSQLException

wdfink Jan 12, 2012 5:57 AM (in response to harikrishnas)

Hi Hari,
please try to remove the posts that created by fault (I see 8 with different post timestamps and the same log excerpt)

I suppose it is a bug with the new SSO, I have also some funny effects with the login
Also often an error after submit, but if I refresh the browser the post is done
Actions
6. Re: java.lang.RuntimeException: Error obtaining connection: org.jboss.util.NestedSQLException

harikrishnas Jan 13, 2012 12:23 AM (in response to wdfink)

Yes Wolf-Dieter,

When i was trying to give the reply i was getting error as try again.
Actions

Go to original post