Announcement

Collapse

Information Needed

See more
See less

Error Posting to Salesforce

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

  • Error Posting to Salesforce

    We received the following error notification:
    Date: 7/2/2019

    Hi SF IT,
    Sorry, but we have encountered an error while posting the data to your Salesforce account.

    Additional information:
    • Order number: 39346eab-cbd6-4925-93d4-bcd3b385c39d
    • Contact name:
    • Transaction Result:
    • C&P Data ID: 50192
    • Organization ID: 00D50000000cBTw
    • C&P Account #:
    • Organization Name: Appalachian Mountain Club
    • Applications : Application Name: CnP_PaaS_FM_GravityForm- Version Number3.700.003/WP:v4.9.8/GF:v2.3.3
      Installed Packages: 5.1905050001-9.1905190013
    System response:

    "Insert failed. First exception on row 0; first error: UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record or 1 records: 003500000321LMKAA2: []"

    Please check the following link for details:

    https://outdoors.my.salesforce.com/a0y2J00000I9B2X
    If you need further assistance please submit a support ticket at http://Help.ClickandPledge.com
    Regards,
    Click & Pledge Development Team
    Salesforce Group
    But it doesn't look like anything is wrong with the customer's info or recurring donation. Can you explain why this error message came through, and confirm if anything is wrong and needs to be fixed? I have granted login access for 1 week.

  • #2
    Good day @kaldrich@outdoors.org

    The reason for the above error is updating of record in the asynchronous form. In other words, the objects were busy when we were trying to insert the data. We simply reposted the data and it fixed it. It's about timing.

    However, you no need to worry about such errors. For these very reasons, we have the feature included in C&P Settings called Self Healing under Maintenence which will automatically resolve such errors. We suggest you enabled it and get rid of the above errors.
    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
      We turned on Self Healing and it sent tons of error notifications of old errors that we've since resolved through workaround processes. Can we choose to turn on Self Healing from this point forward without re-processing old transactions?

      Also, I wonder if this error is related or a different issue?:
      Date: 7/16/2019

      Hi SF IT,
      Sorry, but we have encountered an error while posting the data to your Salesforce account.

      Additional information:
      • Order number: 37312-190716094914779
      • Contact name: Thomas Phillips
      • Transaction Result: Authorized
      • C&P Data ID: 51417
      • Organization ID: 00D50000000cBTw
      • C&P Account #: 37,312
      • Organization Name: Appalachian Mountain Club
      • Applications : Application Name: CnP_PaaS_FM_GravityForm-Version Number : 3.700.000/WP:v4.9.5/GF:v2.2.5
        Installed Packages: 5.1905050001-9.1905190013
      System response:

      "Insert 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 0; first error: UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record or 1 records: a0Y5000000Cs2KWEAZ: []

      (npsp)






      : []"

      Please check the following link for details:

      https://outdoors.my.salesforce.com/a0y2J00000I9F7R
      If you need further assistance please submit a support ticket at http://Help.ClickandPledge.com

      Comment


      • #4
        Good day @kaldrich@outdoors.org

        We have fixed the above order number. Please note that self-healing will try to process those transactions which are ended up with the error and there is no way of knowing how you have fixed those with the workaround processes. If you don't want to run those old transactions which you have fixed through the workaround process then you need to turn the self-healing off.
        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


        • #5
          In order to fix all the errors that came through when we turned on Self Healing, would I have to send them here to the Support Forum? I'm not sure how to fix them on my own.

          Comment


          • #6
            Please list the order numbers here so that we can review it.
            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