View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004597 | SymmetricDS | Bug | public | 2020-10-19 15:00 | 2020-11-09 15:15 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.0 | ||||
| Target Version | 3.11.13 | Fixed in Version | 3.11.13 | ||
| Summary | 0004597: SQL Server bulk loader data conversion with decimal scientific notation | ||||
| Description | For SQL-Server dialect, sending an initial load for a table with decimal, float, or real data types can result in an error for the bulk loader. The decimal data is sent in scientific notation, which is not expected by the bulk insert command. Our standard batch CSV protocol should probably be in decimal format (0.00000001), not scientific notation (1E-8) for compatibility. INFO [client] [ManageIncomingBatchListener] [client-dataloader-97] Bulk loading failed for this batch 12970348, falling back to default loading. (org.jumpmind.db.sql.SqlException: Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 74, column 20 (percentage).) | ||||
| Tags | bulk, dialect: sql-server | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-10-19 15:00 | elong | New Issue | |
| 2020-10-19 15:00 | elong | Status | new => assigned |
| 2020-10-19 15:00 | elong | Assigned To | => elong |
| 2020-10-19 15:00 | elong | Tag Attached: bulk | |
| 2020-10-19 15:00 | elong | Tag Attached: dialect: sql-server | |
| 2020-10-19 15:00 | elong | Issue generated from: 0004580 | |
| 2020-10-19 15:00 | elong | Relationship added | related to 0004580 |
| 2020-10-19 15:01 | elong | Status | assigned => resolved |
| 2020-10-19 15:01 | elong | Resolution | open => fixed |
| 2020-10-19 15:01 | elong | Fixed in Version | => 3.11.13 |
| 2020-10-19 15:01 | elong | Issue cloned: 0004598 | |
| 2020-10-19 15:01 | elong | Relationship added | related to 0004598 |
| 2020-11-09 15:15 | admin | Status | resolved => closed |