[SalesForce] ( INVALID_FIELD_FOR_INSERT_UPDATE, Attempting to update (as part of an upsert) parent field)Upsert failed

I am using the upsert statement to update the custom object Customer__c with two master-detail fields. The fields reference custom Contact__c and Subject__c objects.

Customer__c c = new Customer__c();
c.Contact__c = ConId;
c.Subject__c = SubId;
c.External_Id__c = '100201';
upsert c External_Id__c;

While trying this, I am getting an exception:

System.DmlException: Upsert failed. First exception on row 0; first error: INVALID_FIELD_FOR_INSERT_UPDATE, Attempting to update (as part of an upsert) parent field Contact__c with new value 003g000000aaayLAAQ, current value is 003g0000009c9xyAAY: [Contact__c]

It's working in a developer sandbox and not working in a full copy sandbox.

Note: In the full copy sandbox, Person Account is Enabled.

Best Answer

This error is telling you that you already have a record with field external_Id__c set to '100201'. When you do the upsert, it's trying to update the existing record with a new value for Contact__c.

You need to have the checkbox for Child records can be reparented to other parent records after they are created selected on the Contact__c field for the upsert to work.

Related Solutions

[SalesForce] Required Field Missing, Upsert Fail

You need to set the Account on the new Account_Detail__c records. Try do something like this:

for(Account a : loops over a certain amount of times) {
    Account_Detail__c j = new Account_Detail__c();
    j.name ='blank';
    j.AccountId = a.Id;
    detailList.add(j);
}

[SalesForce] System.DmlException: Insert failed. first error: REQUIRED_FIELD_MISSING, Required fields are missing: [AccountIDc]: [AccountIDc] line 49

In triggers, only the immediate fields of the SObject are populated. So this code will not work:

ID accountID = Committee_Member[0].MN4__Contact__r.Account.Id;

as it is referencing the related Contact object and then in turn the Contact's Account object. Instead you will need to add a query that uses the Committee_Member[0].MN4__Contact__c ID field to query the related Contact object for the Contact.AccountId field.

Also your trigger is coded assuming there is only ever one MN4__Committee_Member__c object inserted/updated/deleted and will not produce correct results when more than one of those objects is inserted/updated/deleted. So you should also apply some of the bulkification patterns in Apex Code Best Practices to address this.

Best Answer

Related Solutions

[SalesForce] Required Field Missing, Upsert Fail

[SalesForce] System.DmlException: Insert failed. first error: REQUIRED_FIELD_MISSING, Required fields are missing: [AccountID__c]: [AccountID__c] line 49

Related Topic

[SalesForce] System.DmlException: Insert failed. first error: REQUIRED_FIELD_MISSING, Required fields are missing: [AccountIDc]: [AccountIDc] line 49