在 Service Manager 中向 System Center 資料倉儲登錄來源系統Register source systems to the System Center data warehouse in Service Manager

重要

此版本的 Service Manager 已達到終止支援,建議您 升級至 Service Manager 2019This version of Service Manager has reached the end of support, we recommend you to upgrade to Service Manager 2019.

Service Manager 中的資料倉儲會從一或多個資料來源取得資料。The data warehouse in Service Manager retrieves data from one or more data sources. 這些資料來源是交易處理系統,會產生和管理您最終想要測量和分析的資料。These data sources are the transactional processing systems that produce and govern data that you will eventually want to measure and analyze. 例如,事件和變更要求會在 Service Manager 中建立和管理、軟體更新和電源原則會在 Configuration Manager 中進行管理,而其他系統則產生和管理其他資料集。For example, incidents and change requests are created and managed in Service Manager, software updates and power policies are managed in Configuration Manager, and other systems produce and govern other data sets.

登錄資料倉儲會在資料倉儲伺服器和來源系統之間建立關聯性,讓資訊可以在兩者之間流動。Registering the data warehouse creates a relationship between the data warehouse server and the source system so that information can flow between them. 在 Service Manager 中,您可以直接註冊 Service Manager、Operations Manager 和 Configuration Manager。In Service Manager, you can register to Service Manager, Operations Manager, and Configuration Manager directly. 您也可以在資料倉儲之上使用更新的軟體開發套件 (SDK) 層,這可讓您直接從其他來源推播資料到資料倉儲中。You can also use the updated software development kit (SDK) layer on top of the data warehouse, which enables you to push data into the data warehouse directly from other sources. 例如,您可能會想在資料倉儲中從人力資源電腦系統推播資料。For example, you might want to push data from your Human Resources computer system in the data warehouse.

向 Operations Manager 登錄 System Center 資料倉儲Register the System Center data warehouse to Operations Manager

您可以在 Service Manager 中使用下列程式,將 System Center 資料倉儲註冊 Operations Manager 然後驗證註冊。You can use the following procedures in Service Manager to register the System Center Data Warehouse to Operations Manager and then validate the registration.

註冊資料倉儲以 Operations ManagerTo register the data warehouse to Operations Manager

  1. 向 Service Manager 的來源註冊 System Center 資料倉儲。Register System Center Data Warehouse to Service Manager Source.

  2. 等候 MPSync 作業完成。Wait for the MPSync job to complete.

  3. 使用屬於 Service Manager 和資料倉儲管理系統管理員群組成員的帳戶,登入裝載 Service Manager 主控台的電腦。Using an account that is a member of the Service Manager and data warehouse management administrators group, log on to the computer that hosts the Service Manager console.

  4. 在 Service Manager 主控台中,選取 [ 資料倉儲]。In the Service Manager console, select Data Warehouse.

  5. 在 [系統 管理 ] 窗格中,展開 [ 資料倉儲],然後選取 [ 資料來源]。In the Administration pane, expand Data Warehouse, and then select Data Sources.

  6. 在 [工作] 清單中,按一下 [註冊資料來源]。In the Tasks list, click Register data source.

  7. 在 [註冊資料來源嚮導] 的 [在 您開始前 ] 頁面上,按 [ 下一步]In the Register Data Source Wizard, on the Before You Begin page, click Next.

  8. 在 [ 資料來源類型 ] 頁面上,選取 [ Operations Manager]。On the Data Source Type page, select Operations Manager.

  9. 在 [ 指定根管理伺服器 ] 區域底下,輸入下列資訊:Under Specify a Root Management Server area, type the following information:

    1. 在 [ 根管理伺服器名稱] 中,輸入伺服器名稱。For Root Management server name, type the server name.

    2. 若為 操作資料庫伺服器,請輸入資料庫伺服器名稱。For Operational database server, type the database server name.

    3. 在 [ 資料庫名稱] 中,輸入資料庫的名稱。For Database name, type the name of the database.

  10. 按 [下一步] 。Click Next.

  11. 在 [ 認證 ] 頁面上,您可以接受 [執行身分 帳戶 ] 清單中的預設專案,然後按 [ 下一步],也可以從您選擇的使用者或群組中輸入認證。On the Credentials page, you can accept the default entry in the Run as account list, and then click Next, or you can enter credentials from a user or group of your choice.

    重要

    您指定的帳號將會被指派 Service Manager 管理伺服器上的系統管理認證,並授與 Service Manager 資料庫的讀取權限。The account that you specify will be assigned administrative credentials on the Service Manager management server and granted Read permission on the Service Manager database. 當您向資料倉儲註冊時,可以在其他 Service Manager 管理群組中指定不同的認證。You can specify different credentials from other Service Manager management groups when you are registering with the data warehouse.

  12. 在 [ 摘要 ] 頁面上,您可以檢查您所選擇的設定。On the Summary page, you can review the settings that you have chosen. 按一下 [完成] 。Click Finish.

  13. 在 [ 結果 ] 頁面上,當 資料來源註冊完成時。On the Result page, when Data source registration complete. 隨即出現,請按一下 [完成]appears, click Finish.

驗證 Operations Manager 註冊程式To validate the Operations Manager registration process

  • 在 [ 資料來源 ] 視圖中,新的資料來源會出現在資料來源清單中,資料來源類型為 [ Operations Manager]。In the Data Sources view, the new data source appears in the list of data sources, with the data source type of Operations Manager. 您可能必須重新整理您的視圖,才能看到新的資料來源。You might have to refresh your view to see the new data source.

向 Configuration Manager 登錄 System Center 資料倉儲Register the System Center data warehouse to Configuration Manager

您可以使用 Service Manager 中的下列步驟,向 System Center 資料倉儲註冊 Configuration Manager,然後驗證註冊。You can use the following steps in Service Manager to register Configuration Manager with the System Center Data Warehouse and then validate the registration.

