View Issue Details

IDProjectCategoryView StatusLast Update
0002749SymmetricDSImprovementpublic2016-08-24 15:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.8.0 
Target Version3.8.3Fixed in Version3.8.3 
Summary0002749: Firebird "arithmetic exception, numeric overflow, or string truncation" on extract
DescriptionAdd warning to log when getting "arithmetic exception, numeric overflow, or string truncation" on Firebird that the user needs to enable contains_big_lobs for the channel. The stack trace below is happening on an extract.

Caused by: org.jumpmind.db.sql.SqlException: GDS Exception. 335544321. arithmetic exception, numeric overflow, or string truncation
No message for code 335544914 found.
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:283)
    at org.jumpmind.db.platform.firebird.FirebirdJdbcSqlTemplate.translate(FirebirdJdbcSqlTemplate.java:59)
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:274)
    at org.jumpmind.db.sql.JdbcSqlReadCursor.next(JdbcSqlReadCursor.java:131)
    at org.jumpmind.symmetric.service.impl.DataExtractorService$SelectFromSymDataSource.next(DataExtractorService.java:1582)
    at org.jumpmind.symmetric.io.data.reader.ExtractDataReader.nextTable(ExtractDataReader.java:101)
    at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:161)
    at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:116)
    at org.jumpmind.symmetric.service.impl.DataExtractorService.extractOutgoingBatch(DataExtractorService.java:842)
    at org.jumpmind.symmetric.service.impl.DataExtractorService$1.call(DataExtractorService.java:584)
    at org.jumpmind.symmetric.service.impl.DataExtractorService$1.call(DataExtractorService.java:1)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    ... 3 more
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 8f6d3d1e

2016-08-24 10:59:57

admin

Details Diff
0002749: Firebird "arithmetic exception, numeric overflow, or string
truncation" on extract
Affected Issues
0002749
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File

Issue History

Date Modified Username Field Change
2016-08-24 14:58 elong New Issue
2016-08-24 14:58 elong Status new => assigned
2016-08-24 14:58 elong Assigned To => elong
2016-08-24 15:00 admin Changeset attached => SymmetricDS 3.8 8f6d3d1e
2016-08-24 15:00 elong Status assigned => resolved
2016-08-24 15:00 elong Fixed in Version => 3.8.3
2016-08-24 15:00 elong Resolution open => fixed