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

RSExecution Log

Does anyone have a link where I can download the RS Execution Log add-in for
RS 2000? I've looked everywhere I can think and Can't locate the file.
Thanks
ScottHello Scott,
I would like to know what do you mean about the RS Execution Log add-in.
If you mean to the DTS package which discribed in the BOL, you could copy
these files from the Product CD.
Querying and Reporting on Report Execution Log Data
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
/arp_rslogfiles_v1_88gy.asp
If you could not find these files, please send an email to me and I will
try to provide these files to you.
My direct email address is weilu@.ONLINE.microsoft.com ( Please remove
ONLINE when you send the email ), you may send the request to me directly.
Thank you!
direct email address is weilu@.ONLINE.microsoft.com ( Please remove ONLINE
when you send the email ), you may send the file to me directly|||Yes, that is exactly what I needed. I forgot that they were on the CDs :)
We had a server crash and things haven't been the same!!! Still trying to
recover, thanks for your help.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:uPdIBGOxGHA.5560@.TK2MSFTNGXA01.phx.gbl...
> Hello Scott,
> I would like to know what do you mean about the RS Execution Log add-in.
> If you mean to the DTS package which discribed in the BOL, you could copy
> these files from the Product CD.
> Querying and Reporting on Report Execution Log Data
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
> /arp_rslogfiles_v1_88gy.asp
> If you could not find these files, please send an email to me and I will
> try to provide these files to you.
> My direct email address is weilu@.ONLINE.microsoft.com ( Please remove
> ONLINE when you send the email ), you may send the request to me directly.
> Thank you!
> direct email address is weilu@.ONLINE.microsoft.com ( Please remove ONLINE
> when you send the email ), you may send the file to me directly
>|||Hi Scott,
Thank you for the update. If you have any questions on the recover issue,
please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hello Scott,
How is the recover going? Is is all be fine? If you have any problem,
please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Well, I was having page locks left and right on my RS's temp DB
(ReportServerTempDB). I think I resolved those, though. There were no
indexes on the DB and the recovery model was set to full. Trying out the
indexes and simple mode today. Will post onto how it did.
Just putting this out there so someone can Google it if they have the issue
:)
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:ychB29oxGHA.400@.TK2MSFTNGXA01.phx.gbl...
> Hi Scott,
> Thank you for the update. If you have any questions on the recover issue,
> please feel free to let me know.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
>

RsConfig -e command for Unattended execution

Hi
When I run the following RsConfig -e command for Unattended execution, I get
the "System.Management.ManagementException: Not found" error. Does anyone
know what the problem is?
C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rsconfig -e -u
Sqlusername -p SqlPassword -t
System.Management.ManagementException: Not found
at
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
errorCode)
at System.Management.PropertyData.RefreshPropertyInfo()
at System.Management.PropertyDataCollection.get_Item(String propertyName)
at System.Management.ManagementBaseObject.GetPropertyValue(String
propertyName)
at System.Management.ManagementBaseObject.get_Item(String propertyName)
at
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.ConnectToWmi()
at
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
Thanks,
MarkCan you try running mofcomp on ReportingServices.mof and see if this fixes
your issue.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"MCC" <cmc_za@.hotmail.com> wrote in message
news:evdrsvWpEHA.2900@.TK2MSFTNGP12.phx.gbl...
> Hi
> When I run the following RsConfig -e command for Unattended execution, I
get
> the "System.Management.ManagementException: Not found" error. Does anyone
> know what the problem is?
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rsconfig -e -u
> Sqlusername -p SqlPassword -t
> System.Management.ManagementException: Not found
> at
>
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> errorCode)
> at System.Management.PropertyData.RefreshPropertyInfo()
> at System.Management.PropertyDataCollection.get_Item(String
propertyName)
> at System.Management.ManagementBaseObject.GetPropertyValue(String
> propertyName)
> at System.Management.ManagementBaseObject.get_Item(String propertyName)
> at
> Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.ConnectToWmi()
> at
> Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[]
args,
> BaseCmdLine instance)
> Thanks,
> Mark
>|||That worked a treat, thanks.
Mark
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:eegzg5WpEHA.1992@.TK2MSFTNGP09.phx.gbl...
> Can you try running mofcomp on ReportingServices.mof and see if this fixes
> your issue.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "MCC" <cmc_za@.hotmail.com> wrote in message
> news:evdrsvWpEHA.2900@.TK2MSFTNGP12.phx.gbl...
> > Hi
> >
> > When I run the following RsConfig -e command for Unattended execution, I
> get
> > the "System.Management.ManagementException: Not found" error. Does
anyone
> > know what the problem is?
> >
> > C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rsconfig -e -u
> > Sqlusername -p SqlPassword -t
> >
> > System.Management.ManagementException: Not found
> >
> > at
> >
>
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> > errorCode)
> > at System.Management.PropertyData.RefreshPropertyInfo()
> > at System.Management.PropertyDataCollection.get_Item(String
> propertyName)
> > at System.Management.ManagementBaseObject.GetPropertyValue(String
> > propertyName)
> > at System.Management.ManagementBaseObject.get_Item(String
propertyName)
> > at
> >
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.ConnectToWmi()
> > at
> >
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
> > at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[]
> args,
> > BaseCmdLine instance)
> >
> > Thanks,
> >
> > Mark
> >
> >
>

