org.jumpmind.db.sql.SqlException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=CAPEST.SYM_CHANNEL;TABLE, DRIVER=4.14.137

symmetricds | malachi83 | 1 week ago
  1. 0

    Symmetric DS upgrade from 3.7.17 to 3.8.10 problem

    symmetricds | 1 month ago | anshusachdeva
    org.jumpmind.db.sql.SqlException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=SMIS.SYM_SYNC_NODE_DISABLED;VARIABLE, DRIVER=3.58.82
  2. 0

    SymmetricDS H2 - Class Not Found EmbeddedDbFunction when running create-sym-tables

    Stack Overflow | 3 years ago | jdchowell
    org.jumpmind.db.sql.SqlException: Class "org.jumpmind.symmetric.db.EmbeddedDbFunctions" not found; SQL statement: CREATE ALIAS IF NOT EXISTS SYM_BASE64_ENCODE for "org.jumpmind.symmetric.db.EmbeddedDbFunctions.encodeBase64"; [90086-176]
  3. 0

    Post by sbrattla on MySQL throws an error for special characters

    symmetricds | 2 years ago | lightning2008
    org.jumpmind.db.sql.SqlException: Specified key was too long; max key length is 1000 bytes
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Setup with Informix

    symmetricds | 4 years ago | houles
    org.jumpmind.db.sql.SqlException: Another routine (informixsym_triggers_disabled) with same signature already exists in database.
  6. 0

    SymmetricsDS Installation - Fails on start up.

    symmetricds | 1 week ago | malachi83
    org.jumpmind.db.sql.SqlException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=CAPEST.SYM_CHANNEL;TABLE, DRIVER=4.14.137

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. IBM DB2
      oo.execute
      1. com.ibm.db2.jcc.am.ed.a(ed.java:677)
      2. com.ibm.db2.jcc.am.ed.a(ed.java:60)
      3. com.ibm.db2.jcc.am.ed.a(ed.java:127)
      4. com.ibm.db2.jcc.am.oo.c(oo.java:2715)
      5. com.ibm.db2.jcc.am.oo.d(oo.java:2703)
      6. com.ibm.db2.jcc.am.oo.b(oo.java:2070)
      7. com.ibm.db2.jcc.t4.ab.i(ab.java:226)
      8. com.ibm.db2.jcc.t4.ab.c(ab.java:48)
      9. com.ibm.db2.jcc.t4.p.b(p.java:38)
      10. com.ibm.db2.jcc.t4.qb.h(qb.java:114)
      11. com.ibm.db2.jcc.am.oo.hb(oo.java:2065)
      12. com.ibm.db2.jcc.am.oo.a(oo.java:3237)
      13. com.ibm.db2.jcc.am.oo.e(oo.java:1073)
      14. com.ibm.db2.jcc.am.oo.execute(oo.java:1056)
      14 frames
    3. Commons DBCP
      DelegatingStatement.execute
      1. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
      2. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
      2 frames
    4. org.jumpmind.db
      SqlScript.execute
      1. org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:416)
      2. org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:401)
      3. org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:491)
      4. org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:401)
      5. org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:107)
      5 frames
    5. org.jumpmind.symmetric
      SymmetricEngineHolder$EngineStarter.run
      1. org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:474)
      2. org.jumpmind.symmetric.db.db2.Db2SymmetricDialect.createOrAlterTablesIfNecessary(Db2SymmetricDialect.java:48)
      3. org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:155)
      4. org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:449)
      5. org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:423)
      6. org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:580)
      7. org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:571)
      8. org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:244)
      9. org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:478)
      9 frames