Errors posting transactions to Salesforce

[joemoran]

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): []"

[CnP.Support]

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.

[joemoran]

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.

[joemoran]

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: []"

[CnP.Support]

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:



Once Self-Healing was done:





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.



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.

[joemoran]

Woohoo! Thank you so much! That saves me a lot of work

[CnP.Support]

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



Do you want us to upgrade your instance? Highly recommended.. did I say highly?!

[joemoran]

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?

[CnP.Support]

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.

[joemoran]

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!

[CnP.Support]

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.

[CnP.Support]

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:

• PaaS 9.1006: http://cnp.mn/1OVLkta
• Event 3.1011: http://cnp.mn/1OVLq46

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.

[CnP.Support]

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.