向資料倉儲註冊 Configuration ManagerTo register Configuration Manager with the data warehouse

  1. 使用屬於 Service Manager 和資料倉儲管理系統管理員群組成員的帳戶,登入裝載 Service Manager 主控台的電腦。By using an account that is a member of the Service Manager and data warehouse management administrators group, log on to the computer that hosts the Service Manager console.

  2. 在 Service Manager 主控台中,選取 [ 資料倉儲]。In the Service Manager console, select Data Warehouse.

  3. 在 [系統 管理 ] 窗格中,展開 [ 資料倉儲],然後選取 [ 資料來源]。In the Administration pane, expand Data Warehouse, and then select Data Sources.

  4. 在 [工作] 清單中,按一下 [註冊資料來源]。In the Tasks list, click Register data source.

  5. 在 [註冊資料來源嚮導] 的 [在 您開始前 ] 頁面上,按 [ 下一步]In the Register Data Source Wizard, on the Before You Begin page, click Next.

  6. 在 [ 資料來源類型 ] 頁面上,選取 [ Configuration Manager]。On the Data Source Type page, select Configuration Manager.

  7. 在 [ 指定中央網站伺服器] 下,輸入下列資訊:Under Specify a Central Site Server, type the following information:

    1. 在 [ 中央網站伺服器名稱] 中,輸入網站伺服器名稱。For Central Site server name, type the site server name.

    2. 在 [ 資料庫名稱] 中,輸入資料庫的名稱。For Database name, type the name of the database.

  8. 按 [下一步] 。Click Next.

  9. 在 [ 認證 ] 頁面上,您可以接受 [執行身分 帳戶 ] 清單中的預設專案,然後按 [ 下一步],也可以從您選擇的使用者或群組中輸入認證。On the Credentials page, you can accept the default entry in the Run as account list, and then click Next, or you can enter credentials from a user or group of your choice.

    重要

    您指定的帳號將會被指派 Service Manager 管理伺服器上的系統管理認證,並授與 Service Manager 資料庫的讀取權限。The account that you specify will be assigned administrative credentials on the Service Manager management server and granted Read permission on the Service Manager database. 當您向資料倉儲註冊時,可以在其他 Service Manager 管理群組中指定不同的認證。You can specify different credentials from other Service Manager management groups when you are registering with the data warehouse.

  10. 在 [ 資料選擇 ] 頁面上,選擇要解壓縮的網域,然後按 [下一步]On the Data Selection page, choose the domains to extract, and then click Next. 例如,選取 [ System center Configuration Manager 連接器 設定] 和 [ System Center Configuration Manager 電源管理連接器]。For example, select System Center Configuration Manager Connector Configuration and System Center Configuration Manager Power Management Connector.

  11. 在 [ 摘要 ] 頁面上,您可以檢查您所選擇的設定。On the Summary page, you can review the settings that you have chosen. 按一下 [完成] 。Click Finish.

  12. 在 [ 結果 ] 頁面上,當 [ 資料來源註冊完成 ] 出現時,按一下 [完成]On the Result page, when Data source registration complete appears, click Finish.

驗證 Configuration Manager 註冊程式To validate the Configuration Manager registration process

  • 在 [ 資料來源 ] 視圖中,新的資料來源會出現在資料來源清單中,資料來源類型為 [ Configuration Manager]。In the Data Sources view, the new data source appears in the list of data sources, with the data source type of Configuration Manager. 您可能必須重新整理您的視圖,才能看到新的資料來源。You might have to refresh your view to see the new data source.

向 Service Manager wource 登錄 System Center 資料倉儲Register the System Center data warehouse to a Service Manager wource

您可以在 Service Manager 中使用下列程式,向 Service Manager 管理群組註冊 System Center 資料倉儲,然後驗證註冊。You can use the following procedures in Service Manager to register the System Center Data Warehouse with a Service Manager management group and then validate the registration. 如此一來,就可以在單一資料倉儲中裝載多個 Service Manager 管理群組。This makes it possible to host multiple Service Manager management groups in a single data warehouse.

若要向另一個 Service Manager 管理群組註冊資料倉儲To register the data warehouse with another Service Manager management group

  1. 使用屬於 Service Manager 和資料倉儲管理系統管理員群組成員的帳戶,登入裝載 Service Manager 主控台的電腦。By using an account that is a member of the Service Manager and data warehouse management administrators group, log on to the computer that hosts the Service Manager console.

  2. 在 Service Manager 主控台中,選取 [ 資料倉儲]。In the Service Manager console, select Data Warehouse.

  3. 在 [系統 管理 ] 窗格中,展開 [ 資料倉儲],然後選取 [ 資料來源]。In the Administration pane, expand Data Warehouse, and then select Data Sources.

  4. 在 [工作] 清單中,按一下 [註冊資料來源]。In the Tasks list, click Register data source.

  5. 在 [註冊資料來源嚮導] 的 [在 您開始前 ] 頁面上,按 [ 下一步]In the Register Data Source Wizard, on the Before You Begin page, click Next.

  6. 在 [ 資料來源類型 ] 頁面上,選取 [ Service Manager]。On the Data Source Type page, select Service Manager.

  7. 在 [ 指定 Service Manager 伺服器] 下,輸入下列資訊:Under Specify a Service Manager Server, type the following information:

    1. 在 [ Service Manager 伺服器名稱] 中,輸入伺服器名稱。For Service Manager server name, type the server name.
  8. 按 [下一步] 。Click Next.

  9. 在 [ 認證 ] 頁面上,您可以接受 [執行身分 帳戶 ] 清單中的預設專案,然後按 [ 下一步],也可以從您選擇的使用者或群組中輸入認證。On the Credentials page, you can accept the default entry in the Run as account list, and then click Next, or you can enter credentials from a user or group of your choice.

    重要

    您指定的帳號將會被指派 Service Manager 管理伺服器上的系統管理認證,並授與 Service Manager 資料庫的讀取權限。The account that you specify will be assigned administrative credentials on the Service Manager management server and granted Read permission on the Service Manager database. 向資料倉儲進行登錄時,您可以指定來自其他 Service Manager 管理伺服器的不同認證。You can specify different credentials from other Service Manager management groups when registering with the data warehouse.

  10. 在 [ 摘要 ] 頁面上,您可以檢查您所選擇的設定。On the Summary page, you can review the settings that you have chosen. 按一下 [完成] 。Click Finish.

  11. 在 [ 結果 ] 頁面上,當 資料來源註冊完成時。On the Result page, when Data source registration complete. 隨即出現,請按一下 [完成]appears, click Finish.

