Reporting & Openaccess & Cache error

2 posts, 0 answers
  1. Vladimír
    Vladimír avatar
    3 posts
    Member since:
    Aug 2011

    Posted 01 Oct 2014 Link to this post

    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












  2. Hinata
    Hinata avatar
    146 posts
    Member since:
    Dec 2013

    Posted 03 Oct 2014 in reply to Vladimír Link to this post

    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.
Back to Top