SharePoint Server 的 Access Services 知識庫文章Access Services in SharePoint Server knowledge articles

了解如何解決 Systems Center Operations Manager (SCOM) 的 SharePoint Server 2016 和 SharePoint Server 2013 管理組件中 Access Services 的相關警示。Learn how to resolve alerts about Access Services in the SharePoint Server 2016 and SharePoint Server 2013 management pack for Systems Center Operations Manager (SCOM).

本節中的文章為 SharePoint Server 中 Access Services 的相關知識庫文章。通常在 Operations Manager 主控台中按一下警示內的連結後,就會顯示這些文章。這些文章可用於協助您針對 SharePoint Server 中的 Access Services 進行疑難排解並解決問題。請下載並安裝適用於 SharePoint Server 2016 的 System Center 監視組件適用於 SharePoint Server 2013的 System Center 監視組件,或適用於 SharePoint Foundation 的 System Center 監視組件The articles in this section are knowledge articles for Access Services in SharePoint Server. Typically, you would see these articles after clicking a link in an alert in the Operations Manager console. You can use these articles to help you troubleshoot and resolve problems in Access Services in SharePoint Server. Download and install System Center Monitoring Pack for SharePoint Server 2016, System Center Monitoring Pack for SharePoint Server 2013, or System Center Monitoring Pack for SharePoint Foundation.

內容資料庫中沒有應用程式資訊No application info from content database

警示名稱:Access Services: 內容資料庫中沒有應用程式資訊Alert Name: Access Services: No application info from content database

摘要:Access Data Services 嘗試從 SharePoint 內容資料庫擷取應用程式資訊,但是找不到相關的應用程式資訊。如果發生此情況,將無法使用應用程式。Summary: Access Data Services tries to retrieve application information from the SharePoint Content Database, but cannot find the relevant app's information. If this occurs, the application will not be available for use.

原因Cause

某人所建立的網站使用實際上不是 Access 應用程式的 Access 範本。Someone creates a site that uses an Access template that is not actually an Access application.

解決方案Resolution

刪除錯誤建立的網站。Delete the site that is created incorrectly.

WFE 與 ADS 的通訊失敗WFE to ADS communication failure

警示名稱:Access Services: WFE 與 ADS 的通訊失敗Alert Name: Access Services: WFE to ADS communication failure

摘要:Access Data Services WFE (Web 前端) 無法與 ADS (Access Data Services) 中間層通訊。Summary: Access Data Services WFE (Web Front End) is unable to communicate with the ADS (Access Data Services) middle tier.

原因Cause

可能原因包括下列一或多項:One or more of the following might be the cause:

  • 網路問題Network issues

  • 硬體失敗Hardware failure

  • SharePoint 服務失敗SharePoint service failure

  • 伺服器上的 Access 資料庫服務已停用Disabled Access Database Services on the server

解決方案Resolution

  1. 確定網路狀況良好。Ensure that network is healthy.

  2. 確定 ADS 伺服器可用。Ensure that ADS server is available.

  3. 確定可從 WFE 存取 ADS 伺服器。Ensure that ADS server can be accessed from WFE.

  4. 確定 ADS 應用程式集區的 IIS 處理序正在執行。Ensure IIS Process for ADS application pool is running.

  5. 確定失敗的 ADS 伺服器上已啟用 ADS 服務。Ensure that the ADS service is enabled on the failing ADS server.

沒有可建立資料庫的伺服器No servers available for database creation

警示名稱:Access Services: 沒有可建立資料庫的伺服器Alert Name: Access Services: No servers available for database creation

摘要:建立應用程式時,Access Data Services 找不到可佈建新資料庫的 SQL Server。Summary: During application creation, Access Data services cannot find an available SQL Server to provision the new database.

原因Cause

未針對 Access 設定 SQL 資料庫伺服器以佈建新資料庫。No SQL database servers are configured for Access to provision new databases.

