facing issue while upgrading db of Tridion 2013 SP1 database to Web 8 for Content manager.

Tried 2 times but its not happening and getting this error message :- enter image description here

Any clue? I have tried twice from scratch...

Thanks in advance!!


This looks as though the upgrade script is unable to cope with your database. You should contact support. Modifying either your database or the upgrade script without the approval of support will leave you with an unsupported system, so only they can help you with this.

  • Thanks Dominic, I have already contacted to SDL support team, Just trying my luck here if someone has faced the same issue as i have faced... – Naveen Anand Jun 22 '16 at 9:36
  • 1
    Not the fastest, but I would probably setup a new 2013 SP1 database and find the AK_PUBLISH_STATE_01 constraint (which you seem to be missing in your real DB) and then try to re-create it. Could be that it's the only issue in your DB, and maybe at some point in time someone thought it would be a good idea to try this to solve some other problem? – Nuno Linhares Jun 22 '16 at 14:41

Thanks everyone for your answer, and issues was :-

After DB restore from Tridion 2013 SP1 to Web 8, there were some duplicate records, and after removing all the duplicate records, add the constraint.

  • 1
    Naveen, can you mark this post as the answer? :) – Kunal Jun 30 '16 at 7:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.