Syncronisation issue for crm 4.0

Beetween rollup 7 and 8 of the crm client plugin for outlook. Some CRM user may experience some SQL error when trying to track a contact from outlook to CRM. THis also happen when a user try to force the sync beetween outlook client and the CRM database. The reason for it is that there is a missing SQL table in the SQL database of the organisation. Here is a server sided script that will allow you to resolve this problem.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SubscriptionManuallyTrackedObject](
[Track] [bit] NOT NULL,
[SubscriptionId] [uniqueidentifier] NOT NULL,
[ObjectId] [uniqueidentifier] NOT NULL,
[ObjectTypeCode] [int] NULL,
[SubscriptionManuallyTrackedObjectId] [uniqueidentifier] NOT NULL,
CONSTRAINT [ndx_PrimaryKey_SubscriptionManuallyTrackedObject] PRIMARY KEY NONCLUSTERED
(
[SubscriptionManuallyTrackedObjectId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SubscriptionManuallyTrackedObject] WITH NOCHECK ADD CONSTRAINT [subscription_subscriptionmanuallytrackedobject] FOREIGN KEY([SubscriptionId])
REFERENCES [dbo].[Subscription] ([SubscriptionId])
NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[SubscriptionManuallyTrackedObject] CHECK CONSTRAINT [subscription_subscriptionmanuallytrackedobject]
GO
ALTER TABLE [dbo].[SubscriptionManuallyTrackedObject] ADD CONSTRAINT [DF_SubscriptionManuallyTrackedObject_Track] DEFAULT ((0)) FOR [Track]
GO
ALTER TABLE [dbo].[SubscriptionManuallyTrackedObject] ADD CONSTRAINT [DF_SubscriptionManuallyTrackedObject_SubscriptionManuallyTrackedObjectId] DEFAULT (newid()) FOR [SubscriptionManuallyTrackedObjectId]
GO


Once applied , simply restart your SQL process on the server , for ce a new syncronisation and the error is gone.

Yan Desjardins | CRM specialist.