Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

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...DNN 6.1.3 to 6.1.5 SqlDataProvider ErrorDNN 6.1.3 to 6.1.5 SqlDataProvider Error
Previous
 
Next
New Post
4/7/2012 3:02 PM
 
Pingle


Joined: 8/8/2009
Posts: 937
Hi,

I upgraded two installs today, both from 6.1.3 to 6.1.5, one went through without any errors but one had the following error:

Upgrading DotNetNuke
Current Assembly Version: 06.01.05
Current Database Version: 06.01.03

Upgrade Status Report
00:00:00.265 - Upgrading to Version: 06.01.05
00:00:00.562 -   Executing Script: 06.01.04.SqlDataProvider Success
00:00:01.875 -   Executing Script: 06.01.05.SqlDataProvider Error! (see 06.01.05.log.resources for more information)
00:00:08.015 -   Executing Application Upgrades: 06.01.04 Success
00:00:08.875 -   Executing Application Upgrades: 06.01.05 Success
00:00:08.875 -   Cleaning Up Files: 06.01.04 Success
00:00:08.890 -   Cleaning Up Files: 06.01.05 Success
00:00:08.890 -   Updating Config Files: 06.01.04 Success
00:00:08.906 -   Updating Config Files: 06.01.05 Success
00:00:08.906 - Performing General Upgrades
00:00:09.046 - Installing Optional Modules:
00:00:09.125 -   Installing Package File DDRMenu_02.00.02_Install:  Success
00:00:11.937 -   Installing Package File DNNCE_HTML_06.01.05_Install:  Success
00:00:13.218 -   Installing Package File DNNCE_Messaging_06.01.05_Install:  Success
00:00:13.843 -   Installing Package File DNNCE_MobileManagement_06.01.05_Install:  Success
00:00:14.281 -   Installing Package File DNNCE_Taxonomy_06.01.05_Install:  Success
00:00:14.953 -   Installing Package File Telerik_06.01.03_Install:  Success
00:00:22.406 - Installing Optional Skins:
00:00:22.437 -   Installing Package File DarkKnight_01.00.00_Install:  Success
00:00:30.281 - Installing Optional Containers:
00:00:30.296 - Installing Optional Languages:
00:00:30.328 - Installing Optional Providers:
00:00:30.406 -   Installing Package File AspNetMembershipProvider_06.01.05_Install:  Success
00:00:31.046 -   Installing Package File CorePermissionProvider_06.01.05_Install:  Success
00:00:32.015 -   Installing Package File CoreSitemapProvider_06.01.05_Install:  Success
00:00:32.296 -   Installing Package File DatabaseLoggingProvider_06.01.05_Install:  Success
00:00:32.671 -   Installing Package File DNNMembershipProvider_06.01.05_Install:  Success
00:00:33.250 -   Installing Package File DNNMenuNavigationProvider_06.01.05_Install:  Success
00:00:34.656 -   Installing Package File DNNTreeNavigationProvider_06.01.05_Install:  Success
00:00:34.984 -   Installing Package File FiftyOneClientCapabilityProvider_06.01.05_Install:  Success
00:00:36.156 -   Installing Package File FileBasedCachingProvider_06.01.05_Install:  Success
00:00:36.437 -   Installing Package File FileModuleCachingProvider_06.01.05_Install:  Success
00:00:36.781 -   Installing Package File MemoryModuleCachingProvider_06.01.05_Install:  Success
00:00:37.109 -   Installing Package File RadEditorProvider_06.01.05_Install:  Success
00:00:42.656 -   Installing Package File SchedulingProvider_06.01.05_Install:  Success
00:00:43.031 -   Installing Package File SearchIndexProvider_06.01.05_Install:  Success
00:00:43.875 -   Installing Package File SearchProvider_06.01.05_Install:  Success
00:00:44.546 -   Installing Package File SolpartMenuNavigationProvider_06.01.05_Install:  Success
00: -   Installing Package File TelerikEditorProvider_05.06.03_Install:  Success
00:00:49.078 - Installing Optional AuthSystems:
00:00:49.093 - Installing Optional Packages:
Upgrade Complete

Can someone point me to where I can find the 06.01.05.log.resources?

Many thanks in advance.
 
New Post
4/7/2012 3:08 PM
 
cathal connolly


cathal connolly's Avatar

www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676
you'll find it at \Providers\DataProviders\SqlDataProvider\06.01.05.log.resources
Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
4/7/2012 3:08 PM
 
Ken Grierson