驗證 Service Manager 註冊程式To validate the Service Manager registration process

  • 在 [ 資料來源 ] 視圖中,新的資料來源會出現在資料來源清單中,資料來源類型為 [ Service Manager]。In the Data Sources view, the new data source appears in the list of data sources, with the data source type of Service Manager. 您可能必須重新整理您的視圖,才能看到新的資料來源。You might have to refresh your view to see the new data source.

管理 Operations Manager 和 Configuration Manager 的資料匯入作業Manage data import jobs for Operations Manager and Configuration Manager

您可以使用下列程式來管理 Service Manager 中的資料倉儲資料匯入作業。You can use the following procedure to manage data warehouse data import jobs in Service Manager. 資料匯入作業就像其他資料倉儲工作一樣,您也可以使用 Service Manager 主控台以及 Windows PowerShell Cmdlet 來管理它們。Data import jobs are like other data warehouse jobs, and you can manage them with the Service Manager console and also with Windows PowerShell cmdlets. 管理方法包括:Methods of management include:

  • 將處理排程修訂為每小時、每日或每週Revising the processing schedule to hourly, daily, or weekly

  • 暫停作業Suspending a job

  • 繼續暫停或未啟動的作業Resuming a suspended, or Not Started, job

若要管理資料匯入作業和變更作業排程To manage data import jobs and change a job schedule

  1. 在 Service Manager 主控台中,按一下 [ 資料倉儲],展開 [ 資料倉儲],然後按一下 [ 資料倉儲作業]。In the Service Manager console, click Data Warehouse, expand Data Warehouse, and then click Data Warehouse Jobs.

  2. 在 [資料倉儲作業] 窗格中,選取作業名稱,然後按一下 [工作]底下的 [****屬性]。In the Data Warehouse Jobs pane, select a job name, and then under Tasks, click Properties.

  3. 在出現的 [作業屬性] 對話方塊中,您可以查看目前的排程。In the job properties dialog box that appears, you can view the current schedule. 您可以將排程變更為您選擇的其中一個。You can change the schedule to one of your choice. 例如,將排程變更為 [ 每日 ],然後在 上午 1:00執行工作,然後按一下 [確定]For example, change the schedule to Daily and run the job at 1:00 AM, and then click OK.

  4. 您可以選擇性地 暫停 工作,也可以 繼續 已暫停或未啟動的作業。You can optionally Suspend jobs, and you can Resume any that are suspended or Not Started.

針對 System Center 資料倉儲錯誤進行疑難排解Troubleshoot System Center data warehouse errors

本節說明您可以採取的步驟,以針對 Service Manager 中的 System Center 資料倉儲錯誤進行疑難排解。This section describes steps you can take to troubleshoot System Center data warehouse errors in Service Manager.

使用資料倉儲伺服器上的 Operations Manager 事件記錄檔來針對錯誤進行疑難排解Use the Operations Manager event log on the Data Warehouse server to troubleshoot errors

Service Manager 事件記錄檔可在 Operations Manager 事件記錄檔中找到。Service Manager event logs are found in the Operations Manager event log. 評估此記錄檔中的事件非常有幫助,因為資料倉儲產生的錯誤大多可在這個事件記錄檔中找到。Evaluating events in the log is useful because most errors from the data warehouse are found in this event log. 記錄檔中的事件是來自兩個不同的來源:部署和資料倉儲。Events in the log are from two different sources: Deployment and Data Warehouse.

具有 [部署] **** 來源的事件通常是在管理組件部署期間產生,包括報表部署或組譯資料倉儲,例如建立子維度、維度和事實資料表。Events with a source of Deployment are usually generated during management pack deployment, which includes report deployment or assembling the data warehouse, for example, by creating outriggers, dimensions, and fact tables. 事件記錄檔中的錯誤通常包含如何從錯誤復原的指示。Errors in the event log usually include instructions about how to recover from the errors. 例如,您可能會讀到建議您停止後再重新開機 Service Manager 服務的指示。For example, you might read instructions suggesting that you stop and then restart the Service Manager services. 資料倉儲管理伺服器上的三種服務是:The three services on a data warehouse management server are:

  • System Center 資料存取服務System Center Data Access Service

  • Microsoft Monitoring AgentMicrosoft Monitoring Agent

  • System Center 管理設定System Center Management Configuration

當您啟動和停止 Service Manager 服務時,必須停止並啟動這三種服務。When you start and stop Service Manager services, you must stop and start all three services.

在部署資料倉儲之後,事件來源是 [資料倉儲] **** 的機率會提高。After the data warehouse is deployed, events are more likely to have a source of Data Warehouse. 這些事件是由正常操作程序內的作業所產生,例如擷取、轉換及載入 (ETL) 作業、MPSync 作業,以及 DWMaintenance 作業。These events are created by jobs within the normal course of operations like extract, transform, and load (ETL) jobs; the MPSync job; and the DWMaintenance job.

使用 Service Manager 主控台針對錯誤進行疑難排解Use the Service Manager console to troubleshoot errors

在 Service Manager 主控台中,按一下 [ 資料倉儲工作 ],您將會看到 ETL 作業和 MPSync 作業狀態。In the Service Manager console, click Data Warehouse Jobs and you will see ETL job and MPSync job status. 如果您的部署成功,而且您的資料倉儲已正確註冊到至少一個 Service Manager 管理群組,您就會看到至少五個作業。If your deployment was successful and your data warehouse is correctly registered to at least one Service Manager management group, you see at least five jobs. 每個作業都應該具有 [執行中] **** 或 [未啟動] **** 的狀態。Every job should have the status Running or Not Started.

