CMS Database Fails to Upgrade

Montecristo

Before opening a support ticket, I was wondering if anyone else had run into this problem. The 4.9.2.70 update attempts to upgrade the CMS database, but fails. The main visible symptom is slow startup time with "Upgrading CMS..." appearing on every startup. The studio log states:

2016-56-28 20:56:09.864 WARNING: /src/sdksource/cloud/dzcloudtasknotifier.cpp(178): Unexpected exception in upgradeDb: ERROR:  duplicate key value violates unique constraint "category_content_content_id_category_id_key"
DETAIL:  Key (content_id, category_id)=(188671, 460) already exists.

If I could translate the IDs into text, I may be able to manually correct the problem, but I'm unsure where the ID to text mapping is kept.

Thanks 

mjc1016

See this thread, particularly Daz_Rawb's replies...

http://www.daz3d.com/forums/discussion/89536/4-9-2-updating-cms-takes-too-long-to-load#latest

Montecristo

Thanks, I was afraid that might be the answer. I do have custom categories and content, so that's likely the issue.