Products

Solutions

Resources

Partners

Community

Blog

About

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 ...Not found store procedure Not found store procedure 'dbo.dnn_GetPortals'
Previous
 
Next
New Post
8/10/2006 10:18 AM
 
I'm using SQL Server 2000 + IIS in Windows XP Professional.

It's my problem (help please):

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: No se encontró el procedimiento almacenado 'dbo.dnn_GetPortals'.

Source Error:

Line 143: Dim objFolderController As New Services.FileSystem.FolderController
Line 144: Dim objPortalController As New PortalController
Line 145: Dim arrPortals As ArrayList = objPortalController.GetPortals()
Line 146: Dim i As Integer
Line 147: For i = 0 To arrPortals.Count - 1


Source File: D:\DotNetNuke\App_Code\Global.asax.vb Line: 145

Stack Trace:

[SqlException (0x80131904): No se encontró el procedimiento almacenado 'dbo.dnn_GetPortals'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857434
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735046
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
System.Data.SqlClient.SqlDataReader.get_MetaData() +62
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +62
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) +499
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +201
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText) +40
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +262
DotNetNuke.Data.SqlDataProvider.GetPortals() +47
DotNetNuke.Entities.Portals.PortalController.GetPortals() +19
DotNetNuke.Common.Global.CacheMappedDirectory() in D:\DotNetNuke\App_Code\Global.asax.vb:145
DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs E) in D:\DotNetNuke\App_Code\Global.asax.vb:255


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

 
New Post
8/10/2006 1:59 PM
 
DotNetNuke Installation Guide.pdf, page 50 (page 56 through Acrobat) has a section called "Cound not find stored procedure 'dbo.GetPortals'.  It starts, "This error can be caused by an incorrect {objectqualifier}. ... more info .. and, one solutio is ... delete the dnn.config file form the /Install folder.  So, check the installation guide and see if that helps.
 
New Post
8/15/2006 5:42 PM
 

I Got the same problem upgrading from V403 to 434. The dnn_GetPortals is not in the database. I delete dnn.config as suggested but nothing right .. 

On the same server but other portal I got : DotNetNuke Upgrade Error

The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )    ERROR: Could not connect to database

Any  other suggestions ?

Thank you for your help

LM

 

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Not found store procedure Not found store procedure 'dbo.dnn_GetPortals'


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