因為出錯代碼比較長，就放在后面了。

出現"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元

自定義