Hello,
I came across this warning:
“ 2024-10-08 15:14:19| 14.7| 0.0|WARN |Microsoft SQL Server Non-Spatial Writer: Failed to parse `Date' from attribute value ` 19810101' for column `InstallDate'
2024-10-08 15:14:19| 14.7| 0.0|WARN |Microsoft SQL Server Non-Spatial Writer: Failed to parse ' 19810101' as a datetime value. For FME datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/! “
As you can see, FME is trying to write to a SQL database, but is failing due to syntax error.
This results in all of the items that have this syntax error NOT BEING WRITTEN to the database, and those which do match the syntax being written. In my specific case this resulted in 25 features out of 20,000 not being written, as this was a warning rather than an error this was missed for several months, causing quite a few issues.
Can we get an option to cancel transactions or throw an actual error in the case data is not being written in its full extent?
Thanks