View Issue Details

IDProjectCategoryView StatusLast Update
0004598SymmetricDSBugpublic2020-11-09 15:15
Reporterelong Assigned Toelong  
Status closedResolutionfixed 
Product Version3.10.0 
Target Version3.12.5Fixed in Version3.12.5 
Summary0004598: 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


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


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-10-19 15:01 elong New Issue
2020-10-19 15:01 elong Status new => assigned
2020-10-19 15:01 elong Assigned To => elong
2020-10-19 15:01 elong Tag Attached: bulk
2020-10-19 15:01 elong Tag Attached: dialect: sql-server
2020-10-19 15:01 elong Issue generated from: 0004597
2020-10-19 15:01 elong Relationship added related to 0004597
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.12.5
2020-11-09 15:15 admin Status resolved => closed