Dynamics Community Forum Thread Details

update conflict on record

I have got 2 custom tables with same key fields and almost same fields.

When the data gets updated in one table the other table has to be updated with the same data and vice versa.

When I make any updates on one form, I randomly get the below error message

Cannot edit a record in xxx (xxxTable). An update conflict occured due to another user process deleting the record or changing one or fields in the record.

I am the only user in my dev environment and no other user is currently changing anything

So, on the form datasource write() method I have written code to update the data

table 1

public void write()
{
     GeneralTable     generalTableFind, generalTableUpdate;
    
    super();
	
    element.numberSeqFormHandler().formMethodDataSourceWrite();       
    
    ttsbegin;

    update_recordset BatchAttributesTable
                setting
                 Group             =  GeneralTable.Group,
                FromDate           =  GeneralTable.FromDate,
                ToDate             =  GeneralTable.ToDate,
                AlloyNum           =  GeneralTable.AlloyNum,
                Metric             =  GeneralTable.Metric,
                MARS               =  GeneralTable.MARS,                
        where BatchAttributesTable.GeneralId    ==  GeneralTable.GeneralId;

    ttscommit;
}

For the second table I have written code on the update method

public void update()
{
     GeneralTable             this_Orig = this.orig();
     GeneralAndTable          GeneralAndTable;
     BatchAttributesTable     BatchAttributesTable;
    
    ttsbegin;

    super();

    if(this_Orig.GeneralId != this.GeneralId || this_Orig.Version != this.Version)
    {
        
        while select forupdate GeneralTable
            where GeneralAndTable.General Id == this_Orig.GeneralId
               && GeneralAndTable.Version == this_Orig.Version
        {
            GeneralAndTable.GeneralId = this.GeneralId;
            GeneralAndTable.Version = this.Version;
            GeneralAndTable.update();
        }
        
    }

    ttscommit;
}

Categories:

Dynamics 365 Finance

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL