Announcement

Collapse

Information Needed

See more
See less

Cannot insert/update membership because membership period would completely overlap

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

  • Cannot insert/update membership because membership period would completely overlap

    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: []"
    Last edited by CnP.Support; 08-26-2015, 05:04 AM.
    Diane
    Salesforce Administrator
    Bicycle Transportation Alliance
    Portland, OR

  • #2
    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.
    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
      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.
      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


      • #4
        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.

        Diane
        Salesforce Administrator
        Bicycle Transportation Alliance
        Portland, OR

        Comment


        • #5
          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.



          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


          • #6
            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.
            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
              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.
              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