"Failed to execute" from JBoss Messaging when starting JBoss EAP
Issue
- What can be done to prevent this message: "Failed to execute"? Here is an example:
DEBUG [org.jboss.messaging.core.impl.JDBCSupport] Failed to execute: CREATE TABLE JBM_DUAL (DUMMY INTEGER, PRIMARY KEY (DUMMY))java.sql.SQLException: ORA-00955: name is already used by an existing object
Here is another example:
DEBUG [org.jboss.jms.server.plugin.JDBCJMSUserManager] Failed to execute INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('nobody','nobody')
java.sql.SQLException: Violation of unique constraint SYS_PK_60: duplicate value (s) for column (s)
- When I try to bring up ports-01 in EAP 4.3 -CP06, I get a warning message as below. Can you please advise on how to fix this issue?
2012-06-14 08:15:04,435 DEBUG [org.jboss.messaging.core.impl.JDBCSupport] Failed to execute: CREATE TABLE JBM_DUAL (DUMMY INTEGER, PRIMARY KEY(DUMMY))
java.sql.SQLException: Table already exists: JBM_DUAL in statement [CREATE TABLE JBM_DUAL]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
Environment
JBoss Enterprise Application Platform (EAP)
- 4.3
- 5
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
