When you are running a scheduled Scribe solution for a Microsoft™ Dynamics CRM to Acoustic Campaign Integration the maps named Microsoft CRM to Acoustic Campaign - Contact Sync, MicrosoftCRM to Acoustic Campaign - Lead Sync or, Microsoft CRM to Acoustic Campaign - Leads\Contacts Sync handles the adding and updating synchronized records to Acoustic Campaign from CRM.
If the record was the last one successfully processed, and the next scheduled run keeps encountering the same 'insert' operation for the record based on the last 'modified on' date in CRM, then the following error will occur until Scribe gets a new record to process.
Scribe is just saying 'I've already processed this record, I don't have another active record to process that matches, or more recently modified, the LAST_MODIFIED_ON date requested in the Query block of the specified map, so I'm letting you know again this record has already been added'
|Map Name||MS CRM to Acoustic Campaign - Lead Sync|
|Error Title||Error in calling Operation Update/Insert|
|Error Description||Operation failed. Label: Update/Insert Lead, Name: CRMDatabase_LeadUpdateInsert, Message: Failure: failure_type='permanent' crm_sync_id='########-####-####-####-############' Message: 'Error Updating Recipient; Sync ID Already Exists in List - Error Adding Recipient: ############'|
'MSCRM to Acoustic Campaign Contact Delete' and 'MSCRM to Acoustic Campaign Lead Delete' handles the removal of synchronized records in Acoustic Campaign that have been deactivated in CRM.
The CRM GUIDs and Acoustic Campaign RecipientIDs of deactivated records are placed in a table in CRM name 'sp_deletedobjectpointer'. The deactivation and deletion maps in Scribe check this table by the deleted on date of the record. If the record is deleted in both environments but the Scribe mapping process date has not changed an error continuously occurs in Scribe for the last set of records that were actually processed.
The error is explaining that the Acoustic Campaign recipient with the matching CRM GUID has already been deactivated in Acoustic Campaign . This could have been by a previous Scribe sync or someone manually deleting the record in Acoustic Campaign .
Scribe is just saying 'I've already processed this record, I don't have another active record to process that matches, or more recently modified, the LAST_MODIFIED_ON date requested in the Query block of the specified map, so I'm letting you know again this record has already been deleted'
|Map Name||MSCRM to Acoustic Campaign Contact Delete|
|Error Title||Error in calling Operation Delete|
|Error Description||Failure: failure_type='permanent' crm_sync_id='81529A51-241B-E311-BE9D-00155D006E53' Message: 'Recipient Already Deleted in Acoustic Campaign '|
Resolving the problem
To resolve the issue, change the 'Most recent record processed' date in Scribe for the source of affected map.
Change the date to match the 'Last run time' of the solution.
For Advanced Maps, Open\Edit the Query Block and go to the General Tab to see the 'Most Recent record processed' field.