View Issue Details

IDProjectCategoryView StatusLast Update
0005412SymmetricDSTaskpublic2022-08-17 17:38
Reporterkuldeep171 Assigned Toelong  
Priorityurgent 
Status feedbackResolutionopen 
Product Version3.14.0 
Summary0005412: Error ERROR [primary] [SymmetricEngineHolder] [background-refresher-1] Failed to initialize engine StackTraceKey.init [SqlExcept
DescriptionHello,
I am new in symmetric ds and configuring replication. After clicking finished the below error logged in error log file symmetric.log.
==========================================================================================================
2022-08-17 10:55:15,280 ERROR [primary] [SymmetricEngineHolder] [background-refresher-1] Failed to initialize engine StackTraceKey.init [SqlException:3606663129] org.jumpmind.db.sql.SqlException: JZ0SB: Parameter index out of range: 1.
        at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:308)
=============================================================================================================

The detail logs are attached below:

2022-08-17 10:53:56,387 INFO [gui] [JdbcDatabasePlatformFactory] [qtp728943498-12] Detected database 'Adaptive Server Enterprise', version '16', protocol 'sybase'
2022-08-17 10:53:56,390 INFO [gui] [JdbcDatabasePlatformFactory] [qtp728943498-12] The IDatabasePlatform being used is org.jumpmind.db.platform.ase.AseDatabasePlatform
2022-08-17 10:55:08,753 INFO [gui] [JdbcDatabasePlatformFactory] [qtp728943498-12] Detected database 'Adaptive Server Enterprise', version '16', protocol 'sybase'
2022-08-17 10:55:08,756 INFO [gui] [JdbcDatabasePlatformFactory] [qtp728943498-12] The IDatabasePlatform being used is org.jumpmind.db.platform.ase.AseDatabasePlatform
2022-08-17 10:55:15,210 INFO [not available] [SecurityService] [background-refresher-1] Initialized with AES 256-bit
2022-08-17 10:55:15,219 INFO [primary] [ClientSymmetricEngine] [background-refresher-1] Initializing connection to database
2022-08-17 10:55:15,250 INFO [primary] [JdbcDatabasePlatformFactory] [background-refresher-1] Detected database 'Adaptive Server Enterprise', version '16', protocol 'sybase'
2022-08-17 10:55:15,251 INFO [primary] [JdbcDatabasePlatformFactory] [background-refresher-1] The IDatabasePlatform being used is org.jumpmind.db.platform.ase.AseDatabasePlatform
2022-08-17 10:55:15,266 INFO [primary] [AseSymmetricDialect] [background-refresher-1] The DbDialect being used is org.jumpmind.symmetric.db.ase.AseSymmetricDialect
2022-08-17 10:55:15,273 INFO [primary] [AseSymmetricDialect] [background-refresher-1] Page size is 2048
2022-08-17 10:55:15,279 INFO [primary] [AbstractSymmetricEngine] [background-refresher-1] Stopping SymmetricDS externalId=primary version=3.14.0 database=Adaptive Server Enterprise
2022-08-17 10:55:15,280 ERROR [primary] [SymmetricEngineHolder] [background-refresher-1] Failed to initialize engine StackTraceKey.init [SqlException:3606663129] org.jumpmind.db.sql.SqlException: JZ0SB: Parameter index out of range: 1.
        at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:308)
        at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:297)
        at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:492)
        at org.jumpmind.db.platform.AbstractJdbcDdlReader.getSchemaNames(AbstractJdbcDdlReader.java:1442)
        at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:298)
        at org.jumpmind.db.platform.AbstractDatabasePlatform.getTableFromCache(AbstractDatabasePlatform.java:345)
        at org.jumpmind.db.platform.AbstractDatabasePlatform.getTableFromCache(AbstractDatabasePlatform.java:333)
        at org.jumpmind.symmetric.service.impl.ExtensionService.refresh(ExtensionService.java:87)
        at org.jumpmind.symmetric.service.impl.ClientExtensionService.refresh(ClientExtensionService.java:45)
        at org.jumpmind.symmetric.AbstractSymmetricEngine.init(AbstractSymmetricEngine.java:287)
        at org.jumpmind.symmetric.ClientSymmetricEngine.init(ClientSymmetricEngine.java:199)
        at org.jumpmind.symmetric.web.ServerSymmetricEngine.init(ServerSymmetricEngine.java:80)
        at org.jumpmind.symmetric.ClientSymmetricEngine.<init>(ClientSymmetricEngine.java:150)
        at org.jumpmind.symmetric.web.ServerSymmetricEngine.<init>(ServerSymmetricEngine.java:59)
        at org.jumpmind.symmetric.web.SymmetricEngineHolder.create(SymmetricEngineHolder.java:339)
        at org.jumpmind.symmetric.web.SymmetricEngineHolder.install(SymmetricEngineHolder.java:292)
        at com.jumpmind.symmetric.console.impl.cp.u(AbstractWizardScreen.java:188)
        at com.jumpmind.symmetric.console.impl.cL$a.a(SummaryScreen.java:64)
        at com.jumpmind.symmetric.console.impl.cL$a.doWork(SummaryScreen.java:60)
        at com.jumpmind.symmetric.console.ui.common.K$1.onBackgroundDataRefresh(InProgressDialog.java:102)
        at com.jumpmind.symmetric.console.ui.b.a(BackgroundRefresherService.java:87)
        at com.jumpmind.symmetric.console.ui.b$2.run(BackgroundRefresherService.java:126)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:750)
