I am trying to use a GUID field to update records in an ArcSDE Writer. It seems to work perfectly when using an integer field for the Update Key, but when I use a field with type=guid the update does not go through.
Solved
Can you do an UPDATE fme_db_operation using a field of type GUID as the Update Key?
Best answer by nathanatsafe
Different versions of FME treat GUIDs slightly differently, including possibly adding or dropping the surrounding { } characters, which can confuse a writer or a transformer like the ChangeDetector. The behaviour also varies slightly between File GDB and ArcSDE GDB. Close inspection of the attribute before the writer, as @david_r suggested, should reveal discrepancies if this is the root issue. Such an issue can be fixed with an AttributeManager.
Which version of FME are you using? Older versions of FME didn't fully support GUID fields, but I believe FME 2016 and later should be able to do it.
I also suggest inspecting the contents of the GUID attribute just before the writer to make sure it contains a valid value.
+12- Safer
d4 wrote:
Using FME 2017.0.
The GUID looks to be a valid value.
+7- Safer
- Best Answer
Different versions of FME treat GUIDs slightly differently, including possibly adding or dropping the surrounding { } characters, which can confuse a writer or a transformer like the ChangeDetector. The behaviour also varies slightly between File GDB and ArcSDE GDB. Close inspection of the attribute before the writer, as @david_r suggested, should reveal discrepancies if this is the root issue. Such an issue can be fixed with an AttributeManager.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.