timed out error when running a report

[Former Member]

The error is:

"Request timed out because there has been no reply from the server in 600000 ms"

Does anybody have any idea how to solve the issue?

The following is more info on the report:

Report has 8 subreports and data set is around 7MB size

We generated another report with 83MB of data and this report doesn't have any subreports and its running completely.

using Crystal reports XI r2 SP3, Visual studio 9, BOXI server SP3 and using XML as data source.

Any help would be appreciated.

The following is the Stack Trace:

System.Exception was unhandled by user code

Message="Load report failed."

Source="CrystalDecisions.CrystalReports.Engine"

StackTrace:

at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()

at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, EnterpriseSession enterpriseSession)

at Covance.ED.Framework.Reporting.Workflow.CreateReportOutputActivity.executeCrystalReport_ExecuteCode(Object sender, EventArgs e) in C:\Source\TR\Components\Framework\Covance.ED.Framework.Reporting\Workflow\CreateReportOutputActivity.cs:line 189

at System.Workflow.ComponentModel.Activity.RaiseEvent(DependencyProperty dependencyEvent, Object sender, EventArgs e)

at System.Workflow.Activities.CodeActivity.Execute(ActivityExecutionContext executionContext)

at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(T activity, ActivityExecutionContext executionContext)

at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(Activity activity, ActivityExecutionContext executionContext)

at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)

InnerException: System.Runtime.InteropServices.COMException

Message="Failed to load info object."

Source="Analysis Server"

ErrorCode=-2147467259

StackTrace:

at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options)

at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options)

at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()

InnerException:

[former_member208657 · Accepted solution]

There are a few timeouts that could come into play here. One is a Corba timeout.

You'll want to adjust your ConnectionTimeout in your regisry under HKEY_LOCAL_MACHINE\SOFTWARE\BUSINESS OBJECTS\Suite 11.5\CER. The default value is 600000. Try doubling it to 1200000.

You may also want to increase your httpExecution timeout as well in your web.config file.

http://msdn.microsoft.com/en-us/library/e1f13641.aspx