I'm using FME to write spatial data to a SQL Server database via an SDE connection, but the table is created without the spatial data. How can I ensure the spatial data is written correctly?
Error message below for refernce
An error occurred while attempting to create the feature class 'EL.DATA'. The error number from ArcObjects is: '-2147216061'. The error message from ArcObjects is: {Table already exists 42S01::Microsoft]]ODBC Driver 17 for SQL Server]]SQL Server]
Hi
Given the error message, “Table already exists”, you might wanna test with a simple read/write workspace to diagnose where the issue is in writing the data. It may be a permissions issue or the table “EL.DATA” itself.
Also, depending on the writer or transformer you’re using, you might wanna check that you have the right settings to “overwrite” or “drop and create” your table (with caution, since this will permanently delete data I would test with a sample first):
It might be worth double-checking that the geometry is defined for the destination correctly before writing to SQL Server via the SDE. Checking the SDE connection parameters, the coordinate systems, feature type definition.
I haven’t written spatial data to SQL Server myself, but if you’re able to share an sample workspace template I’m happy to help investigate further! 