Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Data Warehouse alert - WebException

420 views
Skip to first unread message

David

unread,
Sep 16, 2007, 7:49:36 PM9/16/07
to
I'm getting several errors a day like below. Any idea what I can do to
resolve it?

Regards


----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Alert: Data Warehouse failed to request a list of management packs from SQL
RS server
Source: opsmgr-rms.domain.com
Path: opsmgr-rms.domain.com
Last modified by: System
Last modified time: 16/09/2007 17:57:02
Alert description: Data Warehouse failed to request a list of management
packs which contain reports deployed to SQL Reporting Services Server.
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: opsmgr-rms.domain.com

Instance ID: {4735038D-224A-7AA7-1EDE-57233A34425F}

Management group: OpsMG
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Anders Bengtsson

unread,
Sep 16, 2007, 11:54:45 PM9/16/07
to
Hi David,

Seems there is a problem with access to SQL Reporting Services. Try open
the Report Service Manager page (http://server/Reports) in Internet Explorer
from your RMS, running as the data reader account.

-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se


D> I'm getting several errors a day like below. Any idea what I can do
D> to resolve it?
D>
D> Regards
D>
D> ---------------------------------------------------------------------
D> ---------------------------------------------------------------------
D> ----------------------------
D>
D> Alert: Data Warehouse failed to request a list of management packs
D> from SQL
D>
D> RS server
D>
D> Source: opsmgr-rms.domain.com
D>
D> Path: opsmgr-rms.domain.com
D>
D> Last modified by: System
D>
D> Last modified time: 16/09/2007 17:57:02
D>
D> Alert description: Data Warehouse failed to request a list of
D> management
D>
D> packs which contain reports deployed to SQL Reporting Services
D> Server.
D>
D> Report deployment process failed to request management pack list from
D> SQL RS
D>
D> Server. The operation will be retried.
D>
D> Exception 'WebException': Unable to connect to the remote server
D>
D> One or more workflows were affected by this.
D>
D> Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report
D>
D> Instance name: opsmgr-rms.domain.com
D>
D> Instance ID: {4735038D-224A-7AA7-1EDE-57233A34425F}
D>
D> Management group: OpsMG
D> ---------------------------------------------------------------------
D> ---------------------------------------------------------------------
D> --------------------------------


David

unread,
Sep 18, 2007, 5:59:43 PM9/18/07
to
Hi Anders,

Thanks for replying. I am able to connect to the SQL Report Services with no
problem when logged on as the data reader account. Do you have any
suggestions as to any further diagnostics I can run to track down the error?

Regards

"Anders Bengtsson" <and...@contoso.se> wrote in message
news:223703beb1438...@news.microsoft.com...

Anders Bengtsson

unread,
Sep 20, 2007, 10:50:04 AM9/20/07
to
Hi David,

Verify your account settings in the console. Also look at the performance
counters for your database server and your management server to see if you
have a hardware bottleneck during the time when you have this issue.

-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se


D> Hi Anders,
D>
D> Thanks for replying. I am able to connect to the SQL Report Services
D> with no problem when logged on as the data reader account. Do you
D> have any suggestions as to any further diagnostics I can run to track
D> down the error?
D>
D> Regards
D>
D> "Anders Bengtsson" <and...@contoso.se> wrote in message
D> news:223703beb1438...@news.microsoft.com...
D>

neil

unread,
Jan 5, 2010, 6:56:04 PM1/5/10
to
was there a resolution to this particular issue? i am having the same alert appearing several times a day.
does anyone know the actual source of this alert to tune it out while trying to fix the problem?

thanks,
neil

Anders Bengtsson wrote:

Hi David,Seems there is a problem with access to SQL Reporting Services.
19-Sep-07

Hi David,

Previous Posts In This Thread:

On Sunday, September 16, 2007 7:49 PM
David wrote:

Data Warehouse alert - WebException


I'm getting several errors a day like below. Any idea what I can do to
resolve it?

Regards


----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Alert: Data Warehouse failed to request a list of management packs from SQL
RS server
Source: opsmgr-rms.domain.com
Path: opsmgr-rms.domain.com
Last modified by: System

Last modified time: 16/09/2007 17:57:02

Alert description: Data Warehouse failed to request a list of management
packs which contain reports deployed to SQL Reporting Services Server.
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: opsmgr-rms.domain.com

Instance ID: {4735038D-224A-7AA7-1EDE-57233A34425F}

Management group: OpsMG
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

On Tuesday, September 18, 2007 5:59 PM
David wrote:

Hi Anders,Thanks for replying.
Hi Anders,

Thanks for replying. I am able to connect to the SQL Report Services with no
problem when logged on as the data reader account. Do you have any
suggestions as to any further diagnostics I can run to track down the error?

Regards

"Anders Bengtsson" <and...@contoso.se> wrote in message

news:223703beb1438...@news.microsoft.com...

On Wednesday, September 19, 2007 10:04 PM
Anders Bengtsson wrote:

Hi David,Seems there is a problem with access to SQL Reporting Services.
Hi David,


Submitted via EggHeadCafe - Software Developer Portal of Choice
Build a Reverse Phone Number Lookup App for your Smartphone
http://www.eggheadcafe.com/tutorials/aspnet/f36fd957-00c7-4e0a-a5c6-2ebdc8a247d9/build-a-reverse-phone-num.aspx

0 new messages