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
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade from 4.9.5 to 5.5.0 gives error 05.00.00.SqlDataProvider Error!Upgrade from 4.9.5 to 5.5.0 gives error 05.00.00.SqlDataProvider Error!
Previous
 
Next
New Post
8/9/2010 2:12 PM
 
Thomas

Joined: 10/29/2007
Posts: 201
I tried upgrading 4.9.5 to 5.0.0 and it worked with no errors. I was able to login as host and everything seemed fine (except for Dashboard, which I am hoping was a bug in 5.0.0).

With that success, I then upgraded that to 5.2.1 and got an error: Executing Script: 05.02.01.SqlDataProvider Error! (see 05.02.01.log for more information).

The log said:

System.Data.SqlClient.SqlException: Invalid object name 'Lists'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.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)

/* Set DataType List to be a SystemList */
/****************************************/

UPDATE Lists SET SystemList = 'True' WHERE ListName = 'DataType'

 


I was able to login as host, and everything seemed to work, even lists, except for the Dashboard again:
(DotNetNuke.Services.Exceptions.ModuleLoadException: The file '/DotNetNuke/Admin/Dashboard/Dashboard.ascx' does not exist.).

So now I am thinking I will try upgrading 5.0.0 to 5.2.0, and then upgrading that to 5.2.1 to see if I can avoid the error. But it seems to work, so far. I am hoping to get all the way to 5.5.0 and get it to work. First I will try to avoid the errors, though.

I couldn't find anything on this forum about the 'Lists' object name problem above, so if you have any insights, please let me know.

Here is the log:


Upgrading DotNetNuke

Current Assembly Version: 05.02.01

Current Database Version: 05.00.00



Upgrade Status Report

00:00:00.048 - Upgrading to Version: 05.02.01
00:00:00.386 - Executing Script: 05.00.01.SqlDataProvider Success
00:00:12.922 - Executing Script: 05.01.00.SqlDataProvider Success
00:00:29.270 - Executing Script: 05.01.01.SqlDataProvider Success
00:00:35.647 - Executing Script: 05.01.02.SqlDataProvider Success
00:00:35.750 - Executing Script: 05.01.03.SqlDataProvider Success
00:00:36.366 - Executing Script: 05.01.04.SqlDataProvider Success
00:00:36.670 - Executing Script: 05.02.00.SqlDataProvider Success
00:00:40.595 - Executing Script: 05.02.01.SqlDataProvider Error! (see 05.02.01.log for more information)
00:00:41.822 - Executing Application Upgrades: 05.00.01 Success
00:00:42.102 - Executing Application Upgrades: 05.01.00 Success
00:00:54.778 - Executing Application Upgrades: 05.01.01 Success
00:00:54.897 - Executing Application Upgrades: 05.01.02 Success
00:00:54.898 - Executing Application Upgrades: 05.01.03 Success
00:00:55.429 - Executing Application Upgrades: 05.01.04 Success
00:00:55.429 - Executing Application Upgrades: 05.02.00 Success
00:00:55.819 - Executing Application Upgrades: 05.02.01 Error!
00:00:55.901 - Cleaning Up Files: 05.00.01 Success
00:00:55.996 - Cleaning Up Files: 05.01.00 Success
00:00:56.826 - Cleaning Up Files: 05.01.01 Success
00:00:56.827 - Cleaning Up Files: 05.01.02 Success
00:00:56.827 - Cleaning Up Files: 05.01.03 Success
00:00:56.827 - Cleaning Up Files: 05.01.04 Success
00:00:56.827 - Cleaning Up Files: 05.02.00 Success
00:00:56.827 - Cleaning Up Files: 05.02.01 Success
00:00:56.828 - Updating Config Files: 05.00.01 Success
00:00:56.830 - Updating Config Files: 05.01.00 Success
00:00:56.924 - Updating Config Files: 05.01.01 Success
00:00:56.924 - Updating Config Files: 05.01.02 Success
00:00:56.924 - Updating Config Files: 05.01.03 Success
00:00:56.924 - Updating Config Files: 05.01.04 Success
00:00:56.924 - Updating Config Files: 05.02.00 Success
00:00:56.992 - Updating Config Files: 05.02.01 Success
00:00:57.105 - Performing General Upgrades
00:00:57.372 - Installing Optional Modules:
00:00:57.375 - Installing Package File HTML_Community_05.02.00_Install: Success
00:01:03.453 - Installing Optional Skins:
00:01:03.454 - Installing Optional Containers:
00:01:03.454 - Installing Optional Languages:
00:01:03.455 - Installing Optional Providers:
00:01:03.456 - Installing Package File AspNetMembershipProvider_05.02.00_Install: Success
00:01:03.768 - Installing Package File CorePermissionProvider_05.01.01_Install: Success
00:01:05.011 - Installing Package File DatabaseLoggingProvider_05.01.01_Install: Success
00:01:05.165 - Installing Package File DNNMembershipProvider_05.01.03_Install: Success
00:01:05.324 - Installing Package File DNNMenuNavigationProvider_05.01.00_Install: Success
00:01:05.484 - Installing Package File DNNTreeNavigationProvider_05.01.00_Install: Success
00:01:06.029 - Installing Package File FckHtmlEditorProvider_02.00.04_Install: Success
00:02:14.468 - Installing Package File FileBasedCachingProvider_05.01.03_Install: Success
00:02:14.877 - Installing Package File FileModuleCachingProvider_05.02.01_Install: Success
00:02:15.139 - Installing Package File MemoryModuleCachingProvider_05.02.01_Install: Success
00:02:15.815 - Installing Package File SchedulingProvider_05.02.01_Install: Success
00:02:16.034 - Installing Package File SearchIndexProvider_05.01.00_Install: Success
00:02:16.311 - Installing Package File SearchProvider_05.01.01_Install: Success
00:02:17.017 - Installing Package File SolpartMenuNavigationProvider_05.01.00_Install: Success
00:02:17.565 - Installing Optional AuthSystems:
00:02:17.565 - Installing Package File LiveID_01.00.01_Install: Success
00:02:17.829 - Installing Package File OpenID_02.00.00_Install: Success
00:02:18.028 - Installing Optional Packages:

