View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004147 | SymmetricDS | Bug | public | 2019-11-13 19:42 | 2021-06-19 21:05 |
| Reporter | hanes | Assigned To | |||
| Priority | normal | ||||
| Status | new | Resolution | open | ||
| Product Version | 3.11.0 | ||||
| Summary | 0004147: Interbase Data Truncation Issue with monitor firing | ||||
| Description | I believe this is a monitor that has fired and trying to be saved as a monitor event. [store-002] - JdbcSqlTemplate - Parameter arg '[{"mostRecentThreadName":"store-002-dataloader-16","firstOccurranceTime":1573673423491,"mostRecentTime":1573673900280,"count":9,"message":"Failed to load batch 000-61","stackTrace":"java.lang.RuntimeException: Could not convert a value of 0.99 for column PRICE of type INTEGER\n\tat org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValues(AbstractDatabasePlatform.java:383)\n\tat org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.execute(DefaultDatabaseWriter.java:927)\n\tat org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.insert(DefaultDatabaseWriter.java:213)\n\tat org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:192)\n\tat org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)\n\tat org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:84)\n\tat org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)\n\tat org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:201)\n\tat org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:212)\n\tat org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:178)\n\tat org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:124)\n\tat org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1080)\n\tat org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1057)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: java.lang.NumberFormatException: For input string: \".99\"\n\tat java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)\n\tat java.lang.Integer.parseInt(Integer.java:569)\n\tat java.math.BigInteger.<init>(BigInteger.java:470)\n\tat java.math.BigInteger.<init>(BigInteger.java:606)\n\tat org.jumpmind.db.platform.AbstractDatabasePlatform.parseInteger(AbstractDatabasePlatform.java:493)\n\tat org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValue(AbstractDatabasePlatform.java:419)\n\tat org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValues(AbstractDatabasePlatform.java:378)\n\t... 16 more\n","levelInt":40000},{"mostRecentThreadName":"store-002-pull-default-3","firstOccurranceTime":1573673423605,"mostRecentTime":1573673900399,"count":9,"message":"Failed to process batch","stackTrace":"java.lang.RuntimeException: Could not convert a value of 0.99 for column PRICE of type INTEGER\n\tat org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValues(AbstractDatabasePlatform.java:383)\n\tat org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.execute(DefaultDatabaseWriter.java:927)\n\tat org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.insert(DefaultDatabaseWriter.java:213)\n\tat org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:192)\n\tat org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)\n\tat org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:84)\n\tat org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)\n\tat org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:201)\n\tat org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:212)\n\tat org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:178)\n\tat org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:124)\n\tat org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1080)\n\tat org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1057)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: java.lang.NumberFormatException: For input string: \".99\"\n\tat java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)\n\tat java.lang.Integer.parseInt(Integer.java:569)\n\tat java.math.BigInteger.<init>(BigInteger.java:470)\n\tat java.math.BigInteger.<init>(BigInteger.java:606)\n\tat org.jumpmind.db.platform.AbstractDatabasePlatform.parseInteger(AbstractDatabasePlatform.java:493)\n\tat org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValue(AbstractDatabasePlatform.java:419)\n\tat org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValues(AbstractDatabasePlatform.java:378)\n\t... 16 more\n","levelInt":40000},{"mostRecentThreadName":"store-002-job-10","firstOccurranceTime":1573673474504,"mostRecentTime":1573673956915,"count":9,"message":"Exception while executing job 'Monitor'","stackTrace":"org.jumpmind.db.sql.SqlException: Data truncation\n\tat org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:305)\n\tat org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:294)\n\tat org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:519)\n\tat org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:358)\n\tat org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:227)\n\tat org.jumpmind.symmetric.service.impl.MonitorService.insertMonitorEvent(MonitorService.java:344)\n\tat org.jumpmind.symmetric.service.impl.MonitorService.updateMonitor(MonitorService.java:231)\n\tat org.jumpmind.symmetric.service.impl.MonitorService.update(MonitorService.java:124)\n\tat org.jumpmind.symmetric.job.MonitorJob.doJob(MonitorJob.java:45)\n\tat org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:227)\n\tat org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:298)\n\tat org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)\n\tat java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)\n\tat java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: java.sql.DataTruncation: Data truncation\n\tat interbase.interclient.PreparedStatement.setString(Unknown Source)\n\tat org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)\n\tat org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)\n\tat org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:400)\n\tat org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:232)\n\tat org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:163)\n\tat org.jumpmind.db.sql.JdbcSqlTemplate.doSetValue(JdbcSqlTemplate.java:1144)\n\tat org.jumpmind.db.sql.JdbcSqlTemplate.setValues(JdbcSqlTemplate.java:1121)\n\tat org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:391)\n\tat org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:358)\n\tat org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:517)\n\t... 16 more\n","levelInt":40000}]' caused exception: Data truncation [store-002] - MonitorJob - Exception while executing job 'Monitor' org.jumpmind.db.sql.SqlException: Data truncation at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:305) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:294) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:519) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:358) at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:227) at org.jumpmind.symmetric.service.impl.MonitorService.insertMonitorEvent(MonitorService.java:344) at org.jumpmind.symmetric.service.impl.MonitorService.updateMonitor(MonitorService.java:231) at org.jumpmind.symmetric.service.impl.MonitorService.update(MonitorService.java:124) at org.jumpmind.symmetric.job.MonitorJob.doJob(MonitorJob.java:45) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:227) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:298) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.DataTruncation: Data truncation at interbase.interclient.PreparedStatement.setString(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:400) at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:232) at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:163) at org.jumpmind.db.sql.JdbcSqlTemplate.doSetValue(JdbcSqlTemplate.java:1144) at org.jumpmind.db.sql.JdbcSqlTemplate.setValues(JdbcSqlTemplate.java:1121) at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:391) at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:358) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:517) ... 16 more | ||||
| Tags | dialect: interbase | ||||