Skip to main content
  • EN

I have come across this issue a cuple of times and I want to understand what is happening:

I use newid() to insert uniqueidentifier for all new rows.

The writer set to import table definition from datasource and thus includes the local_id attribute (defualt to newid())

 

My features to INSERT already have a local_ids from the source that i need to remove which I do my remove the attribute all together using the featureManager transformer. Despite of this FME produce an insert query with local_id is set to <null>.

 

Do I really need to remove my local_id in the writer for it to be left alone to let the DB produce the id?

I have other columns default to timestamp (Now()) and that is triggered as expected by the DB, so I am a bit confused to why the identifyer key is treated differently.

In your writer, check that the output attributes tab doesn't have 'local_id' specified

I am running fme_db_operation, using the same writer for UPDATE, INSERT and DELETE so I cannot remove local_id without duplicating the writer. Easier to make FME create GUID for me instead of the database, altough I would had prefer the db to create the GUID for me

Reply


Community Stats

30,171
Posts
114,533
Replies
37,830
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.