Announcement

Collapse

Information Needed

See more
See less

Required field missing on Opportunity record

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Required field missing on Opportunity record

    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



  • #2
    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.
    Regards,
    Click & Pledge Support Department

    On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

    Join us @ the educational webinars: https://clickandpledge.com/webinars/
    Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
    Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

    Comment


    • #3
      ok to reprocess

      Comment


      • #4
        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.

        Click image for larger version

Name:	2021-03-29_16-37-41.jpg
Views:	29
Size:	23.8 KB
ID:	58743

        Click image for larger version

Name:	2021-03-29_16-39-29.jpg
Views:	21
Size:	35.6 KB
ID:	58744

        Click image for larger version

Name:	2021-03-29_16-50-31.jpg
Views:	22
Size:	45.1 KB
ID:	58745

        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


        Regards,
        Click & Pledge Support Department

        On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

        Join us @ the educational webinars: https://clickandpledge.com/webinars/
        Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
        Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

        Comment

        Working...
        X