Upgrade Complete



Click Here To Access Your Portal
 
New Post
8/9/2010 4:23 PM
 
Matthias Schlomann


Joined: 8/10/2003
Posts: 3594
There could be a issue on a earlier upgrade.  I want try to discript you what could happens.

If on a earlier Upgrade the execution was rin as i.e:

Create Table {databaseOwner}[Lists]  this would create the Table as i.e. dbo.Lists but you are using an objectQualifier like "test"  you could have a issue on later upgrade when the table would alter i.e:

Alter Table {databaseOwner}[{objectQualifier}Lists

This want try to alter the table dbo.test_Lists  but it could not be find.

Other issue can be on missing databaseOwner statements if you using a other schema as "dbo" as your databaseOwner.  As exsample:  the databaseOwner is "username"  you have set on your web.config file and the obejectQualifier is "test".

Create Table {objectQualifier}Lists want create the table dbo.test_Lists

So this could make issue on running the instance about if a module want read from the Lists table it searches to the table username.test_Lists but could not find it and you get a time out and the SQL server can caused a 100% of CPU usage about searching the database.

then of you run a upgrade with a correct Alter of the list table with this script

Alter Table {databaseOwner}[{objectQualifier}Lists] want alter the Table username.test_Lists which could not find on the database. 

{databaseOwner} and {objectQualifier} are placeholders that value are set on the web.config file.

Tables with missing one of those placeholders have to be deleted on a later upgrade and must recreate with the correct settings. The content of the wrong table had to moved to a tempTable before deleting the old Table and had to be moved to the new created table.  On the end the tempTable must be deleted.

Spocs, Views and Functions with missing thos placeholders could be altered if it is not missing on the naming of it.  Otherwise the have to be deleted and also be recreated with the correct script.

Attention!
The databaseOwner and objectQialifier value on the web.config File could not changed after a completet installation, due to the SQL Server security.  If you want to do this, you have to manuelly altered the complete artifacts (tables,spocs,views, functions) of the database, which is a high time stamp work!

To check your database you could manuelly check it by getting the databaseOwner and objectQualifier values and check all tables naming, the programmed functions, spocs and views on the database. 

Notice:
The aspnet tables do not use the databaseOwner and objectQualifier placeholders about the are running as system service. So they are always created under the use of the "dbo" !

As a new install DNN 5.4.4 and 5.5.0(Beta) the executed scripts running without any issues using a objectQualifier and special databaseOwner.

I hope this could help you to solve your issue.


Regards
Matthias
DNN MVP
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
New Post
10/27/2010 11:03 PM
 
Trisata

Joined: 1/14/2006
Posts: 27
I have the same problem, have been trying upgrade dnn4.9.5 since 5.1.x untill now 5.5.1 with the same error.

System.Data.SqlClient.SqlException: 'PK_EventLogMaster' is not a constraint.
Could not drop constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.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 I upgrade from 4.9.5--> 5.0.1, I got the error message like above, clicking in "Access to your portal " will get "an error occur"  just like Thomas described.
Not sure how can I fix that, have to stay with 4.9.5 for long time now.




/* Fix OobjectQualifier for PK_EventLogMaster */
/**********************************************/
 
 Page 2 of 2
Previous12 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade from 4.9.5 to 5.5.0 gives error 05.00.00.SqlDataProvider Error!Upgrade from 4.9.5 to 5.5.0 gives error 05.00.00.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