question

kumaravelu-1265 avatar image
0 Votes"
kumaravelu-1265 asked Crystal-MSFT commented

SCOM 2019: Data Warehouse failed to request a list of management packs from SQL RS server

Hi All,

We received the following alert in SCOM 2019 "Data Warehouse failed to request a list of management packs from SQL RS server" and also we do not see anything under Reporting pane in the SCOM console.

looking at the description we see the below information.

Event iD: 31569
Description: Report deployment process failed to request management pack list from SQL RS Server. The operation will be retried. Exception 'WebException': Unable to connect to the remote server One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report Instance name: Data Warehouse Synchronization Service Instance ID: {FBD2DCEA-B8A2-1346-879F-EAEE247B2F} Management group

msc-operations-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Crystal-MSFT avatar image
0 Votes"
Crystal-MSFT answered Crystal-MSFT commented

@kumaravelu-1265,For our issue, could you firstly help to confirm if we can access SSRS Web service URL and Web portal URL successfully using Data reader account?

Meanwhile, please also check if there's any network or bad proxy in our environment.

To check the proxy entry from MonitoringHost.Exe.Config. we can go to location: C:\Program Files\Microsoft System Center\Operations Manager\Server and check if there's any

<defaultProxy>
<proxy proxyaddress=http://127.0.0.1:8888 **="true" />
<bypasslist>
</bypasslist>
</defaultProxy>
</system.net>

Please check the above information and if there's any update, feel free to let us know.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Crystal,

Yes we are not able to access the Web Report URL.

Also please confirm on which server do we need to view the below information, we checked this in all of the Management servers and i do not see the below information in MonitoringHost.Exe.Config file.

<defaultProxy>
<proxy proxyaddress=http://127.0.0.1:8888 **="true" />
<bypasslist>
</bypasslist>
</defaultProxy>
</system.net>

0 Votes 0 ·

@kumaravelu-1265, Thanks for the reply. For the MonitoringHost.Exe.Config file, I check it on SCOM server. we can see more details in the following link:
https://techcommunity.microsoft.com/t5/system-center-blog/support-tip-some-microsoft-operations-manager-management-packs/ba-p/351587

From your description, I know the web portal URL is unable to access. Could you let us know what error we get?

Meanwhile, we can check the Report Server Service Trace Log to see if there's any more finding. We can find the location in the following link with different version:
https://docs.microsoft.com/en-us/sql/reporting-services/report-server/reporting-services-log-files-and-sources?view=sql-server-ver15

If there's any update, feel free to let us know.

0 Votes 0 ·

Hi Crystal,

Thank you for the update.

FYI we were able to access the reporting from the SCOM console earlier, now all of a sudden the reporting view in the SCOM console are blank.


Regards,
Kumar

0 Votes 0 ·
Show more comments
RogerXue-3369 avatar image
0 Votes"
RogerXue-3369 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.