System.OutOfMemoryException and Query Timeout Expired

[mihiri2]

Hi,

I have a Stimulsoft report which is on SS2011.1.919 version.
The report can be run as a summary (in which case data are first inserted in to a Temporary table in Report Begin Render Event) or detail report(which uses Data sources directly).
My issue is When run for a large range of data
1. Summary gives Query Timeout Expired Error
2. Detail gives Exception of type 'System.OutOfMemoryException' was thrown Error.

How ever these queries run fine on SQL Server Management Studio, takes in average 5 minutes.

Could you please explain what can be causing these issues and why I do get different errors on the two scenarios?
What can I do to avoid the errors. Please note the report data sources Command Time out Property is already 6000.


Thanks

[Alex K.]

Hello,

Can you please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

[mihiri2]

Hi Aleksey,

I am afraid I can not send you data on this case as it is on our Production system and that is our client confidential data.

Any other suggestions as to what could be causing this and how to prevent it?

Thanks

[Alex K.]

Hello,

It is difficult to say something without sample which reproduces the issue.
Can you please prepare a sample with Demo data, for example Northwind sample MSSQL database.

Thank you.