Skip to main content
Question

Has anyone had problems inserting new polygons into an esri sde polygon feature class using INSERT writer?

dnguye1
Participant
Forum|alt.badge.img+1

11 replies

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • September 27, 2017

Could be a lot of issues here: invalid geometry, duplicate key, invalid domain values.

You do need to give more information for us to help.

Can you provide the log file?

danilo_fme
Evangelist
Forum|alt.badge.img+42
  • danilo_fmeEvangelist
  • Evangelist
  • September 27, 2017

Hi @dnguye1,

Has a interesting Question here in Knowledge Center New Records to SDE, please check if it is godd for you.

Thanks,

Danilo

fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • September 27, 2017
Hi @dnguye1, what kind of problems are you experiencing? Are there any errors in the log file? Is this a versioned table?
dnguye1
Participant
Forum|alt.badge.img+1
  • dnguye1Participant
  • Author
  • Participant
  • September 27, 2017
The workspace ran and said 5 or so number of records were inserted but when I checked the feature class table, no records were inserted. What confused me is if I also have a fme_db_operation = UPDATE to the same table in the workspace, then both the UPDATE and INSERT works fine but not when I only do the INSERT alone.

 

 

fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • September 27, 2017
dnguye1 wrote:
The workspace ran and said 5 or so number of records were inserted but when I checked the feature class table, no records were inserted. What confused me is if I also have a fme_db_operation = UPDATE to the same table in the workspace, then both the UPDATE and INSERT works fine but not when I only do the INSERT alone.

 

 

Interesting! Are you writing to an existing table then? Can you attach your log file?

 

 

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • September 27, 2017

The priority will be "fme_db_operation" over "Feature Type write mode" over "Writer write mode".

So, setting fme_db_operation to UPDATE will force all features with the attribute to be written in UPDATE mode.

That will not fail if the key is not available.

dnguye1
Participant
Forum|alt.badge.img+1
  • dnguye1Participant
  • Author
  • Participant
  • September 27, 2017

Hi Erik, I added the writer as INSERT (writer Mode = Insert under writer parameter) and one stream to the writer is to insert records. From another stream I set fme_db_operation = UPDATE and send to the same writer which will do update on existing records. I've done this on other project with point and line features and it worked fine but this is the first time for polygons.

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • September 27, 2017
dnguye1 wrote:

Hi Erik, I added the writer as INSERT (writer Mode = Insert under writer parameter) and one stream to the writer is to insert records. From another stream I set fme_db_operation = UPDATE and send to the same writer which will do update on existing records. I've done this on other project with point and line features and it worked fine but this is the first time for polygons.

So what is the error/information in the log file?

 

 

dnguye1
Participant
Forum|alt.badge.img+1
  • dnguye1Participant
  • Author
  • Participant
  • September 27, 2017
dnguye1 wrote:

Hi Erik, I added the writer as INSERT (writer Mode = Insert under writer parameter) and one stream to the writer is to insert records. From another stream I set fme_db_operation = UPDATE and send to the same writer which will do update on existing records. I've done this on other project with point and line features and it worked fine but this is the first time for polygons.

Erik, there is no error in the INSERT (failed Insert) log file. It says 9 records were written but nothing was inserted into the feature class table.

 

 

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • September 27, 2017
dnguye1 wrote:

Hi Erik, I added the writer as INSERT (writer Mode = Insert under writer parameter) and one stream to the writer is to insert records. From another stream I set fme_db_operation = UPDATE and send to the same writer which will do update on existing records. I've done this on other project with point and line features and it worked fine but this is the first time for polygons.

Looks like someone has to have a close look at the workspace and the log file.

 

I suggest submitting them to Support@Safe.com or attaching them to this question thread.

 

I believe we mentioned all options that can be mentioned without further investigation.

 

 

dnguye1
Participant
Forum|alt.badge.img+1
  • dnguye1Participant
  • Author
  • Participant
  • September 27, 2017
dnguye1 wrote:

Hi Erik, I added the writer as INSERT (writer Mode = Insert under writer parameter) and one stream to the writer is to insert records. From another stream I set fme_db_operation = UPDATE and send to the same writer which will do update on existing records. I've done this on other project with point and line features and it worked fine but this is the first time for polygons.

The reader and writer read and write to an ersi sde version, I am not sure how to send you that part of the workspace. Please let me know. Thanks.

 

 

Reply


Helpful Members This Week

Community Stats

31,000
Posts
117,487
Replies
38,778
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.