org.jumpmind.db.sql.SqlException

DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=CAPEST.SYM_CHANNEL;TABLE, DRIVER=4.14.137


Solutions on the web72

Solution icon of sourceforge
DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=CAPEST.SYM_CHANNEL;TABLE, DRIVER=4.14.137

Solution icon of sourceforge
DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=SMIS.SYM_SYNC_NODE_DISABLED;VARIABLE, DRIVER=3.58.82

Solution icon of sourceforge
DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=TIMESTAMP_ISO;FUNCTION, DRIVER=3.63.123

Solution icon of sourceforge
via symmetricds by mtnbiker67
, 1 year ago
DB2 SQL Error: SQLCODE=-7008, SQLSTATE=55019, SQLERRMC=SYM_C00001;A3RALFRT ;3, DRIVER=4.17.29

Solution icon of sourceforge
via symmetricds by robgiovanardi
, 4 months ago
DB2 SQL Error: SQLCODE=-313, SQLSTATE=07004, SQLERRMC=null, DRIVER=3.64.141

Solution icon of sourceforge
Can't create table 'goldrush.#sql-2840_64' (errno: 150)

Solution icon of sourceforge
via symmetricds by mbnoimi
, 1 year ago
[SQLITE_ERROR] SQL error or missing database (near "CONSTRAINT": syntax error)

Solution icon of sourceforge
via symmetricds by raja_s_patil
, 1 year ago
GDS Exception. 335544569. Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 1 deleteIncomingErrorsSql

Solution icon of sourceforge
via symmetricds by rwysocki
, 1 year ago
ERROR: update or delete on table "sym_channel" violates foreign key constraint "sym_fk_trg_2_chnl" on table "sym_trigger" Key (channel_id)=(my_channel_name) is still referenced from table "sym_trigger".

Solution icon of sourceforge
via symmetricds by robny
, 1 year ago
Table "SYM_CHANNEL" not found; SQL statement: update sym_channel set processing_order=?, max_batch_size=?, max_batch_to_send=?, max_data_to_route=?, use_old_data_to_route=?, use_row_data_to_route=?, use_pk_data_to_route=?, contains_big_lob

Stack trace

  • org.jumpmind.db.sql.SqlException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=CAPEST.SYM_CHANNEL;TABLE, DRIVER=4.14.137 at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:303) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:294) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:493) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:401) at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:107) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:474) at org.jumpmind.symmetric.db.db2.Db2SymmetricDialect.createOrAlterTablesIfNecessary(Db2SymmetricDialect.java:48) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:155) at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:449) at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:423) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:580) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:571) at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:244) at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:478) Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=CAPEST.SYM_CHANNEL;TABLE, DRIVER=4.14.137 at com.ibm.db2.jcc.am.ed.a(ed.java:677) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:127) at com.ibm.db2.jcc.am.oo.c(oo.java:2715) at com.ibm.db2.jcc.am.oo.d(oo.java:2703) at com.ibm.db2.jcc.am.oo.b(oo.java:2070) at com.ibm.db2.jcc.t4.ab.i(ab.java:226) at com.ibm.db2.jcc.t4.ab.c(ab.java:48) at com.ibm.db2.jcc.t4.p.b(p.java:38) at com.ibm.db2.jcc.t4.qb.h(qb.java:114) at com.ibm.db2.jcc.am.oo.hb(oo.java:2065) at com.ibm.db2.jcc.am.oo.a(oo.java:3237) at com.ibm.db2.jcc.am.oo.e(oo.java:1073) at com.ibm.db2.jcc.am.oo.execute(oo.java:1056) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:416) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:401) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:491) ... 11 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.