Upgraded to FME 2023. When writing to SQL server database, Bulk Insert = 'Yes' results in features dropping and not writing to DB (even though the correct amount of features are listed in the Total Features Written message). If I set Bulk Insert = 'No', the correct number of records write to the DB but one of the nvarchar attributes is empty in the database. Everything looks correct in the final inspector prior to writing. This is using workbenches originally created on 2022.1.2.0, Build 22627. New version of FME is 2023.0.0.3, Build 23319. I reran workbenches on 2022 and it's working correctly
Question
SQL writer dropping features and attributes with Bulk Insert on FME 2023. Works correctly on FME 2022.
+12- Safer
Hi @mcannalea12 I tried reproducing this issue in FME 2023.0.0.3 but haven't had any success so far.
Would you be able to share some more information about the data you are writing to your database? How many features are you writing to your SQL Server? What data types are contained within your schema? Are you writing to an existing table or creating a new one? If you're able to share some source data and a workspace, this would be very helpful for resolving the issue.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.