Required field missing on Opportunity record

[BobD]

I saw two similar transactions go through, one with an error, one with out. This is for a new form that I just put online.

With the error:
transaction id=35724-2103252228407247991
SKU for main item=event|Ronline|CCONNECT|A20|D2021-03-25T12:00:00-08:00
SKU for covering transaction costs=eventRonlineCCONNECTD2021-03-25T12:00:00-08:00

without the error:
transaction id=35724-2103252222274807417
SKU for main item=event|Ronline|CCONNECT|A30|D2021-03-25T12:00:00-08:00
SKU for covering transaction costs=eventRonlineCCONNECTD2021-03-25T12:00:00-08:00


The Custom mapping for the region field says to set the region field to "Online" if the SKU starts with either eventRonline or event|Ronline

The error is:
"Upsert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, npsp.TDTM_Opportunity: execution of AfterInsert caused by: System.DmlException: Insert failed. First exception on row 1; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [Region]: [Region] (npsp): []--null--359--(CnP_PaaS)--System.DmlException"

I interpret that error to mean that it wasn't able to set the region field. However, as near as I can tell, the two transactions should have the same region. The SKUs for the main item differ by 1 character, which should not affect the region field. The SKUs for covering the transaction cost are identical.


I don't see anything to explain the difference between the transactions or determine why the later one failed.. Can you?

Bob

[CnP.Support.AM]

Good day @BobD

We need your permission to reprocess the C&P Data in order to debug the issue.

Looking forward to hearing back from you.

[BobD]

ok to reprocess

[CnP.LiveSupport.AB]

BobD ,

I looked at this, and shown above, and as we discussed- the error mentions npsp

"Upsert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, npsp.TDTM_Opportunity: execution of AfterInsert caused by: System.DmlException: Insert failed. First exception on row 1; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [Region]: [Region] (npsp): []--null--359--(CnP_PaaS)--System.DmlException"

You have a setting in your NPSP Settings to map the value of the Opportunity Region field (a lookup) to the Payment's Region field (a picklist).
I'm surprised that NPSP Settings allowed you to create the rule at all. Best practice when mapping fields like these is to make sure the fields on both objects are as alike as possible - in this case they should both be picklists with all the same values.

Your mapping is setting the value of your Region to "Online", and that value is not one of the options in Payment. When PaaS creates the Opportunity, NPSP creates the payment record and can't, which then means PaaS cannot finish creating the Opportunity and throws the error.

~ Amanda
C&P Live Support