none
Unknown SQL Exception 201 occurred. Additional error information from SQL Server is included below. 过程或函数 'proc_GetSiteProps' 需要参数 '@WebSiteId',但未提供该参数。 RRS feed

  • 常规讨论

  • System.Data.SqlClient.SqlException (0x80131904): 过程或函数 'proc_GetSiteProps' 需要参数 '@WebSiteId',但未提供该参数。     System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()     System.Data.SqlClient.SqlDataReader.get_MetaData()     System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)     System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)     System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)     System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)     System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)     Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)     Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock)     Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock)  ClientConnectionId:9df19f24-44fe-4ea2-ba8a-0d24f7845f56  Error Number:201,State:4,Class:16

    Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock)     Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock)     Microsoft.SharePoint.Library.SPRequestInternalClass.OpenSite(String bstrUrl, Boolean bGetUrlOnly, String& pbstrServerRelativeUrl, Guid& pgSiteId, Int32& pOwnerID, Int32& pSecondaryContactID, DateTime& pdtLastContentChange, DateTime& pdtLastSecurityChange, Int32& plSchemaMajorVersion, Int32& plSchemaMinorVersion, Int32& plSchemaBuildVersion, Int32& plSchemaRevisionVersion, Boolean& pfIsEvalSite, Guid& pgSourceSiteId, DateTime& pdtExpirationDate, Guid& pgEvalSiteId, Int32& plUpgradeFlags, DateTime& pdtReminderDate)     Microsoft.SharePoint.Library.SPRequestInternalClass.OpenSite(String bstrUrl, Boolean bGetUrlOnly, String& pbstrServerRelativeUrl, Guid& pgSiteId, Int32& pOwnerID, Int32& pSecondaryContactID, DateTime& pdtLastContentChange, DateTime& pdtLastSecurityChange, Int32& plSchemaMajorVersion, Int32& plSchemaMinorVersion, Int32& plSchemaBuildVersion, Int32& plSchemaRevisionVersion, Boolean& pfIsEvalSite, Guid& pgSourceSiteId, DateTime& pdtExpirationDate, Guid& pgEvalSiteId, Int32& plUpgradeFlags, DateTime& pdtReminderDate)     Microsoft.SharePoint.Library.SPRequest.OpenSite(String bstrUrl, Boolean bGetUrlOnly, String& pbstrServerRelativeUrl, Guid& pgSiteId, Int32& pOwnerID, Int32& pSecondaryContactID, DateTime& pdtLastContentChange, DateTime& pdtLastSecurityChange, Int32& plSchemaMajorVersion, Int32& plSchemaMinorVersion, Int32& plSchemaBuildVersion, Int32& plSchemaRevisionVersion, Boolean& pfIsEvalSite, Guid& pgSourceSiteId, DateTime& pdtExpirationDate, Guid& pgEvalSiteId, Int32& plUpgradeFlags, DateTime& pdtReminderDate)     Microsoft.SharePoint.SPSite.InitSite()     Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.GetContextCompatibilityLevel(Uri requestUri)     Microsoft.SharePoint.WebControls.DeveloperDashboard.IsOn(HttpContext& reqCtx)     Microsoft.SharePoint.WebControls.DeveloperDashboard.Initialize()     Microsoft.SharePoint.Administration.SPRequestUsageMonitoredScope..ctor(Boolean clearCorrelationId, String name)     Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.BeginRequestHandler(Object oSender, EventArgs ea)     System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)     System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)     System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)     System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)     System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

     

    • 已更改类型 GuYuming 2016年3月29日 5:53
    2016年3月29日 5:52

全部回复

  • 这个发生在一次创建 其他 Web Application 出错后。在Central Administration里看到Web Application创建了,但是估计IIS使用的哪些配置文件没有建立好。我删除了那些创建过程出错的Web Application ,问题就消失了。访问 /_layouts/15/settings.aspx 页面就正常了

    不能重现。

    • 已编辑 GuYuming 2016年3月29日 9:20 不能重现
    2016年3月29日 6:04
  • ISAPI 向其工作进程报告了一个不正常状态。因此,为应用程序池“SharePoint Central Administration v4”提供服务并且进程 ID 为“6872”的工作进程请求了一个回收。

    为应用程序池“SharePoint Central Administration v4”提供服务的进程在关闭过程中超出时间限制。该进程 ID 为“1452”。

    我加大了 Application Pool 的关闭时间限制, shutdowntimelimit ,创建Web Application 就成功了。但我还是不知道为啥

    2016年3月31日 0:59