RS.EXE SCRIPT TU AUTOMATE REPORT EXECUTION

Hi,
I am searchig RSS script for RS.EXE to automate excution/run of reports.
I would like to be able to generate reports both in PDF and Excel and store
them in a predefined Server Folder.
There is 2 RSS samples even in SP1 and none of them is doing such job.
I think it could be useful to a lot of people.
Many ThanksJean-Marc,
If you want to automate report deliviery, you don't have to use rs.exe. In
report manager, check out data-driven subscriptions.
Jon Jahren
"Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
news:OTmF9jIyEHA.824@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I am searchig RSS script for RS.EXE to automate excution/run of reports.
> I would like to be able to generate reports both in PDF and Excel and
store
> them in a predefined Server Folder.
> There is 2 RSS samples even in SP1 and none of them is doing such job.
> I think it could be useful to a lot of people.
> Many Thanks
>|||Jon,
I know this Reporting Services features.
BUT, I have to do it in automatically in our company Product independently
of any Reporting Services User Interface.
Best Regards.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:%23CzFczJyEHA.3120@.TK2MSFTNGP12.phx.gbl...
> Jean-Marc,
> If you want to automate report deliviery, you don't have to use rs.exe. In
> report manager, check out data-driven subscriptions.
> Jon Jahren
> "Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
> news:OTmF9jIyEHA.824@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > I am searchig RSS script for RS.EXE to automate excution/run of reports.
> >
> > I would like to be able to generate reports both in PDF and Excel and
> store
> > them in a predefined Server Folder.
> >
> > There is 2 RSS samples even in SP1 and none of them is doing such job.
> >
> > I think it could be useful to a lot of people.
> >
> > Many Thanks
> >
> >
>|||Have you checked out web services. It would surprise me if that didn't have
the capability to do what you are talking about. Use web services to setup
the data driven subscriptions. I think you still want to do that, why
reinvent the wheel.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
news:uGtWbTLyEHA.1396@.tk2msftngp13.phx.gbl...
> Jon,
> I know this Reporting Services features.
> BUT, I have to do it in automatically in our company Product
> independently
> of any Reporting Services User Interface.
> Best Regards.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:%23CzFczJyEHA.3120@.TK2MSFTNGP12.phx.gbl...
>> Jean-Marc,
>> If you want to automate report deliviery, you don't have to use rs.exe.
>> In
>> report manager, check out data-driven subscriptions.
>> Jon Jahren
>> "Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
>> news:OTmF9jIyEHA.824@.TK2MSFTNGP11.phx.gbl...
>> > Hi,
>> >
>> > I am searchig RSS script for RS.EXE to automate excution/run of
>> > reports.
>> >
>> > I would like to be able to generate reports both in PDF and Excel and
>> store
>> > them in a predefined Server Folder.
>> >
>> > There is 2 RSS samples even in SP1 and none of them is doing such job.
>> >
>> > I think it could be useful to a lot of people.
>> >
>> > Many Thanks
>> >
>> >
>>
>

