Issue
A successful Riva connection to Microsoft Dynamics CRM 2011 experienced a connection error after applying Roll Up 10 or higher to the CRM system. This article includes:
- Before implementing Dynamics CRM Roll Up 10.
- After implementing Dynamics CRM Roll Up 10.
- Explanation.
- New Riva XRM-based connection for Dynamics CRM.
- Difference between the two CRM connections.
- Switching to the Riva XRM-based Dynamics CRM connection.
Before implementing Dynamics CRM Roll-Up 10
Examination of crmex-log files reveals that standard CRM connections worked as expected.
2013-08-28 17:55:25,110 INFO [CTP-eqf #1887] [21ERJKI5GNB4] [xd9da39c952a5401f, x6036ca329a7e65e9] Discovered! DOMAIN\riva_connection_user (riva_connection_user@example.com) via https://crm.example.com/MSCRMServices/2007/SPLA/CrmDiscoveryService.asmx with Org: ExampleOrgName (21cf307e-a6ca-e111-bbd6-0050568e7f47) to https://crm.example.com/MSCrmServices/2007/CrmService.asmx
2013-08-28 17:55:27,625 INFO [CTP-eqf #1887] [21ERJKI5GNB4] [xd9da39c952a5401f, x6036ca329a7e65e9] DOMAIN\riva_connection_user
After Implementing Dynamics CRM Roll-Up 10
Examination of the crmex-log files reveals the following CRM connection error:
2013-08-29 06:00:01,165 INFO [CTP-zpj #123] [1U141126TZB4] Establishing connection to Microsoft Dynamics CRM [IMPERSONATION]...
2013-08-29 06:00:01,322 ERROR [CTP-zpj #123] [1U141126TZB4] [CL: xd9da39c952a5401f; M:x6036ca329a7e65e9] Attempted connection to: DOMAIN\riva_connection_user (DOMAIN\riva_connection_user) @ https://crm.example.com/MSCRMServices/2007/SPLA/CrmDiscoveryService.asmx
2013-08-29 06:00:01,322 INFO [CTP-zpj #123] [1U141126TZB4] Connection to CRM Server failed: The request failed with HTTP status 404: Not Found.
Explanation
The Riva server used a connection to Dynamics CRM that consumed standard web service "endpoints". We refer to that client as the "Legacy" client, which supports Dynamics CRM 4 and 2011.
Dynamics 2011 also included support for XRM web service endpoints, which have been supported since the RTM release. The Riva "Legacy" connection to Dynamics CRM does not support XRM web service endpoints.
With the conversion of CRM Dynamics Online to Office 365, Microsoft removed support for standard web service endpoints and switched to using XRM web service endpoints. After Office 365 and Dynamics Online customers with Riva servers were transitioned to those new instances, their Riva "Legacy" connection failed.
New Riva XRM-based Connection for Dynamics CRM
Riva 2.4.35 includes a new XRM-based Riva connection to Dynamics CRM. In some circumstances, you can choose which Riva connection to use:
- For Dynamics CRM 2011 Roll Up 10 or higher, use only the Riva XRM-based client.
- For Dynamics CRM 2011 RTM to Roll Up 8, you can use the Riva "Legacy" client or the Riva XRM-based client.
- For Dynamics CRM 4, use only the Riva "Legacy" client.
Differences between the two Riva CRM Connections
There is one major difference between the "Legacy" and XRM-based CRM connections.
- The "Legacy" CRM connection supports the Outlook Plug-in by offering a "compatibility" mode that enables using Riva and the Plug-in concurrently. This mode supports such CRM-Outlook features as "follow me".
- The XRM-based CRM connection does not support plug-in "compatibility" mode. If you need to switch Riva from the "Legacy" connection to the XRM-based connection, CRM users need to disable the Dynamics plug-in to prevent Riva from creating duplicate records of items that are synced between Exchange and the CRM. For more information, contact the Riva Success Team.
If you are considering applying the Dynamics Roll-up 10 or higher, be aware of the requirement to switch to using the Riva XRM-based CRM connection and the lack of plug-in "compatibility" mode.
Switching to the Riva XRM-based Dynamics CRM connection
If the Riva server was originally configured with a "Legacy" CRM connection and an Office 365 Dynamics Online refresh (upgrade) or applying Dynamics CRM 2011 Roll Up 10 or higher has resulted in CRM connection errors, use the following procedure to upgrade to the XRM-based CRM connection.
To replace a "Legacy" connection with a "XRM-based" connection:
-
In the Riva Manager application, disable the CRM sync policies.
-
In the Riva CRM Service Monitor application, stop the service.
-
Make a complete backup of the \Riva\Transactions folder structure.
-
Critical requirement: Disable/Discontinue the use of the Dynamics Outlook plug-in by users that will be synced by Riva.
-
On the Windows system hosting Riva, install the required .NET Framework version.
-
Create an XRM-based Riva connection to Dynamics CRM. You can use the same user credentials that are configured in the "Legacy" CRM connection.
-
Configure each sync policy to reset the CRM connection to use the new XRM-based connection. Edit the Riva sync policies: on the General page, select the Select >> link for the CRM connection, and select the new XRM-based connection (created in step 6). Save the sync policy, but DO NOT start the sync service.
-
Highly recommended: Run a "Dry Run Mode" sync for the sync policy with the least number of target users.
This will confirm if there are potential data sync issues.
-
If a "Dry Run Mode" sync shows errors for a large number of items deleted or created, stop the sync service, disable all sync policies, and contact the Riva Success Team.
-
After successfully completing your data sync testing you are prepared to enable data sync for production Riva sync policies, disable "Dry Run Mode" in the sync policy tested (in step 8), and enable the remaining sync policies.
Note: After a Riva sync policy is modified to use the new XRM-based connection and it is enabled, Riva should start to sync users from the point that the last successful Riva sync was completed with the Legacy CRM connection.