Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Mario 99 posts 663 karma points c-trib
    1 week ago
    Mario
    0

    Unable to update record field in workflow

    I have created a workflow to submit a registration to an external API . That API returns a receipt number that I wan to save in the record.

    I have followed the instructions in the docs but saving is failing with the error:

    The DELETE statement conflicted with the REFERENCE constraint "FK_UFRecordDataString_UFRecordFields_Key". The conflict occurred in database "XXXXXX", table "dbo.UFRecordDataString", column 'Key'. The statement has been terminated.

    My code is this:

    using (RecordStorage store = new RecordStorage())
    {
        var receiptField = record.GetRecordFieldByAlias("receiptID");
    
        receiptField.Values.Clear();
        receiptField.Values.Add(receiptId);
    
        store.UpdateRecord(record, e.Form);
    }
    

    Any idea what's going on?

  • marcelh 171 posts 471 karma points
    1 day ago
    marcelh
    0

    I'm running into the exact same issue here! Running Umbraco Forms 7.2.0. Did you manage to find a solution?

    I found, that when you "Enable Post Moderation" saving works miraculously fine.

    See also: https://issues.umbraco.org/issue/CON-1482

  • Mario 99 posts 663 karma points c-trib
    1 day ago
    Mario
    0

    No, I haven't found a solution yet.

Please Sign in or register to post replies

Write your reply to:

Draft