HI All,
I am running 2
JBOSS server in my PC and I getting below error
2010-08-28 18:34:58,841 DEBUG [org.jboss.messaging.core.impl.JDBCSupport] Failed to execute: CREATE TABLE JBM_MSG_REF (MESSAGE_ID INTEGER, CHANNEL_ID INTEGER, TRANSACTION_ID INTEGER, STATE CHAR(1), ORD INTEGER, PAGE_ORD INTEGER, DELIVERY_COUNT INTEGER, SCHED_DELIVERY INTEGER, PRIMARY KEY(MESSAGE_ID, CHANNEL_ID))
java.sql.SQLException: ORA-00955: name is already used by an existing object
2010-08-28 18:34:58,997 DEBUG [org.jboss.jms.server.plugin.JDBCJMSUserManager] Failed to execute INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('processInjector','processInjectorQueueUser')
java.sql.SQLException: ORA-00001: unique constraint (IPCUSER02.SYS_C005472) violated
The database username/pwd of these 2 servers are different but the DB instance is same.
Any idea why I am getting the error? What is the impact if this error occurs? How do I fix this error?