Why has the profiles not synchronizing between Salesfor and Reltio?

Question

Account and Site profiles are not syncing with Reltio. It had been working before and had stopped working on 3/3/2024.

Upon further investigation, we found that their profiles are in the Reltio Sync table within SFDC but not syncing with Reltio.

The same mapping and identical confirmation work in our lower environment.

Answer 
Run the following query to check if events may be pending or failed.

SELECT Id,
Name,
Object_Type__c,
Object_Id__c,
Operation__c,
Status__c,
Retry_Count__c,
CreatedDate,
LastModifiedDate
FROM Reltio_Sync__c
WHERE Object_Type__c IN ('Account','Contact') 
AND CreatedDate < 2024-03-03T00:00:00Z 
AND Status__c IN ('Pending','Failed') 
ORDER BY CreatedDate ASC
LIMIT 50

To guarantee the sequence of processing events for the same object, an additional query is executed that excludes the IDs of objects that are being processed from the result (Status__c = 'Pending'):

Query: SELECT Id, Object_Id__c FROM Reltio_Sync__c WHERE Object_Id__c IN :sobjectIds AND  Status__c = 'Pending'

Please run the below Apex script in the "Executing Anonymous" code (see https://help.salesforce.com/s/articleView?id=sf.code_dev_console_execute_anonymous.htm) to unblock the processing and remove stuck events.

List<rtsync__Reltio_Sync__c> records = [ 
    SELECT Id, rtsync__Status__c, CreatedDate 
    FROM   rtsync__Reltio_Sync__c 
    WHERE  rtsync__Status__c = 'Pending' 
      AND  CreatedDate < DateTime.newInstance(2024, 3, 03, 0, 0, 0) 
    LIMIT  1000 
]; 
delete records;