View Issue Details

IDProjectCategoryView StatusLast Update
0003834SymmetricDSBugpublic2019-05-18 09:06
Reportergilles.riandAssigned To 
Priorityhigh 
Status acknowledgedResolutionopen 
Product Version3.9.14 
Target VersionFixed in Version 
Summary0003834: Startup fails on Interbase trying to insert sym_monitor bec "type" is reserved word
DescriptionI try to install on Interbase, I make my own SQL Script to fixed Issue 0003832

auto.config.database=false

and DESCRIPTION ONLY 1024


CREATE TABLE SYM_TRIGGER
".."
    LAST_UPDATE_TIME TIMESTAMP NOT NULL,
    DESCRIPTION VARCHAR(1024)
);


But now... or in th e gui !!! Where the Details of the SQL Queries ?


2018-12-17 17:33:32,651 INFO [lame-easy_test_3_9_15] [JobManager] [symmetric-engine-startup-1] Job File Sync Pull not configured for auto start
2018-12-17 17:33:32,651 INFO [lame-easy_test_3_9_15] [JobManager] [symmetric-engine-startup-1] Job File Sync Push not configured for auto start
2018-12-17 17:33:32,651 INFO [lame-easy_test_3_9_15] [InitialLoadExtractorJob] [symmetric-engine-startup-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Mon Dec 17 17:33:38 CET 2018
2018-12-17 17:33:32,651 INFO [lame-easy_test_3_9_15] [MonitorJob] [symmetric-engine-startup-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Mon Dec 17 17:33:38 CET 2018
2018-12-17 17:33:32,651 INFO [lame-easy_test_3_9_15] [JobManager] [symmetric-engine-startup-1] Job Report Status not configured for auto start
2018-12-17 17:33:32,654 INFO [lame-easy_test_3_9_15] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS Node STARTED:
     nodeId=easy_test_3_9_15
     groupId=lame
     type=professional
     subType=null
     name=lame-easy_test_3_9_15
     softwareVersion=3.9.15
     databaseName=InterBase
     databaseVersion=10.0
     driverName=InterClient
     driverVersion=10.0.9 for Java 1.6 with InterBase XE, 2009 and 2007
     uptime=0 sec.
2018-12-17 17:33:36,629 ERROR [gui] [b] [qtp12134395-17] [interclient][interbase]Dynamic SQL Error
[interclient][interbase]SQL error code = -104
[interclient][interbase]Token unknown - line 1, char 65
[interclient][interbase]type StackTraceKey.init [SqlException:4204806638]
org.jumpmind.db.sql.SqlException: [interclient][interbase]Dynamic SQL Error
[interclient][interbase]SQL error code = -104
[interclient][interbase]Token unknown - line 1, char 65
[interclient][interbase]type
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302)
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291)
    at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:503)
    at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:342)
    at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:224)
    at com.jumpmind.symmetric.console.service.impl.ProConsoleService.createSystemMonitors(ProConsoleService.java:49)
    at com.jumpmind.symmetric.console.ui.b.initializeTabs(MainWindow.java:624)
    at com.jumpmind.symmetric.console.ui.b.a(MainWindow.java:531)
    at com.jumpmind.symmetric.console.ui.b.a(MainWindow.java:399)
    at com.jumpmind.symmetric.console.ui.b.a(MainWindow.java:342)
    at com.jumpmind.symmetric.console.ui.AppUI.init(AppUI.java:57)
    at com.vaadin.ui.UI.doInit(UI.java:745)
    at com.vaadin.server.communication.UIInitHandler.getBrowserDetailsUI(UIInitHandler.java:216)
    at com.vaadin.server.communication.UIInitHandler.synchronizedHandleRequest(UIInitHandler.java:74)
    at com.vaadin.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:41)
    at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1568)
    at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:381)
Tagsdialect: interbase, install

Activities

elong

2019-04-26 18:16

developer   ~0001451

From stack trace, it's running a prepared insert statement:

insert into sym_monitor (monitor_id, node_group_id, external_id, type, expression, threshold, run_period, run_count, severity_level, enabled, last_update_time, last_update_by, create_time) values(?,?,?,?,?,?,?,?,?,?,?,?,?)

It complains about unknown token around the "type" column. I'm guessing "type" is a reserved word. We'll need to call it "monitor_type" instead.

Issue History

Date Modified Username Field Change
2018-12-17 11:41 gilles.riand New Issue
2019-04-26 18:16 elong Note Added: 0001451
2019-04-26 19:09 elong Summary Log Details Error => Startup fails on Interbase trying to insert sym_monitor bec "type" is reserved word
2019-04-29 10:25 elong Tag Attached: dialect: interbase
2019-04-29 10:25 elong Tag Attached: install
2019-04-29 10:25 elong Project SymmetricDS Pro => SymmetricDS
2019-05-18 09:06 elong Priority normal => high
2019-05-18 09:06 elong Status new => acknowledged