Microsoft Content Management Server - Scripted Content Import causes SQL PK violation error

This is Interesting: Free IT Magazines  
Home > Archive > Microsoft Content Management Server > October 2006 > Scripted Content Import causes SQL PK violation error





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Scripted Content Import causes SQL PK violation error
Stephen Cassels

2006-10-31, 7:19 am

Hi

The content import to our production server failed last night and the event
viewer reported the following warning:

MCMS Site Deployment - Error occured. System.Data.SqlClient.SqlError:
Violation of PRIMARY KEY constraint 'PK__##impBlobData__180EE73F'. Cannot
insert duplicate key in object '##impBlobData'.
System.Data.SqlClient.SqlError: The statement has been terminated.


We are running MSCMS 2002 SP1a on Win 2003.

Also the BGProcessing job failed on step 5 (Purge data for deleted resources).



--


Stephen
Stefan Goßner [MSFT]

2006-10-31, 7:19 am

Hi Stephen,

please install this hotfix: 907802

Cheers,
Stefan


"Stephen Cassels" <StephenCassels@discussions.microsoft.com> wrote in
message news:0EE08D11-D1E8-4735-819E-146EEEF89512@microsoft.com...
> Hi
>
> The content import to our production server failed last night and the
> event
> viewer reported the following warning:
>
> MCMS Site Deployment - Error occured. System.Data.SqlClient.SqlError:
> Violation of PRIMARY KEY constraint 'PK__##impBlobData__180EE73F'. Cannot
> insert duplicate key in object '##impBlobData'.
> System.Data.SqlClient.SqlError: The statement has been terminated.
>
>
> We are running MSCMS 2002 SP1a on Win 2003.
>
> Also the BGProcessing job failed on step 5 (Purge data for deleted
> resources).
>
>
>
> --
>
>
> Stephen


Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com