I'm using SymmetricDS v3.7.29 and still entry level with symmetricds,
I was tried with oracle 11 g (winserver 2008 R2) and db2luw (virtual box with winserver 2008 R2), it was succeded to syncronize.
Then I try to sync between DB2/AS400 v5.4 with oracle 11 g (winserver 2008 R2)
with jt400as driver ; db.driver=com.ibm.as400.access.AS400JDBCDriver
this is the log from symmetric :
2016-03-07 11:35:59,852 INFO [corp-000][JdbcDatabasePlatformFactory][symmetric-engine-startup-0] Detected database 'db2as400', version '5', protocol 'as400'
2016-03-07 11:35:59,857 INFO [corp-000][JdbcDatabasePlatformFactory][symmetric-engine-startup-0] The IDatabasePlatform being used is org.jumpmind.db.platform.db2.Db2As400DatabasePlatform
2016-03-07 11:36:00,511 INFO [corp-000][Db2As400SymmetricDialect][symmetric-engine-startup-0] The DbDialect being used is org.jumpmind.symmetric.db.db2.Db2As400SymmetricDialect
2016-03-07 11:36:00,633 INFO [corp-000][ExtensionService][symmetric-engine-startup-0] Found 0 extension points from the database that will be registered
2016-03-07 11:36:00,635 INFO [corp-000][StagingManager][symmetric-engine-startup-0] The staging directory was initialized at the following location: C:\01MyWork\IntegTools\symmetric-server-3.7.29\tmp\corp-000
2016-03-07 11:36:00,645 INFO [corp-000][ClusterService][symmetric-engine-startup-0] This node picked a server id of COMPUTERN
2016-03-07 11:36:00,917 INFO [corp-000][ExtensionService][symmetric-engine-startup-0] Found 0 extension points from the database that will be registered
2016-03-07 11:36:00,918 INFO [corp-000][ClientExtensionService][symmetric-engine-startup-0] Found 9 extension points from spring that will be registered
2016-03-07 11:36:00,980 INFO [corp-000][AbstractSymmetricEngine][symmetric-engine-startup-0] Initializing SymmetricDS database
2016-03-07 11:36:00,980 INFO [corp-000][Db2As400SymmetricDialect][symmetric-engine-startup-0] Checking if SymmetricDS tables need created or altered
2016-03-07 11:36:02,515 INFO [corp-000][ConfigurationService][symmetric-engine-startup-0] Auto-configuring config channel
2016-03-07 11:36:02,581 ERROR [corp-000][AbstractSymmetricEngine][symmetric-engine-startup-0] An error occurred while starting SymmetricDS
org.jumpmind.db.sql.SqlException: [SQL7008] SYM_C00001 in SVS not valid for operation.
at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288)
at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:279)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:438)
at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:303)
at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:212)
at org.jumpmind.symmetric.service.impl.ConfigurationService.saveChannel(ConfigurationService.java:235)
at org.jumpmind.symmetric.service.impl.ConfigurationService.initDefaultChannels(ConfigurationService.java:443)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:409)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:396)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:535)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:527)
at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:237)
at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:464)
Caused by: java.sql.SQLException: [SQL7008] SYM_C00001 in SVS not valid for operation.
at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:895)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:682)
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1024)
at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1409)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:326)
at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:303)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:436)
... 10 more
2016-03-07 11:36:02,592 INFO [corp-000][AbstractSymmetricEngine][symmetric-engine-startup-0] Stopping SymmetricDS externalId=000 version=3.7.29 database=DB2 UDB for AS/400
What can i do for this problem. Thanks for help ...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm using SymmetricDS v3.7.29 and still entry level with symmetricds,
I was tried with oracle 11 g (winserver 2008 R2) and db2luw (virtual box with winserver 2008 R2), it was succeded to syncronize.
Then I try to sync between DB2/AS400 v5.4 with oracle 11 g (winserver 2008 R2)
with jt400as driver ; db.driver=com.ibm.as400.access.AS400JDBCDriver
this is the log from symmetric :
2016-03-07 11:35:59,852 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-0] Detected database 'db2as400', version '5', protocol 'as400'
2016-03-07 11:35:59,857 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-0] The IDatabasePlatform being used is org.jumpmind.db.platform.db2.Db2As400DatabasePlatform
2016-03-07 11:36:00,511 INFO [corp-000] [Db2As400SymmetricDialect] [symmetric-engine-startup-0] The DbDialect being used is org.jumpmind.symmetric.db.db2.Db2As400SymmetricDialect
2016-03-07 11:36:00,633 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-0] Found 0 extension points from the database that will be registered
2016-03-07 11:36:00,635 INFO [corp-000] [StagingManager] [symmetric-engine-startup-0] The staging directory was initialized at the following location: C:\01MyWork\IntegTools\symmetric-server-3.7.29\tmp\corp-000
2016-03-07 11:36:00,645 INFO [corp-000] [ClusterService] [symmetric-engine-startup-0] This node picked a server id of COMPUTERN
2016-03-07 11:36:00,917 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-0] Found 0 extension points from the database that will be registered
2016-03-07 11:36:00,918 INFO [corp-000] [ClientExtensionService] [symmetric-engine-startup-0] Found 9 extension points from spring that will be registered
2016-03-07 11:36:00,980 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Initializing SymmetricDS database
2016-03-07 11:36:00,980 INFO [corp-000] [Db2As400SymmetricDialect] [symmetric-engine-startup-0] Checking if SymmetricDS tables need created or altered
2016-03-07 11:36:02,515 INFO [corp-000] [ConfigurationService] [symmetric-engine-startup-0] Auto-configuring config channel
2016-03-07 11:36:02,581 ERROR [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] An error occurred while starting SymmetricDS
org.jumpmind.db.sql.SqlException: [SQL7008] SYM_C00001 in SVS not valid for operation.
at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288)
at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:279)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:438)
at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:303)
at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:212)
at org.jumpmind.symmetric.service.impl.ConfigurationService.saveChannel(ConfigurationService.java:235)
at org.jumpmind.symmetric.service.impl.ConfigurationService.initDefaultChannels(ConfigurationService.java:443)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:409)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:396)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:535)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:527)
at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:237)
at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:464)
Caused by: java.sql.SQLException: [SQL7008] SYM_C00001 in SVS not valid for operation.
at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:895)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:682)
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1024)
at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java:1409)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:326)
at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:303)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:436)
... 10 more
2016-03-07 11:36:02,592 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Stopping SymmetricDS externalId=000 version=3.7.29 database=DB2 UDB for AS/400
What can i do for this problem. Thanks for help ...
It sounds like you need to setup your schema for journalling. Here is some more information on how you can achieve this.
http://www.symmetricds.org/doc/3.7/html/user-guide.html#_db2_for_ibm_i
Thanks for your suggestion, i'll be contact db2as400 admin about setup for journalling.
Problem continue with fail to create global variable SYM_SYNC_TRIGGERS_DISABLED.
Still use DB2/AS400 version 5. What i have to do ?