Announcement

Collapse
No announcement yet.

"Upsert failed" error for reacurring payments

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

  • "Upsert failed" error for reacurring payments

    I am getting the following error for some, but not all, recurring payments:

    Upsert failed. First exception on row 0; first error: DUPLICATE_VALUE, duplicate value found: unknown duplicates value on record with id: 006U000000LPfBE: []

    I spoke to Kamran Razvan about this during the office hour webinar and he instructed me to post it here.

  • #2
    Good day!

    We tried to review your account but don't have access.

    How to grant access: http://forums.clickandpledge.com/showthread.php?t=1065
    Please make sure to post your organization name & the Salesforce Organization ID so we know how to locate your instance.

    Please reply to this thread when access has been granted.
    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
      Support,

      I apologize for not granting support I thought I had. I just did it again and you should now have log in access. The "Upsert failed" error occurred for another recurring donation that was made over the weekend. Let me know if you need any additional information to resolve this as I though that this problem was already resolved through a premier support tech call case #00008960.

      Thank you for taking the time to fix this correctly.

      Comment


      • #4
        Support,

        I just got done with talking with Kamran Razvan about this error. I have fixed the settings on my side according to Kamran and he informed me to give you the order numbers of the error opportunities that need to get pushed again from your end to my data base. Thanks, and please let me know if you need any additional information from me.
        Order numbers:
        14113010234296480056327
        14113010233412414773692
        1411288255457542411935
        1411288254523546653142
        1411274335387414755474
        1411239314024414748791
        141114821430414726819
        141256203617414718048
        Last edited by Lucas.Veldhuis; 12-05-2014, 03:34 PM.

        Comment


        • #5
          Support,

          The error is still occurring. I will yet again extend your access for you to FIX the issue. Here are the recent order numbers for the error:
          141278414837422876182
          141285384888426676386

          I would really appreciate an update as well as I have yet to hear anything back from you in regaurds to solving the issue rather than just seeing the error order numbers being pushed into our system correctly.
          Thanks you.

          Comment


          • #6
            Good day!

            We fixed the transactions as requested.

            It is strange that this keeps happening- it is as if you have a program that is really consuming Salesforce's processes.
            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


            • #7
              When you say, "it is as if you have a program that is really consuming Salesforce's processes" I don't understand what I am supposed to do with that information. I would love to know who I can fix this problem from occurring in the future. Does this statement mean that you cant find out how to do this? Will you continue to help me fix this error? Please advise me on what I can do if anything to fix this error.

              Thank you.

              Comment


              • #8
                Hi Kamran,

                Thanks for continuing to look into this for me as I really do appreciate it. here is the new error order number:

                ​1412141042067414792332

                Comment


                • #9
                  Good day!

                  We have resolved the issue for you for that transaction.

                  In reviewing your instance and comparing it with our other clients we see one app that we have not seen before. It is an app you have installed by RoundCorner.

                  Any idea about that app and if it does something to the opportunity?
                  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


                  • #10
                    Hi Kamran,

                    I looked into round corner and I have no knowledge of the app however, I believe that our company might have used them when we transitioned to Salesforce back in 2011 but it still should have nothing to do with the opportunity itself. Thanks for continuing to look into this for me as I really do appreciate it. Here are the new error order numbers:

                    141216722072549016775
                    141216723155426632857

                    Comment


                    • #11
                      Good day!

                      We fixed the 2 Order Numbers you provided.

                      Please see below:
                      Click image for larger version

Name:	RoundCorner-app.jpg
Views:	1
Size:	97.1 KB
ID:	15579

                      the app you are not using has triggers on the opportunity. While we are not sure this is the reason for the problem, we would like to see if you can remove it - naturally if you are not using it. You may also want to disable the trigger and test.

                      As stated before we have never tested our app in the presence of this product and knowing the cross talk would help us narrow down your issue.

                      Let me know if you need help with disabling the trigger or the app.
                      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


                      • #12
                        Yes,

                        Could you please go in and disable the trigger. I would like to keep the app there encase it needs to be there for other applications that other employees are running. Thanks in advance for all of your help.


                        Comment


                        • #13
                          Good day Lucas,

                          The trigger you are referring to is part of a managed package and cannot be disabled by us.

                          The only solution is to un-install it if you are not using it.

                          Let us know if we can be of any further assistance or if you wish for us to uninstall the package.
                          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


                          • #14
                            I am waiting to hear back from a college about removing the app. In the meantime there was another error.
                            Order numbers:
                            151811112985488899287

                            Comment


                            • #15
                              Good day!

                              We tried to fix this for you but we no longer have access to your instance.

                              Please grant us login access so we can review the transaction.
                              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