Skip to main content
Question

MSSQL_SPATIAL writer: Failed to open writer

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
  • May 7, 2021
daraghatsafe wrote:

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.

Reply


Helpful Members This Week

Community Stats

30,946
Posts
117,275
Replies
38,743
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.