Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||

I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||

I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||

I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||

I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?sql

Report Builder - TimeOut while creating model

How can I avoid the connection TimeOuts while creating a model for Report
Builder? The databases we're using are pretty big (100s of tables) and in
the millions of rows. Is Report Builder just not up for this kind of
processes?Are you trying to create a model that has 100s of tables? The whole point of
Report Builder is to make reporting easier for end users. So why not create
different models that have the data that different users/groups need access
to? (each model having only a few tables, not 100s.) Also, with that much
data, have you considered analysis services?
Mike G.
"SYoung" <SYoung@.discussions.microsoft.com> wrote in message
news:73F8298C-DE21-4F2D-B11B-CF11F284F9A6@.microsoft.com...
> How can I avoid the connection TimeOuts while creating a model for Report
> Builder? The databases we're using are pretty big (100s of tables) and in
> the millions of rows. Is Report Builder just not up for this kind of
> processes?|||I kept timing out while trying to deploy a model and found out the
deployment was being blocked by another process which was 'getting
model information'...the process was hung up for two days before I
found it.