Reporting & Openaccess & Cache error

[Vladimír]

Hello telerik,

we have problem with telerik reporting cache configuration. We have web application with that one configuration
Cache configuration for Telerik Reporting - Documentation

But we have limit for web request execution timeout <httpRuntime maxRequestLength="10240" executionTimeout="120" /> in web.config.

If user print more than ten reports sometimes error occured. 
In IIS we found that error:
Event code: 3001 
Event message: The request has been aborted. 
Event time: 1. 10. 2014 8:28:28 
Event time (UTC): 1. 10. 2014 8:28:28 
Event ID: fac8e9f29da44308a956b8a40a77f776 
Event sequence: 468895 
Event occurrence: 4 
Event detail code: 0 
......
Request information: 
    Request URL: ...../Telerik.ReportViewer.axd?instanceID=e2e347934c98455992ff6c852ad9b479&optype=Report&PageIndex=0&RenderID=1cf163f3e6dc4c469f1ee686e29ee837&RenderingFormat=HTML5 
    Request path: /Telerik.ReportViewer.axd 
    ....(sensitive data)
    Is authenticated: True 
    Authentication Type: Forms 
    Thread account name: NT AUTHORITY\NETWORK SERVICE 

In Application stack trace error:
Delete failed: System.InvalidOperationException: ExecuteReader needed open Connection. Current state is closed.
   v Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeUpdate()
   v OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeUpdate()
   v OpenAccessRuntime.Relational.RelationalStorageManager.deleteRow(PreparedStatement ps, RelationalOID oid, String sql)
Row: GenericOID@6e636f66 SessionState resource_id=05ceed656ae242a3a0b5c2f083098bf2/session_id=6fc22894b45a47878fa2e191f9fdcd1a
DELETE FROM [session_state] WHERE [resource_id] = ? AND [session_id] = ?
(set event logging to all to see parameter values) System.InvalidOperationException: ExecuteReader vyžaduje otevřené a dostupný element Connection. Aktuální stav připojení je Zavřeno.
   v Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeUpdate()
   v OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeUpdate()
   v OpenAccessRuntime.Relational.RelationalStorageManager.deleteRow(PreparedStatement ps, RelationalOID oid, String sql)


How can solve that problem?

Best regards
Vladimir

[Hinata]

Hi Vladimir,

I have a feeling that increasing the executionTimeout will resolve the issue. You can test it and let us know how it goes.