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 ...Installation Error - Cites a missing stored procInstallation Error - Cites a missing stored proc
Previous
 
Next
New Post
11/13/2006 5:46 PM
 
Hi

I am trying to install DNN 4.3.5 but am having problems with the installation script. Looking at the event log it appears to be a missing stored proceedure! I don't understand how this is possible, as I've checked that the stored proc does indeed exist in the DB.

The web.config file has been changed to use a new, empty DB, i.e.:

key="SiteSqlServer" value="server=69.XXX.XXX.245\sqlexpress;database=dnntest;uid=dnntest;pwd=XXXXX;"

Any help would be appreciated.

All pertinant error messages are listed below. The first is a copy of the installation script output, and the following four are the items listed in the event log.



Installing DotNetNuke

Version: 04.03.05



Installation Status Report

00:00:00.050 - Installing Version: 3.1.0
00:00:00.080 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.310 - Installing Script: DotNetNuke.Schema.SqlDataProvider Success
00:00:31.234 - Installing Script: DotNetNuke.Data.SqlDataProvider Success
00:01:22.348 - Installing MemberRole Provider:
00:01:22.348 - Executing InstallCommon.sql
00:01:25.252 - Executing InstallMembership.sql
00:01:30.630 - Executing InstallProfile.sql
00:01:33.073 - Executing InstallRoles.sql
 Success
00:01:36.418 - Upgrading to Version: 3.1.1 Success
00:01:46.282 - Upgrading to Version: 3.2.0 Success
00:01:46.543 - Upgrading to Version: 3.2.1 Success
00:01:46.913 - Upgrading to Version: 3.2.2 Success
00:01:47.234 - Upgrading to Version: 3.2.3 Success
00:01:54.534 - Upgrading to Version: 3.2.4 Success
00:01:54.664 - Upgrading to Version: 3.2.5 Success
00:01:54.714 - Upgrading to Version: 3.2.6 Success
00:01:54.935 - Upgrading to Version: 3.2.7 Success
00:01:54.975 - Upgrading to Version: 3.3.0 Success
00:01:55.045 - Upgrading to Version: 3.3.1 Success
00:01:55.165 - Upgrading to Version: 3.3.2 Success
00:01:55.576 - Upgrading to Version: 3.3.3 Success
00:01:56.347 - Upgrading to Version: 4.0.0 Success
00:01:57.158 - Upgrading to Version: 4.0.1 Success
00:01:57.589 - Upgrading to Version: 4.0.2 Success
00:01:57.719 - Upgrading to Version: 4.0.3 Success
00:01:57.859 - Upgrading to Version: 4.0.4 Success
00:02:02.666 - Upgrading to Version: 4.0.5 Success
00:02:02.696 - Upgrading to Version: 4.0.6 Success
00:02:02.766 - Upgrading to Version: 4.0.7 Success
00:02:02.806 - Upgrading to Version: 4.3.0 Success
00:02:03.016 - Upgrading to Version: 4.3.1 Success
00:02:03.046 - Upgrading to Version: 4.3.2 Success
00:02:03.437 - Upgrading to Version: 4.3.3 Success
00:02:04.238 - Upgrading to Version: 4.3.4 Success
00:02:04.328 - Upgrading to Version: 4.3.5 Success
00:02:05.620 - Performing General Upgrades
00:02:08.194 - Loading Host Settings:
00:02:09.315 - Configuring SuperUser:
00:02:10.748 - Installing Modules:
00:02:10.788 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Announcements_03.03.04_Install.zip:  Success
00:02:13.552 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Blog_3.02.00_Install.zip:  Success
00:02:22.134 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Contacts_3.1_Install.zip:  Success
00:02:23.035 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Documents_03.01.05_Install.zip:  Success
00:02:25.098 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Events_3.2_Install.zip:  Success
00:02:33.430 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\FAQs_3.1_Install.zip:  Success
00:02:34.832 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Feedback_03.02.01_Install.zip:  Success
00:02:36.024 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Forum_3.20.08_Install.zip:  Success
00:03:16.262 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Gallery_3.0.12_Install.zip:  Success
00:03:30.342 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Help_2.0.4_Install.zip:  Success
00:03:35.590 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\HTML_3.3.0_Install.zip:  Success
00:03:37.282 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\IFrame_3.2_Install.zip:  Success
00:03:38.964 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Links_3.3_Install.zip:  Success
00:03:47.406 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Media_03.02.02_Install.zip:  Success
00:03:51.613 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\NewsFeeds_3.1.1_Install.zip:  Success
00:03:52.694 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Reports_4.3.1_Source.zip:  Success
00:03:56.359 -   Installing Module File d:\HostingSpaces\Code Red1\testing.codered.com.au\wwwroot\dnntest\Install\Module\Repository_3.1.10_Install.zip:

 