如果您看到列出的作業狀態是 [失敗] ****,可以選取該作業,然後在 [工作] **** 窗格中,按一下 [模組] **** ,找出失敗的作業模組。If you see a job status listed as Failed, you can select the job, and then in the Tasks pane, click Modules to find out which job module has failed. 然後,您可以檢查資料倉儲伺服器上的 Operations Manager 事件記錄檔,以判斷模組失敗的原因。Then, you can examine the Operations Manager event log on the data warehouse server to determine why the module failed.

您可以在 [資料倉儲] **** 工作區的左窗格中,按一下 [管理組件] **** 。In the Data Warehouse workspace, you can click Management Packs in the left pane. 您可在此檢視資料倉儲中的所有管理組件,以及其部署的狀態That is where you can view all the management packs in the data warehouse and the status of their deployment. 當您將管理元件匯入 Service Manager 時,MPSync 作業會將其同步處理至資料倉儲,其中 MPSync 作業會從管理元件同步處理中衍生其名稱。When you import a management pack to Service Manager, the MPSync job synchronizes it to the data warehouse, where the MPSync job derives its name from management pack synchronization. 當您取得資料倉儲中管理組件的清單時,便可得知管理組件是否已部署成功。When you get the list of management packs in the data warehouse, you can find out if your management pack has been deployed successfully or not.

如果您的管理組件己定義資料倉儲專屬元素,例如子維度、維度、事實資料表或報表,則該管理組件必須部署成功,然後才能準備開始使用新的資料表和報表。If your management pack has defined data warehouse-specific elements, such as outriggers, dimensions, fact tables, or reports, that management pack must be successfully deployed before the new tables and reports will be ready to use.

使用 Windows PowerShell 對錯誤進行疑難排解Use Windows PowerShell to troubleshoot errors

下表中的 Windows PowerShell Cmdlet 提供有關資料倉儲作業的詳細資訊。The Windows PowerShell cmdlets in the following table provide detailed information about the data warehouse jobs.

CommandCommand 描述Description
Get-SCDWMgmtGroupGet-SCDWMgmtGroup 這個命令可讓您知道哪些來源目前已登錄到資料倉儲。This command tells you which sources are currently registered with the data warehouse. 您應該會看到至少兩個不同的 DataSourceName 值。You should expect to see at least two different DataSourceName values.
Get-SCDWJobGet-SCDWJob 這個命令會列出目前批次的資料倉儲作業狀態。This command lists the data warehouse job status of the current batch. 您可以使用此命令檢查作業是否已啟用、哪些作業正在執行,以及作業啟動的時間。Using the command, you can check whether the jobs are enabled or not, which jobs are running, and when they started.

當 MPSync 或 DWMaintenance 作業啟動時,這些作業會停用所有的 ETL 作業。When the MPSync or DWMaintenance jobs start, they disable all of the ETL jobs. 您會看到每個 ETL 作業的 [已啟用] **** 欄都設定為 [False] **** 。You will see the Is Enabled column set to False for each of the ETL jobs. 這表示即使 ETL 作業狀態顯示成正在執行,其實此作業並未執行。This means that even if the ETL job status shows it is running, it actually is not running. 當 MPSync 或 DWMaintenance 作業完成時,ETL 作業便會自動啟用並繼續處理。When the MPSync or DWMaintenance job completes, the ETL jobs are automatically enabled and resume processing.

除非前一個批次已完成,否則作業通常具有 [未啟動] **** 的狀態。Jobs normally have the Not Started status, unless the previous batch has completed. 您可以依個人喜好,使用 Get-SCDWJob 命令來檢視特定作業的最後幾個批次。If you prefer, you can use the Get-SCDWJob command to view the last few batches of a specific job.
>enable-scdwjob-JobName 特定的 作業名稱 -NumberOfBatches 號碼Get-SCDWJob -JobName Specific job name -NumberOfBatches number 您可以使用此命令來查看由 特定工作名稱、已完成、啟動時間和結束時間所指定的最新工作。Use this command to see the latest job, specified by Specific job name, completed, when it started, and when it ended. 您可以計算作業執行時間,以及下一個批次識別碼和狀態是什麼。You can calculate how long it ran and what the next batch ID and status is. 作業批次識別碼一律採用遞增編號。The job batch ID is always incremental.
Get-SCDWJobModuleGet-SCDWJobModule 這個命令會提供關於作業內特定模組的詳細資訊。This command provides detailed information about the specific modules within the job. 當您看到作業失敗而想找出失敗原因時,這個命令非常有用。This is very useful when you see job failures and you want to find out what caused the failure.

針對常見的資料倉儲問題進行疑難排解Troubleshoot common data warehouse issues

這份清單不是完整清單,但已包含您可能遇到的大部分常見問題。This list is not exhaustive, but it covers most of the common problems that you are likely to encounter.

登錄資料倉儲後未部署報表Reports are not deployed after registering the data warehouse

徵兆Symptoms

當您開啟 Service Manager 主控台時,會出現一個對話方塊,指出報表服務無法使用。When you open the Service Manager console, a dialog box appears indicating that the Reporting Service is unavailable. 另一個徵兆是 [ 報表 工作區] 按鈕會出現在 Service Manager 主控台中;但是,工作區中沒有顯示任何報表。Another symptom is that the Reporting workspace button appears in the Service Manager console; however, there are no reports displayed in the workspace. 還有一個徵兆是尚無任何報表已部署到 Reporting Services 伺服器。Another symptom is that no reports have been deployed to the Reporting Services server.

資料倉儲部署的其他層面可能看起來都很流暢。Other aspects of the data warehouse deployment might appear to have gone smoothly. 例如,在 Service Manager 主控台中,當您按一下 [ 資料倉儲],然後按一下 [ 資料倉儲作業] 時,您會看到兩個解壓縮工作、轉換和載入作業,以及一個 MPSync 作業。For example, in the Service Manager console, when you click Data Warehouse, and then click Data Warehouse Jobs, you see two extract jobs, a transform and load job, and an MPSync job.

