"Upsert failed" error for reacurring payments

[Lucas.Veldhuis]

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.

[CnP.Support]

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.

[Lucas.Veldhuis]

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.

[Lucas.Veldhuis]

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

[Lucas.Veldhuis]

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.

[CnP.Support]

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.

[Lucas.Veldhuis]

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.

[Lucas.Veldhuis]

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

[CnP.Support]

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?

[Lucas.Veldhuis]

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

[CnP.Support]

Good day!

We fixed the 2 Order Numbers you provided.

Please see below:


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.

[Lucas.Veldhuis]

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.

[CnP.Support]

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.

[Lucas.Veldhuis]

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

[CnP.Support]

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.