Skip to main content
Question

MSSQL_SPATIAL writer: Failed to open writer

  • May 5, 2021
  • 2 replies
  • 58 views
A

Hi all,

 

I've publish my workspace with SQL Server connection to FME Server and build an automation from that. However, the error message "MSSQL_SPATIAL writer: Failed to open writer" is returned when I run the automation.

 

error 

I've check all three workaround given in this article, " https://community.safe.com/s/article/fme-and-sql-server-troubleshooting-guide " but none of them works.

 

Anyone have any idea or suggestions on how can I resolve this issue?

2 replies

daraghatsafe
Forum|alt.badge.img

Hi @aafirah​ does the workspace work on FME Desktop before it gets published to Server?

 

A
  • aafirah
  • Author
  • 10 replies
  • May 7, 2021

Hi @aafirah​ does the workspace work on FME Desktop before it gets published to Server?

 

Hi @daraghatsafe​.

Yes, the workspace works and successfully update the database in SQL Server. FYI, I'm using the ArcGIS Pro Data Interoperability Workbench application.


Community Stats

32,105
Posts
121,901
Replies
39,752
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.