Products

Solutions

Learn More

Partners

Community

Blog

About

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

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...05.04.00.SqlDataProvider error when upgrading from 05.03.0105.04.00.SqlDataProvider error when upgrading from 05.03.01
Previous
 
Next
New Post
4/22/2010 6:34 AM
 

Hi

I got one error in the upgrade process:

00:00:00.359 - Executing Script: 05.04.00.SqlDataProvider Error! (See 05.04.00.log for more information)

 

 

Her is the 05.04.00 log

System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
Violation of PRIMARY KEY constraint 'PK_TabModuleSettings'. Cannot insert duplicate key in object 'dbo.TabModuleSettings'.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

/************************************************************/
/*****              SqlDataProvider                     *****/
/*****                                                  *****/
/*****                                                  *****/
/***** Note: To manually execute this script you must   *****/
/*****       perform a search and replace operation     *****/
/*****       for dbo. and   *****/
/*****                                                  *****/
/************************************************************/

/* Initialize HideAdminBorder setting for modules under the Admin and Host tabs */
/*************************************************/

DECLARE @TabModuleID int
DECLARE CursorQuery CURSOR FOR

SELECT TabModuleID
FROM dbo.TabModules
WHERE (TabID IN(SELECT TabID
FROM dbo.Tabs
WHERE (TabID IN(SELECT AdminTabId FROM dbo.vw_Portals)) OR
(ParentId IN(SELECT AdminTabId FROM dbo.vw_Portals AS vw_Portals_1)) OR (PortalID IS NULL)))

OPEN CursorQuery
---Perform fetch
FETCH NEXT FROM CursorQuery
INTO @TabModuleID
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
        WHILE @@FETCH_STATUS = 0
        BEGIN
            -- now insert the id from the main table into the related table.
            -- hard code values for now for some options.
            -- This is executed as long as the previous fetch succeeds.
        INSERT INTO dbo.TabModuleSettings (
   TabModuleId,
        SettingName,
   SettingValue,
   CreatedByUserID,
   CreatedOnDate,
   LastModifiedByUserId,
   LastModifiedOnDate
   ) VALUES (
   @TabModuleID,
   'hideadminborder',
   'True',
   -1,
   GetDate(),
   -1,
   GetDate())

 FETCH NEXT FROM CursorQuery
 INTO @TabModuleID

END

CLOSE CursorQuery
DEALLOCATE CursorQuery

/* Add RegisterTabId to PortalLocalization Table */
/*************************************************/

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME='PortalLocalization' AND COLUMN_NAME='RegisterTabId')
 BEGIN
  -- Add new RegisterTabId Column
  ALTER TABLE dbo.PortalLocalization
   ADD RegisterTabId int NULL
 END

 


System.Data.SqlClient.SqlException: There is already an object named 'FK_ContentItems_Tags_ContentItems' in the database.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

/* Add Missing Foreign Keys For ContentItems_Tags */
/**************************************************/

ALTER TABLE dbo.[ContentItems_Tags]  WITH CHECK
 ADD  CONSTRAINT [FK_ContentItems_Tags_ContentItems] FOREIGN KEY([ContentItemID]) REFERENCES dbo.[ContentItems] ([ContentItemID]) ON UPDATE CASCADE ON DELETE CASCADE
 
ALTER TABLE dbo.[ContentItems_Tags]  WITH CHECK
 ADD  CONSTRAINT [FK_ContentItems_Tags_Taxonomy_Terms] FOREIGN KEY([TermID]) REFERENCES dbo.[Taxonomy_Terms] ([TermID]) ON UPDATE CASCADE ON DELETE CASCADE


System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_PortalLocalization_Portals". The conflict occurred in database "DotNetNuke", table "dbo.Portals", column 'PortalID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

 

IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'FK_PortalLocalization_Portals') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1)
 BEGIN
  /* add key and cascade delete rule */
  ALTER TABLE dbo.PortalLocalization
   ADD CONSTRAINT FK_PortalLocalization_Portals
    FOREIGN KEY ( PortalID ) REFERENCES dbo.Portals ( PortalID ) ON DELETE  CASCADE
 END 

 
New Post
4/22/2010 9:38 AM
 

Restore your database and dotnetnuke directory.  See this threads: http://www.dotnetnuke.com/Community/F...

 
New Post
4/22/2010 11:12 AM
 
Is there a solutuion to just wait for 05.04.01 ?? I realy dont want to start restoring!
 
New Post
4/23/2010 9:57 AM
 

Hi Christian,

If you repeated the upgrade once this error has sense, because the upgrade DNN 5.4.0 left oncoming installation of zip files in modules directory "install/modules" and the only way to fix this is to reinstall.

 
New Post
4/23/2010 11:25 AM
 
Ok! I got this error IN first upgrade try (5.4.0), the error was there on the second too! Sow I have to reinstall what?
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...05.04.00.SqlDataProvider error when upgrading from 05.03.0105.04.00.SqlDataProvider error when upgrading from 05.03.01


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:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. 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.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out