Skip to main content
Solved

ArcSDE geodatabase writer

  • March 18, 2024
  • 4 replies
  • 100 views
fme_can_do_it
Enthusiast
Forum|alt.badge.img+12

When using the Transaction Type: Versioned Edit session in an ArcSDE geodatabase writer, all edits will be rolled back in the event of a translation failure. 

The geodatabase writer is set to Insert records in my workspace and I noticed numerous duplicate records after the translation failed due to conflicts identified during reconciliation. Do we need to modify anything in the writer?

 

Thank you!

Best answer by evieatsafe

Hi @fme_can_do_it thanks for your question. I’m wondering if you could check the settings in this photo attached? would be good to confirm if it is in fact attempting to write duplicate IDs. FME should be rolling back the Features if an error is encountered.


If you have checked these settings, and everything seems correct, perhaps you could submit a support case for us to investigate further!

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    4 replies

    evieatsafe
    Safer
    • evieatsafeSafer
    • Safer
    • Best Answer
    • March 19, 2024

    Hi @fme_can_do_it thanks for your question. I’m wondering if you could check the settings in this photo attached? would be good to confirm if it is in fact attempting to write duplicate IDs. FME should be rolling back the Features if an error is encountered.


    If you have checked these settings, and everything seems correct, perhaps you could submit a support case for us to investigate further!

    Happy to help - Evie
    fme_can_do_it
    Enthusiast
    Forum|alt.badge.img+12
    • fme_can_do_itEnthusiast
    • Author
    • Enthusiast
    • March 20, 2024

    @evieatsafe thank you for the reply! I see this in the writer settings:

     I was not writing in a version so I kept the rec and post option empty as I was writing directly into the Default. Was this causing duplicate records in my workspace?

    evieatsafe
    Safer
    • evieatsafeSafer
    • Safer
    • March 20, 2024

    @fme_can_do_it ah, yes this is likely the reason for the duplicate values because it is not being written to a version in a versioned edit session. I would change the settings to match my screenshot for better results.

    Happy to help - Evie
    fme_can_do_it
    Enthusiast
    Forum|alt.badge.img+12
    • fme_can_do_itEnthusiast
    • Author
    • Enthusiast
    • March 20, 2024

    i'm a little confused here since I'm writing in a parent Default version. If I select "Delete Child state" following "rec" and post to "Yes," which version will it delete?

    Community Stats

    32,154
    Posts
    122,047
    Replies
    39,812
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.