疑難排解步驟Troubleshooting Steps

若要疑難排解這個問題,請完成下列步驟。To troubleshoot this problem, complete the following steps.

步驟 1:檢查管理組件的部署狀態:Step 1: Check the deployment status of your management packs:

  1. 在 Service Manager 主控台中,按一下 [資料倉儲]****。In the Service Manager console, click Data Warehouse.

  2. 按一下 [管理組件] ****,然後在搜尋 [篩選器] **** 方塊中輸入 reportClick Management Packs, and in the search Filter box, type report. 這個步驟會將結果篩選成報告相關管理組件。This filters results to report-related management packs.

  3. 檢查下列管理組件的部署狀態 (最後一欄)。Check the deployment status (last column) of the following management packs. 任何管理組件都不應該具有 [失敗] **** 的狀態。None of the management packs should have a status of Failed.

    • ServiceManager.ActivityManagement.Report.LibraryServiceManager.ActivityManagement.Report.Library

    • ServiceManager.ProblemManagement.Report.LibraryServiceManager.ProblemManagement.Report.Library

    • ServiceManager.IncidentManagement.Report.LibraryxxxServiceManager.IncidentManagement.Report.Libraryxxx

    • ServiceManager.ConfigurationManagement.Report.LibraryServiceManager.ConfigurationManagement.Report.Library

    • ServiceManager.ChangeManagement.Report.LibraryServiceManager.ChangeManagement.Report.Library

步驟 2:檢查事件記錄檔是否有任何錯誤訊息提到組件 Microsoft.EnterpriseManagement.Reporting.Code.dll 檔案。Step 2: Check the event log for error messages that mention the assembly Microsoft.EnterpriseManagement.Reporting.Code.dll file.

若上述五個管理組件有任何一個部署失敗:If any of the above five management packs failed deployment:

  1. 在資料倉儲管理伺服器上,開啟 Operations Manager 事件記錄檔。On the data warehouse management server, open the Operations Manager event log.

  2. 篩選 [事件來源] **** 是 [部署] **** 且 [事件層級] **** 是 [錯誤] **** 的事件。Filter the events with Event Sources as Deployment and Event Level as Error.

  3. 如果事件記錄檔中有錯誤訊息指出 [無法載入組件 Microsoft.EnterpriseManagement.Reporting.Code.dll] ****,請檢閱下列項目:If there are error messages in the event log that indicate cannot load Assembly Microsoft.EnterpriseManagement.Reporting.Code.dll, review the following items:

    1. 您可能將 SQL Server Reporting Services (SSRS) 安裝在與資料倉儲管理伺服器不同的伺服器上。Your installation of SQL Server Reporting Services (SSRS) may be on a different server than the data warehouse management server.

    2. 如果您將 SSRS 安裝在與資料倉儲管理伺服器相同的伺服器上,請重新啟動 SSRS 服務。If your SSRS installation is on the same server as the data warehouse management server, restart the SSRS service.

  4. 重新啟動 SSRS:Restart SSRS:

    1. 登入安裝 SSRS 的伺服器。Log on to the server where SSRS is installed.

    2. 開啟 Reporting Services 組態管理員Open Reporting Services Configuration Manager.

    3. 在 [Reporting Services 組態管理員] **** 視窗中,按一下 [連線] ****。In the Reporting Services Configuration Connection window, click Connect.

    4. 在 [報表伺服器狀態] **** 視窗中,按一下 [停止] ****,然後按一下 [開始] ****。In the Reporting Server Status window, click Stop, and then click Start.

    5. 按一下 [結束]Click Exit.

步驟 3:重新部署任何失敗的報表管理組件:Step 3: Redeploy any failed report management packs:

  1. 在 Service Manager 主控台中,按一下 [資料倉儲]****。In the Service Manager console, click Data Warehouse.

  2. 按一下 [管理組件] ****,然後在搜尋篩選器中輸入 reportClick Management Packs, and then in the search filter, type report.

  3. 針對列在步驟 1 的管理組件,在 [工作] **** 中按一下 [重新啟動部署] ****。For each of the management packs listed in step 1, in the Tasks Pane, click Restart Deployment.

    注意

    如果管理組件列出的部署狀態是 [已完成] ****,則無法使用 [重新啟動部署] **** 選項。If the deployment status of a management pack is listed as Completed, the Restart Deployment option is unavailable.

當報表管理元件的部署狀態從 [ 失敗 ] 更新為 [ 已完成] 之後,請開啟 Service Manager 主控台。After the deployment status of the report management packs has updated from Failed to Completed, open the Service Manager console. 報表應該會顯示在 [報表] **** 工作區中。Reports should display in the Reporting workspace. 您可能必須重新開機 Service Manager 主控台以查看報表,因為主控台會快取報表清單。You may have to restart the Service Manager console to view the reports because the console caches the list of reports.

匯入自訂管理組件後作業失敗Jobs fail after importing a custom management pack

徵兆Symptom

在匯入自訂管理組件並同步處理到資料倉儲之後,一或多個資料倉儲作業啟動失敗。One or more data warehouse jobs start failing after importing a custom management pack and synchronizing it to the data warehouse.

疑難排解步驟Troubleshooting Steps

