Skip to main content
  • EN

Hi,

 

 

I`m using FME 2014 to populate a table in our postGIS db. The problem is that the data is somehow not beeing loaded into the database. The logfile is telling that, 

 

 

"Failed to build an SQL statement because the feature lacked an 'fme_where' attribute. Update and delete features require an 'fme_where' attribute to be specified"

 

 

I´m guessing I have to set the fme_where attribute, but is really lost in why and howto set it? What should fme_where point to or include? Can someone help me in the right direction?

 

 

Christian

Hi,

 

 

it isn't normally necessary to set the fme_where attribute if you're just appending to an existing table. Could you post a screenshot of the the writer config and the relevant section of the error in the log?

 

 

David
Hi,

 

 

Link to the screenshot:

 

 

https://dl.dropboxusercontent.com/u/8365323/WFS%20%E2%86%92%20POSTGIS%20(CUserscn19928DesktopFMEplandk-forsyningsomraade2postgis.png

 

 

Link to a portion of the log-file:

 

 

https://dl.dropboxusercontent.com/u/8365323/wfs2postgis.log

 

 

Christian

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
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.