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

出现"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.

De ion: Anunhandled exception occurred during the execution of the current webrequest. Please review the stack trace for more information about theerror 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,  [] 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,  [] 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(  s, EventArgs e) +1193
            System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +138
            System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +65

继续阅读与本文标签相同的文章

None
最新文章 最热文章
收藏 打印

特别推荐 2026年05月25日 星期一

精彩发现

热门标签

阻止表单提交 窗口 关闭浏览器 清除 CDATA css文件 光标位置 坐标 javascrpt !important 超链接 数字

相关文章

1
如何在DNN模块中插入一个图片--在模块中引用资源文件
1372人阅读
2
Control cannot be created because Visual Studio cannot find the control's type in the control assembly 问题的解决
406人阅读
3
DNN北京爱好者聚会报名啦！
968人阅读