若要疑難排解這個問題,請完成下列步驟:To troubleshoot this problem, complete the following steps:

  1. 檢查事件記錄檔,確認根本原因是自訂管理組件:Check the event log to ensure that the root cause is the custom management pack:

    1. 在資料倉儲管理伺服器上,開啟 Operations Manager 事件記錄檔。On data warehouse management server, open the Operations Manager event log.

    2. 尋找與作業失敗相關的事件。Find the event that is related to the job failure.

    3. 判斷失敗是否與您匯入的自訂管理組件有關。Determine if the failure is related to the custom management pack you imported.

  2. 如果失敗與自訂管理組件有關,您應該移除自訂管理組件,並讓其餘資料倉儲作業正常運作。If the failure is related to the custom management pack, you should remove it and let the rest of the data warehouse operate as usual. 您可以在稍後修正管理組件並重新匯入:You can fix the management pack and reimport it later:

    1. 使用 Service Manager 主控台卸載自訂管理元件。Uninstall the custom management pack using the Service Manager console.

    2. 執行 MP Sync 作業。Run the MP Sync job.

    3. 確認自訂管理組件列在 [資料倉儲] **** 中的[管理組件] **** 底下。Verify that the custom management pack is listed in Data Warehouse under Management Packs.

    4. 在 MP Sync 作業完成之後,請從 Service Manager 主控台或使用 Windows PowerShell Cmdlet,繼續執行失敗的作業。After the MP Sync job is completed, resume the failed job either from the Service Manager console or with a Windows PowerShell cmdlet.

  3. 修正並重新匯入自訂管理組件:Fix and reimport the custom management pack:

    1. 移除自訂管理組件,並使用前面所示的步驟 2, 從失敗復原。Remove the custom management pack and recover from the failure using step 2, shown previously.

    2. 修正自訂管理組件。Fix the custom management pack.

    3. 將固定的自訂管理元件匯入 Service Manager 中,然後執行 MP Sync 作業,將其同步處理至資料倉儲。Import the fixed custom management pack into Service Manager, and then run the MP Sync job to sync it to the data warehouse.

資料倉儲未收到新資料,或完成作業所花的時間似乎太長Data warehouse is not receiving new data, or jobs seem to take too long to complete

徵兆Symptom

您在任何報表中都沒有看到資料或新資料。You do not see data or new data in any of your reports. 另一個徵兆是 ETL 作業執行時間過長,且作業並未顯示 [未啟動] **** 的狀態。Another symptom is that ETL jobs are taking too long to run and the jobs do not show a status of Not Started.

疑難排解步驟Troubleshooting Steps

若要疑難排解這個問題,請完成下列步驟:To troubleshoot this problem, complete the following steps:

  1. 使用 Windows PowerShell Cmdlet Get-SCDWJob 判斷所有 ETL 作業是否都已啟用。Use the Windows PowerShell cmdlet Get-SCDWJob to determine if all ETL jobs are enabled. 請啟動 Windows PowerShell,然後輸入 Get-SCDWJobStart Windows PowerShell, and then type Get-SCDWJob.

  2. 如果 ETL 作業已停用且 MPSyncJob 或 DWMaintenance 作業正在執行,您必須稍候片刻,才能再次取得作業狀態,因為這兩個背景作業都會停用 ETL 作業。If the ETL jobs are disabled and either the MPSyncJob or DWMaintenance jobs are running, you will have to wait awhile to get the job status again because these two background jobs disable the ETL jobs. 不過,如果兩個工作都列為 [未啟動] **** 且 ETL 作業已停用,您可以使用 Enable-SCDWJob Cmdlet 啟用各個項目,例如:However, if the two jobs are listed as Not Started and the ETL jobs are disabled, you can use the Enable-SCDWJob cmdlet to enable each of them, for example:

    Enable-SCDWJob -JobName Transform.Common
    
  3. 如果 MPSync 和 DWMaintenance ETL 作業都已啟用且正在執行,但其個別批次識別碼已長時間未變更,或者如果您將 Get-SCDWJobModule Cmdlet 用於特定作業,且沒有看到任何模組確實正在執行,請檢查事件記錄檔,並查看是否有任何錯誤訊息。If the MPSync and DWMaintenance ETL jobs are all enabled and running but their individual batch ID has not changed for a long time, or if you use the Get-SCDWJobModule cmdlet for specific jobs and you do not see that any module is actually running, check the event log and see if there are any error messages. 有時候,錯誤訊息可能已經是好幾天前的訊息,而且您可能需檢閱許多天的事件。Sometimes the error message might be many days old and you might need to review many days-worth of events.

  4. 檢查三項服務: System Center 資料存取服務、Microsoft Monitoring Agent,以及資料倉儲管理伺服器上的 System Center 管理設定是否實際上正在執行。Check if the three services: System Center Data Access Service, Microsoft Monitoring Agent, and System Center Management Configuration on the data warehouse management server are actually running. 在資料倉儲管理伺服器上,按一下 [開始] ****,再按一下 [執行] ****,然後輸入 Services.mscOn the data warehouse management server, click Start, click Run, and then type Services.msc. 在 [ 服務 ] 中,確認下列服務正在執行: System Center 資料存取服務、Microsoft Monitoring Agent 和 System center 管理設定。In Services verify that the following services are running: System Center Data Access Service, Microsoft Monitoring Agent, and System Center Management Configuration.

    若其中有任何服務並未執行,請重新啟動所有服務 (三個)。If any of the services are not running, restart all three services. 此外,如果所有服務都在執行,事件來源資料倉儲和 OpsMgr SDK 服務的事件就會傳送至 Operations Manager 事件記錄檔。In addition, if all services are actually running, events from the Event Source Data Warehouse and OpsMgr SDK Service are sent to the Operations Manager event log. 您可以使用這項資訊作為確認所有服務是否正在執行的另一個來源。You can use this information as another source to verify whether all the services are running. 如果您長時間沒有看到事件來源資料倉儲和 OpsMgr SDK 服務產生的事件,則應該將這三個服務全部重新啟動。If you do not see events from the Event Source Data Warehouse and OpsMgr SDK Service for a long time, you should restart all three services.

自訂資料倉儲延伸模組未出現在資料倉儲中Custom data warehouse extensions do not appear in the data warehouse

徵兆Symptom

匯入管理元件之後,它會定義某些維度或事實資料表來 Service Manager,MPSync 作業已執行幾次,但您仍然沒有在資料超市中看到您的維度或事實資料表。After importing your management pack, which defines some dimensions or fact tables to Service Manager, the MPSync job has run several times, but you still do not see your dimension or fact tables in the DataMart.

