Solved

Field Data Type Issue when writing to Microsoft SQL Server

Forum|Forum|3 months ago
August 6, 2025
5 replies
76 views

+9

vassok
Contributor

Hi!

I have encountered the following error when using Feature Writer transformer (dynamic workspace) writing a Microsoft SQL Server Spatial table.

2025-08-06 16:11:20| 148.0| 0.0|ERROR |Microsoft SQL Server Spatial Writer: Query failed, possibly due to a malformed statement. Query Text `CREATE TABLE [Infrastructure].[Fire_Hydrants_Audit] ([FH_ID] bigint, [Work_Required] bit, [Paint_Post] bit, [New_Post] bit, [Paint_Surround] bit, [Clear_Vegetation] bit, [Post_Reflector] bit, [Inspection_Date] datetime2, [Inspected_By] varchar_max, [Works_Completed] bit, [MI_PRINX] integer, [SP_GEOMETRY] geometry)'. Provider error `(2715) Column, parameter, or variable #9: Cannot find data type varchar_max.'

Any thoughts how to resolve this?

Thanks!

Best answer by j.botterill

On the FME downloads page, there is a change log. I can see a bug fix implemented in 2025.1 version

Download this version of Form and see if it helps.

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.