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

1
2
3
4
5

Home

Getting Started

Installing DNN ...

Problems with Upgrading DB to version 4.02

1/24/2006 3:56 PM

Mike Blurton

Joined: 7/14/2005

Posts: 1

Problems with Upgrading DB to version 4.02 Modified By Mike Blurton on 1/30/2006 11:04:58 AM

I'm trying to upgrade an exsisting portal from 3.11 to 4.02, I am currently trying to get the database to upgrade but get the following error, Any help would be appriciated.

Server Error in '/DotNetNuke_2' Application.

The stored procedure 'dbo.GetTabByName' doesn't exist.

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.InvalidOperationException: The stored procedure 'dbo.GetTabByName' doesn't exist.

Source Error:

Line 386:        End Function
Line 387:        Public Overrides Function GetTabByName(ByVal TabName As String, ByVal PortalId As Integer) As IDataReader
Line 388:            Return CType(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner & ObjectQualifier & "GetTabByName", TabName, GetNull(PortalId)), IDataReader)
Line 389:        End Function
Line 390:        Public Overrides Function GetTabsByParentId(ByVal ParentId As Integer) As IDataReader

Source File: C:\Development\DotNetNuke4x\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb Line: 388

Stack Trace:

[InvalidOperationException: The stored procedure 'dbo.GetTabByName' doesn't exist.]
   System.Data.SqlClient.SqlCommand.DeriveParameters() +878680
   System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +88
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +212
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +303
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +154
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +36
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +200
   DotNetNuke.Data.SqlDataProvider.GetTabByName(String TabName, Int32 PortalId) in C:\Development\DotNetNuke4x\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:388
   DotNetNuke.Entities.Tabs.TabController.GetTabByName(String TabName, Int32 PortalId, Int32 ParentId) in C:\Development\DotNetNuke4x\Library\Components\Tabs\TabController.vb:496
   DotNetNuke.Entities.Tabs.TabController.GetTabByName(String TabName, Int32 PortalId) in C:\Development\DotNetNuke4x\Library\Components\Tabs\TabController.vb:491
   DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication() in C:\Development\DotNetNuke4x\Library\Components\Upgrade\Upgrade.vb:1363
   DotNetNuke.Services.Upgrade.Upgrade.UpgradeDNN(String strProviderPath, String strDatabaseVersion) in C:\Development\DotNetNuke4x\Library\Components\Upgrade\Upgrade.vb:2365
   DotNetNuke.Framework.Install.UpgradeApplication() in C:\Development\DotNetNuke4x\Website\Install\Install.aspx.vb:199
   DotNetNuke.Framework.Install.Page_Load(Object sender, EventArgs e) in C:\Development\DotNetNuke4x\Website\Install\Install.aspx.vb:373
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

5/31/2006 10:56 AM

Cornelius Mostert

Joined: 12/31/2004

Posts: 7

Re: Problems with Upgrading DB to version 4.02

Hallo

I had this error Yesterday and found this posting in 2 forums so here it goes... I did not test this as yet but think it will work

____________________
I had this error and the solution was to change the collating sequence of my SQL Server 2005 DotNetNuke database to a case-INsensitive one. It appears that using a case-sensitive (CS) collating sequence causes the installer to fail to create all of the stored procedures.

I don't see this in the install notes anywhere (perhaps it should be). I learned this from somewhere else so I pass on my good fortune, HTH.

Jim
______________________

Page 1 of 1

Home

Getting Started

Installing DNN ...

Problems with Upgrading DB to version 4.02

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

Server Error in '/DotNetNuke_2' Application.

The stored procedure 'dbo.GetTabByName' doesn't exist.

DNN Corp. (DotNetNuke)