Skip to main content
Question

postgis - problems with adding data to database

R
Forum|alt.badge.img

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
Celebrity
  • david_rCelebrity
  • May 20, 2014
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
Forum|alt.badge.img
  • rkcha
  • Author
  • May 20, 2014
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


Helpful Members This Week

Community Stats

31,341
Posts
118,850
Replies
38,930
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.