Joined: 7/18/2009
Posts: 613
You might also check the log.resource file found @ <web folder>\Portals\_default\Logs
Ken Grierson
DotNetNuke Corporation
Test Lead
 
New Post
4/7/2012 4:02 PM
 
Pingle


Joined: 8/8/2009
Posts: 937
Many thanks, Cathal and Ken!

The 06.01.15.log.resources seems to be telling me to run the following script:

/************************************************************/
/*****              SqlDataProvider                     *****/
/************************************************************/

/** DNN-13280 - Clustered Primary Key for Portals **/

DECLARE @TableName nvarchar(128), @ConstraintName nvarchar(128), @UpdateRule nvarchar(128), @DeleteRule nvarchar(128)
CREATE TABLE #constraints
(
   TableName nvarchar(128),
   ConstraintName nvarchar(128),
   UpdateRule nvarchar(128),    
   DeleteRule nvarchar(128)   
)
 
INSERT INTO #constraints  
SELECT
K_Table = FK.TABLE_NAME,
Constraint_Name = C.CONSTRAINT_NAME,
C.UPDATE_RULE,
C.DELETE_RULE
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME
INNER JOIN (
SELECT i1.TABLE_NAME, i2.COLUMN_NAME
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2 ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME
WHERE i1.CONSTRAINT_TYPE = 'PRIMARY KEY'
) PT ON PT.TABLE_NAME = PK.TABLE_NAME
---- optional:
WHERE PK.TABLE_NAME IN ('Portals')

DECLARE @SQLString nvarchar(500);
DECLARE remove_constraint_tables_cursor CURSOR FOR
SELECT TableName, ConstraintName, UpdateRule, DeleteRule from #constraints

OPEN remove_constraint_tables_cursor
FETCH NEXT FROM remove_constraint_tables_cursor
INTO @TableName, @ConstraintName, @UpdateRule, @DeleteRule
WHILE @@FETCH_STATUS = 0
BEGIN
 PRINT 'Table Name: ' + @TableName + ' Constraint:' +  @ConstraintName
 SET @SQLString = N'ALTER TABLE ' + @TableName + ' DROP CONSTRAINT ' + @ConstraintName
 EXEC sp_executesql @SQLString

 FETCH NEXT FROM remove_constraint_tables_cursor
 INTO @TableName, @ConstraintName, @UpdateRule, @DeleteRule
END

CLOSE remove_constraint_tables_cursor
DEALLOCATE remove_constraint_tables_cursor

ALTER TABLE dbo.Portals DROP CONSTRAINT PK_Portals
ALTER TABLE dbo.Portals ADD CONSTRAINT
 PK_Portals PRIMARY KEY CLUSTERED
 (
 PortalID
 )


DECLARE add_constraint_tables_cursor CURSOR FOR
SELECT TableName, ConstraintName, UpdateRule, DeleteRule from #constraints

OPEN add_constraint_tables_cursor
FETCH NEXT FROM add_constraint_tables_cursor
INTO @TableName, @ConstraintName, @UpdateRule, @DeleteRule
WHILE @@FETCH_STATUS = 0
BEGIN
 SET @SQLString = N'ALTER TABLE ' + @TableName + ' ADD CONSTRAINT ' + @ConstraintName
 + ' FOREIGN KEY (PortalID) REFERENCES dbo.Portals (PortalID) ON UPDATE ' + @UpdateRule + ' ON DELETE ' + @DeleteRule
 PRINT @SQLString
 EXEC sp_executesql @SQLString
 FETCH NEXT FROM add_constraint_tables_cursor
 INTO @TableName, @ConstraintName, @UpdateRule, @DeleteRule
END

CLOSE add_constraint_tables_cursor
DEALLOCATE add_constraint_tables_cursor


I'm out of my comfort zone with SQL. Do I copy and paste this in to Host > SQL or do I have to run it by logging in to the server using SQL Server Management Studio ... or  none of the above?

Help! Many thanks.
 
New Post
4/9/2012 3:29 PM
 
cathal connolly


cathal connolly's Avatar

www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676
I beleive the problem isnt with the DotNetNuke tables, but rather with the blog module tables - see http://www.dotnetnuke.com/Community/Community-Exchange/Question/660/Upgrade-issue-from-6-01-04-to-6-01-05-SQL.aspx for more details - essentially you will need to manually remove the invalid portalid from the blog table and then re-run the script (or ideally remove it from your backup and do the upgrade again) - you can rerun scripts via host->sql
Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...DNN 6.1.3 to 6.1.5 SqlDataProvider ErrorDNN 6.1.3 to 6.1.5 SqlDataProvider Error


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