Microsoft KB Archive/941567

= Error message when you run a PWDB DTS task in Solution for Hosted Messaging and Collaboration 3.5: &quot;Violation of UNIQUE KEY constraint&quot; =

Article ID: 941567

Article Last Modified on 1/4/2008

-

APPLIES TO


 * Microsoft Solution for Hosted Messaging and Collaboration 3.5

-



SYMPTOMS
In a Microsoft Solution for Hosted Messaging and Collaboration 3.5 environment, you run the Data Transformation Service (DTS) package that is named PWDB Import Customer Data DTS. However, a PWDB DTS task that is run manually or that is scheduled to be run automatically may not run successfully. Additionally, you may receive the following error message:

Violation of UNIQUE KEY constraint 'uq_CustomerPlans_PlanId_CustomerId'. Cannot insert duplicate key in object 'CustomerPlans'.



RESOLUTION
To resolve this problem, install the software update that is described in Microsoft Knowledge Base article 942229. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

942229 Error message when you run PWDB Import Customer Data DTS in a Hosted Messaging and Collaboration 3.5 environment: &quot;Step Error Description: The task reported failure on execution&quot;



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



Instructions to apply the software update
If the PWDB database and the HeCustomerDB database are not on the same server, follow steps 1 through 2 to add a linked server before you apply the software update. Otherwise, follow steps 3 through 7.   Run the following stored procedure to change the database property to allow for updates to the system database. sp_configure 'allow updates',1 GO RECONFIGURE WITH OVERRIDE GO   Add this stored procedure to add a linked server that is named &quot;HeCustomerDB.&quot; exec sp_addlinkedserver '[ServerName]','ss','SQLOLEDB','[DataSourceServer]',null,null,null  Uninstall the original PwdbSetup file. Install the software update that is described in Microsoft Knowledge Base article 942229. Run the PwDbDeployment.bat file to create the spRemoveDupCustomerPlans procedure. This file is located in the following folder:



 Create a new DTS package (PWDB Import Customer Data).</li> Schedule the DTS task.</li></ol>

Additional query words: PWDB Import DTS Task Violation UNIQUE KEY CustomerPlans

Keywords: kbqfe kbhotfixserver kbfix KB941567

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.