Skip to main content
  • EN

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 AInfrastructure].uFire_Hydrants_Audit] (iFH_ID] bigint, iWork_Required] bit, bPaint_Post] bit, bNew_Post] bit, bPaint_Surround] bit, bClear_Vegetation] bit, bPost_Reflector] bit, bInspection_Date] datetime2, mInspected_By] varchar_max, mWorks_Completed] bit, bMI_PRINX] integer, gSP_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!

Reply


Community Stats

31,790
Posts
120,751
Replies
39,405
Members

Latest FME

Terms & ConditionsCookie settings
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.