Problem starting service PersistenceManager during JBoss ON startup

Solution Verified - Updated -

Issue

During the JBoss ON startup, a WARN message is thrown in the rhq-server-log4j.log. Follow the message below:

2011-09-22 11:42:34,697 WARN  [org.jboss.system.ServiceController] Problem starting service jboss.mq:service=PersistenceManager
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions.  Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: ORA-00933: SQL command not properly ended
)
        at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:489)
        at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1842)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)

...

Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

...  

The issue occurs on an existing installation. What could be the reason of this WARN ?

Environment

  • JBoss Operations Network (JON)
    • 2.4.x
    • 3.0.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content