Question

postgis - problems with adding data to database

R
Badge

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

2 replies

david_r
Rank
Userlevel 4
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
R
Badge
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

28,724
Posts
109,519
Replies
36,564
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.