View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003257 | SymmetricDS Pro | Bug | public | 2017-09-25 15:50 | 2018-02-14 20:08 |
| Reporter | kpatierno | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.9.2 | Fixed in Version | 3.9.2 | ||
| Summary | 0003257: Syntax Formatting Error When Connected to ORACLE DB | ||||
| Description | Symmetric 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 Reproduce | Setup an Oracle Server to Symmetric | ||||
| Tags | No tags attached. | ||||
| 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 |