Remove From My Forums

CRM 4 to 2011 upgrade issue

Question
0

Sign in to vote
Hi All,

I am trying to upgrade CRM 4.0 to 2011. But i get 2 errors

Violation of PRIMARY KEY constraint 'PK__#ActualC__59D4927546SFA08'. Cannot insert duplicate key in object 'dbo.#ActualColumns'.

Violation of PRIMARY KEY constraint 'PK__#4542R4C__73365VR4TT2BDR'. Cannot insert duplicate key in object 'dbo.@ActualUserTables'.

Thanks

Suresh
- Moved by Andrii ButenkoMVP, Moderator Tuesday, March 27, 2012 9:38 PM (From:CRM Development)
Tuesday, March 27, 2012 6:16 PM

Answers

1

Sign in to vote
Maybe re-run it with sql profiler on to see what query it blew up on. That might help us figure out the problem.
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!
- Marked as answer by Jamie MileyModerator Saturday, February 7, 2015 5:21 PM
Thursday, March 29, 2012 2:00 PM

Moderator
0

Sign in to vote
only other thing I can think of is making sure you are on the newest UR in 4.0 going to 2011 and make sure you use UR 14 if you are going from 2011 to 2013
- Marked as answer by Jamie MileyModerator Saturday, February 7, 2015 5:21 PM
Saturday, February 7, 2015 5:21 PM

Moderator

All replies

0

Sign in to vote

This is a weird one. Have you tried it at least twice and verified it keeps happening. Also verify that this org hasn't been already imported into this CRM 2011 instance.

Hmmm.. Lastly I would like to verify that there weren't any manual changes made to the database you are trying to upgrade beyond what is supported by the SDK and normal customization mechanisms for CRM.
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!

Wednesday, March 28, 2012 2:19 PM

Moderator
0

Sign in to vote

Hi Jamie

I have tried 4 times and get same errors. I have not changed any think in database level. Just tried in a fresh CRM 2011.

Thanks

Suresh

Thursday, March 29, 2012 1:07 PM
1

Sign in to vote
Maybe re-run it with sql profiler on to see what query it blew up on. That might help us figure out the problem.
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!
- Marked as answer by Jamie MileyModerator Saturday, February 7, 2015 5:21 PM
Thursday, March 29, 2012 2:00 PM

Moderator
0

Sign in to vote

update installation files before installing and give a try ..
Ahmed - CRM Application Management

Wednesday, April 4, 2012 5:17 PM
0

Sign in to vote

Did you get this figured out.
Jamie Miley

Check out RBA Today!

Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!

Thursday, March 7, 2013 7:23 PM

Moderator
0

Sign in to vote
I'm getting the same error when I run the 2013 setup while upgrading from crm 2011. So I'm going from 2011 to 2013 and I'm seing the same error except the second error is saying the violation occurred on "PK_#4fcd00_..."

Any Ideas?
- Edited by ehanna Monday, March 31, 2014 7:02 PM
Monday, March 31, 2014 7:00 PM
1

Sign in to vote
It really looks like there have been made unsupported direct changes to the DB - maybe indexes or views

You should check with your DBA and delete unsupported modifications
- Marked as answer by Jamie MileyModerator Saturday, February 7, 2015 5:19 PM
- Unmarked as answer by Jamie MileyModerator Saturday, February 7, 2015 5:19 PM
Tuesday, April 1, 2014 8:39 AM
0

Sign in to vote
only other thing I can think of is making sure you are on the newest UR in 4.0 going to 2011 and make sure you use UR 14 if you are going from 2011 to 2013
- Marked as answer by Jamie MileyModerator Saturday, February 7, 2015 5:21 PM
Saturday, February 7, 2015 5:21 PM

Moderator

Answered by:

CRM 4 to 2011 upgrade issue

Question

Answers

All replies