Data Warehouse Synchronization Service

Dashboard Server
1

bonjour Teams,
Depuis quelque temps j’obtiens cette erreur avec une event ID 32569 sur l’un de mes serveurs de Gestion SCOM. après plusieurs tentative de résolution, alerte persiste toujours. merci de bien vouloir m’aider.
“*One or more workflows were affected by this. *
*Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report *
*Instance name: Data Warehouse Synchronization Service *
*Instance ID: {6E4B536D-59E3-5D47-648F---------------} *
Management group: …”

2

Hi Adam,

Based on the snippet of message you supplied, it sounds like your reports are having a problem loading reports to your SSRS server. (I am also assuming you meant error #31569, not #32569.)

To troubleshoot this, we need the rest of the error message. Can you log onto one of your Management Servers and look for error 31569 on the Operations Manager event log and post the contents of the entire message here? Be sure to remove any sensitive information before posting (but replace the content with something generic).

Here is a sample error from my notes. As you can see, the message description details what the actual problem is. In this case, the SCOM Reporting Account doesn’t have the necessary permissions on the SSRS server. Once you grant the necessary permissions to the SCOM Service Account on the SSRS server, the error should go away (*you might need to restart the Management Server services, but I’m not sure).

Sample message from the Event Log for ID 31569:

Log Name:      Operations Manager
Source:        Health Service Modules
Date:          3/14/20## 10:54:36 AM
Event ID:      31569
Task Category: Data Warehouse
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      MgmtServerName.sub.domain.com
Description:
Report deployment process failed to request management pack list from SQL RS Server. The operation will be retried.
Exception 'SoapException': The permissions granted to user 'DOMAIN\SCOM-ServiceAcct-Reports' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DOMAIN\SCOM-ServiceAcct-Reports' are insufficient for performing this operation. 

One or more workflows were affected by this.  

Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report 
Instance name: MgmtServerName.sub.domain.com 
Instance ID: {657FC2AF-0D86-3399-B330-2A5473D42405} 
Management group: ITSOWindows
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Health Service Modules" />
    <EventID Qualifiers="49152">31569</EventID>
    <Level>2</Level>
    <Task>3</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="20##-03-14T14:54:36.000000000Z" />
    <EventRecordID>120599</EventRecordID>
    <Channel>Operations Manager</Channel>
    <Computer>MgmtServerName.sub.domain.com</Computer>
    <Security />
  </System>
  <EventData>
    <Data>ITSOWindows</Data>
    <Data>Microsoft.SystemCenter.DataWarehouse.Deployment.Report</Data>
    <Data>MgmtServerName.sub.domain.com</Data>
    <Data>{657FC2AF-0D86-3399-B330-2A5473D42405}</Data>
    <Data>SQL RS Server</Data>
    <Data>SoapException</Data>
    <Data>The permissions granted to user 'DOMAIN\SCOM-ServiceAcct-Reports' are insufficient for performing this operation. ---&gt; Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DOMAIN\SCOM-ServiceAcct-Reports' are insufficient for performing this operation.</Data>
  </EventData>
</Event>
3

Bonjour SHAWN149,
Merci pour ton aide. merci de trouver ci-dessous le message d’erreur complet.
Le message est apparut depuis que j’ai deplacé la datawarehouse et operationnel vers une allways on.

''Report deployment process failed to request management pack list from SQL RS Server. The operation will be retried.
Exception ‘WebException’: The underlying connection was closed: An unexpected error occurred on a receive.

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report
Instance name: Data Warehouse Synchronization Service
Instance ID: {6E4B536D-59E3-5D47-648F-72576029AE44}
Management group: ivoire20"

4

What does the EventData field contain when you view the alert in Event Viewer? (This is the Details/XML view of the alert in Event viewer.)

5

Bonjour comme vous pouvez le constater il n’ya pas rien au niveau du eventdata.

BODY{font:x-small ‘Verdana’;margin-right:1.5em} .c{cursor:hand} .b{color:red;font-family:‘Courier New’;font-weight:bold;text-decoration:none} .e{margin-left:1em;text-indent:-1em;margin-right:1em} .k{margin-left:1em;text-indent:-1em;margin-right:1em} .t{color:#990000} .xt{color:#990099} .ns{color:red} .dt{color:green} .m{color:blue} .tx{font-weight:bold} .db{text-indent:0px;margin-left:1em;margin-top:0px;margin-bottom:0px;padding-left:.3em;border-left:1px solid #CCCCCC;font:small Courier} .di{font:small Courier} .d{color:blue} .pi{color:blue} .cb{text-indent:0px;margin-left:1em;margin-top:0px;margin-bottom:0px;padding-left:.3em;font:small Courier;color:#888888} .ci{font:small Courier;color:#888888} PRE{margin:0px;display:inline}

31569

2

3

0x80000000000000

281824

Operations Manager

GSESCOMM1P.univers.ci

-

ivoire20

Microsoft.SystemCenter.DataWarehouse.Deployment.Report

Data Warehouse Synchronization Service

{6E4B536D-59E3-5D47-648F-72576029AE55}

SQL RS Server

WebException

The underlying connection was closed: An unexpected error occurred on a receive.

6

Thanks for the extra information. At this point, I can’t really determine the underlying issue.

Are there any other error messages on your event log? What other symptoms are you encountering?

In the meantime, I have no idea if this will work for you, but have you seen and implemented this?

7

merci pour ton aide, je l’ai déjà fais sans succès