Question

MSSQL_SPATIAL writer: Failed to open writer


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

Badge

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

 

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