Error on Report based on Analysis Services

I've got most of my first stab at using Reporting Services. I am using the
Report Viewer control in VS 2005. When I point it at a report based on
standard TSQL it runs. My next query is based on Analysis Services. It runs
via the URL when I login as an Administrator but I get the following error
when I do it via the Report Viewer. The problem is the web server can't
"see" itself (i.e. typing the URL of the ASP.net page doesn't seem to work)-
something which I will get the network people to look at tomorrow so I can't
see a more detailed error. I am just starting trying to get an understanding
of roles etc but some pointers would be great. Regards, Chris.
a..
An error has occurred during report processing. a.. Query execution failed
for data set 'Analysis_Services_Project1'. a.. For more information about
this error navigate to the report server on the local server machine, or
enable remote errors a..I figured it out - I needed to add the IUSR as a role to the Analysis
Services DB.
"Fresno Bob" <nospam@.nospam.com> wrote in message
news:%23QvrOp98HHA.3940@.TK2MSFTNGP05.phx.gbl...
> I've got most of my first stab at using Reporting Services. I am using the
> Report Viewer control in VS 2005. When I point it at a report based on
> standard TSQL it runs. My next query is based on Analysis Services. It
> runs via the URL when I login as an Administrator but I get the following
> error when I do it via the Report Viewer. The problem is the web server
> can't "see" itself (i.e. typing the URL of the ASP.net page doesn't seem
> to work)- something which I will get the network people to look at
> tomorrow so I can't see a more detailed error. I am just starting trying
> to get an understanding of roles etc but some pointers would be great.
> Regards, Chris.
> a..
> An error has occurred during report processing. a.. Query execution failed
> for data set 'Analysis_Services_Project1'. a.. For more information about
> this error navigate to the report server on the local server machine, or
> enable remote errors a..
>

Error not flowing down Error Precedent Constraint path

I have a dataflow task which keeps erroring, at which point the flow should go down the red path to my error handling SQL Task.

But it is failing to do so.

anyone know why?

What type of transform are you using? (note: task is for control flow not data flow) Have you set up your error output to redirect rows on error? How about for truncation?

etc...

|||

Adolf,

could you explain bettter what is your problem?

You have in eventhandler a SQL task to save the inesperated error, true?

the error is in this SQL Task?

Regards!

|||This is occuring at the Control Flow level.

The design:
A data flow task has two paths coming out of it: 1 green, 1 red.
The green path continues on to another DF task, the red goes to an SQL task.

What happens:
The DF turns red but the flow does not then progress to the SQL task. It just stops.|||What I failed to mention was that the SQL task has 3 other failure paths joining it

I just set the precedence to "OR" instead of "AND" and it works.

Error Message When Deploying Report - The Item '/Data Sources'