RS Execution Logs sample project

Hi,

I was going through the link http://msdn2.microsoft.com/en-us/library/aa964131.aspx for "Monitoring Report Execution Performance with Execution Logs". There is a link (http://datainspirations.com/uploads/rsexecutionlogging.zip) proviced for downloading sample project. It seems that the page no more exists.

Can any one please let me know from where can i download the sample project?

TIA

You can find correct links here:

http://datainspirations.com/Publications.html

|||Even this link doesn't work.If you know the llink,please send me.|||It works for me.

RS Execution Logs sample project

Hi,

I was going through the link http://msdn2.microsoft.com/en-us/library/aa964131.aspx for "Monitoring Report Execution Performance with Execution Logs". There is a link (http://datainspirations.com/uploads/rsexecutionlogging.zip) proviced for downloading sample project. It seems that the page no more exists.

Can any one please let me know from where can i download the sample project?

TIA

You can find correct links here:

http://datainspirations.com/Publications.html

|||Even this link doesn't work.If you know the llink,please send me.|||It works for me.

RS Execution Log and SQL 2005

Hello All,
SQL 2000 Reporting Services came with a DTS package that could be configured
to collect data daily on Report Execution. The results were then stored in a
RSExecutionLog database. Is this functionality still supported in 2005
Reporting Services?Well, for RS 2005 it is not a DTS package, it is a Integration Services
package. I was trying to get this working and I did not have Integration
Services installed (which requires reinstalling all service packs). So I
delayed until I had some time to install it.
Bruce Loehle-Conger
"EFrayer@.community.nospam"
<EFrayercommunitynospam@.discussions.microsoft.com> wrote in message
news:9F060287-4EAF-4FBD-9DA8-A1192674999E@.microsoft.com...
> Hello All,
> SQL 2000 Reporting Services came with a DTS package that could be
> configured
> to collect data daily on Report Execution. The results were then stored
> in a
> RSExecutionLog database. Is this functionality still supported in 2005
> Reporting Services?|||Can I get a little more information on how to do this? Where can I find this
Integration Services package that you are taking about?
"Bruce L-C [MVP]" wrote:
> Well, for RS 2005 it is not a DTS package, it is a Integration Services
> package. I was trying to get this working and I did not have Integration
> Services installed (which requires reinstalling all service packs). So I
> delayed until I had some time to install it.
> Bruce Loehle-Conger
> "EFrayer@.community.nospam"
> <EFrayercommunitynospam@.discussions.microsoft.com> wrote in message
> news:9F060287-4EAF-4FBD-9DA8-A1192674999E@.microsoft.com...
> > Hello All,
> > SQL 2000 Reporting Services came with a DTS package that could be
> > configured
> > to collect data daily on Report Execution. The results were then stored
> > in a
> > RSExecutionLog database. Is this functionality still supported in 2005
> > Reporting Services?
>
>

RS bug

I think I've found small bug.
1. ReportManager
2. Report Properties
3. Execution
when I once change defult option
"Do not cache temporary copies of this report"
to
"Cache a temporary copy of the report. Expire copy of report after a
number of minutes"
then I can not get back to first, defult option.
I can choose one but after selecting Apply button nothing happens.
KamelNothing has changed in SP2 on this page. Do you see a script error in IE?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"kamel" <kwiciak@.gmail.com> wrote in message
news:1114444103.114031.282320@.f14g2000cwb.googlegroups.com...
>I think I've found small bug.
> 1. ReportManager
> 2. Report Properties
> 3. Execution
> when I once change defult option
> "Do not cache temporary copies of this report"
> to
> "Cache a temporary copy of the report. Expire copy of report after a
> number of minutes"
> then I can not get back to first, defult option.
> I can choose one but after selecting Apply button nothing happens.
> Kamel
>|||ok, this is IE error
IE restart solved the problem
thanks,
Kamel