Skip to main content
  • EN

I am using fme_db_operation to write some data into SQL spatial server.

After the running finished, in translation log it says:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Features not written - verify feature type fanout/dynamic settings

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

(Check that fanout/dynamic feature type attribute exists and has a value)

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

12809

==============================================================================

Total features not written 12809

 

From my checking, all new data are insert successfully.

 

Another error log is:

 

Microsoft SQL Server Spatial Writer: Data type `identity' of attribute `gisids' of feature type `featureXXX' is not supported for writing. Attribute will be ignored by writer.

 

The attribute was not ignored, it successfully updated in the database. I am really get confused by the log, it can't give the correct workbench running result.

 

 

 

@brandonguo​ You probably need to have your FME Reseller take a closer look at this. I'd suggest you file a support case with them. They'll probably need to see your workspace and data - perhaps through a screen share

Reply


Community Stats

30,185
Posts
114,569
Replies
37,848
Members
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.