Query formatting in 2005 converted reports

Yikes! I have upgraded to SQL Server 2005 Developer Edition, including the
RS upgrade. The ReportServer and reports all came over and are running
fabulously well. However, strange things are happening with my queries in
Intelligence Studio (and VS Studio 2005, I've tried both) after being
converted to the new report definition format. My extensive queries have
been reformatted predominantly as straight-text (very unreadable) and my
queries no longer pass SQL verification.
I tried retrieving the well-formatted queries from local text file backups,
but the new designer continues to reformat it as straight-text.
What can I do to get the following format in my queries:
Select A,
B,
C (as string),
D
From TableA
Where [clause]
I'm querying against a MySQL 4.0 database with MyODBC 3.5.1 driver.
Thanks.
bhcHave you tried using the generic query designer (2 panes instead of 4). I
should leave it a alone. It is one of the buttons to the right of the ... to
switch to it).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bhc" <bhc@.discussions.microsoft.com> wrote in message
news:40DB9C60-A240-4B6E-9020-E79DEBEA613A@.microsoft.com...
> Yikes! I have upgraded to SQL Server 2005 Developer Edition, including
> the
> RS upgrade. The ReportServer and reports all came over and are running
> fabulously well. However, strange things are happening with my queries in
> Intelligence Studio (and VS Studio 2005, I've tried both) after being
> converted to the new report definition format. My extensive queries have
> been reformatted predominantly as straight-text (very unreadable) and my
> queries no longer pass SQL verification.
> I tried retrieving the well-formatted queries from local text file
> backups,
> but the new designer continues to reformat it as straight-text.
> What can I do to get the following format in my queries:
> Select A,
> B,
> C (as string),
> D
> From TableA
> Where [clause]
> I'm querying against a MySQL 4.0 database with MyODBC 3.5.1 driver.
> Thanks.
> bhc|||I get the following after converting to the new report definition format when
I access the Data tab:
Error in SELECT clause: alias not recognized.
Error in list of function arguments: 'DataCenter' not recognized.
Error in list of function arguments: ',' not recognized.
Error in list of function arguments: '<' not recognized.
Error in list of function arguments: 'out_month' not recognized.
Unable to parse query text.
If I let things load in the multi-pane view and use the Verify SQL button, a
Microsoft Visual Database Tools window pops up with "The command is not
supported by this provider".
Having reviewed a few of my report queries facing this issue, I notice
problems only with queries using native MySQL functions, such as date/time
conversions. All functions have been encapsulated by single quotes, so
instead of 60-SECOND(A.TIMESTAMP), I now have to contend with
60-'SECOND'(A.TIMESTAMP). Any attempts to remove them are futile; they
simply get inserted when I go to verify the SQL or move out of the Query text
pane. Though I get the above errors on other MySQL queries, I am still able
to run ones without functions in them.
Is there any way to configure RS to stop doing this? This is just nasty.
Thanks.
bhc
"Bruce L-C [MVP]" wrote:
> Have you tried using the generic query designer (2 panes instead of 4). I
> should leave it a alone. It is one of the buttons to the right of the ... to
> switch to it).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "bhc" <bhc@.discussions.microsoft.com> wrote in message
> news:40DB9C60-A240-4B6E-9020-E79DEBEA613A@.microsoft.com...
> > Yikes! I have upgraded to SQL Server 2005 Developer Edition, including
> > the
> > RS upgrade. The ReportServer and reports all came over and are running
> > fabulously well. However, strange things are happening with my queries in
> > Intelligence Studio (and VS Studio 2005, I've tried both) after being
> > converted to the new report definition format. My extensive queries have
> > been reformatted predominantly as straight-text (very unreadable) and my
> > queries no longer pass SQL verification.
> >
> > I tried retrieving the well-formatted queries from local text file
> > backups,
> > but the new designer continues to reformat it as straight-text.
> >
> > What can I do to get the following format in my queries:
> > Select A,
> > B,
> > C (as string),
> > D
> > From TableA
> > Where [clause]
> >
> > I'm querying against a MySQL 4.0 database with MyODBC 3.5.1 driver.
> >
> > Thanks.
> > bhc
>
>|||Have you tried going to the generic query designer? I have no doubt you are
seeing these problems in the 4 pane graphical query designer. What happens
if you switch over to the generic query designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bhc" <bhc@.discussions.microsoft.com> wrote in message
news:ABF940A7-4625-4F04-8A88-D26B05E8B78B@.microsoft.com...
>I get the following after converting to the new report definition format
>when
> I access the Data tab:
> Error in SELECT clause: alias not recognized.
> Error in list of function arguments: 'DataCenter' not recognized.
> Error in list of function arguments: ',' not recognized.
> Error in list of function arguments: '<' not recognized.
> Error in list of function arguments: 'out_month' not recognized.
> Unable to parse query text.
> If I let things load in the multi-pane view and use the Verify SQL button,
> a
> Microsoft Visual Database Tools window pops up with "The command is not
> supported by this provider".
> Having reviewed a few of my report queries facing this issue, I notice
> problems only with queries using native MySQL functions, such as date/time
> conversions. All functions have been encapsulated by single quotes, so
> instead of 60-SECOND(A.TIMESTAMP), I now have to contend with
> 60-'SECOND'(A.TIMESTAMP). Any attempts to remove them are futile; they
> simply get inserted when I go to verify the SQL or move out of the Query
> text
> pane. Though I get the above errors on other MySQL queries, I am still
> able
> to run ones without functions in them.
> Is there any way to configure RS to stop doing this? This is just nasty.
> Thanks.
> bhc
> "Bruce L-C [MVP]" wrote:
>> Have you tried using the generic query designer (2 panes instead of 4). I
>> should leave it a alone. It is one of the buttons to the right of the ...
>> to
>> switch to it).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "bhc" <bhc@.discussions.microsoft.com> wrote in message
>> news:40DB9C60-A240-4B6E-9020-E79DEBEA613A@.microsoft.com...
>> > Yikes! I have upgraded to SQL Server 2005 Developer Edition, including
>> > the
>> > RS upgrade. The ReportServer and reports all came over and are running
>> > fabulously well. However, strange things are happening with my queries
>> > in
>> > Intelligence Studio (and VS Studio 2005, I've tried both) after being
>> > converted to the new report definition format. My extensive queries
>> > have
>> > been reformatted predominantly as straight-text (very unreadable) and
>> > my
>> > queries no longer pass SQL verification.
>> >
>> > I tried retrieving the well-formatted queries from local text file
>> > backups,
>> > but the new designer continues to reformat it as straight-text.
>> >
>> > What can I do to get the following format in my queries:
>> > Select A,
>> > B,
>> > C (as string),
>> > D
>> > From TableA
>> > Where [clause]
>> >
>> > I'm querying against a MySQL 4.0 database with MyODBC 3.5.1 driver.
>> >
>> > Thanks.
>> > bhc
>>|||Yes, I have tried using just the generic query designer (that's what I'm used
from RS 2000). It is the generic query designer where I'm having all the
problems. It's very unreadable and does not parse when MySQL functions are
used in the query even if the generic query designer is the only pane
displayed. The properties on Query Designer are as follows:
Distinct Values = No
Output All Columns= No
Query Parameter Identification = [nothing here]
Query Parameter List = [greyed out, no parameters specified]
Thoughts?
bhc
"Bruce L-C [MVP]" wrote:
> Have you tried going to the generic query designer? I have no doubt you are
> seeing these problems in the 4 pane graphical query designer. What happens
> if you switch over to the generic query designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "bhc" <bhc@.discussions.microsoft.com> wrote in message
> news:ABF940A7-4625-4F04-8A88-D26B05E8B78B@.microsoft.com...
> >I get the following after converting to the new report definition format
> >when
> > I access the Data tab:
> > Error in SELECT clause: alias not recognized.
> > Error in list of function arguments: 'DataCenter' not recognized.
> > Error in list of function arguments: ',' not recognized.
> > Error in list of function arguments: '<' not recognized.
> > Error in list of function arguments: 'out_month' not recognized.
> > Unable to parse query text.
> >
> > If I let things load in the multi-pane view and use the Verify SQL button,
> > a
> > Microsoft Visual Database Tools window pops up with "The command is not
> > supported by this provider".
> >
> > Having reviewed a few of my report queries facing this issue, I notice
> > problems only with queries using native MySQL functions, such as date/time
> > conversions. All functions have been encapsulated by single quotes, so
> > instead of 60-SECOND(A.TIMESTAMP), I now have to contend with
> > 60-'SECOND'(A.TIMESTAMP). Any attempts to remove them are futile; they
> > simply get inserted when I go to verify the SQL or move out of the Query
> > text
> > pane. Though I get the above errors on other MySQL queries, I am still
> > able
> > to run ones without functions in them.
> >
> > Is there any way to configure RS to stop doing this? This is just nasty.
> > Thanks.
> > bhc
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Have you tried using the generic query designer (2 panes instead of 4). I
> >> should leave it a alone. It is one of the buttons to the right of the ...
> >> to
> >> switch to it).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "bhc" <bhc@.discussions.microsoft.com> wrote in message
> >> news:40DB9C60-A240-4B6E-9020-E79DEBEA613A@.microsoft.com...
> >> > Yikes! I have upgraded to SQL Server 2005 Developer Edition, including
> >> > the
> >> > RS upgrade. The ReportServer and reports all came over and are running
> >> > fabulously well. However, strange things are happening with my queries
> >> > in
> >> > Intelligence Studio (and VS Studio 2005, I've tried both) after being
> >> > converted to the new report definition format. My extensive queries
> >> > have
> >> > been reformatted predominantly as straight-text (very unreadable) and
> >> > my
> >> > queries no longer pass SQL verification.
> >> >
> >> > I tried retrieving the well-formatted queries from local text file
> >> > backups,
> >> > but the new designer continues to reformat it as straight-text.
> >> >
> >> > What can I do to get the following format in my queries:
> >> > Select A,
> >> > B,
> >> > C (as string),
> >> > D
> >> > From TableA
> >> > Where [clause]
> >> >
> >> > I'm querying against a MySQL 4.0 database with MyODBC 3.5.1 driver.
> >> >
> >> > Thanks.
> >> > bhc
> >>
> >>
> >>
>
>|||I am in the process of upgrading and testing all my reports. I will look at
some of the more complex ones that go against Sybase and see how it works.
I'll let you know.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bhc" <bhc@.discussions.microsoft.com> wrote in message
news:46E4343F-8FB0-4F09-A582-D7A3F5E9AF0A@.microsoft.com...
> Yes, I have tried using just the generic query designer (that's what I'm
> used
> from RS 2000). It is the generic query designer where I'm having all the
> problems. It's very unreadable and does not parse when MySQL functions
> are
> used in the query even if the generic query designer is the only pane
> displayed. The properties on Query Designer are as follows:
> Distinct Values = No
> Output All Columns= No
> Query Parameter Identification = [nothing here]
> Query Parameter List = [greyed out, no parameters specified]
> Thoughts?
> bhc
> "Bruce L-C [MVP]" wrote:
>> Have you tried going to the generic query designer? I have no doubt you
>> are
>> seeing these problems in the 4 pane graphical query designer. What
>> happens
>> if you switch over to the generic query designer.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "bhc" <bhc@.discussions.microsoft.com> wrote in message
>> news:ABF940A7-4625-4F04-8A88-D26B05E8B78B@.microsoft.com...
>> >I get the following after converting to the new report definition format
>> >when
>> > I access the Data tab:
>> > Error in SELECT clause: alias not recognized.
>> > Error in list of function arguments: 'DataCenter' not recognized.
>> > Error in list of function arguments: ',' not recognized.
>> > Error in list of function arguments: '<' not recognized.
>> > Error in list of function arguments: 'out_month' not recognized.
>> > Unable to parse query text.
>> >
>> > If I let things load in the multi-pane view and use the Verify SQL
>> > button,
>> > a
>> > Microsoft Visual Database Tools window pops up with "The command is not
>> > supported by this provider".
>> >
>> > Having reviewed a few of my report queries facing this issue, I notice
>> > problems only with queries using native MySQL functions, such as
>> > date/time
>> > conversions. All functions have been encapsulated by single quotes, so
>> > instead of 60-SECOND(A.TIMESTAMP), I now have to contend with
>> > 60-'SECOND'(A.TIMESTAMP). Any attempts to remove them are futile; they
>> > simply get inserted when I go to verify the SQL or move out of the
>> > Query
>> > text
>> > pane. Though I get the above errors on other MySQL queries, I am still
>> > able
>> > to run ones without functions in them.
>> >
>> > Is there any way to configure RS to stop doing this? This is just
>> > nasty.
>> > Thanks.
>> > bhc
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Have you tried using the generic query designer (2 panes instead of
>> >> 4). I
>> >> should leave it a alone. It is one of the buttons to the right of the
>> >> ...
>> >> to
>> >> switch to it).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "bhc" <bhc@.discussions.microsoft.com> wrote in message
>> >> news:40DB9C60-A240-4B6E-9020-E79DEBEA613A@.microsoft.com...
>> >> > Yikes! I have upgraded to SQL Server 2005 Developer Edition,
>> >> > including
>> >> > the
>> >> > RS upgrade. The ReportServer and reports all came over and are
>> >> > running
>> >> > fabulously well. However, strange things are happening with my
>> >> > queries
>> >> > in
>> >> > Intelligence Studio (and VS Studio 2005, I've tried both) after
>> >> > being
>> >> > converted to the new report definition format. My extensive queries
>> >> > have
>> >> > been reformatted predominantly as straight-text (very unreadable)
>> >> > and
>> >> > my
>> >> > queries no longer pass SQL verification.
>> >> >
>> >> > I tried retrieving the well-formatted queries from local text file
>> >> > backups,
>> >> > but the new designer continues to reformat it as straight-text.
>> >> >
>> >> > What can I do to get the following format in my queries:
>> >> > Select A,
>> >> > B,
>> >> > C (as string),
>> >> > D
>> >> > From TableA
>> >> > Where [clause]
>> >> >
>> >> > I'm querying against a MySQL 4.0 database with MyODBC 3.5.1 driver.
>> >> >
>> >> > Thanks.
>> >> > bhc
>> >>
>> >>
>> >>
>>|||The way the generic query designer works for me is it leaves everything
exactly the way I type it in. If it has been in the graphical designer it
can get munged up. If you clean it up it should work for you.
The properties you mentioned, I don't see anyplace to see these properties?
Where are you seeing them?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%238%23y%23UW5FHA.724@.TK2MSFTNGP14.phx.gbl...
>I am in the process of upgrading and testing all my reports. I will look at
>some of the more complex ones that go against Sybase and see how it works.
>I'll let you know.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "bhc" <bhc@.discussions.microsoft.com> wrote in message
> news:46E4343F-8FB0-4F09-A582-D7A3F5E9AF0A@.microsoft.com...
>> Yes, I have tried using just the generic query designer (that's what I'm
>> used
>> from RS 2000). It is the generic query designer where I'm having all the
>> problems. It's very unreadable and does not parse when MySQL functions
>> are
>> used in the query even if the generic query designer is the only pane
>> displayed. The properties on Query Designer are as follows:
>> Distinct Values = No
>> Output All Columns= No
>> Query Parameter Identification = [nothing here]
>> Query Parameter List = [greyed out, no parameters specified]
>> Thoughts?
>> bhc
>> "Bruce L-C [MVP]" wrote:
>> Have you tried going to the generic query designer? I have no doubt you
>> are
>> seeing these problems in the 4 pane graphical query designer. What
>> happens
>> if you switch over to the generic query designer.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "bhc" <bhc@.discussions.microsoft.com> wrote in message
>> news:ABF940A7-4625-4F04-8A88-D26B05E8B78B@.microsoft.com...
>> >I get the following after converting to the new report definition
>> >format
>> >when
>> > I access the Data tab:
>> > Error in SELECT clause: alias not recognized.
>> > Error in list of function arguments: 'DataCenter' not recognized.
>> > Error in list of function arguments: ',' not recognized.
>> > Error in list of function arguments: '<' not recognized.
>> > Error in list of function arguments: 'out_month' not recognized.
>> > Unable to parse query text.
>> >
>> > If I let things load in the multi-pane view and use the Verify SQL
>> > button,
>> > a
>> > Microsoft Visual Database Tools window pops up with "The command is
>> > not
>> > supported by this provider".
>> >
>> > Having reviewed a few of my report queries facing this issue, I notice
>> > problems only with queries using native MySQL functions, such as
>> > date/time
>> > conversions. All functions have been encapsulated by single quotes,
>> > so
>> > instead of 60-SECOND(A.TIMESTAMP), I now have to contend with
>> > 60-'SECOND'(A.TIMESTAMP). Any attempts to remove them are futile;
>> > they
>> > simply get inserted when I go to verify the SQL or move out of the
>> > Query
>> > text
>> > pane. Though I get the above errors on other MySQL queries, I am
>> > still
>> > able
>> > to run ones without functions in them.
>> >
>> > Is there any way to configure RS to stop doing this? This is just
>> > nasty.
>> > Thanks.
>> > bhc
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Have you tried using the generic query designer (2 panes instead of
>> >> 4). I
>> >> should leave it a alone. It is one of the buttons to the right of the
>> >> ...
>> >> to
>> >> switch to it).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "bhc" <bhc@.discussions.microsoft.com> wrote in message
>> >> news:40DB9C60-A240-4B6E-9020-E79DEBEA613A@.microsoft.com...
>> >> > Yikes! I have upgraded to SQL Server 2005 Developer Edition,
>> >> > including
>> >> > the
>> >> > RS upgrade. The ReportServer and reports all came over and are
>> >> > running
>> >> > fabulously well. However, strange things are happening with my
>> >> > queries
>> >> > in
>> >> > Intelligence Studio (and VS Studio 2005, I've tried both) after
>> >> > being
>> >> > converted to the new report definition format. My extensive
>> >> > queries
>> >> > have
>> >> > been reformatted predominantly as straight-text (very unreadable)
>> >> > and
>> >> > my
>> >> > queries no longer pass SQL verification.
>> >> >
>> >> > I tried retrieving the well-formatted queries from local text file
>> >> > backups,
>> >> > but the new designer continues to reformat it as straight-text.
>> >> >
>> >> > What can I do to get the following format in my queries:
>> >> > Select A,
>> >> > B,
>> >> > C (as string),
>> >> > D
>> >> > From TableA
>> >> > Where [clause]
>> >> >
>> >> > I'm querying against a MySQL 4.0 database with MyODBC 3.5.1 driver.
>> >> >
>> >> > Thanks.
>> >> > bhc
>> >>
>> >>
>> >>
>>
>|||If you right-click the generic query designer, there's an option for
Properties. Those are the properties I referenced in my previous email.
I have since been poring through the Tools | Options in Report Designer to
see if there's a way to turn off the automatic quotes and perhaps the
straight-text formatting. Any idea what these options might be? Maybe I can
customize Report Designer to behave the way I want/expect.
Thoughts?
"Bruce L-C [MVP]" wrote:
> The way the generic query designer works for me is it leaves everything
> exactly the way I type it in. If it has been in the graphical designer it
> can get munged up. If you clean it up it should work for you.
> The properties you mentioned, I don't see anyplace to see these properties?
> Where are you seeing them?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%238%23y%23UW5FHA.724@.TK2MSFTNGP14.phx.gbl...
> >I am in the process of upgrading and testing all my reports. I will look at
> >some of the more complex ones that go against Sybase and see how it works.
> >I'll let you know.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "bhc" <bhc@.discussions.microsoft.com> wrote in message
> > news:46E4343F-8FB0-4F09-A582-D7A3F5E9AF0A@.microsoft.com...
> >> Yes, I have tried using just the generic query designer (that's what I'm
> >> used
> >> from RS 2000). It is the generic query designer where I'm having all the
> >> problems. It's very unreadable and does not parse when MySQL functions
> >> are
> >> used in the query even if the generic query designer is the only pane
> >> displayed. The properties on Query Designer are as follows:
> >> Distinct Values = No
> >> Output All Columns= No
> >> Query Parameter Identification = [nothing here]
> >> Query Parameter List = [greyed out, no parameters specified]
> >>
> >> Thoughts?
> >> bhc
> >>
> >> "Bruce L-C [MVP]" wrote:
> >>
> >> Have you tried going to the generic query designer? I have no doubt you
> >> are
> >> seeing these problems in the 4 pane graphical query designer. What
> >> happens
> >> if you switch over to the generic query designer.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "bhc" <bhc@.discussions.microsoft.com> wrote in message
> >> news:ABF940A7-4625-4F04-8A88-D26B05E8B78B@.microsoft.com...
> >> >I get the following after converting to the new report definition
> >> >format
> >> >when
> >> > I access the Data tab:
> >> > Error in SELECT clause: alias not recognized.
> >> > Error in list of function arguments: 'DataCenter' not recognized.
> >> > Error in list of function arguments: ',' not recognized.
> >> > Error in list of function arguments: '<' not recognized.
> >> > Error in list of function arguments: 'out_month' not recognized.
> >> > Unable to parse query text.
> >> >
> >> > If I let things load in the multi-pane view and use the Verify SQL
> >> > button,
> >> > a
> >> > Microsoft Visual Database Tools window pops up with "The command is
> >> > not
> >> > supported by this provider".
> >> >
> >> > Having reviewed a few of my report queries facing this issue, I notice
> >> > problems only with queries using native MySQL functions, such as
> >> > date/time
> >> > conversions. All functions have been encapsulated by single quotes,
> >> > so
> >> > instead of 60-SECOND(A.TIMESTAMP), I now have to contend with
> >> > 60-'SECOND'(A.TIMESTAMP). Any attempts to remove them are futile;
> >> > they
> >> > simply get inserted when I go to verify the SQL or move out of the
> >> > Query
> >> > text
> >> > pane. Though I get the above errors on other MySQL queries, I am
> >> > still
> >> > able
> >> > to run ones without functions in them.
> >> >
> >> > Is there any way to configure RS to stop doing this? This is just
> >> > nasty.
> >> > Thanks.
> >> > bhc
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Have you tried using the generic query designer (2 panes instead of
> >> >> 4). I
> >> >> should leave it a alone. It is one of the buttons to the right of the
> >> >> ...
> >> >> to
> >> >> switch to it).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "bhc" <bhc@.discussions.microsoft.com> wrote in message
> >> >> news:40DB9C60-A240-4B6E-9020-E79DEBEA613A@.microsoft.com...
> >> >> > Yikes! I have upgraded to SQL Server 2005 Developer Edition,
> >> >> > including
> >> >> > the
> >> >> > RS upgrade. The ReportServer and reports all came over and are
> >> >> > running
> >> >> > fabulously well. However, strange things are happening with my
> >> >> > queries
> >> >> > in
> >> >> > Intelligence Studio (and VS Studio 2005, I've tried both) after
> >> >> > being
> >> >> > converted to the new report definition format. My extensive
> >> >> > queries
> >> >> > have
> >> >> > been reformatted predominantly as straight-text (very unreadable)
> >> >> > and
> >> >> > my
> >> >> > queries no longer pass SQL verification.
> >> >> >
> >> >> > I tried retrieving the well-formatted queries from local text file
> >> >> > backups,
> >> >> > but the new designer continues to reformat it as straight-text.
> >> >> >
> >> >> > What can I do to get the following format in my queries:
> >> >> > Select A,
> >> >> > B,
> >> >> > C (as string),
> >> >> > D
> >> >> > From TableA
> >> >> > Where [clause]
> >> >> >
> >> >> > I'm querying against a MySQL 4.0 database with MyODBC 3.5.1 driver.
> >> >> >
> >> >> > Thanks.
> >> >> > bhc
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
> >
> >
>
>sql

query execution failed for dataset

have all my reports on a server, and so far have had no problems giving
users access. They are all located in the Cg Role, i created. Here's the
delima, I added a new user and to this role. The user can view report
manager, view the folders, and view the reports..but when they try to run a
report, they get this error.
query execution failed for dataset "CrashStatisticalYear" (rsError
executingcommand)
She has access to everything, why is she the only one getting this error'
Please Help!It seems like she doesnt have access to a specific table inside that
dataset.
"Tenchy" <Tenchy@.discussions.microsoft.com> wrote in message
news:4088044D-2DD6-4FB1-A9BC-59BED72B1C24@.microsoft.com...
> have all my reports on a server, and so far have had no problems giving
> users access. They are all located in the Cg Role, i created. Here's the
> delima, I added a new user and to this role. The user can view report
> manager, view the folders, and view the reports..but when they try to run
> a
> report, they get this error.
>
> query execution failed for dataset "CrashStatisticalYear" (rsError
> executingcommand)
>
> She has access to everything, why is she the only one getting this error'
>
> Please Help!
>

Query execution failed for data set ''RS_MeterReading

Hi,

We are using SQL 2005 server for generating reports.When we ran the reports it taking so much time after some time it shows this error:

ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

Can you help me out.

Thanks,

--Amit

Hi AMITMEENA

Can you check the Report Query whether it contains all valid columns and tables.

This type of Error may Occur when we are trying to Query the Columns that are not related the tables present in the Query

|||

Hi

This looks like Sql query/procedure error. Check the dataset query/procedure in Sql Query analyzer.

Senthil

|||

Yes ,I did this thing also.But When we ran the " StoreProcedure in Queranalyzer it is working fine ..I am getting the data within 10 sec. for all system.But When we ran the same report from reportviewer..we are getting this eror "ERROR: An exception has occurred in data source . Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set . > System.Data.SqlClient.SqlException: A severe error occurred on the current command"

Can give some inputs.

Your inputs would be appreciated.

|||

Could this be a permissions problem? IOW, does the identity executing the query through RS have the permissions it needs to execute the proc?

>L<

|||

can you give me some detail expaination.I didn't understand what does it?

Thanks,

Amit

|||

What didn't you understand? Checking the permissions for a sproc? Or something else in this thread?

>L<

|||

I have also increase the SesionTimeOut upto 6000sec. but still am getting that error.So i am sending the log files of system.here we want to run the Performancereport,it works fine when we ran this report in QueryAnalyzer but when i ran that report in WebReorting am getting that error log files.:--

|||

Does the report run under the credentials of the user or (as probably has to be for a snapshot) are you storing the credentials with/in report server?

It looks like you're creating a snapshot here.

So, under what credentials is that running? And does that identity have permissions to execute this stored procedure in the appropriate database?

(going to bed now, won't see your reply immediately)

>L<

|||I need some more explaination|||

Hi moderator,

Can you delete my all threads from your system.

Thanks

A

|||

My team is also facing similar problem. The RS trace logs report:

w3wp!processing!13!9/26/2007-15:31:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'. > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.

In our system, Report Server and Database are on different machines. Report Server access database using a service account who has stored proc execute permissions on database.

Problem comes only if the query execution time exceeds 5 mins. Otherwise the report gets generated successfully.

I suspected this to be some timeout issue. But I have checked that all timeout settings in rs config files are as default.

Any pointers?

Thanks

puns

pun_iit@.hotmail.com

Query execution failed for data set ''RS_MeterReading

Hi,

We are using SQL 2005 server for generating reports.When we ran the reports it taking so much time after some time it shows this error:

ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

Can you help me out.

Thanks,

--Amit

Hi AMITMEENA

Can you check the Report Query whether it contains all valid columns and tables.

This type of Error may Occur when we are trying to Query the Columns that are not related the tables present in the Query

|||

Hi

This looks like Sql query/procedure error. Check the dataset query/procedure in Sql Query analyzer.

Senthil

|||

Yes ,I did this thing also.But When we ran the " StoreProcedure in Queranalyzer it is working fine ..I am getting the data within 10 sec. for all system.But When we ran the same report from reportviewer..we are getting this eror "ERROR: An exception has occurred in data source . Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set . > System.Data.SqlClient.SqlException: A severe error occurred on the current command"

Can give some inputs.

Your inputs would be appreciated.

|||

Could this be a permissions problem? IOW, does the identity executing the query through RS have the permissions it needs to execute the proc?

>L<

|||

can you give me some detail expaination.I didn't understand what does it?

Thanks,

Amit

|||

What didn't you understand? Checking the permissions for a sproc? Or something else in this thread?

>L<

|||

I have also increase the SesionTimeOut upto 6000sec. but still am getting that error.So i am sending the log files of system.here we want to run the Performancereport,it works fine when we ran this report in QueryAnalyzer but when i ran that report in WebReorting am getting that error log files.:--

|||

Does the report run under the credentials of the user or (as probably has to be for a snapshot) are you storing the credentials with/in report server?

It looks like you're creating a snapshot here.

So, under what credentials is that running? And does that identity have permissions to execute this stored procedure in the appropriate database?

(going to bed now, won't see your reply immediately)

>L<

|||I need some more explaination|||

Hi moderator,

Can you delete my all threads from your system.

Thanks

A

|||

My team is also facing similar problem. The RS trace logs report:

w3wp!processing!13!9/26/2007-15:31:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'. > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.

In our system, Report Server and Database are on different machines. Report Server access database using a service account who has stored proc execute permissions on database.

Problem comes only if the query execution time exceeds 5 mins. Otherwise the report gets generated successfully.

I suspected this to be some timeout issue. But I have checked that all timeout settings in rs config files are as default.

Any pointers?

Thanks

puns

pun_iit@.hotmail.com

Query execution failed for data set ''RS_MeterReading

Hi,

We are using SQL 2005 server for generating reports.When we ran the reports it taking so much time after some time it shows this error:

ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

Can you help me out.

Thanks,

--Amit

Hi AMITMEENA

Can you check the Report Query whether it contains all valid columns and tables.

This type of Error may Occur when we are trying to Query the Columns that are not related the tables present in the Query

|||

Hi

This looks like Sql query/procedure error. Check the dataset query/procedure in Sql Query analyzer.

Senthil

|||

Yes ,I did this thing also.But When we ran the " StoreProcedure in Queranalyzer it is working fine ..I am getting the data within 10 sec. for all system.But When we ran the same report from reportviewer..we are getting this eror "ERROR: An exception has occurred in data source . Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set . > System.Data.SqlClient.SqlException: A severe error occurred on the current command"

Can give some inputs.

Your inputs would be appreciated.

|||

Could this be a permissions problem? IOW, does the identity executing the query through RS have the permissions it needs to execute the proc?

>L<

|||

can you give me some detail expaination.I didn't understand what does it?

Thanks,

Amit

|||

What didn't you understand? Checking the permissions for a sproc? Or something else in this thread?

>L<

|||

I have also increase the SesionTimeOut upto 6000sec. but still am getting that error.So i am sending the log files of system.here we want to run the Performancereport,it works fine when we ran this report in QueryAnalyzer but when i ran that report in WebReorting am getting that error log files.:--

|||

Does the report run under the credentials of the user or (as probably has to be for a snapshot) are you storing the credentials with/in report server?

It looks like you're creating a snapshot here.

So, under what credentials is that running? And does that identity have permissions to execute this stored procedure in the appropriate database?

(going to bed now, won't see your reply immediately)

>L<

|||I need some more explaination|||

Hi moderator,

Can you delete my all threads from your system.

Thanks

A

|||

My team is also facing similar problem. The RS trace logs report:

w3wp!processing!13!9/26/2007-15:31:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'. > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.

In our system, Report Server and Database are on different machines. Report Server access database using a service account who has stored proc execute permissions on database.

Problem comes only if the query execution time exceeds 5 mins. Otherwise the report gets generated successfully.

I suspected this to be some timeout issue. But I have checked that all timeout settings in rs config files are as default.

Any pointers?

Thanks

puns

pun_iit@.hotmail.com

Query execution failed for data set ''RS_MeterReading

Hi,

We are using SQL 2005 server for generating reports.When we ran the reports it taking so much time after some time it shows this error:

ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

Can you help me out.

Thanks,

--Amit

Hi AMITMEENA

Can you check the Report Query whether it contains all valid columns and tables.

This type of Error may Occur when we are trying to Query the Columns that are not related the tables present in the Query

|||

Hi

This looks like Sql query/procedure error. Check the dataset query/procedure in Sql Query analyzer.

Senthil

|||

Yes ,I did this thing also.But When we ran the " StoreProcedure in Queranalyzer it is working fine ..I am getting the data within 10 sec. for all system.But When we ran the same report from reportviewer..we are getting this eror "ERROR: An exception has occurred in data source . Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set . > System.Data.SqlClient.SqlException: A severe error occurred on the current command"

Can give some inputs.

Your inputs would be appreciated.

|||

Could this be a permissions problem? IOW, does the identity executing the query through RS have the permissions it needs to execute the proc?

>L<

|||

can you give me some detail expaination.I didn't understand what does it?

Thanks,

Amit

|||

What didn't you understand? Checking the permissions for a sproc? Or something else in this thread?

>L<

|||

I have also increase the SesionTimeOut upto 6000sec. but still am getting that error.So i am sending the log files of system.here we want to run the Performancereport,it works fine when we ran this report in QueryAnalyzer but when i ran that report in WebReorting am getting that error log files.:--

|||

Does the report run under the credentials of the user or (as probably has to be for a snapshot) are you storing the credentials with/in report server?

It looks like you're creating a snapshot here.

So, under what credentials is that running? And does that identity have permissions to execute this stored procedure in the appropriate database?

(going to bed now, won't see your reply immediately)

>L<

|||I need some more explaination|||

Hi moderator,

Can you delete my all threads from your system.

Thanks

A

|||

My team is also facing similar problem. The RS trace logs report:

w3wp!processing!13!9/26/2007-15:31:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'. > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.

In our system, Report Server and Database are on different machines. Report Server access database using a service account who has stored proc execute permissions on database.

Problem comes only if the query execution time exceeds 5 mins. Otherwise the report gets generated successfully.

I suspected this to be some timeout issue. But I have checked that all timeout settings in rs config files are as default.

Any pointers?

Thanks

puns

pun_iit@.hotmail.com

Query execution failed for data set ''RS_MeterReading

Hi,

We are using SQL 2005 server for generating reports.When we ran the reports it taking so much time after some time it shows this error:

ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

Can you help me out.

Thanks,

--Amit

Hi AMITMEENA

Can you check the Report Query whether it contains all valid columns and tables.

This type of Error may Occur when we are trying to Query the Columns that are not related the tables present in the Query

|||

Hi

This looks like Sql query/procedure error. Check the dataset query/procedure in Sql Query analyzer.

Senthil

|||

Yes ,I did this thing also.But When we ran the " StoreProcedure in Queranalyzer it is working fine ..I am getting the data within 10 sec. for all system.But When we ran the same report from reportviewer..we are getting this eror "ERROR: An exception has occurred in data source . Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set . > System.Data.SqlClient.SqlException: A severe error occurred on the current command"

Can give some inputs.

Your inputs would be appreciated.

|||

Could this be a permissions problem? IOW, does the identity executing the query through RS have the permissions it needs to execute the proc?

>L<

|||

can you give me some detail expaination.I didn't understand what does it?

Thanks,

Amit

|||

What didn't you understand? Checking the permissions for a sproc? Or something else in this thread?

>L<

|||

I have also increase the SesionTimeOut upto 6000sec. but still am getting that error.So i am sending the log files of system.here we want to run the Performancereport,it works fine when we ran this report in QueryAnalyzer but when i ran that report in WebReorting am getting that error log files.:--

|||

Does the report run under the credentials of the user or (as probably has to be for a snapshot) are you storing the credentials with/in report server?

It looks like you're creating a snapshot here.

So, under what credentials is that running? And does that identity have permissions to execute this stored procedure in the appropriate database?

(going to bed now, won't see your reply immediately)

>L<

|||I need some more explaination|||

Hi moderator,

Can you delete my all threads from your system.

Thanks

A

|||

My team is also facing similar problem. The RS trace logs report:

w3wp!processing!13!9/26/2007-15:31:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'. > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.

In our system, Report Server and Database are on different machines. Report Server access database using a service account who has stored proc execute permissions on database.

Problem comes only if the query execution time exceeds 5 mins. Otherwise the report gets generated successfully.

I suspected this to be some timeout issue. But I have checked that all timeout settings in rs config files are as default.

Any pointers?

Thanks

puns

pun_iit@.hotmail.com

Query execution failed for data set ''RS_MeterReading

Hi,

We are using SQL 2005 server for generating reports.When we ran the reports it taking so much time after some time it shows this error:

ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

Can you help me out.

Thanks,

--Amit

Hi AMITMEENA

Can you check the Report Query whether it contains all valid columns and tables.

This type of Error may Occur when we are trying to Query the Columns that are not related the tables present in the Query

|||

Hi

This looks like Sql query/procedure error. Check the dataset query/procedure in Sql Query analyzer.

Senthil

|||

Yes ,I did this thing also.But When we ran the " StoreProcedure in Queranalyzer it is working fine ..I am getting the data within 10 sec. for all system.But When we ran the same report from reportviewer..we are getting this eror "ERROR: An exception has occurred in data source . Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set . > System.Data.SqlClient.SqlException: A severe error occurred on the current command"

Can give some inputs.

Your inputs would be appreciated.

|||

Could this be a permissions problem? IOW, does the identity executing the query through RS have the permissions it needs to execute the proc?

>L<

|||

can you give me some detail expaination.I didn't understand what does it?

Thanks,

Amit

|||

What didn't you understand? Checking the permissions for a sproc? Or something else in this thread?

>L<

|||

I have also increase the SesionTimeOut upto 6000sec. but still am getting that error.So i am sending the log files of system.here we want to run the Performancereport,it works fine when we ran this report in QueryAnalyzer but when i ran that report in WebReorting am getting that error log files.:--

|||

Does the report run under the credentials of the user or (as probably has to be for a snapshot) are you storing the credentials with/in report server?

It looks like you're creating a snapshot here.

So, under what credentials is that running? And does that identity have permissions to execute this stored procedure in the appropriate database?

(going to bed now, won't see your reply immediately)

>L<

|||I need some more explaination|||

Hi moderator,

Can you delete my all threads from your system.

Thanks

A

|||

My team is also facing similar problem. The RS trace logs report:

w3wp!processing!13!9/26/2007-15:31:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'. > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.

In our system, Report Server and Database are on different machines. Report Server access database using a service account who has stored proc execute permissions on database.

Problem comes only if the query execution time exceeds 5 mins. Otherwise the report gets generated successfully.

I suspected this to be some timeout issue. But I have checked that all timeout settings in rs config files are as default.

Any pointers?

Thanks

puns

pun_iit@.hotmail.com

Query execution failed for data set

Hi,

We are using SQL 2005 server for generating reports.When we ran the reports it taking so much time after some time it shows this error:

ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

Can you help me out.

Thanks,

--Amit

Hi AMITMEENA

Can you check the Report Query whether it contains all valid columns and tables.

This type of Error may Occur when we are trying to Query the Columns that are not related the tables present in the Query

|||

Hi

This looks like Sql query/procedure error. Check the dataset query/procedure in Sql Query analyzer.

Senthil

|||

Yes ,I did this thing also.But When we ran the " StoreProcedure in Queranalyzer it is working fine ..I am getting the data within 10 sec. for all system.But When we ran the same report from reportviewer..we are getting this eror "ERROR: An exception has occurred in data source . Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set . > System.Data.SqlClient.SqlException: A severe error occurred on the current command"

Can give some inputs.

Your inputs would be appreciated.

|||

Could this be a permissions problem? IOW, does the identity executing the query through RS have the permissions it needs to execute the proc?

>L<

|||

can you give me some detail expaination.I didn't understand what does it?

Thanks,

Amit

|||

What didn't you understand? Checking the permissions for a sproc? Or something else in this thread?

>L<

|||

I have also increase the SesionTimeOut upto 6000sec. but still am getting that error.So i am sending the log files of system.here we want to run the Performancereport,it works fine when we ran this report in QueryAnalyzer but when i ran that report in WebReorting am getting that error log files.:--

|||

Does the report run under the credentials of the user or (as probably has to be for a snapshot) are you storing the credentials with/in report server?

It looks like you're creating a snapshot here.

So, under what credentials is that running? And does that identity have permissions to execute this stored procedure in the appropriate database?

(going to bed now, won't see your reply immediately)

>L<

|||I need some more explaination|||

Hi moderator,

Can you delete my all threads from your system.

Thanks

A

|||

My team is also facing similar problem. The RS trace logs report:

w3wp!processing!13!9/26/2007-15:31:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'. > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.

In our system, Report Server and Database are on different machines. Report Server access database using a service account who has stored proc execute permissions on database.

Problem comes only if the query execution time exceeds 5 mins. Otherwise the report gets generated successfully.

I suspected this to be some timeout issue. But I have checked that all timeout settings in rs config files are as default.

Any pointers?

Thanks

puns

pun_iit@.hotmail.com

Query execution failed for data set

Hi,

We are using SQL 2005 server for generating reports.When we ran the reports it taking so much time after some time it shows this error:

ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

Can you help me out.

Thanks,

--Amit

Hi AMITMEENA

Can you check the Report Query whether it contains all valid columns and tables.

This type of Error may Occur when we are trying to Query the Columns that are not related the tables present in the Query

|||

Hi

This looks like Sql query/procedure error. Check the dataset query/procedure in Sql Query analyzer.

Senthil

|||

Yes ,I did this thing also.But When we ran the " StoreProcedure in Queranalyzer it is working fine ..I am getting the data within 10 sec. for all system.But When we ran the same report from reportviewer..we are getting this eror "ERROR: An exception has occurred in data source . Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set . > System.Data.SqlClient.SqlException: A severe error occurred on the current command"

Can give some inputs.

Your inputs would be appreciated.

|||

Could this be a permissions problem? IOW, does the identity executing the query through RS have the permissions it needs to execute the proc?

>L<

|||

can you give me some detail expaination.I didn't understand what does it?

Thanks,

Amit

|||

What didn't you understand? Checking the permissions for a sproc? Or something else in this thread?

>L<

|||

I have also increase the SesionTimeOut upto 6000sec. but still am getting that error.So i am sending the log files of system.here we want to run the Performancereport,it works fine when we ran this report in QueryAnalyzer but when i ran that report in WebReorting am getting that error log files.:--

|||

Does the report run under the credentials of the user or (as probably has to be for a snapshot) are you storing the credentials with/in report server?

It looks like you're creating a snapshot here.

So, under what credentials is that running? And does that identity have permissions to execute this stored procedure in the appropriate database?

(going to bed now, won't see your reply immediately)

>L<

|||I need some more explaination|||

Hi moderator,

Can you delete my all threads from your system.

Thanks

A

|||

My team is also facing similar problem. The RS trace logs report:

w3wp!processing!13!9/26/2007-15:31:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'. > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.

In our system, Report Server and Database are on different machines. Report Server access database using a service account who has stored proc execute permissions on database.

Problem comes only if the query execution time exceeds 5 mins. Otherwise the report gets generated successfully.

I suspected this to be some timeout issue. But I have checked that all timeout settings in rs config files are as default.

Any pointers?

Thanks

puns

pun_iit@.hotmail.com

Query execution failed for data set

Hi,

We are using SQL 2005 server for generating reports.When we ran the reports it taking so much time after some time it shows this error:

ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

Can you help me out.

Thanks,

--Amit

Hi AMITMEENA

Can you check the Report Query whether it contains all valid columns and tables.

This type of Error may Occur when we are trying to Query the Columns that are not related the tables present in the Query

|||

Hi

This looks like Sql query/procedure error. Check the dataset query/procedure in Sql Query analyzer.

Senthil

|||

Yes ,I did this thing also.But When we ran the " StoreProcedure in Queranalyzer it is working fine ..I am getting the data within 10 sec. for all system.But When we ran the same report from reportviewer..we are getting this eror "ERROR: An exception has occurred in data source . Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set . > System.Data.SqlClient.SqlException: A severe error occurred on the current command"

Can give some inputs.

Your inputs would be appreciated.

|||

Could this be a permissions problem? IOW, does the identity executing the query through RS have the permissions it needs to execute the proc?

>L<

|||

can you give me some detail expaination.I didn't understand what does it?

Thanks,

Amit

|||

What didn't you understand? Checking the permissions for a sproc? Or something else in this thread?

>L<

|||

I have also increase the SesionTimeOut upto 6000sec. but still am getting that error.So i am sending the log files of system.here we want to run the Performancereport,it works fine when we ran this report in QueryAnalyzer but when i ran that report in WebReorting am getting that error log files.:--

|||

Does the report run under the credentials of the user or (as probably has to be for a snapshot) are you storing the credentials with/in report server?

It looks like you're creating a snapshot here.

So, under what credentials is that running? And does that identity have permissions to execute this stored procedure in the appropriate database?

(going to bed now, won't see your reply immediately)

>L<

|||I need some more explaination|||

Hi moderator,

Can you delete my all threads from your system.

Thanks

A

|||

My team is also facing similar problem. The RS trace logs report:

w3wp!processing!13!9/26/2007-15:31:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'. > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.

In our system, Report Server and Database are on different machines. Report Server access database using a service account who has stored proc execute permissions on database.

Problem comes only if the query execution time exceeds 5 mins. Otherwise the report gets generated successfully.

I suspected this to be some timeout issue. But I have checked that all timeout settings in rs config files are as default.

Any pointers?

Thanks

puns

pun_iit@.hotmail.com

Query execution failed for data set

Hi,

We are using SQL 2005 server for generating reports.When we ran the reports it taking so much time after some time it shows this error:

ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

Can you help me out.

Thanks,

--Amit

Hi AMITMEENA

Can you check the Report Query whether it contains all valid columns and tables.

This type of Error may Occur when we are trying to Query the Columns that are not related the tables present in the Query

|||

Hi

This looks like Sql query/procedure error. Check the dataset query/procedure in Sql Query analyzer.

Senthil

|||

Yes ,I did this thing also.But When we ran the " StoreProcedure in Queranalyzer it is working fine ..I am getting the data within 10 sec. for all system.But When we ran the same report from reportviewer..we are getting this eror "ERROR: An exception has occurred in data source . Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set . > System.Data.SqlClient.SqlException: A severe error occurred on the current command"

Can give some inputs.

Your inputs would be appreciated.

|||

Could this be a permissions problem? IOW, does the identity executing the query through RS have the permissions it needs to execute the proc?

>L<

|||

can you give me some detail expaination.I didn't understand what does it?

Thanks,

Amit

|||

What didn't you understand? Checking the permissions for a sproc? Or something else in this thread?

>L<

|||

I have also increase the SesionTimeOut upto 6000sec. but still am getting that error.So i am sending the log files of system.here we want to run the Performancereport,it works fine when we ran this report in QueryAnalyzer but when i ran that report in WebReorting am getting that error log files.:--

|||

Does the report run under the credentials of the user or (as probably has to be for a snapshot) are you storing the credentials with/in report server?

It looks like you're creating a snapshot here.

So, under what credentials is that running? And does that identity have permissions to execute this stored procedure in the appropriate database?

(going to bed now, won't see your reply immediately)

>L<

|||I need some more explaination|||

Hi moderator,

Can you delete my all threads from your system.

Thanks

A

|||

My team is also facing similar problem. The RS trace logs report:

w3wp!processing!13!9/26/2007-15:31:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'msdb'. > System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.

In our system, Report Server and Database are on different machines. Report Server access database using a service account who has stored proc execute permissions on database.

Problem comes only if the query execution time exceeds 5 mins. Otherwise the report gets generated successfully.

I suspected this to be some timeout issue. But I have checked that all timeout settings in rs config files are as default.

Any pointers?

Thanks

puns

pun_iit@.hotmail.com

Query execution failed

Hi,

I have a group of reports using a shared datasource. Going to the preview of the report works fine in the report designer, but when I try and view it from a browser (deployed on a website), it gives the error:

"An error has occurred during report processing.

Query execution failed for data set 'DataSet1_ticketInfo'.

Failed to parse SQL.[long sql query here]"

If there's a problem with it, I don't get why it works in preview mode. I'm using SQL server 2005.

Thanks.
Hi,

Can you provide some more details about your Report

1) 'DataSet1_ticketInfo' - Is this your main DataSet ie; the result of this DS is used on the Report body OR
2) Are you using 'DataSet1_ticketInfo' DS for populating Report Parameters OR
3) Your DS contains some script (query or Stored Proc) that requires special permissions to be executed through your asp.net web-site

I think you may be missing some params used by above mentioned DS, which may be causing the error.

Regards,
abhi_viking

|||That dataset is the main dataset for the report. One of these reports (all are having the same problem) does take parameters, but I have a default value set, which actually shows up in the datepicker correctly. This particular dataset doesn't take any parameters. The actual report doesn't load however (but does in preview)

|||

Hi,

Are you using some code that requires permission to be executed thro' your asp.net website?

If possible, do paste ur DS code here, that might help us solve your issue.

Regards,

abhi_viking

|||How would I get the actual code of the DS? Just to be clear, this is a server report, not a client one. I've verified that the conn. string is correct and does connect ok.
|||After talking to MS support, it seems that if you use a column name alias (ie "as") in the select statement, the report viewer refuses to parse the SQL. It seems to be some sort of bug. We were able to get around it by having the report run a stored procedure, which allowed the column names. Hope this helps anyone else that runs into this issue.

Query execution failed

Hi,

I have a group of reports using a shared datasource. Going to the preview of the report works fine in the report designer, but when I try and view it from a browser (deployed on a website), it gives the error:

"An error has occurred during report processing.

Query execution failed for data set 'DataSet1_ticketInfo'.

Failed to parse SQL.[long sql query here]"

If there's a problem with it, I don't get why it works in preview mode. I'm using SQL server 2005.

Thanks.
Hi,

Can you provide some more details about your Report

1) 'DataSet1_ticketInfo' - Is this your main DataSet ie; the result of this DS is used on the Report body OR
2) Are you using 'DataSet1_ticketInfo' DS for populating Report Parameters OR
3) Your DS contains some script (query or Stored Proc) that requires special permissions to be executed through your asp.net web-site

I think you may be missing some params used by above mentioned DS, which may be causing the error.

Regards,
abhi_viking

|||That dataset is the main dataset for the report. One of these reports (all are having the same problem) does take parameters, but I have a default value set, which actually shows up in the datepicker correctly. This particular dataset doesn't take any parameters. The actual report doesn't load however (but does in preview)

|||

Hi,

Are you using some code that requires permission to be executed thro' your asp.net website?

If possible, do paste ur DS code here, that might help us solve your issue.

Regards,

abhi_viking

|||How would I get the actual code of the DS? Just to be clear, this is a server report, not a client one. I've verified that the conn. string is correct and does connect ok.
|||After talking to MS support, it seems that if you use a column name alias (ie "as") in the select statement, the report viewer refuses to parse the SQL. It seems to be some sort of bug. We were able to get around it by having the report run a stored procedure, which allowed the column names. Hope this helps anyone else that runs into this issue.

Query execution failed

Hi,

I have a group of reports using a shared datasource. Going to the preview of the report works fine in the report designer, but when I try and view it from a browser (deployed on a website), it gives the error:

"An error has occurred during report processing.

Query execution failed for data set 'DataSet1_ticketInfo'.

Failed to parse SQL.[long sql query here]"

If there's a problem with it, I don't get why it works in preview mode. I'm using SQL server 2005.

Thanks.
Hi,

Can you provide some more details about your Report

1) 'DataSet1_ticketInfo' - Is this your main DataSet ie; the result of this DS is used on the Report body OR
2) Are you using 'DataSet1_ticketInfo' DS for populating Report Parameters OR
3) Your DS contains some script (query or Stored Proc) that requires special permissions to be executed through your asp.net web-site

I think you may be missing some params used by above mentioned DS, which may be causing the error.

Regards,
abhi_viking

|||That dataset is the main dataset for the report. One of these reports (all are having the same problem) does take parameters, but I have a default value set, which actually shows up in the datepicker correctly. This particular dataset doesn't take any parameters. The actual report doesn't load however (but does in preview)

|||

Hi,

Are you using some code that requires permission to be executed thro' your asp.net website?

If possible, do paste ur DS code here, that might help us solve your issue.

Regards,

abhi_viking

|||How would I get the actual code of the DS? Just to be clear, this is a server report, not a client one. I've verified that the conn. string is correct and does connect ok.
|||After talking to MS support, it seems that if you use a column name alias (ie "as") in the select statement, the report viewer refuses to parse the SQL. It seems to be some sort of bug. We were able to get around it by having the report run a stored procedure, which allowed the column names. Hope this helps anyone else that runs into this issue.

Query Engine Error again

I have crystal reports in my VS2005 project. We have wrapped dll for report printing, but using version 9.2.3300.0. So I got Error "Query Engine Error" when printing. If I use Crystal Reports 10.2.3600.0, It works fine.
How can I print report (10.2.3600.0) by wrapped dll (9.2.3300.0)?Did you miss any dlls?
Do very database and check

Query Engine Error

Hi
We have a table change in the DB2 database. I mean an old table
is being replaced with a new one. I updated the reports by
replacing the old table column names with the new ones in all
the reports. all the reports are running fine. there's one
report which is giving Query Engine Error. it pops up a window
which says 'The Query can not be performed. An illegal link
cycle was detected'.Please help me in finding out the issue.
Thanks in Advance

Regards
MadhaviDid you verify database inside your report file?|||I did verify. And its not showing any error. But i am not able to see the SQL also.
When i say 'Show SQL' i get the same error as when i run the report.|||I did verify. And its not showing any error. But i am not able to see the SQL also.
When i say 'Show SQL' i get the same error as when i run the report.
If you couldn't see the SQL statement, it means that table structure inside
rpt file corrupted. You need to recreate them.

Query based parameter value changes back to default value

I have several parameters on my report, some have non-queried lists, and
some have queried lists. All of them have default values. When I ran
reports on the Report Manager, I changed the value of the parameters from
the drop-down list to produce different reports. My problem is whenever I
changed the value of a parameter(pA), the value of those queried-based
parameters that were listed after pA would switch back to their respective
default values. This didn't happen when I previewed reports on Visual
Studio .Net Development Environment. Is this a bug, limitation, or am I
missing something?
Any help would be appreciated.
Paul
--
Message posted via http://www.sqlmonster.comPaul,
It sounds like your default values are calculated values (begin with a '=').
The way that RS computes these is that whenever you change a parameter, it
recalculates all the calculated parameters after it. This behaviour is to
allow cascading parameters. As far as I know, there is no way to turn this
calculation off. However, I worked around it by creating another dataset
which had a column for each default value (I do a lot of default dates). You
can then set the default values for the parameters to the dataset value in
the parameters window. I have to use SQL to do the calculations, but for
most things, this should be an easy workaround. It gets rid of the changing
values and also the refresh that takes place when you change calculated
parameters
"Paul via SQLMonster.com" wrote:
> I have several parameters on my report, some have non-queried lists, and
> some have queried lists. All of them have default values. When I ran
> reports on the Report Manager, I changed the value of the parameters from
> the drop-down list to produce different reports. My problem is whenever I
> changed the value of a parameter(pA), the value of those queried-based
> parameters that were listed after pA would switch back to their respective
> default values. This didn't happen when I previewed reports on Visual
> Studio .Net Development Environment. Is this a bug, limitation, or am I
> missing something?
> Any help would be appreciated.
> Paul
> --
> Message posted via http://www.sqlmonster.com
>|||Hi David, that works great. Thank you very much!!
Paul
--
Message posted via http://www.sqlmonster.com