解決方案Resolution

  • 如果從 Access 用戶端建立失敗,請檢查資料庫伺服器群組對應,以判斷發生短缺的位置:If the creation failure occurs while creating from the Access client, check the Database Server group mappings to determine where the shortage has occurred:

    • 使用 Get-SPAccessServicesDatabaseServerGroupMapping 判斷物件模型是否對應至伺服器群組。Use Get-SPAccessServicesDatabaseServerGroupMapping to determine whether there is a mapping from the Object Model to the Server Group.

    • 使用 Get-SPAccessServicesDatabaseServerGroup 判斷伺服器群組是否至少有一個資料庫。Use Get-SPAccessServicesDatabaseServerGroup to determine whether the server group has at least one database.

    • 使用 Get-SPAccessServicesDatabaseServer 判斷伺服器群組中是否至少有一個資料庫標示為 "AvailableForCreate"。Use Get-SPAccessServicesDatabaseServer to determine whether there is at least one database in the server group marked as "AvailableForCreate".

  • 如果從公司目錄建立失敗,請檢查資料庫伺服器群組對應,以判斷發生短缺的位置:If the creation failure occurs while creating from the Corporate Catalog, check the Database Server group mappings to determine where the shortage has occurred:

    • 使用 Get-SPAccessServicesDatabaseServerGroupMapping 判斷公司目錄是否對應至伺服器群組。Use Get-SPAccessServicesDatabaseServerGroupMapping to determine whether there is a mapping from the Corporate Catalog to the Server Group.

    • 使用 Get-SPAccessServicesDatabaseServerGroup 判斷伺服器群組是否至少有一個資料庫。Use Get-SPAccessServicesDatabaseServerGroup to determine whether the server group has at least one database.

    • 使用 Get-SPAccessServicesDatabaseServer 判斷伺服器群組中是否至少有一個資料庫標示為 "AvailableForCreate"。Use Get-SPAccessServicesDatabaseServer to determine whether there is at least one database in the server group marked as "AvailableForCreate".

Get-SPAccessServicesDatabaseServerGroupMappingGet-SPAccessServicesDatabaseServerGroupMapping

Get-SPAccessServicesDatabaseServerGroupGet-SPAccessServicesDatabaseServerGroup

Get-SPAccessServicesDatabaseServerGet-SPAccessServicesDatabaseServer

已分割的 SSS 通訊失敗Partitioned SSS communication failure

警示名稱:Access Services: 已分割的 SSS 通訊失敗Alert Name: Access Services: Partitioned SSS communication failure

摘要:Access Data Services 嘗試與 SharePoint 已分割的 Secure Store Service 通訊,但是無法與其通訊。Summary: Access Data Services tries to communicate with SharePoint partitioned Secure Store Service, but is unable to communicate with it.

原因Cause

伺服器陣列中已分割的 Secure Store Service 由於網路問題或不正確的設定而停止服務或無法連線。Partitioned Secure Store Service in the farm is down or unreachable because of Network issues or incorrect configurations.

解決方案Resolution

  1. 確定已分割的 Secure Store Service 應用程式存在且執行中。Ensure partitioned Secure Store Service Application exists and is running.

  2. 確定已分割 Secure Store Service 的 Proxy 存在且在預設 Proxy 群組中。Ensure Proxy for partitioned Secure Store Service exists and is in the default Proxy group.

在 SharePoint Server 中設定 Secure Store ServiceConfigure the Secure Store Service in SharePoint Server

未分割的 SSS 通訊失敗Unpartitioned SSS communication failure

警示名稱:Access Services: 未分割的 SSS 通訊失敗Alert Name: Access Services: Unpartitioned SSS communication failure

摘要:Access Data Services 嘗試與 SharePoint 未分割的 Secure Store Service 通訊,但是無法與其通訊。Summary: Access Data Services tries to communicate with SharePoint unpartitioned Secure Store Service, but is unable to communicate with it.

原因Cause

