2009. 5. 31. 10:13
SCOM 2007 보고서 배포 오류 - 'SqlException': Timeout expired SystemCenter2009. 5. 31. 10:13
Symptoms:
Event Type: Error
Event Source: Health Service Modules
Event Category: Data Warehouse
Event ID: 31569
Data Warehouse failed to enumerate database components to be deployed. Failed to enumerate Data Warehouse components for deployment. The operation will be retried. Exception 'SqlException': Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component Instance name: <Instance name> Instance ID: {AC6FACD9-
Resolution:
1. OpsMgr DW 데이터베이스에 대해 exec sp_updatestats 실행
2. 1의 방법으로 해결되지 않을 경우
http://support.microsoft.com/?kbid=954643 설치 후
Managementpackinstall.sp.sql 쿼리 실행
Event Type: Error
Event Source: Health Service Modules
Event Category: Data Warehouse
Event ID: 31569
Data Warehouse failed to enumerate database components to be deployed. Failed to enumerate Data Warehouse components for deployment. The operation will be retried. Exception 'SqlException': Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component Instance name: <Instance name> Instance ID: {AC6FACD9-
Resolution:
1. OpsMgr DW 데이터베이스에 대해 exec sp_updatestats 실행
2. 1의 방법으로 해결되지 않을 경우
http://support.microsoft.com/?kbid=954643 설치 후
Managementpackinstall.sp.sql 쿼리 실행
