Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error Message since Content Store Restore

Status
Not open for further replies.

navshiv

MIS
Feb 15, 2002
91
US
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?
 
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

 
Hi

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

I take it that is a good thing?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top