伺服器陣列中未分割的 Secure Store Service 由於網路問題或不正確的設定而停止服務或無法連線。Unpartitioned Secure Store Service in the farm is down or unreachable because of Network issues or incorrect configurations.

解決方案Resolution

  1. 確定未分割的 Secure Store Service 應用程式存在且執行中。Ensure unpartitioned Secure Store Service Application exists and is running.

  2. 確定未分割 Secure Store Service 的 Proxy 存在且在預設 Proxy 群組中。Ensure Proxy for unpartitioned Secure Store Service exists and is in the default Proxy group.

在 SharePoint Server 中設定 Secure Store ServiceConfigure the Secure Store Service in SharePoint Server

觸發過多失敗的 SQL 連線要求Trigger for excessive failed SQL connections requests

警告名稱:Access Services: 觸發過多失敗的 SQL 連線要求Alert Name: Access Services: Trigger for excessive failed SQL connections requests

摘要:當 Access Data Services 連線至 SQL Server 資料庫時,若超過預期的重試次數,則會發生此警示。Summary: This alert occurs when Access Data services exceed the expected number of retries when the services connect to the SQL Server Databases.

原因Cause

SQL Server 資料庫伺服器關閉、無法使用或無法連線。SQL Server database server is down, unavailable, or unreachable.

解決方案Resolution

  • 檢查網路狀況。Check network health.

  • 確定 SQL Server 資料庫伺服器可用且狀況良好。Make sure that the SQL Server database server is available and healthy.

過多失敗的 SQL 連線Excessive failed SQL connections

警告名稱:Access Services: 過多失敗的 SQL 連線Alert Name: Access Services: Excessive failed SQL connections

摘要:這會追蹤失敗的 SQL 連線數目。Summary: This tracks the number of failed SQL connections.

原因Cause

N/A

解決方案Resolution

N/A

觸發過多的 SQL 連線重試Trigger for excessive SQL connection retries

警告名稱:Access Services: 觸發過多的 SQL 連線重試Alert Name: Access Services: Trigger for excessive SQL connection retries

摘要:當 Access Data Services 連線至應用程式 SQL 資料庫時,若超過預期的重試次數,則會發生此警示。Summary: This alert occurs when Access Data services exceed the expected number of retries when the services connect to the Application SQL Databases.

原因Cause

可能原因包括下列一或多項:One or more of the following might be the cause:

  • 網路問題Network issues

  • 應用程式 SQL 資料庫無法使用或無法連線。Application SQL databases are unavailable or unreachable.

解決方案Resolution

  1. 檢查網路狀況。Check network health.

  2. 檢查應用程式 SQL 資料庫可用性及狀況良好狀態。Check Application SQL databases availability and healthy states.

過多的 SQL 連線重試Excessive SQL connection retries

警告名稱:Access Services: 過多的 SQL 連線重試Alert Name: Access Services: Excessive SQL connection retries

摘要:這會監視 SQL 資料庫伺服器連線重試次數。Summary: This monitors the number of SQL Database Server Connection retries.

原因Cause

N/A

解決方案Resolution

N/A

觸發過多的 SQL 寫入失敗Trigger for excessive SQL write failures

警告名稱:Access Services: 觸發過多的 SQL 寫入失敗Alert Name: Access Services: Trigger for excessive SQL write failures

摘要:若有太多 SQL 寫入失敗,則會發生此警示。Summary: This alert occurs if there are too many SQL Write failures.

原因Cause

過多的 SQL 寫入失敗數目。Excessive number of SQL Write failures.

解決方案Resolution

  1. 檢查網路狀況。Check network health.

  2. 檢查 SQL Azure 服務的狀態。Check status of SQL Azure service.

  3. 提出 SQL Azure 事件以取得解決方案。Raise an incident with SQL Azure for resolution.

過多的 SQL 寫入失敗Excessive SQL write failures

警告名稱:Access Services: 過多的 SQL 寫入失敗Alert Name: Access Services: Excessive SQL write failures

摘要:監視失敗的 SQL 資料庫伺服器寫入數目。Summary: Monitors the number of failed SQL Database Server writes

