Query giving error path not found

Hi,
Can any 1 tell why this query is giving error when it is coming to
last to database i.e test and model. It is giving error as path could
not be found. For 1st 2 database also path is same but that time it is
working fine. It will be a great help if u will run and see what is
the error.
ALTER proc [dbo].[backup_proc5] @.para2 varchar(120)
As
declare @.str varchar(50),@.var1 varchar(20),@.para1 varchar(100)
declare @.str1 varchar(200),@.sql varchar(8000)
select @.str='Adventureworks,Adventureworksdw,test,model'
while(1 <> 2)
begin
select @.var1=substring(@.str,0,charindex(',',@.str))
if (@.var1='')
begin
break
end
select @.para1=@.var1
SET @.sql= 'mkdir "'+@.para2+'\'+@.para1+'" '
exec master.dbo.xp_cmdshell @.sql
declare @.datetime nvarchar(20)
SELECT @.datetime = @.para1+'_db_'+CONVERT(VARCHAR, GETDATE(),111)
set @.str1='backup database '+ @.para1 +' to disk ='''+ @.para2 + '\' +
@.para1 + '\' + @.datetime +'.bak'''
exec(@.str1)
print @.str1
select @.str=right(@.str,len(@.str)-len(substring(@.str,
1,charindex(',',@.str))))
end
select @.para1=@.str
SELECT @.datetime = @.para1+'_db_'+CONVERT(VARCHAR, GETDATE(),111)
set @.str1='backup database '+ @.para1 +' to disk ='''+ @.para2 + '\' +
@.para1 + '\' + @.datetime +'.bak'''
exec(@.str1)
You are using relative paths and assuming that xp_cmdshell and BACKUP use
the same default directory. On my server, xp_cmdshell uses the
C:\Windows\System32 directory by default but this may be different in your
environment. BACKUP will use the SQL Server default backup folder.
I suggest you fully-qualify the backup path to avoid this issue.
Hope this helps.
Dan Guzman
SQL Server MVP
"mohit" <goenka.mohit@.gmail.com> wrote in message
news:b9dc3c61-ea2e-4607-b165-e0dd18e0f243@.s12g2000prg.googlegroups.com...
> Hi,
> Can any 1 tell why this query is giving error when it is coming to
> last to database i.e test and model. It is giving error as path could
> not be found. For 1st 2 database also path is same but that time it is
> working fine. It will be a great help if u will run and see what is
> the error.
> ALTER proc [dbo].[backup_proc5] @.para2 varchar(120)
> As
> declare @.str varchar(50),@.var1 varchar(20),@.para1 varchar(100)
> declare @.str1 varchar(200),@.sql varchar(8000)
> select @.str='Adventureworks,Adventureworksdw,test,model'
> while(1 <> 2)
> begin
> select @.var1=substring(@.str,0,charindex(',',@.str))
> if (@.var1='')
> begin
> break
> end
> select @.para1=@.var1
> SET @.sql= 'mkdir "'+@.para2+'\'+@.para1+'" '
> exec master.dbo.xp_cmdshell @.sql
> declare @.datetime nvarchar(20)
> SELECT @.datetime = @.para1+'_db_'+CONVERT(VARCHAR, GETDATE(),111)
> set @.str1='backup database '+ @.para1 +' to disk ='''+ @.para2 + '\' +
> @.para1 + '\' + @.datetime +'.bak'''
> exec(@.str1)
> print @.str1
> select @.str=right(@.str,len(@.str)-len(substring(@.str,
> 1,charindex(',',@.str))))
> end
> select @.para1=@.str
> SELECT @.datetime = @.para1+'_db_'+CONVERT(VARCHAR, GETDATE(),111)
> set @.str1='backup database '+ @.para1 +' to disk ='''+ @.para2 + '\' +
> @.para1 + '\' + @.datetime +'.bak'''
> exec(@.str1)

Query giving error path not found

Hi,
Can any 1 tell why this query is giving error when it is coming to
last to database i.e test and model. It is giving error as path could
not be found. For 1st 2 database also path is same but that time it is
working fine. It will be a great help if u will run and see what is
the error.
ALTER proc [dbo].[backup_proc5] @.para2 varchar(120)
As
declare @.str varchar(50),@.var1 varchar(20),@.para1 varchar(100)
declare @.str1 varchar(200),@.sql varchar(8000)
select @.str='Adventureworks,Adventureworksdw,test,model'
while(1 <> 2)
begin
select @.var1=substring(@.str,0,charindex(',',@.str))
if (@.var1='')
begin
break
end
select @.para1=@.var1
SET @.sql= 'mkdir "'+@.para2+'\'+@.para1+'" '
exec master.dbo.xp_cmdshell @.sql
declare @.datetime nvarchar(20)
SELECT @.datetime = @.para1+'_db_'+CONVERT(VARCHAR, GETDATE(),111)
set @.str1='backup database '+ @.para1 +' to disk ='''+ @.para2 + '\' +
@.para1 + '\' + @.datetime +'.bak'''
exec(@.str1)
print @.str1
select @.str=right(@.str,len(@.str)-len(substring(@.str,
1,charindex(',',@.str))))
end
select @.para1=@.str
SELECT @.datetime = @.para1+'_db_'+CONVERT(VARCHAR, GETDATE(),111)
set @.str1='backup database '+ @.para1 +' to disk ='''+ @.para2 + '\' +
@.para1 + '\' + @.datetime +'.bak'''
exec(@.str1)You are using relative paths and assuming that xp_cmdshell and BACKUP use
the same default directory. On my server, xp_cmdshell uses the
C:\Windows\System32 directory by default but this may be different in your
environment. BACKUP will use the SQL Server default backup folder.
I suggest you fully-qualify the backup path to avoid this issue.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"mohit" <goenka.mohit@.gmail.com> wrote in message
news:b9dc3c61-ea2e-4607-b165-e0dd18e0f243@.s12g2000prg.googlegroups.com...
> Hi,
> Can any 1 tell why this query is giving error when it is coming to
> last to database i.e test and model. It is giving error as path could
> not be found. For 1st 2 database also path is same but that time it is
> working fine. It will be a great help if u will run and see what is
> the error.
> ALTER proc [dbo].[backup_proc5] @.para2 varchar(120)
> As
> declare @.str varchar(50),@.var1 varchar(20),@.para1 varchar(100)
> declare @.str1 varchar(200),@.sql varchar(8000)
> select @.str='Adventureworks,Adventureworksdw,test,model'
> while(1 <> 2)
> begin
> select @.var1=substring(@.str,0,charindex(',',@.str))
> if (@.var1='')
> begin
> break
> end
> select @.para1=@.var1
> SET @.sql= 'mkdir "'+@.para2+'\'+@.para1+'" '
> exec master.dbo.xp_cmdshell @.sql
> declare @.datetime nvarchar(20)
> SELECT @.datetime = @.para1+'_db_'+CONVERT(VARCHAR, GETDATE(),111)
> set @.str1='backup database '+ @.para1 +' to disk ='''+ @.para2 + '\' +
> @.para1 + '\' + @.datetime +'.bak'''
> exec(@.str1)
> print @.str1
> select @.str=right(@.str,len(@.str)-len(substring(@.str,
> 1,charindex(',',@.str))))
> end
> select @.para1=@.str
> SELECT @.datetime = @.para1+'_db_'+CONVERT(VARCHAR, GETDATE(),111)
> set @.str1='backup database '+ @.para1 +' to disk ='''+ @.para2 + '\' +
> @.para1 + '\' + @.datetime +'.bak'''
> exec(@.str1)

Query generates failures: Error 3624, Error 5180, or Error 823 when run without MAXDOP 1,

Posting the details of this situation so that others (including Microsoft)
are aware...
We had a simple query such as this on a multi-processor SQL Server:
SELECT count(*) FROM [Northwind].[dbo].[Orders] WHERE ShipRegion IS NULL
That would generate various severe errors (3624, 5180, 823), some of which
at first appeared to be hardware related. The errors were not generated if
the query were run with OPTION (MAXDOP 1). In the end a DBCC REINDEX of a
particular index on the table involved in the query fixed the problem,
although DBCC checks never indicated any problem with indexes.
Symptoms:
--
1. A stack dump indicating a failed assertion in file recbase.cpp
2. One of the following before the stack dump:
A. Error 3624 (retail assertion) of severity 20 (fatal error in current
process) that has follow-up message indicating the cause of the error, i.e.,
just "Error: 3624, Severity: 20, State: 1".
B. Error 5180 (could not open FCB for invalid file) of severity 22 (fatal
error, table integrity suspect) such as the following: "Error: 5180,
Severity: 22, State: 1 <next log entry> Could not open FCB for invalid file
ID 768 in database 'Northwind' ".
C. Error 823 (I/O error) of severity 24 (hardware error) such as the
following: "Error: 823, Severity: 24, State: 2 <new log entry> I/O error
38(Reached the end of the file.) detected during read at offset
0x00002000600000 in file 'C:\Program Files\Microsoft SQL
Server\MSSQL\Northwind.MDF' ".
3. The offending command that generated the initial failed assertion
continues to throw one of three errors listed above on subsequent
executions.
4. There are no hardware-related events in the Windows/NT Event Log.
5. The offending command uses parallelism.
6. When the offending command is run with OPTION (MAXDOP 1) to force serial
execution, it does not throw an error.
7. The following commands do not detect any integrity errors: DBCC
CHECKDB, DBCC CHECKCATALOG, DBCC CHECKTABLE (table only or table plus index
arguments), and DBCC CHECKFILEGROUP.
Investigation Notes:
--
1. Issue came up with the following statement sql statement
SELECT count(*) FROM [Northwind].[dbo].[Orders] WHERE ShipRegion IS NULL
2. Adding OPTION (MAXDOP 1) brought back results
3. Adding WITH (NOLOCK) had no effect.
4. Individual column names were substituted for the * in the SELECT clause.
The results were mixed: some executions brought back results and others
returned one of the errors listed in the Symptoms above. Checking the
execution plans for all the variants using the MAXDOP option (so that the
actual plan could be retrieved, not just the planned one) revealed that the
failing ones all used a particular nonclustered index while the successful
ones used the clustered index.
5. When running the DBCC CHECK commands listed in the symptoms to try to
rectify the issue, the filegroup and indid of the problem index where used
where possible (in addition to the more generic executions with just a table
name). No DBCC commands revealed any integrity errors, though, regardless
of whether they used the table name or the table name plus the
filegroup/index.
Resolution:
--
DBCC REINDEX of the problematic index resolved the issue without
serialization of the query plan (MAXDOP 1). Once working, the actual
execution plan was checked to ensure it used parallelism; it did.
Subsequent tests with OPTION (MAXDOP 1) continued to work, as did the
inclusion/omission of locking hints like (NOLOCK).Hi Frank,
Thans for sharing your experience with MSDN Newsgroup!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
---
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

query failure

I've got an email from one of the users complaining about query failure. He
is doing queries using MS ACCESS. He is getting the following error message:
ODBC - call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server] Could not allocate new page
for database 'TEMPDB'. There are no more pages available in filegroup
DEFAULT. Space can be created by dropping objects, adding additional files,
or allowing file growth. (#1101)
However, the TEMPDB is 60MB in size with 59MB free. It has unrestricted
growth as well. Any suggestions?
Thanks in advance,
Antonin
The answer is in the message you've got. TempDB has grown and there is no disk space to continue growth.
|||Thanks Ray. I cleaned up the disk and the problem is gone.
Antonin
"Ray D" <ray_d@.mail.ru> wrote in message
news:05B82F27-73AB-4EAA-A10E-4A46A67C71D2@.microsoft.com...
> The answer is in the message you've got. TempDB has grown and there is no
disk space to continue growth.

query failure

I've got an email from one of the users complaining about query failure. He
is doing queries using MS ACCESS. He is getting the following error message:
ODBC - call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server] Could not allocate new page
for database 'TEMPDB'. There are no more pages available in filegroup
DEFAULT. Space can be created by dropping objects, adding additional files,
or allowing file growth. (#1101)
However, the TEMPDB is 60MB in size with 59MB free. It has unrestricted
growth as well. Any suggestions?
Thanks in advance,
AntoninThe answer is in the message you've got. TempDB has grown and there is no disk space to continue growth.|||Thanks Ray. I cleaned up the disk and the problem is gone.
Antonin
"Ray D" <ray_d@.mail.ru> wrote in message
news:05B82F27-73AB-4EAA-A10E-4A46A67C71D2@.microsoft.com...
> The answer is in the message you've got. TempDB has grown and there is no
disk space to continue growth.

query failure

I've got an email from one of the users complaining about query failure. He
is doing queries using MS ACCESS. He is getting the following error message:
ODBC - call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server] Could not alloca
te new page
for database 'TEMPDB'. There are no more pages available in filegroup
DEFAULT. Space can be created by dropping objects, adding additional files,
or allowing file growth. (#1101)
However, the TEMPDB is 60MB in size with 59MB free. It has unrestricted
growth as well. Any suggestions?
Thanks in advance,
AntoninThe answer is in the message you've got. TempDB has grown and there is no di
sk space to continue growth.|||Thanks Ray. I cleaned up the disk and the problem is gone.
Antonin
"Ray D" <ray_d@.mail.ru> wrote in message
news:05B82F27-73AB-4EAA-A10E-4A46A67C71D2@.microsoft.com...
> The answer is in the message you've got. TempDB has grown and there is no
disk space to continue growth.

Query Execution failed for dataset error / the syntax for " " is incorrect

Hi,

Am totally new to MDX Queries.

I got this error while previewing a report that we had made. It goes like this --

Query execution failed for dataset 'some_dataset'.

Parser: the syntax for 'some_character' is incorrect.

What was figured out was this error shows up only for those values in a particular dropdown list which are multiword. Eg : My Company Technology and not for those values which a re single word. Eg : Company

what could be the possible problem and the solution to that.

Try to use [My Company Technology] as parameter value.|||

I dont wish to hard code the values.

It should be dynamic

|||

Hi Madu,

here you can find the rules for the identifiers in MDX:

http://msdn2.microsoft.com/en-us/library/ms145572.aspx

Query Execution Failed for Dataset (Beginner)

I got this Error, Query Execution for Dataset 'Source'.

When i try to run a report that is actually a drillthrough from another report. It runs fine in Report Designer, and when i deploy to my Local server. But when i deploy it to my virtual Report Server, I get this error messege. Why is it doing this? and where can i see errors for this type of stuff, so i can figure this out. This uses the same Datasource as the report linked from it. That report works fine, why wont this one? any ideas?

Look for the report server log at this location C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles if installed to the default location.|||A collegue of mine helped me figure this one out. My stored procedure was not set to public in the properties section. Thats why it worked on my local computer and not on the report server.

Query execution failed for data set...

Hi,
Query execution failed for data set<dataset name>
Does anyone know why this error could be coming up? If I log in as a member
of the Administrators group the report runs fine.If I run it as a user that
I have given every permission to (Browser, Content Manager, etc.) I get the
error.
TIA,
Jarryd.On Jul 20, 7:14 am, "Jarryd" <jar...@.community.nospam> wrote:
> Hi,
> Query execution failed for data set<dataset name>
> Does anyone know why this error could be coming up? If I log in as a member
> of the Administrators group the report runs fine.If I run it as a user that
> I have given every permission to (Browser, Content Manager, etc.) I get the
> error.
> TIA,
> Jarryd.
You will want to make sure that the default DB user account that the
report is running under has execute permissions on the stored
procedure in the dataset, if you're using one. If you're not using
one, make sure that the default DB user account has select permissions
on any tables used in the query. Note that DB user account/permissions
are not the same as Report Manager/Windows user account/permissions.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||You nailed it dude. Thanks for that.
Jarryd
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1184936231.667037.306150@.22g2000hsm.googlegroups.com...
> On Jul 20, 7:14 am, "Jarryd" <jar...@.community.nospam> wrote:
>> Hi,
>> Query execution failed for data set<dataset name>
>> Does anyone know why this error could be coming up? If I log in as a
>> member
>> of the Administrators group the report runs fine.If I run it as a user
>> that
>> I have given every permission to (Browser, Content Manager, etc.) I get
>> the
>> error.
>> TIA,
>> Jarryd.
>
> You will want to make sure that the default DB user account that the
> report is running under has execute permissions on the stored
> procedure in the dataset, if you're using one. If you're not using
> one, make sure that the default DB user account has select permissions
> on any tables used in the query. Note that DB user account/permissions
> are not the same as Report Manager/Windows user account/permissions.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

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 <name> For more information about this error navigate

I have created and deployed my first report. It renders fine for me and the other database admin. When others attempt to view it, we get the error

Query execution failed for data set 'periods'. (rsErrorExecutingCommand), For more information about this error navigate to the report server on the local server machine, or enable remote errors

Initially, We created a local group on the machine that hosts both the database and webserver and added the individuals to that group. Then, within SRS Report manager, we added that group to the Browswer role of the report.

The error message was slightly different, in that it couldn't even open the Datasource.

We then added an individual to the database as dbreader, and got the above message. It apprently is starting to render, and when it encounters the first query (dataset "periods", which populates a drop down list for a parameter), it chokes. BTW, the Periods dataset executes a stored procedure dbo.Period_List that has no parameters. It returns a list of reporting periods.

I could not figure out how to "enable remote errors" or find an error log on the server. The C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles Log files did not appear to record any errors.

Please advise!

Have you given execute permissions on the stored procedure? You can try troubleshooting with SQL Server Profiler (http://msdn2.microsoft.com/en-us/library/ms187929.aspx), but that might be like hitting a gnat with a sledge hammer.

Larry

|||

I want to add some information. We recently enabled remote errors, and found that EXECUTE permission on the stored procedure was denied.

Does this mean that we have to grant permissions on every stored procedure to User Groups?

I love SRS, but this is turning into an Admin nightmare.

|||

Ok, let's back up a second and take another run at this. As long as you don't require the data on your reports to change based on who is viewing them, use a shared DataSource with stored credentials (http://technet.microsoft.com/en-us/library/ms178308.aspx). That way, you admin a single user and everyone (including you during development) sees the same report.

To continue to use Windows Authentication, yes, you would need to grant permissions for every stored procedure that you want SSRS to use to any user that will run a report using that stored procedure.

Larry

|||

thank you!

Ok, the first option sounds like the way to go for the moment, but something you said intrigued me...

"As long as you don't require the data on your reports to change based on who is viewing them..."

Actually, we would like to restrict what the users see based upon who they are, and haven't figured out how to do that yet. For example, if a person is from business unit A, we would like them only to see their business units data. All business units are in the same table however, so we would have to use a parameter or a filter, based upon the longin User ID. Not sure how to do this, any ideas?

|||

Well, you could implement row level security to filter the results returned based on the user. Here is a tutorial from Books On Line (BOL) (http://msdn2.microsoft.com/en-us/library/ms365305.aspx) and here is a white paper discussing it (http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx). It is a bit complex to get setup, but the results are well worth the effort.

Larry

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