View Issue Details

IDProjectCategoryView StatusLast Update
0004239SymmetricDSBugpublic2022-08-02 14:54
Reporteralexey_danilov Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.11.3 
Summary0004239: Error on symadmin.bat ... create-sym-tables on Sybase SQLAnywhere 12.0.1
DescriptionHello all!
We try to use symmetric DS 3.10.2 with SQLAnywhere 12.0.1 - all work fine, but when we need add Apache Ignite to replicate from SQLAnywhere we have error ...
look at http://www.symmetricds.org/issues/view.php?id=4236

Now we try to use symmetric DS 3.11.3 and after run symadmin.bat --engine buffer_dev-000 create-sym-tables and look followin error:
.....
2020-01-15 12:10:26,538 INFO [buffer_dev-000] [SqlAnywhereSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2020-01-15 12:11:47,680 INFO [buffer_dev-000] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring config channel
2020-01-15 12:11:47,696 ERROR [buffer_dev-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] An error occurred while starting SymmetricDS StackTraceKey.init [NullPointerException:943317330]
java.lang.NullPointerException
    at org.springframework.jdbc.core.StatementCreatorUtils.setNull(StatementCreatorUtils.java:248)
    at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:229)
    at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:163)
    at org.jumpmind.db.sql.JdbcSqlTemplate.doSetValue(JdbcSqlTemplate.java:1144)
    at org.jumpmind.db.sql.JdbcSqlTemplate.setValues(JdbcSqlTemplate.java:1121)
    at org.jumpmind.db.platform.sybase.SybaseJdbcSqlTemplate.setValues(SybaseJdbcSqlTemplate.java:160)
    at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:391)
    at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:358)
    at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:517)
    at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:358)
    at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:227)
    at org.jumpmind.symmetric.service.impl.ConfigurationService.saveChannel(ConfigurationService.java:290)
    at org.jumpmind.symmetric.service.impl.ConfigurationService.initDefaultChannels(ConfigurationService.java:481)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:518)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:487)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:657)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:646)
    at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:270)
    at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:601)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
2020-01-15 12:11:47,711 INFO [buffer_dev-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Stopping SymmetricDS externalId=000 version=3.11.3 database=SQL Anywhere
-----------------------------------
engine files:
engine.name=buffer_dev-000
db.driver=com.sybase.jdbc4.jdbc.SybDriver
# The JDBC URL used to connect to the database
db.url=jdbc:sybase:Tds:192.168.1.41:2643/buffer_dev

# The user to login as who can create and update tables
db.user=dba

# The password for the user to login as
db.password=

# JDBC driver connection properties
#db.connection.properties=

registration.url=
sync.url=http://192.168.1.41:31415/sync/buffer_dev-000
#sync.url=http://AS41:31415/sync/buffer_dev-000

# Do not change these for running the demo
group.id=cons
external.id=000

# Don't muddy the waters with purge logging
job.purge.period.time.ms=7200000

# This is how often the routing job will be run in milliseconds
#job.routing.period.time.ms=4500
job.routing.period.time.ms=3000
# This is how often the push job will be run.
#job.push.period.time.ms=9500
job.push.period.time.ms=3100
# This is how often the pull job will be run.
#job.pull.period.time.ms=9500
job.pull.period.time.ms=3200
# Kick off initial load
initial.load.create.first=true
# For large batches to be sent using the push job
http.push.stream.output.enabled=true

#create.table.without.foreign.keys=true
Additional InformationJDBC - Jconn4.jar
Tagsdialect: sql anywhere

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-01-15 09:17 alexey_danilov New Issue
2022-08-02 14:54 elong Tag Attached: dialect: sql anywhere