Hi there, we incorrectly stated up the root server in version 2.1.2, instead
of 2.5.3. When we now try to start up the 2.5.3 server, we get the following :
012-01-24 13:14:31,072 INFO Checking if SymmetricDS tables need created or
altered.
2012-01-24 13:16:13,755 INFO There are SymmetricDS tables that needed altered.
2012-01-24 13:16:22,344 ERROR CREATE SEQUENCE seq_sym_trigger_rigger_hist_id
failed to execute.
java.sql.SQLException: ORA-00955: name is already used by an existing object
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.jav
a:1170)
at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1696)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1662)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.jav
a:261)
at org.jumpmind.symmetric.db.SqlScript$1.doInConnection(SqlScript.java:200)
at org.jumpmind.symmetric.db.SqlScript$1.doInConnection(SqlScript.java:163)
Please advise. Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You probably already resolved this, but it looks like an downgrade/upgrade to
sym_trigger_hist failed. It probably needs to be dropped along with the
associated sequences. There might also be a table named sym_trigger_hist_ that
will need cleaned up as well.
Before you drop sym_trigger_hist backup your sym_trigger_hist rows. If you
have pending data that has not been synchronized they will need the
sym_trigger_hist rows in order to sync properly.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi there, we incorrectly stated up the root server in version 2.1.2, instead
of 2.5.3. When we now try to start up the 2.5.3 server, we get the following :
012-01-24 13:14:31,072 INFO Checking if SymmetricDS tables need created or
altered.
2012-01-24 13:16:13,755 INFO There are SymmetricDS tables that needed altered.
2012-01-24 13:16:22,344 ERROR CREATE SEQUENCE seq_sym_trigger_rigger_hist_id
failed to execute.
java.sql.SQLException: ORA-00955: name is already used by an existing object
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.jav
a:1170)
at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1696)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1662)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.jav
a:261)
at org.jumpmind.symmetric.db.SqlScript$1.doInConnection(SqlScript.java:200)
at org.jumpmind.symmetric.db.SqlScript$1.doInConnection(SqlScript.java:163)
Please advise. Thanks
You probably already resolved this, but it looks like an downgrade/upgrade to
sym_trigger_hist failed. It probably needs to be dropped along with the
associated sequences. There might also be a table named sym_trigger_hist_ that
will need cleaned up as well.
Before you drop sym_trigger_hist backup your sym_trigger_hist rows. If you
have pending data that has not been synchronized they will need the
sym_trigger_hist rows in order to sync properly.