Page 1 of 2

Timeout problem

Posted: Fri Oct 15, 2010 10:31 am
by fuhrj
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?

Timeout problem

Posted: Fri Oct 15, 2010 12:25 pm
by Jan
Hello,

Can you show full error stack of this error?

Thank you.

Timeout problem

Posted: Fri Oct 15, 2010 2:52 pm
by fuhrj
Jan wrote:Hello,

Can you show full error stack of this error?

Thank you.
I've attached a screenshot with the stacktrace:

Image



Timeout problem

Posted: Mon Oct 18, 2010 4:35 am
by Jan
Hello,

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

Thank you.

Timeout problem

Posted: Mon Oct 18, 2010 4:07 pm
by fuhrj
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

Timeout problem

Posted: Mon Oct 18, 2010 4:09 pm
by fuhrj
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

Timeout problem

Posted: Tue Oct 19, 2010 12:01 pm
by fuhrj
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?

Timeout problem

Posted: Wed Oct 20, 2010 3:48 am
by Alex K.
Hello,

Prerelease build already available for download on our site.

Thank you.

Timeout problem

Posted: Wed Oct 20, 2010 2:59 pm
by fuhrj
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.

Timeout problem

Posted: Fri Oct 22, 2010 2:10 am
by Alex K.
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.