Skip to main content
  • EN

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?

Hi @dnguye1,

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

Thanks,

Danilo

Hi @dnguye1, what kind of problems are you experiencing? Are there any errors in the log file? Is this a versioned table?
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.

 

 

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?

 

 

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.

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.

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?

 

 

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.

 

 

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.

 

 

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


Community Stats

30,189
Posts
114,583
Replies
37,854
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.