View Issue Details

IDProjectCategoryView StatusLast Update
0004597SymmetricDSBugpublic2020-11-09 15:15
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.0 
Target Version3.11.13Fixed in Version3.11.13 
Summary0004597: 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 0004580 closedelong SQL Server bulk loader data conversion with decimal scientific notation 
related to 0004598 closedelong SQL Server bulk loader data conversion with decimal scientific notation 

Activities

There are no notes attached to this issue.

Issue History

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