I'm getting a similar error...
I'm Admin on a Win2000 Server in my cube. It has SQL 2000 installed and I'm dbOwner, full rights, and everything is up and running.
I've tried installing 17 Times and I always get this error. There are quite a few stored procedures that are not being placed in the stored procedure folder under my DotNetNuke database. No matter how I clean everything up and reinstall this same error shows up.
Server Error in '/DotNetNuke_2' Application.
Could not find stored procedure 'dbo.GetPortals'.
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: Could not find stored procedure 'dbo.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_2\Website\App_Code\Global.asax.vb Line: 145
Stack Trace:
[SqlException (0x80131904): Could not find stored procedure 'dbo.GetPortals'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857322
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734934
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_2\Website\App_Code\Global.asax.vb:145
DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs E) in D:\DotNetNuke_2\Website\App_Code\Global.asax.vb:255
|
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42