原因Cause

可能原因包括下列一或多項:One or more of the following might be the cause:

  • 應用程式 SQL 資料庫無法使用或無法連線。Application SQL Databases are unavailable or unreachable.

  • 伺服器上發生死結。Deadlock occurs on the server.

  • 伺服器超載導致資料庫伺服器沒有回應。Excessive server load makes the database server unresponsive.

解決方案Resolution

確定資料庫伺服器可用、未超載且沒有死結。Ensure that the Database server is available, is not overloaded, and has no deadlocks.

沒有可用的 ADS 伺服器No available ADS servers

警示名稱:Access Services: 沒有可用的 ADS 伺服器Alert Name: Access Services: No available ADS servers

摘要:沒有 Access Data Services 伺服器,或可用的 Access Data Services 伺服器狀況不足以服務要求。Summary: There are no Access Data Services Servers or the available Access Data Services Servers are not healthy enough to serve the request.

原因Cause

可能原因包括下列一或多項:One or more of the following might be the cause:

  • 記憶體耗用量過多導致 ADS 伺服器超載。Excessive memory consumption overloads your ADS Servers.

  • 網路問題Network problems

  • 多個 Access 資料庫伺服器執行個體失敗或關閉。A number of Access Database Server instances fail or are down.

解決方案Resolution

  1. 確定至少在伺服器陣列中的一部伺服器上啟用 Access 資料庫服務。Ensure that Access Database Services is enabled on at least one server in the farm.

  2. 重新啟動 Access 資料庫服務執行個體以釋放記憶體。Reboot Access Database Service instances to free memory.

  3. 確定 Access 資料庫服務執行個體可用且正確設定。Ensure Access Database Service instances are available and are configured correctly.

沒有預設 ProxyNo default proxy

警示名稱:Access Services: 沒有預設 ProxyAlert Name: Access Services: No default proxy

摘要:預設 Proxy 群組中沒有 Access Data Services Proxy。Summary: There is no Access Data Services Proxy in the Default Proxy group.

原因Cause

設定時未建立預設 Proxy,或佈建時發生問題而未建立預設 Proxy。No default proxy is established during configuration, or there is a problem during provisions and a default proxy is not established.

解決方案Resolution

使用 new-SPAccessServicesApplicationProxy 建立新的預設 Proxy。Use new-SPAccessServicesApplicationProxy to create a new default proxy.

New-SPAccessServicesApplicationNew-SPAccessServicesApplication

無法註冊資料庫伺服器Failed to register database server

警示名稱:Access Services: 無法註冊資料庫伺服器Alert Name: Access Services: Failed to register database server

摘要:設定資料庫伺服器時,無法註冊伺服器。Summary: During Database server configuration, a server fails to register.

原因Cause

可能原因包括下列一或多項:One or more of the following might be the cause:

  • 連線至伺服器時發生網路問題Network issues connecting to the server

  • 資料庫伺服器版本不正確Incorrect Database server version

  • 伺服器不具備必要功能或權限不足Server does not have required features or insufficient permissions

解決方案Resolution

  1. 檢查網路狀況。Check network health.

  2. 更新資料庫伺服器版本。Update the database server version.

  3. 安裝必要功能或更新權限。Install required features or update permissions.

注意

[!附註] 應用程式集區使用者必須具有 DBCreator 和 SecurityAdmin 權限。App pool user must have DBCreator and SecurityAdmin permissions.

另請參閱See also

概念Concepts

監視 SharePoint Server 中的計劃Plan for monitoring in SharePoint Server

其他資源Other Resources

適用於 SharePoint Foundation 的 System Center 監視組件System Center Monitoring Pack for SharePoint Foundation

適用於 SharePoint Server 2013 的 System Center 監視組件System Center Monitoring Pack for SharePoint Server 2013

適用於 SharePoint Server 2016 的 System Center 監視組件System Center Monitoring Pack for SharePoint Server 2016