Server Error in '/dnntest' Application.

Runtime Error

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="Off"/>
    </system.web>
</configuration>

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
    </system.web>
</configuration>






I have included the ouput of all four messages below, for those who wish to know:

1st Error Message:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  14/11/2006
Time:  1:46:09 AM
User:  N/A
Computer: ULTIMA4
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 11/14/2006 1:46:09 AM
Event time (UTC): 11/13/2006 2:46:09 PM
Event ID: 941f98e1f7274e7c9206b66bf0dc1e3b
Event sequence: 6
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/2079243352/ROOT/dnntest-3-128079027480130928
    Trust level: Full
    Application Virtual Path: /dnntest
    Application Path: d:\HostingSpaces\Code Red1\testing.XXXXXX.com.au\wwwroot\dnntest\
    Machine name: ULTIMA4
 
Process information:
    Process ID: 5316
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: SqlException
    Exception message: Could not find stored procedure 'dbo.GetPortals'.
 
Request information:
    Request URL: http://testing.XXXXX.com.au/dnntest/Default.aspx
    Request path: /dnntest/Default.aspx
    User host address: 124.XXX.XXX.XXX
    User: 
    Is authenticated: False
    Authentication Type: 
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 1
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    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.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)
   at DotNetNuke.Data.SqlDataProvider.GetPortals()
   at DotNetNuke.Entities.Portals.PortalController.GetPortals()
   at DotNetNuke.Common.Global.CacheMappedDirectory()
   at DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs E)
 

2nd Error Message:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  14/11/2006
Time:  1:46:12 AM
User:  N/A
Computer: ULTIMA4
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 11/14/2006 1:46:12 AM
Event time (UTC): 11/13/2006 2:46:12 PM
Event ID: e8a642b74af142548f59fa34b6b27276
Event sequence: 2
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/2079243352/ROOT/dnntest-4-128079027721678256
    Trust level: Full
    Application Virtual Path: /dnntest
    Application Path: d:\HostingSpaces\Code Red1\testing.XXXXX.com.au\wwwroot\dnntest\
    Machine name: ULTIMA4
 
Process information:
    Process ID: 5316
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: SqlException
    Exception message: Could not find stored procedure 'dbo.GetPortals'.
 
Request information:
    Request URL: http://testing.XXXXX.com.au/dnntest/Install/Install.aspx?mode=Install
    Request path: /dnntest/Install/Install.aspx
    User host address: 124.XXX.XXX.XXX
    User: 
    Is authenticated: False
    Authentication Type: 
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 6
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    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.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)
   at DotNetNuke.Data.SqlDataProvider.GetPortals()
   at DotNetNuke.Entities.Portals.PortalController.GetPortals()
   at DotNetNuke.Common.Global.CacheMappedDirectory()
   at DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs E)
 

3rd Error Message:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  14/11/2006
Time:  1:52:08 AM
User:  N/A
Computer: ULTIMA4
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 11/14/2006 1:52:07 AM
Event time (UTC): 11/13/2006 2:52:07 PM
Event ID: c238ec9037d44e1b98e016ba4324cb1d
Event sequence: 5
Event occurrence: 2
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/2079243352/ROOT/dnntest-4-128079027721678256
    Trust level: Full
    Application Virtual Path: /dnntest
    Application Path: d:\HostingSpaces\Code Red1\testing.XXXXX.com.au\wwwroot\dnntest\
    Machine name: ULTIMA4
 
Process information:
    Process ID: 5316
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: ThreadAbortException
    Exception message: Thread was being aborted.
 
Request information:
    Request URL: http://testing.XXXXX.com.au/dnntest/Install/Install.aspx?mode=Install
    Request path: /dnntest/Install/Install.aspx
    User host address: 124.XXX.XXX.XXX
    User: 
    Is authenticated: False
    Authentication Type: 
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 6
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   at System.Web.HttpApplication.ResumeSteps(Exception error)
   at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
   at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
 

4th Error Message:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: None
Event ID: 1073
Date:  14/11/2006
Time:  1:52:08 AM
User:  N/A
Computer: ULTIMA4
Description:
Failed to process request.

Exception: System.Threading.ThreadAbortException
Message: Thread was being aborted.
StackTrace:    at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
   at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
   at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

 


 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Installation Error - Cites a missing stored procInstallation Error - Cites a missing stored proc


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