疑難排解步驟Troubleshooting Steps

請確認您的管理組件已密封。Ensure that your management pack is sealed. MPSync 作業只能將密封的管理元件從 Service Manager 匯入資料倉儲中。The MPSync Job can import only sealed management packs from Service Manager into the data warehouse. 如果您尚未密封管理元件,請將它密封,然後使用 Service Manager 加以匯入。If you have not sealed your management pack, seal it, and then import it using the Service Manager.

請完成下列步驟,確認您的管理組件已同步處理到資料倉儲:Ensure that your management pack is synced to the data warehouse by completing the following steps:

  1. 開啟 Service Manager 主控台。Open the Service Manager console.

  2. 按一下 [資料倉儲] ****。Click Data Warehouse.

  3. 按一下 [管理組件] ****,然後在管理組件清單中找到您的管理組件。Click Management Packs, and then locate your management pack in the list of management packs. 若要執行這個動作,請使用搜尋功能,在搜尋方塊中輸入您的管理組件。To do this, use the search feature by typing your management pack name in the search box. 如果沒有看到您的管理組件:If you do not see your management pack:

    1. 管理組件可能無法匯入資料倉儲管理伺服器中。It might have failed to import into the data warehouse management server. 移至資料倉儲管理伺服器,開啟 Operations Manager 事件記錄檔,然後以 事件來源 作為 OpsMgr SDK 服務來篩選事件。Go to the data warehouse management server, open the Operations Manager event log and then filter the events with Event Sources as OpsMgr SDK Service.

    2. MPSync 作業可能尚未執行。The MPSync job may not have run yet. 此作業按照週期性的排程來執行,預設為每個小時一次。It runs on a recurring schedule, which is, by default, once every hour. 您可以使用 Windows PowerShell 來修改排程。You can modify the schedule with Windows PowerShell. 若要加快管理元件的同步處理速度,您可以在匯入管理元件之後,從 Service Manager 主控台或使用 Windows PowerShell 手動恢復 MPSync 作業。To speed up management pack synchronization, after you import your management pack you can manually resume the MPSync job, either from the Service Manager console or by using Windows PowerShell.

檢查管理組件的部署狀態:Check the deployment status of your management pack:

  1. 開啟 Service Manager 主控台。Open the Service Manager console.

  2. 按一下 [資料倉儲] ****。Click Data Warehouse.

  3. 按一下 [管理組件] ****,然後在管理組件清單中找出管理組件。Click Management Packs, and then find your management pack in the list of management packs. 若要這麼做,您可以搜尋管理組件名稱。To do this you can search for your management pack name.

  4. 檢查管理組件的部署狀態。Check the deployment status of your management pack. 如果部署狀態為 [失敗] ****:If the deployment status is Failed:

    1. 在資料倉儲管理伺服器上,開啟 Operations Manager 事件記錄檔,然後以 事件來源 作為 部署來篩選事件。On the data warehouse management server, open the Operations Manager event log, and then filter the events with Event Sources as Deployment.

    2. 如果有錯誤訊息,訊息通常會指出發生錯誤的原因。If there is an error message, the message usually indicates what went wrong. 如果您對管理元件進行任何所需的修正,但仍然發生錯誤,您可以使用 Service Manager 主控台卸載此管理元件。If after you make any needed fixes to the management pack and the error still occurs, you can uninstall this management pack using the Service Manager console. 在 MPSync 作業執行後,系統即會解除安裝資料倉儲管理伺服器上的管理組件。After the MPSync job runs, the management pack is uninstalled from data warehouse management server.

向資料倉儲登錄後,管理組件停留在擱置關聯狀態Management packs are stuck in Pending Association status after registering to the data warehouse

徵兆Symptom

某些管理元件會在向資料倉儲註冊 Service Manager,以及數個 (多達四個或更多的) 小時之後,仍會有幾個小時的 [ 擱置關聯 ] 狀態。Some management packs remain in Pending Association status several hours after registering Service Manager with the data warehouse and several (up to four or more) hours have passed. 您可以開啟 Service Manager 主控台並流覽至 [資料倉儲]、[資料倉儲作業]、[ MPSync 作業],然後按一下 [工作] 窗格中的 [ 詳細資料],以判斷經過的時間。You can determine the time elapsed by opening the Service Manager console and navigating to Data Warehouse, Data Warehouse Jobs, MPSync Job, and then clicking Details from the Tasks pane.

疑難排解步驟Troubleshooting Steps

