View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003364 | SymmetricDS Pro | Bug | public | 2018-01-11 17:32 | 2018-01-22 13:40 |
| Reporter | maxwellpettit | Assigned To | maxwellpettit | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.2 | ||||
| Target Version | 3.9.3 | Fixed in Version | 3.9.3 | ||
| Summary | 0003364: Error viewing load details with a Sybase DB | ||||
| Description | Caused by: org.jumpmind.db.sql.SqlException: Failed to execute sql: select ob.load_id, count(ob.batch_id) as count, ob.status, c.queue, max(ob.last_update_time) as last_update_time, min(ob.create_time) as create_time, sum(ob.data_row_count) as data_events, sum(ob.byte_count) as byte_count, min(extract_start_time) as min_extract_start_time, min(transfer_start_time) as min_transfer_start_time, min(load_start_time) as min_load_start_time, min(summary) as min_summary, max(summary) as max_summary, sum(extract_millis + transform_extract_millis) as full_extract_millis, sum(network_millis) as full_transfer_millis, sum(load_millis + transform_load_millis + filter_millis) as full_load_millis from sym_outgoing_batch ob join sym_channel c on c.channel_id = ob.channel_id where ob.load_id = ? group by ob.load_id, c.queue, ob.status order by ob.load_id asc at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:300) at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:120) at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:140) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:199) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:195) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:185) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:121) at org.jumpmind.symmetric.service.impl.OutgoingBatchService.getLoadStatusSummaries(OutgoingBatchService.java:724) at com.jumpmind.symmetric.console.ui.screen.d.u.<init>(OutgoingLoadDetail.java:66) at com.jumpmind.symmetric.console.ui.screen.d.v.itemClick(OutgoingLoadPanel.java:208) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510) ... 53 more Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'count'. at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:3954) at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3088) at com.sybase.jdbc4.tds.Tds.getResultSetResult(Tds.java:3820) at com.sybase.jdbc4.tds.TdsCursor.open(TdsCursor.java:329) at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2371) at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:258) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:97) ... 66 more | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-01-11 17:32 | maxwellpettit | New Issue | |
| 2018-01-11 17:32 | maxwellpettit | Status | new => assigned |
| 2018-01-11 17:32 | maxwellpettit | Assigned To | => maxwellpettit |
| 2018-01-11 17:33 | maxwellpettit | Status | assigned => resolved |
| 2018-01-11 17:33 | maxwellpettit | Resolution | open => fixed |
| 2018-01-11 17:33 | maxwellpettit | Fixed in Version | => 3.9.3 |
| 2018-01-22 13:40 | chenson | Status | resolved => closed |