View Issue Details

IDProjectCategoryView StatusLast Update
0003257SymmetricDS ProBugpublic2018-02-14 20:08
Reporterkpatierno Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.0 
Target Version3.9.2Fixed in Version3.9.2 
Summary0003257: Syntax Formatting Error When Connected to ORACLE DB
DescriptionSymmetric Log error when attempting to create a monitor from sym_monitor & sym_monitor_event,

2017-09-25 09:23:43,257 ERROR [server-000] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey.init [SqlException:2724980413]
org.jumpmind.db.sql.SqlException: Failed to execute sql:
select
    m.monitor_id, m.external_id, m.node_group_id, m.type, m.expression, m.enabled,
    m.threshold, m.run_period, m.run_count, m.severity_level, m.create_time,
    m.last_update_by, m.last_update_time, me.is_resolved
from
    sym_monitor m join sym_monitor_event me
where
    m.monitor_id = me.monitor_id and (m.node_group_id = ? or m.node_group_id = 'ALL')
    and (m.external_id = ? or m.external_id = 'ALL') and m.enabled = 1 and me.is_resolved = 0

The correct syntax for this query is

select........
from
    sym_monitor m join sym_monitor_event me ON m.monitor_id = me.monitor_id
where
    (m.node_group_id = 'SERVER' or m.node_group_id = 'ALL')
    and (m.external_id = '000' or m.external_id = 'ALL') and m.enabled = 1 and me.is_resolved = 0

The formatting should replace the current 'WHERE' with 'ON' and change the 'AND' that follows to 'WHERE' this will eliminate the problem.
Steps To ReproduceSetup an Oracle Server to Symmetric
TagsNo tags attached.

Activities

kpatierno

2017-09-25 15:50

viewer  

SERVER.log (109,925 bytes)

Related Changesets

SymmetricDS: 3.9 74154442

2017-09-25 12:51:09

admin

Details Diff
0003257: Syntax Formatting Error When Connected to ORACLE DB Affected Issues
0003257
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/MonitorServiceSqlMap.java Diff File

Issue History

Date Modified Username Field Change
2017-09-25 15:50 kpatierno New Issue
2017-09-25 15:50 kpatierno File Added: SERVER.log
2017-09-25 16:49 kpatierno Product Version 3.8.0 => 3.9.0
2017-09-25 16:49 kpatierno Target Version 3.8.30 => 3.9.0
2017-09-25 16:50 elong Assigned To => elong
2017-09-25 16:50 elong Status new => assigned
2017-09-25 16:51 elong Status assigned => resolved
2017-09-25 16:51 elong Resolution open => fixed
2017-09-25 16:51 elong Fixed in Version => 3.9.0
2018-01-02 23:21 mmichalek Fixed in Version 3.9.0 => 3.9.2
2018-01-02 23:22 mmichalek Status resolved => closed
2018-02-14 20:08 admin Changeset attached => SymmetricDS 3.9 74154442