Forums > Users Lounge > Everything Else
Restoring Database error:
Last Post 02/27/2008 8:12 AM by Joseph Craig. 3 Replies.
Author Messages
anandprak
Nuke Newbie
Nuke Newbie
Posts:5


--
02/26/2008 8:12 AM

    In my pc(m/c 1), local DNN(4.7) website which is working perfectly.I just locally hosted my website in another machine(2nd m/c) in which DNN(4.7) is already installed in it(viz.Copy all my dnn file folders except app data in 2nd m/c and taking the back up of db in 1st  m/c and restoring it in db of 2nd m/c  and modyfying web.config in 2nd m/c to access local db.when i run default.aspx, i get following error.But before restoring my db files in 1st m/c to my znd m/c,default.aspx was running perfectly in my 2nd m/c.Anyone who knows solution or sugestion, pls reply.


    Server Error in '/DNN' Application.

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

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    Stack Trace: 

     
    [InvalidOperationException: The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.]
       System.Data.SqlClient.SqlCommand.DeriveParameters() +878696
       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.GetPortalAliasByPortalID(Int32 PortalID) +87
       DotNetNuke.Entities.Portals.PortalAliasController.GetPortalAliasByPortalID(Int32 PortalID) +35
       DotNetNuke.Entities.Portals.PortalSettings.GetPortalAliasLookup() +74
       DotNetNuke.Entities.Portals.PortalSettings.GetPortalAliasInfo(String PortalAlias) +14
       DotNetNuke.HttpModules.UrlRewriteModule.RewriteUrl(HttpApplication app) +3527
       DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +826
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

     

    Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
    Joseph Craig
    DNN MVP
    Posts:11667


    --
    02/26/2008 8:37 AM
    Why did you not copy app_code?
    Did you change portalalias in the moved database?

    Joe Craig, Patapsco Research Group
    Complete DNN Support
    anandprak
    Nuke Newbie
    Nuke Newbie
    Posts:5


    --
    02/26/2008 11:53 PM
    I have copied the app_code as well.

    No.I have not changed the portal alias in moved database.Can u please explain how to change portal alias in
    moved database.
    Joseph Craig
    DNN MVP
    Posts:11667


    --
    02/27/2008 8:12 AM
    My recommendation is that you reveiw

    To edit portalalias, you'll need SQL Server Management Studio Express (or the complete version).  Open your database, then open the portalalias table.  You can then edit it manually.

    Joe Craig, Patapsco Research Group
    Complete DNN Support

    Forums > Users Lounge > Everything Else

    ---