Autorefresh report error

• stephen.redman

  Valued Member

  Points: 70

  More actions

  March 10, 2011 at 7:43 am

  #246715

  Hello,

  I wrote a report for SSRS 2005 a while ago that was designed to be displayed on a screen permanently and to auto-refresh every few minutes. This worked fine. Since running the report on SQL 2008 R2 I've been seeing errors now and then, I thought these were down to the query timing out so today I ran the report on the server itself to see what happened, it errored after a while again and gave the following error:-

  This SqlTransaction has completed; it is no longer usable

  Does anyone know why it may be doing this? I'm not sure but it seems to be when the data changes it errors.

  Thanks for any assistance 🙂

  Steve

• stephen.redman

  Valued Member

  Points: 70

  More actions

  April 4, 2011 at 8:00 am

  #1306983

  UPDATE

  I ended up rewriting the report in SSRS 2008 and it now refreshes fine 😎