Timeout problem

fuhrj · Post by **fuhrj** » Fri Oct 15, 2010 10:31 am

I've written a query that returns rows under 30 seconds if I execute it in SQL Management Studio.

However, when I used the same query in my report, I get a SQL timeout exception.

I've tried increasing the Command Timeout property on the datasource, but it doesn't help.

The report is not complex. It is using the CountIf and Sum functions to summarize several columns.

What else can I check or change to get past this problem?

Post by **Jan** » Fri Oct 15, 2010 12:25 pm

Hello,

Can you show full error stack of this error?

Thank you.

fuhrj · Post by **fuhrj** » Fri Oct 15, 2010 2:52 pm

Jan wrote:Hello,

Can you show full error stack of this error?

Thank you.

I've attached a screenshot with the stacktrace:

Post by **Jan** » Mon Oct 18, 2010 4:35 am

Hello,

We have changed our source code. Please check build from 19 Oct when it will be available.

Thank you.

fuhrj · Post by **fuhrj** » Mon Oct 18, 2010 4:07 pm

Jan wrote:Hello,

We have changed our source code. Please check build from 19 Oct when it will be available.

Thank you.

Thanks Jan.

Will I be able to distribute the new Stimulsoft.Report assemblies to my customer without having to rebuild our application?

The assembly versions that we have distributed with our app is 2010.2.730.0

fuhrj · Post by **fuhrj** » Mon Oct 18, 2010 4:09 pm

Jan wrote:Hello,

We have changed our source code. Please check build from 19 Oct when it will be available.

Thank you.

Thanks Jan.

Will I be able to distribute the new Stimulsoft.Report assemblies to my customer without having to rebuild our application?

The assembly versions that we have distributed with our app is 2010.2.730.0

fuhrj · Post by **fuhrj** » Tue Oct 19, 2010 12:01 pm

Jan wrote:Hello,

We have changed our source code. Please check build from 19 Oct when it will be available.

Thank you.

Where do I check for this information?

Post by **Alex K.** » Wed Oct 20, 2010 3:48 am

Hello,

Prerelease build already available for download on our site.

Thank you.

fuhrj · Post by **fuhrj** » Wed Oct 20, 2010 2:59 pm

I downloaded the 2010.3.20 build which contains version 2010.3.803.0 and rebuilt my application.

I am still getting the timeout error.

What else could I try checking or changing?

Thanks.

Post by **Alex K.** » Fri Oct 22, 2010 2:10 am

Hello,

Please let us know when the error occur after running the report? And how many entries in the tables are used in the report?
Please send us your .MRT file with database for analysis.

Thank you.