View Issue Details

IDProjectCategoryView StatusLast Update
0004580SymmetricDSBugpublic2020-10-19 15:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.10.0 
Target Version3.10.13Fixed in Version3.10.13 
Summary0004580: SQL Server bulk loader data conversion with decimal scientific notation
DescriptionFor 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).)
Tagsbulk, dialect: sql-server

Relationships

related to 0004597 resolvedelong SQL Server bulk loader data conversion with decimal scientific notation 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 f5d89715

2020-10-19 14:47:11

admin

Details Diff
0004580: SQL Server bulk loader data conversion with decimal scientific
notation
Affected Issues
0004580
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java Diff File

SymmetricDS: 3.11 e85e5ab7

2020-10-19 14:47:11

admin

Details Diff
0004580: SQL Server bulk loader data conversion with decimal scientific
notation
Affected Issues
0004580
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java Diff File

SymmetricDS: 3.12 0ddf4561

2020-10-19 14:47:11

admin

Details Diff
0004580: SQL Server bulk loader data conversion with decimal scientific
notation
Affected Issues
0004580
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java Diff File

Issue History

Date Modified Username Field Change
2020-10-07 16:40 elong New Issue
2020-10-07 16:40 elong Status new => assigned
2020-10-07 16:40 elong Assigned To => elong
2020-10-07 16:40 elong Tag Attached: bulk
2020-10-07 16:40 elong Tag Attached: dialect: sql-server
2020-10-19 15:00 admin Changeset attached => SymmetricDS 3.10 f5d89715
2020-10-19 15:00 admin Changeset attached => SymmetricDS 3.11 e85e5ab7
2020-10-19 15:00 admin Changeset attached => SymmetricDS 3.12 0ddf4561
2020-10-19 15:00 elong Status assigned => resolved
2020-10-19 15:00 elong Resolution open => fixed
2020-10-19 15:00 elong Fixed in Version => 3.10.13
2020-10-19 15:00 elong Issue cloned: 0004597
2020-10-19 15:00 elong Relationship added related to 0004597