因为出错代码比较长，就放在后面了。

出现"The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist."报错的情况很多

只要是安装过程中出现异常终止，然后我们又试图访问没有安装好的网站（因为是装了一半终止的，所以DNN不会再触发安装的过程）；
或者其它的设置导致DNN不能正常运行就有可能出现这个报错。

所以我们不要尝试去还原dbo.GetPortalAliasByPortalID，而应该去排查那个地方引起这个报错。比如：连接字符串是不是设置正确， Startkit的安装是不是选择了"Auto"模式，SQL 是不是正常启动，等等。

Server Error in '/DotNetNuke4.8.2' 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() +2973
              

              

            System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +72
              

              

            Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +213
              

              

            Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +304
              

              

            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) +3346
              

              

            DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +1193
              

              

            System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +138
              

              

            System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +65

DNN安装报错-The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.如何解决

更多文章、技术交流、商务合作、联系博主

微信扫码或搜索：z360901061

微信扫一扫加我为好友

QQ号联系： 360901061

您的支持是博主写作最大的动力，如果您喜欢我的文章，感觉我的文章对您有帮助，请用微信扫描下面二维码支持博主2元、5元、10元、20元等您想捐的金额吧，狠狠点击下面给点支持吧，站长非常感激您！手机微信长按不能支付解决办法：请将微信支付二维码保存到相册，切换到微信，然后点击微信右上角扫一扫功能，选择支付二维码完成支付。

【本文对您有帮助就好】元

2元

5元

10元

20元

自定义