rsExecutionNotFound

Hi!
Has anyone figured out what causes a "Execution '2ye0gq45qszd0m55wlgy0n55'
cannot be found (rsExecutionNotFound) " error? Our scenario is this:
A relatively new/unused sql server 2005 (so load is not a factor).
A new report (the first one on this server) conisting of a main report and 2
subreports.
The report requires 2 parameters, both selectable from lists acquired from a
database: selection from the first list (a dropdownlist) is supposed to
trigger generating the list of values for the second list (another
dropdownlist). the sql that generates the lists is in-line so there are no
stored procedures, etc to be missing.
The behavior I'm getting is that the first list populates ok, on selecting
any item from the first list the rsExecutionNoFound error immediately occurs;
there are no time delays and the list is not very long so timeouts are
unlikely . Everything works perfectly in the designer. (On a whim I
attempted to run the subreports standalone providing the required parameter
and they both fail with the rsExecutionNotFound error.)
Basically this implementation of RS 2005 is unusable until this is resolved.
Any suggestions' What might we have overlooked?
Thanks!!
GlennYou may want to verify that the datasource of this report is pointing to the
same one you used in your designer. I have had that happen to me. Open both
the main report and subreports in the Report Manager and click on the
datasources property and verify that they are indeed pointing to the correct
data source ( I hope you are using a shared data source! :) ).
=-Chris
"glennl" <glennl@.discussions.microsoft.com> wrote in message
news:FDD94784-BCC5-40C3-B793-7C6E23F34B2C@.microsoft.com...
> Hi!
> Has anyone figured out what causes a "Execution '2ye0gq45qszd0m55wlgy0n55'
> cannot be found (rsExecutionNotFound) " error? Our scenario is this:
> A relatively new/unused sql server 2005 (so load is not a factor).
> A new report (the first one on this server) conisting of a main report and
> 2
> subreports.
> The report requires 2 parameters, both selectable from lists acquired from
> a
> database: selection from the first list (a dropdownlist) is supposed to
> trigger generating the list of values for the second list (another
> dropdownlist). the sql that generates the lists is in-line so there are no
> stored procedures, etc to be missing.
> The behavior I'm getting is that the first list populates ok, on selecting
> any item from the first list the rsExecutionNoFound error immediately
> occurs;
> there are no time delays and the list is not very long so timeouts are
> unlikely . Everything works perfectly in the designer. (On a whim I
> attempted to run the subreports standalone providing the required
> parameter
> and they both fail with the rsExecutionNotFound error.)
> Basically this implementation of RS 2005 is unusable until this is
> resolved.
> Any suggestions' What might we have overlooked?
> Thanks!!
> Glenn