Cannot insert/update membership because membership period would completely overlap

[btaoregon]

Hello, I've got a weird error. A user signs up for our challenge. He doesn't have a membership. SFDC records a membership post transaction (courtesy of our "CreateMembership" trigger). BUT the transaction shows as "Declined Credit Card" and we get the below error, which seems to indicate that a membership wasn't created...note, there is no overlapping membership. This was the first membership for this contact/account/household.

** THE EMAIL ERROR MESSAGE **

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

Additional information:

• Order number: 1508251654044971972
• Contact name: XXX XXXXXX
• Transaction Result: Authorized
• C&P Data ID: 4091
• Organization ID: 00Di0000000iLgx
• Organization Name: Bicycle Transportation Alliance
• Applications : Application Name: -Version Number :
  Installed Packages: 2.6000-8.7012-2.2000

System response:

"Upsert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, CreateMembership: execution of AfterInsert

caused by: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Cannot insert/update membership because membership period would completely overlap (or be overlapped by) another membership - a0Vi000000QJUAQEA5: []

Trigger.CreateMembership: line 130, column 1: []"

[CnP.Support]

Good day!

This seems like a custom validation rule that is created in your instance:

"Upsert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, CreateMembership: execution of AfterInsert

caused by: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Cannot insert/update membership because membership period would completely overlap (or be overlapped by) another membership - a0Vi000000QJUAQEA5: []

Trigger.CreateMembership: line 130, column 1: []"

This is not a C&P validation rule - when we are trying to create the contact or update settings this validation rule is blocking us.

Please review the CreateMembership trigger for this error.

Hope that helps.

*** Each channel is designated for a specific type of question. Please post the questions in the appropriate channel. This question is related to Salesforce and I will move it to the appropriate channel. ***

Please let us know if we can be of any further assistance.

[CnP.Support]

Good day!

In reviewing your posted error I also realized that you are on an older version of our application. I highly recommend that you upgrade as your version is 4 versions behind and when the version falls too far behind it will have a harder time to be upgraded as is the case with all software.

We can upgrade your instance at no cost. If you wish for us to upgrade your instance please post the request in the Salesforce Upgrade Assistance channel at: http://forums.clickandpledge.com/for...ade-assistance

Let us know if we can be of any further assistance.

[btaoregon]

Hello! I got a number of these errors last night while upgrading to 3.51., prior to deprecating a few key contact fields...

What is needed to address?

---

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

...
System response:

"Upsert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, CreateMembership: execution of AfterInsert

caused by: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Cannot insert/update membership because membership period would completely overlap (or be overlapped by) another membership - a0Vi000000P5SsCEAV: []

Trigger.CreateMembership: line 130, column 1: []"

Please check the following link for details:

https://na15.salesforce.com/a1xi0000002XYeS

Our developers have been notified and will evaluate the error shortly.

[CnP.Support]

Good day!

Please see the error message:

FIELD_CUSTOM_VALIDATION_EXCEPTION, Cannot insert/update membership because membership period would completely overlap (or be overlapped by) another membership - a0Vi000000P5SsCEAV: []

You have a custom field that is stopping us from doing the processing of the posts.

This is not something we have control over - it is a custom validation. See the message.

Hope that helps.

BTW: Once you remove the validation the system will resolve the issue if the Self-Healing is on in the C&P Settings > Maintenance.

[CnP.Support]

Good day!

Based on office hour discussion this issue was resolved by deleting the Declined transactions that had updated your membership based on your custom triggers.

We have also pushed all your transactions to Salesforce dating back to May 2014. There were a lot (& I mean a lot) of transactions.

Please review and let us know if we can be of any further assistance.

[CnP.Support]

Good day!

I just reviewed your instance & noticed that the push of all these transactions have resulted in a number of "Lock Row" errors with NPSP. Do not worry about these errors - the Self-Healing will resolve them.

These conditions occur when NPSP cannot keep up with the rapid succession of posts and as such will not release records in-time for the next post. The Self-Healing will review each error and will resolve them. Considering the total number of transactions all your errors will be resolved by late this evening.

Please review your instance tomorrow & let us know if you see any issues.