若要疑難排解這個問題,請完成下列步驟:To troubleshoot this problem, complete the following steps:

  1. 檢視 MPSync 作業的 [詳細資料] **** 。View the Details of the MPSync job. 在 [管理組件 (MP) 同步處理作業] **** 對話方塊中檢閱問題管理組件的每個批次識別碼。Review each batch ID for the problem management pack in the MPSyncJob dialog box. 在 [管理組件 (MP) 同步處理作業] **** 對話方塊中,按一下 [管理組件] **** 欄名稱,以依據管理組件名稱排序清單。In the MP Sync Job dialog box, click the Management Pack column name to sort the list according to management pack name. 尋找處於 [擱置關聯] **** 狀態的任何管理組件。Find any management packs with Pending Association status. 在管理組件清單中,檢查稍後的批次中管理組件狀態是否列為 [已關聯] ****,例如:In the list of management packs, check to see if, in the later batch, the management pack status is listed as Associated, for example:

    • 對於批次識別碼 136,管理組件 Microsoft.SystemCenter.ConfigurationManager 處於 [擱置關聯] 狀態。For Batch ID 136, Management Pack Microsoft.SystemCenter.ConfigurationManager is Pending Association.

    • 對於批次識別碼 207,管理組件 Microsoft.SystemCenter.ConfigurationManager 處於 [已關聯] 狀態。For Batch ID 207, Management Pack Microsoft.SystemCenter.ConfigurationManager is Associated.

    上述內容指出即使管理組件曾在批次 136 時發生錯誤,不過已在批次 207 正確關聯。This indicates the management pack is associated properly in batch 207, even though it ran into an error in batch 136. 由於它已在批次 207 復原,因此能正確地建立關聯及成功完成同步處理。Because it recovered in batch 207, the management pack is correctly associated and the synchronization completed successfully.

  2. 在 [管理組件 (MP) 同步處理作業] **** 對話方塊中,如果管理組件的 [擱置關聯] 狀態重複在每個批次中出現,您就需要採取進一步的疑難排解措施來判斷管理組件無法建立關聯的原因。If in the MP Sync Job dialog box, the Pending Association status for a management pack repeats for every batch, you will have to troubleshoot further to determine the reason why the management pack fails to associate. 您應從找尋管理組件仰賴之其他管理組件中的部署失敗開始。You should start by looking for deployment failures in other management packs that your management pack depends on.

    在 Service Manager 主控台中,按一下 [ 資料倉儲],再按一下 [ 管理元件],然後按一下 [ 部署狀態 ] 資料行標題。In the Service Manager console, click Data Warehouse, click Management Packs, and then click the Deployment Status column heading. 如果您發現部署狀態為 [失敗] **** 或 [未啟動] **** 的任何管理組件,這通常是由管理組件相依性所引起的。If you see any management pack with a deployment status of Failed or Not Started, this is usually due to a management pack dependency. 由於管理組件可能會相依於其他管理組件,因此任何失敗都會導致其他管理組件無法部署。Because management packs can depend on others, any failure can cause other management packs to fail deployment. 所有受影響的管理組件均會處於 [未啟動] **** 狀態。Any impacted management pack has the Not Started status.

  3. 在事件記錄檔中尋找部署失敗。Find the deployment failures in the event log. 開啟資料倉儲上的 Operations Manager 事件記錄檔,將事件記錄檔篩選至事件來源為 部署 的事件,並將事件層級設為 [ 警告 ] 或 [ 錯誤]。Open the Operations Manager Event log on the data warehouse, filter the event log to the events where the Event Source is Deployment and Event Level is Warning or Error.

  4. 如果出現類似下列訊息的錯誤訊息,您將必須從 Service Manager 取消登錄資料倉儲、重新安裝資料倉儲,然後向資料倉儲管理伺服器重新註冊 Service Manager 管理伺服器:If there is an error message similar to the following message, you will have to unregister the data warehouse from Service Manager, reinstall the data warehouse, and then reregister the Service Manager management server to the data warehouse management server:

    Deployment Execution Infrastructure has retried the maximum number of times and is giving up on this execution step.
    MP Element ID:  DerivedManagementPack.SystemDerivedMp.ServiceManager.ActivityManagement.Library.Datawarehouse
    MP name: ServiceManager.ActivityManagement.Library.Datawarehouse
    MP version: 7.0.5826.0
    Operation: Install
    Error message:  Cannot find resource with ID TransformActivityStatusResource
    

登入認證問題導致 ETL 作業失敗ETL jobs fail due to login credentials problems

徵兆Symptom

部分或所有 ETL 作業失敗。Some or all ETL jobs have failed. 資料倉儲管理伺服器上的 Operations Manager 事件記錄檔指出 ETL 作業失敗與登入使用者失敗有關。The Operations Manager event log on the data warehouse management server indicates that the ETL job failure is related to a login user failure.

疑難排解步驟Troubleshooting Steps

若要疑難排解此問題,請檢查每個執行身分帳戶的密碼是否已變更或到期。To troubleshoot this problem, check if the password for each Run As account has changed or expired. 您可以使用下列步驟更新帳戶:You can update the account using the following steps:

  1. 瀏覽至 [資料倉儲] ****、[安全性] ****、[執行身分帳戶] ****,然後按一下相關的執行身分帳戶。Navigate to Data Warehouse, Security, Run As Accounts, and then click the related run as account. 按一下 [工作] **** 窗格中的 [內容] **** ,更新視窗中的 [密碼] **** 欄位,然後按一下 [確定] ****。Click Properties in the Tasks pane, update the Password field in the window, and then click OK.

  2. 如果執行身分帳戶為 Operational System 帳戶,您還必須更新以該帳戶身分執行的服務:If this Run As account is an Operational System Account, you also have to update the services that are running under the account:

    1. 在資料倉儲管理伺服器上,按一下 [開始] ****,再按一下 [執行] ****,然後輸入 Services.mscOn the data warehouse management server, click Start, click Run, and then type Services.msc.

    2. 在 [服務] **** 中,更新以該帳戶身分執行的服務 (如 System Center 資料存取服務和 System Center 管理設定) 的密碼。In Services, update the passwords for the services that run under the account, for example, System Center Data Access Service and System Center Management Configuration.

    3. 重新啟動服務。Restart the services.

      注意

      管理組件同步處理作業和擷取作業可能會使用 Operational System 帳戶之外的執行身分帳戶。The MP Sync job and Extract jobs can use a different Run As account other than Operational System Account. 此執行身分帳戶是在向資料倉儲登錄 Service Manager 時建立的。This Run As account is created when Service Manager is registered to a data warehouse.

如果該帳戶的密碼已到期,更新的方法很簡單。It is easy to update the password if it is expired. 不過如果您變更執行身分帳戶,更新系統的難度將會高出許多。However it is more difficult to update the system if you change the Run As account. 因此不建議您修改執行身分帳戶。We do not recommend that you modify Run As accounts.

如果作業失敗與密碼無關,請確認失敗作業的執行身分帳戶是否可用來連線到目標資料庫。If the job failure is not related to the password, make sure that the Run As account for the failed job can be used to connect to the target database. 例如,請確定您可以使用「解壓縮工作執行為」帳戶連接到 Service Manager 資料庫。For example, ensure that the Extract job Run As account can be used to connect to the Service Manager database. 如果不行的話,請確認裝載資料庫的結構化查詢語言 (SQL) 服務處於執行狀態。If not, make sure that the Structured Query Language (SQL) service that is hosting the database is running.

後續步驟Next steps