Error Message since Content Store Restore

[navshiv]

Hi
We have a bunch of scheduled Report Studio reports that run daily. Last week we had to restore the Content Store because somebody (not me!) took the development data sources over to production during a content export/import.

Ever since then these scheduled report have been failing. However it is not always the same reports each day. When I look at the first one I see this error - CM-SYS-5001 A Content Manager internal error occurred.Violation of PRIMARY KEY constraint 'PK_CMOBJPROPS10'. Cannot insert duplicate key in object 'dbo.CMOBJPROPS10'.

Has anyone else come across this error at all?

 

[blom0344]

Check the following output when you run :

SELECT CMID FROM CMOBJPROPS10 WHERE CMID NOT IN (SELECT CMID FROM CMOBJECTS)

on the contentstore database.

This should not yield any records..

Ties Blom

 

[navshiv]

Hi

Thanks for the response. I ran the query and no records were returned.

I take it that is a good thing?