View Issue Details

IDProjectCategoryView StatusLast Update
0004147SymmetricDSBugpublic2019-11-13 14:42
ReporterhanesAssigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.11.0 
Target VersionFixed in Version 
Summary0004147: Interbase Data Truncation Issue with monitor firing
DescriptionI 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
Tagsdialect: interbase

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-11-13 14:42 hanes New Issue
2019-11-13 14:42 hanes Tag Attached: dialect: interbase