Announcement

Collapse

Information Needed

See more
See less

Insert Failed

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

  • Insert Failed

    After conducting a registration through our Click and Pledge event registration system for our Local Food Experience event, I received a message that says:
    "Insert failed. First exception on row 0; first error: UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record or 1 records: 0035000000yitkLAAQ: []"

    Can you explain what the issue is and what action I need to take to fix this.
    Thank you,
    Robin Lenner

  • #2
    Good day @rlenner

    The reason for the above error is when posts to Salesforce are made prior to Salesforce finishing the preview triggers it will face a row-lock issue. Another trigger has the row open and has locked it and when we try to do anything with that row it does not give us permission which results the above error.

    However, we noticed that you are at outdated versions of our apps. If you allow us we will upgrade your instance with the latest versions and will fix the above error. Please share the order number and grant us login access to your instance.

    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
      Hello

      I don't understand your explanation. Can you be more specific and let us know what we need to do differently to prevent that from happening? Thank.

      We have granted access so you can proceed with the updates. Is there anything those updates will affect that we should be prepared for, or will need to adjust settings as a result in terms of the Click and Pledge and SalesForce interfaces?

      The order number is:
      • Order number: 22231-1808131530172996532

      Comment


      • #4
        Good day @rlenner

        You have to do nothing and after this upgrade, there should not be an issue again.

        We have upgraded your instance with the latest versions of our apps as requested.

        NOTE: Please note that the Salesforce Campaign defined in Connect (affecting the entire transaction) will be deprecated from Connect. Please review C&P Settings > Opportunity > Primary Campaign rules to ensure Opportunities receive the correct campaign. Check 'Use Transaction Campaign' in your C&P Setting rules to retain the Salesforce Campaign specified in Connect; however, we recommend implementing SKUs as the best long-term strategy.

        SKU Tutorial : http://tutorial.productions.clickand...ideo/209074427

        It is highly recommended that you login to the Connect & re-establish the connection. You may see that your account is already connected but this does not mean the new information has posted to Salesforce.

        To establish connection please see the following KB article: https://cnp.mn/Salesforce-Connection

        Release notes: http://cnp.mn/Salesforce-Latest-Releases

        You may also join our Power of Us Hub: https://bit.ly/1cO852O
        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