Skip to main content
New Idea

Partial failure email when connector fails a certain amount of records

Related products:None
DannyPancratz
bjoern_schulze
Marina Perminova
triskaideka
+3
  • DannyPancratz
    DannyPancratz
  • bjoern_schulze
    bjoern_schulze
  • Marina Perminova
    Marina Perminova
  • Emil
  • triskaideka
    triskaideka
  • Anitahg
  • nate2
    nate2
  • JKelley
    JKelley

cankney
  • Contributor ⭐️⭐️⭐️
  • 19 replies

I recently discovered that our salesforce connector company job has been partially failing each time it runs. Unlike rules, even though I have it set up to send me failure emails, I haven’t received emails for partial failures. This job is especially important because it keeps our information synced and accurate in the two systems.

It would be nice to be able to receive a partial failure email from connectors, but I was also thinking about how because there are usually lots of records in a connector job, it would be especially nice if I had the ability to only be notified when the failures meet a certain threshold (this could be useful for rules engine as well).

For example, our most recent sync had 3357 successes and 12461 failures. Obviously I want to be alerted to that!! But if I had 15800 success and only 18 failures that isn’t cause for alarm. If I could set some sort of threshold for alerting it would be really cool - like alert me if over 60% of records fail or something like that.

5 replies

jean.nairon
Forum|alt.badge.img+4
  • Expert ⭐️
  • 421 replies
  • July 22, 2020

@cankney - I fully agree, there needs to be more information in emails. I haven’t noticed connector notifications not working for me. 

This may not help you, but I have found using the Rules Engine instead of Connector jobs to be much more useful. You can build the exact connector job into a rule and get the notifications as expected. I also find the Rules Engine error results to be often more helpful.

The only draw back I find is you can run Connector jobs every hour and Rules only every 2 hours using a cron expression. So if you prefer data that’s refreshed hourly, I would stick with the connector. 


darkknight
Forum|alt.badge.img+4
  • Expert ⭐️
  • 1980 replies
  • July 24, 2020

PARTIAL_SUCCESS is a misnomer.  If records failed to be inserted/updated, that is a PARTIAL_FAILURE and we should receive an email/notification about it.  

 

 


jean.nairon
Forum|alt.badge.img+4
  • Expert ⭐️
  • 421 replies
  • July 24, 2020

I agree. I’m generally a glass half full kind of person but when it comes to data, it either all worked or didn’t work. If it is fully successful, its Success. If some of the records failed, it failed partially. 


kunal_bhat
  • Helper ⭐️⭐️⭐️
  • 111 replies
  • July 31, 2020

This does make sense! We’ve accepted this as an enhancement request and should have an update soon.


Ritesh Sharma
  • Contributor ⭐️⭐️⭐️⭐️
  • 25 replies
  • March 31, 2022

This has been implemented and now Admins can set email notifications for partial success, failure, success with 0 records as well

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings