New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

Home

Getting Started

Installing DNN ...

Violation of UNIQUE KEY constraint 'IX_Version'

10/27/2009 10:01 AM

Larry Daniele

Joined: 5/3/2007

Posts: 58

Re: Violation of UNIQUE KEY constraint 'IX_Version'

I got the same error when upgrading from DotNetNuke 4.9.4 to 5.1.4. I then went to view the main page of my site and saw most of the page correctly with one "Exception" module. After visiting a few more pages, the site started acting "normally". This doesn't give me the "warm fuzzy feeling" of seeing the "upgrade successful" message, but I'll hold my breath and see if the site behaves.

10/27/2009 6:53 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Violation of UNIQUE KEY constraint 'IX_Version'

please note, that version upgrades in DNN 5 are different than between DNN 4 versions.

please post full error message for proper analyse

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

1/11/2010 3:52 PM

Melih Eroglu

Joined: 3/13/2006

Posts: 41

Re: Violation of UNIQUE KEY constraint 'IX_Version'

Here is the error message...

Current Assembly Version: 05.02.00

Current Database Version: 05.01.01

Upgrade Status Report

00:00:00.031 - Upgrading to Version: 05.02.00
00:00:00.062 - Executing Script: 05.01.02.SqlDataProvider Success
00:00:01.093 - Executing Script: 05.01.03.SqlDataProvider Success

Server Error in '/' Application.

Violation of UNIQUE KEY constraint 'IX_Version'. Cannot insert duplicate key in object 'dbo.Version'.
The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_Version'. Cannot insert duplicate key in object 'dbo.Version'.
The statement has been terminated.

Source Error:

The source code that generated this unhandled exception can only be  shown when compiled in debug mode. To enable this, please follow one of the  below steps, then request the URL:

            

            1. Add a "Debug=true" directive at the  top of the file that generated the error. Example:

            

              <%@ Page  Language="C#" Debug="true" %>

            

            or:

            

            2) Add the following section  to the configuration file of your  application:

            

            <configuration>

               <system.web>

                   <compilation  debug="true"/>

               </system.web>

            </configuration>

            

            Note  that this second technique will cause all files within a given application to be  compiled in debug mode. The first technique will cause only that particular file  to be compiled in debug mode.

            

            Important: Running applications in debug  mode does incur a memory/performance overhead. You should make sure that an  application has debugging disabled before deploying into production  scenario.

Stack Trace:

[SqlException (0x80131904): Violation of UNIQUE KEY constraint 'IX_Version'. Cannot insert duplicate key in object 'dbo.Version'.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +168
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +188
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) +246
   DotNetNuke.Data.SqlDataProvider.UpdateDatabaseVersion(Int32 Major, Int32 Minor, Int32 Build, String Name) +218
   DotNetNuke.Common.Globals.UpdateDataBaseVersion(Version version) +69
   DotNetNuke.Services.Upgrade.Upgrade.UpgradeVersion(String strScriptFile, Boolean writeFeedback) +122
   DotNetNuke.Services.Upgrade.Upgrade.UpgradeDNN(String strProviderPath, Version dataBaseVersion) +338
   DotNetNuke.Services.Install.Install.UpgradeApplication() +931
   DotNetNuke.Services.Install.Install.Page_Load(Object sender, EventArgs e) +272
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Melih Eroglu
DotNetNuke Türkiye | Domain Registration

4/24/2010 11:33 AM

dejan sunderic

www.tssug.com
Joined: 4/4/2006

Posts: 4

Re: Violation of UNIQUE KEY constraint 'IX_Version'

I have the same probelm when trying to install 5.3.1

7/23/2011 12:26 PM

John Cornelison

Joined: 7/15/2005

Posts: 429

Re: Violation of UNIQUE KEY constraint 'IX_Version'

Same thing upgrading from 5.6.2 to 6.0.0. I also started the upgrade, skipped to a different tab in the browser, then when I came back it was blank, so rehit the site and got this error. I'll restore from backup and run setup once (& report back if that doesn't fix things).

- John
Upgrading DotNetNuke
Current Assembly Version: 06.00.00
Current Database Version: 05.06.02

Upgrade Status Report
00:00:00.046 - Upgrading to Version: 06.00.00
00:00:00.203 - Executing Script: 05.06.03.SqlDataProvider Success
00:00:00.406 - Executing Script: 06.00.00.SqlDataProvider Error! (see 06.00.00.log.resources for more information)

--------------------------------------------------------------------------------

Server Error in '/' Application.
--------------------------------------------------------------------------------

Violation of UNIQUE KEY constraint 'IX_Version'. Cannot insert duplicate key in object 'dbo.Version'.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_Version'. Cannot insert duplicate key in object 'dbo.Version'.
The statement has been terminated.

- John
www.VashonSoftware.com

Page 2 of 3

Home

Getting Started

Installing DNN ...

Violation of UNIQUE KEY constraint 'IX_Version'

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Current Assembly Version: 05.02.00

Current Database Version: 05.01.01

Upgrade Status Report

Server Error in '/' Application.

Violation of UNIQUE KEY constraint 'IX_Version'. Cannot insert duplicate key in object 'dbo.Version'.
The statement has been terminated.

DNN Corp. (DotNetNuke)

New Community Website

Current Assembly Version: 05.02.00

Current Database Version: 05.01.01

Upgrade Status Report

Server Error in '/' Application.

Violation of UNIQUE KEY constraint 'IX_Version'. Cannot insert duplicate key in object 'dbo.Version'. The statement has been terminated.

DNN Corp. (DotNetNuke)

Violation of UNIQUE KEY constraint 'IX_Version'. Cannot insert duplicate key in object 'dbo.Version'.
The statement has been terminated.