View Issue Details

IDProjectCategoryView StatusLast Update
0003257SymmetricDS ProBugpublic2017-09-25 12:51
ReporterkpatiernoAssigned Toelong 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version3.9.0 
Target Version3.9.0Fixed in Version3.9.0 
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 11:50

manager  

SERVER.log (109,925 bytes)

Issue History

Date Modified Username Field Change
2017-09-25 11:50 kpatierno New Issue
2017-09-25 11:50 kpatierno File Added: SERVER.log
2017-09-25 12:49 kpatierno Product Version 3.8.0 => 3.9.0
2017-09-25 12:49 kpatierno Target Version 3.8.30 => 3.9.0
2017-09-25 12:50 elong Assigned To => elong
2017-09-25 12:50 elong Status new => assigned
2017-09-25 12:51 elong Status assigned => resolved
2017-09-25 12:51 elong Resolution open => fixed
2017-09-25 12:51 elong Fixed in Version => 3.9.0