Errors returning Tracking Data with Marketing Cloud Connector for Microsoft Dynamics CRM 4.0
|Knowledge Article Number||000233203|
Marketing Cloud platform evolution created a need to enhance the capabilities of Send Tracking to support greater volumes of data. To resolve this need, a new format was adopted for Tracking Data identifiers inside the Marketing Cloud data environment. The Marketing Cloud (MC) Connector for Microsoft Dynamics CRM 4.0 integration was built in the past and doesn't adhere to the new format's requirements.
This situation presents behavior within the Dynamics CRM environment such that Tracking Data retrieval for Marketing Cloud Sends is not possible. An error occurs when the legacy code used by the MC Connector for Microsoft Dynamics CRM 4.0 makes API requests to the Marketing Cloud using an unsupported format for Tracking Data identifiers. The error can be observed in the "ExactTarget Logs" with text similar to the following:
ExactTarget.MSCRM4.BusinessLogic.Connector.ExactTargetTrackingException: Send tracking returned an error result: Error: Specified cast is not valid. at ExactTarget.MSCRM4.ConnectorService.v2.Tracking.TrackingRetriever.GetSendAndSendLinkTracking(List`1& sends, List`1& sendLinks) at ExactTarget.MSCRM4.ConnectorService.v2.Tracking.TrackingRetriever.RetrieveExactTargetTrackingData() at ExactTarget.MSCRM4.ConnectorService.v2.Tracking.TrackingRequest.Execute()
Good to know: The Salesforce Marketing Cloud Connector for Microsoft Dynamics CRM 4.0 is currently in maintenance mode and thus subject only to enhancements around security issues for that package. This status is similar to Microsoft's status for the Dynamics CRM 4.0 platform as a whole.
Use one of two paths to resolve the issue