Solved

After upgrade to 2023.1.2 FME Form from FME Desktop 2022.2 SQL Server Non Spatial Writer start writing empty attribute for all text fields but Datetime field still populating.

Forum|Forum|1 year ago
December 4, 2023
5 replies
167 views

+20

panda
Enthusiast

After upgrade to 2023.1.2 FME Form from FME Desktop 2022.2 Microsoft SQL Server Non Spatial Writer start writing empty attributes for all text fields but Datetime field still populating. Have anyone encountered this issue before? I tried changing TYPE to text, varchar_max, char, non of these works on FME Form 2023.1.2

I have replaced that writer, replaced the workspace with brand new canvas, still no luck.

But when I run the same exact workspace in FME Desktop 2022.2 the table populates fine.

To make it even more confusing, within the same workspace I have another SQL Server writer but it just goes to another table, both version are able to populate all records. Ssms_DtsnfKSLm6 Something interesting I saw on the log for 2023.1.2 version is that before it showed 11 record written to the table, 120 attributes were truncated. (not sure why?), but in 2022.2 version there's no warning on this issue.

Ssms_SqE2w5jMSH I also attached log files from both versions.

Best answer by ctredinnick

Thank you for you suggestion! Unfortunately Bulk insert is set to No already for me and it still not working >,<

There's some more discussion in this thread which is related https://community.safe.com/s/question/0D54Q00009mVZN1SAO/fme-inserts-null-value-into-nvarcharmax-columns-in-sql-server-using-microsoft-sql-server-nonspatial-format-after-the-latest-fme-upgrade . By the comments I think it's still a bit of an issue.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.