Announcement

Collapse

Information Needed

See more
See less

Errors posting transactions to Salesforce

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

  • Errors posting transactions to Salesforce

    Hi,

    For the past couple of weeks, we've been receiving error reports when posting to Salesforce. The errors reference Cazoomi, which is a sync app we use to link our Salesforce data to Mailchimp. We've been using this integration for 2+ years.

    Any idea why Cazoomi might be preventing transactions from posting?

    Error sample below:

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

    Additional information:
    Order number: 1507121030145583219
    Transaction Result: Authorized
    C&P Data ID: 1886
    Organization ID: 00DE0000000bdHC
    Organization Name: True Colors Fund
    Applications : Application Name: Salesforce:CnP_PaaS_Evt:Site-Version Number : 2.6000
    Installed Packages: 2.6000-8.8000-2.3000
    System response:

    "Insert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, cazoomi.EmailOptOut: execution of BeforeInsert

    caused by: System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing.
    Even if a field is indexed a filter might still not be selective when:
    1. The filter value includes null (for instance binding with a list that contains null)
    2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times)

    (cazoomi): []"

  • #2
    Good day!

    Can you check: http://community.cazoomi.com/cazoomi...reply_14286171

    This is not related to our app. Cazoomi is blocking the insert.

    If you wish for us to review the error being generated please grant us login access so we can review the log file.
    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
      Hi, I've granted login access to our account so you can check the logs. I've also reached out to Cazoomi but have not heard back.

      Comment


      • #4
        Also, I uninstalled the Cazoomi package to see if that would alleviate the issue, but now I can't push transactions to Salesforce because it says there are duplicate transaction records. See error below:

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

        Additional information:
        Order number: 1507081947336791009
        Contact name: Michael Randazzo
        Transaction Result: Authorized
        C&P Data ID: 1908
        Organization ID: 00DE0000000bdHC
        Organization Name: True Colors Fund
        Applications : Application Name: Salesforce:CnP_PaaS_Evt:Site-Version Number : 2.6000
        Installed Packages: 2.6000-8.9004-2.3000
        System response:

        "Insert failed. First exception on row 0; first error: DUPLICATE_VALUE, duplicate value found: CnP_PaaS__VaultGUID__c duplicates value on record with id: a1AE0000000IVow: []"

        Comment


        • #5
          Good day @JoeMoran,

          The error explains what is going on. This transaction (Vault GUID) already exists in the system. It seems like to fix this you are posting them again. You should never post a transaction twice to Salesforce as the system will detect duplicates and return error.

          Here is what we did for you.

          Step 1: Added the "Re-Post" button to your C&P Data profile. [part of post-install steps]
          Step 2: Added "Message" to the C&P Data > Error view [part of post-install steps]
          Step 3: Added "Previous Error Message" to the C&P Data Layout [part of post-install steps]
          Step 4: Activated "Self-Healing" in the C&P Settings > Maintenance [part of post-install steps]
          Step 5: Waited 5 minutes
          Step 6: Enjoyed the results

          See the image before Self-Healing fixed all your issues:
          Click image for larger version

Name:	Errors.jpg
Views:	13
Size:	104.5 KB
ID:	18098


          Once Self-Healing was done:
          Click image for larger version

Name:	2015-07-21_12-57-50.jpg
Views:	10
Size:	56.8 KB
ID:	18097




          All Errors are fixed.

          In the future if you encounter an error simply go to the C&P Data and click on repost. This action will delete all incidents & footprint of the prior post and posts the C&P Data again. In 99.99% of cases this will resolve it. If you leave the system alone, the self-Healing service will run every 3 hours and resolves anything that has an error.

          Click image for larger version

Name:	2015-07-21_13-18-21.jpg
Views:	10
Size:	57.3 KB
ID:	18099

          You had error'd transactions from 2014 that were resolved and all fixed.

          Please check the C&P Data and see if you have any errors left.
          Last edited by CnP.Support; 07-21-2015, 12:19 PM.
          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
            Woohoo! Thank you so much! That saves me a lot of work

            Comment


            • #7
              Good day!

              Your event is a release behind and is in 2.6000.7. The only way you can upgrade in the future is to upgrade to 2.7000.22

              Click image for larger version

Name:	2015-07-21_14-04-44.jpg
Views:	10
Size:	49.8 KB
ID:	18102

              Do you want us to upgrade your instance? Highly recommended.. did I say highly?!
              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


              • #8
                I'm confused. I don't see any way to upgrade myself. The version on the App Exchange is still 2.6000.22. Can you upgrade us?

                Comment


                • #9
                  Good day @joemoran;

                  We did not include the 2.6000.22 upgrade through the standard upgrade in C&P Settings as we did not want people to upgrade without reading the release note. The release removed all traces of 1.x event application and in the release note we have a warning that upgrades should NOT be done if event 1.x is still in use.

                  As requested we upgraded your instance to the latest release of 2.6000.22 - we are still waiting for Salesforce to fix their publishing site and as such we have not yet release 3.x

                  In reviewing your instance we fixed a number of post-install issues and also created a new site called "default". We recommend our clients to use only one site for all C&P features such as images in autoresponder, event, invoice, etc. A single site minimizes the work for performing post-installation with future features.

                  We recommend you use the default site from now on - of course that is a choice and you may delete the default if you don't want to use it. It is just a recommendation for easy upgrade in the future.

                  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


                  • #10
                    Thanks! However, I don't see that version number anywhere. It's showing up as 2.6000. Is that correct.

                    We're also having issues with discount codes not working. Is there any way you can help us with that? Particularly this page.

                    Thank you in advance!

                    Comment


                    • #11
                      Good day!

                      To see the correct version number please go to Salesforce Setup. The existing version of C&P Settings does not show 2.6000.22 as we treat the field as a number but patches show up as a second decimal point which makes it not a number. This has been resolved in the update due out soon.

                      As for the discount code- please create a new post so we can review the issue. It is best for new issues to be set up as a new thread.
                      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
                        Good day @JoeMoran,

                        We have upgraded you to the latest release of all applications. Please make sure to review the release notes for the Event & PaaS.

                        Release notes:If upgrading an instance with live events be aware that the registrant & attendee email feature has changed and should be set up immediately. If not set up no email will be sent to the registrant or attendees.
                        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


                        • #13
                          Good day!

                          Today we had 2 updates for the Event & PasS applications and wanted to update your instance as part of your request for upgrade to the latest release of 9.x and 3.x. Unfortunately we no longer have access to your account.

                          If you wish to have your instance upgraded please grant us login access and let us know so we can upgrade 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

                          Working...
                          X