Technical Advice and Knowledge on Issues with Microsoft Dynamics CRM

It’s not uncommon to encounter errors when trying to upgrade from one version of Microsoft Dynamics CRM to another.

We recently encountered an issue when trying to import Microsoft Dynamics CRM online organization version 7.1.2.1025 to a local Microsoft Dynamics CRM 2016 deployment.

The error that comes up in DmSnappin log is:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> Microsoft.Crm.CrmException: SqlException: Invalid object name ‘SubscriptionSyncEntryOutlookBase’.

The cause of this error is a missing ‘SubscriptionSyncEntryOutlookBase’ table from the database.

The resolution is as follows:

Before importing the CRM 2015 database, run the following script against the mscrm database to import (not mscrm_config):

CREATE TABLE [dbo].[SubscriptionSyncEntryOutlookBase]([ObjectTypeCode] [int] NOT NULL,
[ObjectId] [uniqueidentifier] NOT NULL,
[SubscriptionId] [uniqueidentifier] NOT NULL,
[VersionNumber] [bigint] NOT NULL,
[SyncState] [tinyint] NOT NULL,
CONSTRAINT [PK_SubscriptionSyncEntryOutlookBase] PRIMARY KEY CLUSTERED
(
[SubscriptionId] ASC,
[ObjectId] ASC,
[ObjectTypeCode] ASC
)
)

If you need professional assistance with this issue or any other issues encountered with MS Dynamics CRM, please contact us!