Hi All,
I am wondering is someone can point me in the right direction,
I updated to the latest service pack on my Report Server Production Machine
and now when I attempt to deloy a report I get the following message
The Item '/Data Sources' already exists
I have tried everything I can think of to stop the message
~ Disabling and Enabling the OverwriteDataSources
~ Adding the Shared Datasource directly into the SQL frontend...
~ Running around like a chicken with no head
all seem to have the same effect...
Currently all other reports seem to work ok...
Has anyone got idea... apart from never ever ever updating to the latest
patches ;)
...Cheers
MattOn Sep 11, 10:26 pm, Aussie Matt
<AussieM...@.discussions.microsoft.com> wrote:
> Hi All,
> I am wondering is someone can point me in the right direction,
> I updated to the latest service pack on my Report Server Production Machine
> and now when I attempt to deloy a report I get the following message
> The Item '/Data Sources' already exists
> I have tried everything I can think of to stop the message
> ~ Disabling and Enabling the OverwriteDataSources
> ~ Adding the Shared Datasource directly into the SQL frontend...
> ~ Running around like a chicken with no head
> all seem to have the same effect...
> Currently all other reports seem to work ok...
> Has anyone got idea... apart from never ever ever updating to the latest
> patches ;)
> ...Cheers
> Matt
This might be overly simplistic, but have you tried to reselect the
datasource in the Report Mgr for the report? I have installed SP2 on a
couple different Report Servers w/no problems.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
Hi mate... yes that seems to be ok..
The report actually renders ok in the development environment...
I even tried creating a new report to see if that would overwrite the
existing shared data source but it has the same problemâ?¦. I am wondering if
it actually related to IIS6 somehow.. thou all the permissions look ok...
Thanks for the advice thou,
Cheers
Matt
"EMartinez" wrote:
> On Sep 11, 10:26 pm, Aussie Matt
> <AussieM...@.discussions.microsoft.com> wrote:
> > Hi All,
> > I am wondering is someone can point me in the right direction,
> > I updated to the latest service pack on my Report Server Production Machine
> > and now when I attempt to deloy a report I get the following message
> >
> > The Item '/Data Sources' already exists
> >
> > I have tried everything I can think of to stop the message
> > ~ Disabling and Enabling the OverwriteDataSources
> > ~ Adding the Shared Datasource directly into the SQL frontend...
> > ~ Running around like a chicken with no head
> >
> > all seem to have the same effect...
> >
> > Currently all other reports seem to work ok...
> >
> > Has anyone got idea... apart from never ever ever updating to the latest
> > patches ;)
> >
> > ...Cheers
> >
> > Matt
>
> This might be overly simplistic, but have you tried to reselect the
> datasource in the Report Mgr for the report? I have installed SP2 on a
> couple different Report Servers w/no problems.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Hello Again,
Well I fixed it, not sure how / why it got screwy, to fix it I went to the
Reporting Services Configuration Manager
and reset the default properties for the the Report Server Virtual
Directory and Report Manager Virtual Directory... this seem to rectify
whatever the problem
was...
Cheers
Matt
"Aussie Matt" wrote:
> Enrique,
> Hi mate... yes that seems to be ok..
> The report actually renders ok in the development environment...
> I even tried creating a new report to see if that would overwrite the
> existing shared data source but it has the same problemâ?¦. I am wondering if
> it actually related to IIS6 somehow.. thou all the permissions look ok...
> Thanks for the advice thou,
> Cheers
> Matt
> "EMartinez" wrote:
> > On Sep 11, 10:26 pm, Aussie Matt
> > <AussieM...@.discussions.microsoft.com> wrote:
> > > Hi All,
> > > I am wondering is someone can point me in the right direction,
> > > I updated to the latest service pack on my Report Server Production Machine
> > > and now when I attempt to deloy a report I get the following message
> > >
> > > The Item '/Data Sources' already exists
> > >
> > > I have tried everything I can think of to stop the message
> > > ~ Disabling and Enabling the OverwriteDataSources
> > > ~ Adding the Shared Datasource directly into the SQL frontend...
> > > ~ Running around like a chicken with no head
> > >
> > > all seem to have the same effect...
> > >
> > > Currently all other reports seem to work ok...
> > >
> > > Has anyone got idea... apart from never ever ever updating to the latest
> > > patches ;)
> > >
> > > ...Cheers
> > >
> > > Matt
> >
> >
> > This might be overly simplistic, but have you tried to reselect the
> > datasource in the Report Mgr for the report? I have installed SP2 on a
> > couple different Report Servers w/no problems.
> > Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
> >
> >|||On Sep 12, 5:24 am, Aussie Matt <AussieM...@.discussions.microsoft.com>
wrote:
> Hello Again,
> Well I fixed it, not sure how / why it got screwy, to fix it I went to the
> Reporting Services Configuration Manager
> and reset the default properties for the the Report Server Virtual
> Directory and Report Manager Virtual Directory... this seem to rectify
> whatever the problem
> was...
> Cheers
> Matt
> "Aussie Matt" wrote:
> > Enrique,
> > Hi mate... yes that seems to be ok..
> > The report actually renders ok in the development environment...
> > I even tried creating a new report to see if that would overwrite the
> > existing shared data source but it has the same problem... I am wondering if
> > it actually related to IIS6 somehow.. thou all the permissions look ok...
> > Thanks for the advice thou,
> > Cheers
> > Matt
> > "EMartinez" wrote:
> > > On Sep 11, 10:26 pm, Aussie Matt
> > > <AussieM...@.discussions.microsoft.com> wrote:
> > > > Hi All,
> > > > I am wondering is someone can point me in the right direction,
> > > > I updated to the latest service pack on my Report Server Production Machine
> > > > and now when I attempt to deloy a report I get the following message
> > > > The Item '/Data Sources' already exists
> > > > I have tried everything I can think of to stop the message
> > > > ~ Disabling and Enabling the OverwriteDataSources
> > > > ~ Adding the Shared Datasource directly into the SQL frontend...
> > > > ~ Running around like a chicken with no head
> > > > all seem to have the same effect...
> > > > Currently all other reports seem to work ok...
> > > > Has anyone got idea... apart from never ever ever updating to the latest
> > > > patches ;)
> > > > ...Cheers
> > > > Matt
> > > This might be overly simplistic, but have you tried to reselect the
> > > datasource in the Report Mgr for the report? I have installed SP2 on a
> > > couple different Report Servers w/no problems.
> > > Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant
I'm surprised that this resolved the issue; however, I'm glad you
fixed the problem. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||I just spent a considerable amount of time trying to debug this error, and in
the end it was a permissions problem. As a new employee I had been given
access to the Reports folder but not to the Data Sources folder.
Hopefully this note can save someone else some time (and frustration)
diagnosing this error.