We are facing a strange problem with Synchronized Data from our Sales Cloud org.
Long story short, we are observing data inconsistency between Sales Cloud and the Synchronized Data Extensions. Sometimes, data is not updated on the synchronized data extensions even if it is on Sales Cloud. Even the LastModifiedDate is not the same between the two orgs (we've taken in consideration the timezones..).
We are aware of the fact that updating a
Formula field does not update the
LastModifiedDate of the record, and so it isn't picked up by the connector to supply the synchronized data extension. But we are facing the same problem with updates on other fields types as well..
We have been advised by the support to do manual refresh on all Data Sources ONCE A WEEK!! That doesn't make sense. I've even looked for some way to automate this in vain.
So, is anybody out there facing this problem? What are your recommendations/solutions?
PS: The poll schedule is 30 minutes. We've also tested 1 hour poll schedule and still have the problem.