Skip to main content

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!

Which version of FME are you using? There were varchar_max bugs in older versions 

Hi ​@j.botterill FME 2024.1. 

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. 

​@j.botterill  Awesome thanks for this!

​@j.botterill 

FYI the newest version fixed the issue.

Cheers!

Community Stats

32,012
Posts
121,585
Replies
39,634
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.