Caused by: java.sql.SQLException: JZ0SB: Parameter index out of range: 1.
        at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(Unknown Source)
        at com.sybase.jdbc4.jdbc.ParamManager.int(Unknown Source)
        at com.sybase.jdbc4.jdbc.ParamManager.doSetParam(Unknown Source)
        at com.sybase.jdbc4.jdbc.ParamManager.setParam(Unknown Source)
        at com.sybase.jdbc4.jdbc.SybPreparedStatement.a(Unknown Source)
        at com.sybase.jdbc4.jdbc.SybPreparedStatement.a(Unknown Source)
        at com.sybase.jdbc4.jdbc.SybPreparedStatement.setString(Unknown Source)
        at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.a(Unknown Source)
        at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.getSchemas(Unknown Source)
        at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getSchemas(DelegatingDatabaseMetaData.java:789)
        at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getSchemas(DelegatingDatabaseMetaData.java:789)
        at org.jumpmind.db.platform.AbstractJdbcDdlReader$6.execute(AbstractJdbcDdlReader.java:1455)
        at org.jumpmind.db.platform.AbstractJdbcDdlReader$6.execute(AbstractJdbcDdlReader.java:1442)
        at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:490)
        ... 26 more

2022-08-17 10:55:15,283 WARN [primary] [SymmetricEngineHolder] [background-refresher-1] The engine could not be created. It will not be started
2022-08-17 10:55:15,283 ERROR [primary] [b] [background-refresher-1] Exception while refreshing class com.jumpmind.symmetric.console.ui.common.K$1 StackTraceKey.init [RuntimeException:3004221217] java.lang.RuntimeException: The installation of the node failed. Please check the log files for details about the failure.
        at com.jumpmind.symmetric.console.impl.cp.u(AbstractWizardScreen.java:200)
        at com.jumpmind.symmetric.console.impl.cL$a.a(SummaryScreen.java:64)
        at com.jumpmind.symmetric.console.impl.cL$a.doWork(SummaryScreen.java:60)
        at com.jumpmind.symmetric.console.ui.common.K$1.onBackgroundDataRefresh(InProgressDialog.java:102)
        at com.jumpmind.symmetric.console.ui.b.a(BackgroundRefresherService.java:87)
        at com.jumpmind.symmetric.console.ui.b$2.run(BackgroundRefresherService.java:126)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:750)


TagsNo tags attached.

Activities

elong

2022-08-17 17:38

developer   ~0002168

SymmetricDS uses JDBC to connect to Sybase, which needs the metadata tables. Make sure you've enabled them:

ALTER DATABASE Upgrade JCONNECT ON

Here is the documentation on it:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00801.1530/doc/html/san1281564736871.html

Issue History

Date Modified Username Field Change
2022-08-17 05:38 kuldeep171 New Issue
2022-08-17 17:38 elong Assigned To => elong
2022-08-17 17:38 elong Status new => feedback
2022-08-17 17:38 elong Note Added: 0002168