"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, tools, and much more.