rsExecutionNotFound

Hello:

We are using Reporting Services 2005 as our production reporting portal. Sometimes our business users get similar messages to the following message (intermittently ) when running reports.

Execution 'ahk2v0rhpeaj3e45lkrf2ine' cannot be found (rsExecutionNotFound)

I have researched online and forums but could not find a solution to this problem. I know it has something to do with sessions dying and loss of session id. Once the user reruns the report it works fine. What is the way to resolve this from happening at all? We don't want the users to see this on production. Has Microsoft already fixed this problem?

Thanks.

Here is one 'hack' for the problem. It appears to be related to caching. Another way to fix if you are using a custom app is to specify a unique 'fake' parameter guid. rc:guid=<guid>

http://groups.google.fr/group/ReportingServices/browse_thread/thread/685274e5aa25310/bae5e060b65863b0?lnk=st&q=rsexecutionnotfound&rnum=3&hl=fr#bae5e060b65863b0

You may want to try using SQL Profiler against ReportServerTempDB to determine if it is deleting sessions in the same manner as the url above. See the help file to check rsreportserver.config settings.

http://www.samspublishing.com/articles/article.asp?p=469625&seqNum=6&rl=1

cheers,

Andrew

rsAccessDenied and

I have installed Reporting Services on a production server that host a
website using SQL Express. I have set up RS in the RS configuration manager
and got green button all the way down
Requesting http://www.xx.dk/reports replies:
The request failed with HTTP status 400: Bad Request.
Requesting http://www.xx.dk/reportserver replies:
The permissions granted to user 'TF4\ms' are insufficient for performing
this operation. (rsAccessDenied)
Any idea what the problem might be ?
--
Paul SHello Paul,
Based on my research, please check the following settings:
1. Make sure you disable the Anynomous Access on IIS for the reporting
services virtual directory.
2. Make sure you enable Windows Authentication on IIS
3. Make sure you have use the rsconfig utility to connect to the correct
SQL Instance for the report server.
4. Make sure you are using a correct identity for the application pool the
reporting services using. Please try to use a domain account with local
admin privilage to have a check.
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.|||1)
Anynomous Access is disabled for the reportServer dir. and the reports dir.
but not for the parent dir - the original dir for the website.
2)
Windows Authentication is enabled for the reports and the reportserver dir.
3)
I only have one - it's correct
4)
The application pool for both the ReportServer and the Report manager is
DefaultAppPool
ps. In database setup the credentials type is Service credentials
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> Based on my research, please check the following settings:
> 1. Make sure you disable the Anynomous Access on IIS for the reporting
> services virtual directory.
> 2. Make sure you enable Windows Authentication on IIS
> 3. Make sure you have use the rsconfig utility to connect to the correct
> SQL Instance for the report server.
> 4. Make sure you are using a correct identity for the application pool the
> reporting services using. Please try to use a domain account with local
> admin privilage to have a check.
> 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.
>
>|||Hello Paul,
1. Please run the rsconfig utility to specify a new connection to the sql
server:
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
2. Please recreate an application pool for the report server and use a
domain account which have local admin privilage as the identity to have a
try.
Please let me know the result.
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.|||Hello Wei Lu
Your suggestions gave the follwing:
1)
No Reporting Services instance found on localhost.
2)
I created a new user with local admin rights and used him when I created a
new app pool for the reports server - the report manager still uses
DefaultAppPool.
Why is it talking about localhost - I'm not using localhost. The values
specifid in the RS Configuration manager for Report Server Virtual Directory
is:
Name: ReportServer, Website xxx
accessing http://www.xxx.dk/reports gives
The request failed with HTTP status 400: Bad Request.
acessing http://www.xxx.dk/reportserver still gives The permissions granted
to user 'TF4\ms' are insufficient for performing this operation.
(rsAccessDenied)|||Hello Paul,
I would like to get the RSWebApplication.config file and
rsreportserver.config file in the report manager and report server folder.
By default, these two folders is located at :C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\
Also, please send me the screenshot for the Configuration Tool. Make sure
you have a default instance installed in the server.
You may zip the folder and send to me directly. I understand the
information may be sensitive to you. To get my real email addresss, please
remove the ONLINE in my display mail.
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.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
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.|||I've send you the information needed
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> 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.
>|||Hello Paul,
From your rsreportserver.config file, I did not see the LogonUser
credential is applied. So please use the rsconfig utility to specify the
credential to connect to SQL Server Report Server.
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================.|||Hello Wei
I get an error message saying
'No reporting services instance found on localhost'
when I run the rsconfig utility
I have been going through this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=143931&SiteID=1
but I have the folders mentioned.
Paul S
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> From your rsreportserver.config file, I did not see the LogonUser
> credential is applied. So please use the rsconfig utility to specify the
> credential to connect to SQL Server Report Server.
> rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================.
>|||Hello Paul,
According to your email, I found that you are going to configure your
Express instance in your computer.
Please try the following:
rsconfig -c -s <SQLSERVERNAME>\Express -d reportserver -a SQL -u SA -p
<SAPASSWORD>
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Issuing that command was what gave me the
'No reporting services instance found on localhost'
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> According to your email, I found that you are going to configure your
> Express instance in your computer.
> Please try the following:
> rsconfig -c -s <SQLSERVERNAME>\Express -d reportserver -a SQL -u SA -p
> <SAPASSWORD>
>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>|||Hello Paul,
I would like to know how many instances you installed in the machine.
Pleas run the MPS Report .
--
a. Download MPSReport tool from below URL:
<
http://download.microsoft.com/download/b/b/1/bb139fcb-4aac-4fe5-a579-30b0bd9
15706/MPSRPT_SETUPPerf.EXE>
b. Execute the tool on the computer, and if you are prompted "Include the
MSINFO32 report?", please type Y.
c. Please send the result file (CAB file) to me
To reach me, please remove the ONLINE in my display email address.
For detailed information about the MPS Report Tools, please refer to the
following link:
Microsoft Product Support's Reporting Tools
<http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F
-88B7-F9C79B7306C0&displaylang=en>
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
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.|||Hi
I have just send you the described CAB file
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> 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.
>

rsAccessDenied

Hi All,
I have just installed Reporting Services on our production environment.
Everything is set up, the permissions etc and all seems fine until we try to
publish a report
I get the error :
Error rsAccessDenied : The permissions granted to user '[User Name]' are
insufficient for performing this operation.
Deploy complete -- 1 errors, 0 warnings
What have I missed here - on our Dev box I was an Administrator so there
weren't any problems
What permissions does the publisher have to have on the web server to be
able to publish reports?
Thanks
KathrynThe user needs the Manage Reports task. We role this task in a role called
Content Manager (although you could create your own roles with specific
tasks if you want). If you give the user this role then they will be able
to publish reports. To give them permission, go to the folder you want to
give them permission to (in report Manager) and click on the properties tab,
then on the security sub tab. From there you can give them the permissions
you want.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kathy" <joe@.soap.com> wrote in message
news:PvmdnfocNYNSE3_cRVn-vQ@.is.co.za...
> Hi All,
> I have just installed Reporting Services on our production environment.
> Everything is set up, the permissions etc and all seems fine until we try
> to
> publish a report
> I get the error :
> Error rsAccessDenied : The permissions granted to user '[User Name]' are
> insufficient for performing this operation.
> Deploy complete -- 1 errors, 0 warnings
> What have I missed here - on our Dev box I was an Administrator so there
> weren't any problems
> What permissions does the publisher have to have on the web server to be
> able to publish reports?
> Thanks
> Kathryn
>
>|||Thanks Daniel
Turns out this wasn't the problem.
I actually had to give our group permissions on the Report Server and Report
Manager folders.
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:eB%23dH%23z9EHA.3944@.TK2MSFTNGP12.phx.gbl...
> The user needs the Manage Reports task. We role this task in a role
called
> Content Manager (although you could create your own roles with specific
> tasks if you want). If you give the user this role then they will be able
> to publish reports. To give them permission, go to the folder you want to
> give them permission to (in report Manager) and click on the properties
tab,
> then on the security sub tab. From there you can give them the
permissions
> you want.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Kathy" <joe@.soap.com> wrote in message
> news:PvmdnfocNYNSE3_cRVn-vQ@.is.co.za...
> > Hi All,
> >
> > I have just installed Reporting Services on our production environment.
> > Everything is set up, the permissions etc and all seems fine until we
try
> > to
> > publish a report
> > I get the error :
> > Error rsAccessDenied : The permissions granted to user '[User Name]' are
> > insufficient for performing this operation.
> >
> > Deploy complete -- 1 errors, 0 warnings
> >
> > What have I missed here - on our Dev box I was an Administrator so there
> > weren't any problems
> > What permissions does the publisher have to have on the web server to be
> > able to publish reports?
> >
> > Thanks
> > Kathryn
> >
> >
> >
>

RS2005 cant'connect to server

Hi. Like some others here, I'm struggling to get a production install of
RS2005 (SP2). RS is installed on a dedicated W2K3 (SP2) server. The
database is on a separate SQL 2005 (SP2) server. With the help of some posts
here I finally am able to browse to Report Manager and also deploy reports
from VS2005, but only when local to the report server. On my own
workstation, I get "cannot display the page" when I try to browse to Report
Manager , and "connection could not be made to the report server" when I try
to deploy reports. I checked local intranet sites in IE, and the whole
segment is allowed (set in GP) so that isn't th problem. Do you have any
ideas why I can't connect to RS from a workstation on my network? Thanks.Hi,
"cannot display the page" seems to be an IIS layer problem. To help
identifying your problem, can you
-verify url used to browse reports (http://<yourserver>/Reports)
-verify your web request reach IIS (chek logs at
c:\windows\system32\logfiles\)
-verify Http Status code send back by IIS
Jean-Pierre Riehl
http://blog.djeepy1.net
http://www.bewise.fr
"Coop" <Coop@.discussions.microsoft.com> wrote in message
news:48452325-3B31-4318-A3B5-B82F388A591A@.microsoft.com...
> Hi. Like some others here, I'm struggling to get a production install of
> RS2005 (SP2). RS is installed on a dedicated W2K3 (SP2) server. The
> database is on a separate SQL 2005 (SP2) server. With the help of some
> posts
> here I finally am able to browse to Report Manager and also deploy reports
> from VS2005, but only when local to the report server. On my own
> workstation, I get "cannot display the page" when I try to browse to
> Report
> Manager , and "connection could not be made to the report server" when I
> try
> to deploy reports. I checked local intranet sites in IE, and the whole
> segment is allowed (set in GP) so that isn't th problem. Do you have any
> ideas why I can't connect to RS from a workstation on my network? Thanks.|||If you can browse locally (when logged into the server) then everything is
setup correctly. I think the issue here is that you have not configured
roles properly. By default if you are a member of the local administrators
group then you are in the role that allows you to deploy. RS has its own
roles, totally separate from database security. Add your user for your
workstation to the local administrator group on the server. Then give it all
a try.
Also, try fully qualify your server (I assume when local you just used
localhost). For instance try
http://servername.whatever.com/reports
My guess is this is an issue with RS roles.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jean-Pierre Riehl" <jean-pierre.riehl@.b-e-w-i-s-e.fr> wrote in message
news:41E3F7CE-1559-41D5-B5BD-26129028BC7B@.microsoft.com...
> Hi,
> "cannot display the page" seems to be an IIS layer problem. To help
> identifying your problem, can you
> -verify url used to browse reports (http://<yourserver>/Reports)
> -verify your web request reach IIS (chek logs at
> c:\windows\system32\logfiles\)
> -verify Http Status code send back by IIS
>
> --
> Jean-Pierre Riehl
> http://blog.djeepy1.net
> http://www.bewise.fr
>
> "Coop" <Coop@.discussions.microsoft.com> wrote in message
> news:48452325-3B31-4318-A3B5-B82F388A591A@.microsoft.com...
>> Hi. Like some others here, I'm struggling to get a production install of
>> RS2005 (SP2). RS is installed on a dedicated W2K3 (SP2) server. The
>> database is on a separate SQL 2005 (SP2) server. With the help of some
>> posts
>> here I finally am able to browse to Report Manager and also deploy
>> reports
>> from VS2005, but only when local to the report server. On my own
>> workstation, I get "cannot display the page" when I try to browse to
>> Report
>> Manager , and "connection could not be made to the report server" when I
>> try
>> to deploy reports. I checked local intranet sites in IE, and the whole
>> segment is allowed (set in GP) so that isn't th problem. Do you have any
>> ideas why I can't connect to RS from a workstation on my network?
>> Thanks.
>

rs.CreateReport() with overwrite set to true doesn't really overwrite

Here's the situation... We have a report that has been deployed to
production a few weeks ago. Since then the report has changed slightly; two
parameters have changed--one parameter went from not being marked internal
to being marked internal and the other parameter's default value changed
(just a simple string change).
Now we want to programmatically deploy the updated report to production and
overwrite the existing report, including all parameters and parameter
properties. However, when we try this, the parameters, as shown through
Report Manger, have not changed. They're the same as the original
deployment. And, there is no error/exception thrown that might be causing
the problem.
Here's the code snippet:
System.Byte[] definition = null;
ReportingService2005.Warning[] warnings = null;
string name = (string)dr["Name"]; // Variable that holds the name
string file = (string)dr["FullName"]; // Variable that holds the file
System.IO.FileStream stream = System.IO.File.OpenRead(file);
definition = new System.Byte[stream.Length];
stream.Read(definition, 0, (int)stream.Length);
stream.Close();
warnings = rs.CreateReport(name, parent, true, definition, null);
Any help is greatly appreciated. Thanks!Hello Imttag,
This issue may occured by the session the reporting services holding. So I
suggest you reset your IIS after you create the report.
If this still occured, you may try to delete the report first and then
recreate the report again.
Hope this helps.
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.|||Thanks for the info! However, the first idea didn't help. I ran my code to
call the CreateReport method to overwrite the report (and everything worked
fine with no errors). Then I close the browser and went back in (a
completely new session), and no changes. The report appeared to be the old
report, not the new report.
We thought about the second idea (that is, delete the old report and deploy
the new report in its place), but we have another issue with that approach.
The reports will have linked reports, and if we delete the report the linked
reports will not be linked anymore. We need to replace/overwrite the report
and keep the links in place for any linked reports.
Any help/suggestions on how to do this?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:OJiRNQjgHHA.6068@.TK2MSFTNGHUB02.phx.gbl...
> Hello Imttag,
> This issue may occured by the session the reporting services holding. So I
> suggest you reset your IIS after you create the report.
> If this still occured, you may try to delete the report first and then
> recreate the report again.
> Hope this helps.
> 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.
>|||The issue with the default parameters not changing is considered a
feature. They favour server admins over developers. Given that an
admin might of changed the default values from those that were
originally deployed they are always preserved.
What you can do is set the default for the parameters separately after
you call SetReportDefinition to update your report. I use code similar
to that below to loop through the parameters of a report and change
the default values:
ReportParameter[] objReportParameters =objReportingServer.GetReportParameters(ReportNameGoesHere, null, true,
null, null);
foreach (ReportParameter objParameter in objReportParameters)
{
if (objParameter.Name == ParameterToChange)
objParameter.DefaultValues[0] = SomeDefaultValue;
}
Hope this helps,
Shane.
On Apr 18, 11:55 pm, "lmttag" <lmt...@.newsgroup.nospam> wrote:
> Here's the situation... We have a report that has been deployed to
> production a few weeks ago. Since then the report has changed slightly; two
> parameters have changed--one parameter went from not being marked internal
> to being marked internal and the other parameter's default value changed
> (just a simple string change).
> Now we want to programmatically deploy the updated report to production and
> overwrite the existing report, including all parameters and parameter
> properties. However, when we try this, the parameters, as shown through
> Report Manger, have not changed. They're the same as the original
> deployment. And, there is no error/exception thrown that might be causing
> the problem.
> Here's the code snippet:
> System.Byte[] definition = null;
> ReportingService2005.Warning[] warnings = null;
> string name = (string)dr["Name"]; // Variable that holds the name
> string file = (string)dr["FullName"]; // Variable that holds the file
> System.IO.FileStream stream = System.IO.File.OpenRead(file);
> definition = new System.Byte[stream.Length];
> stream.Read(definition, 0, (int)stream.Length);
> stream.Close();
> warnings = rs.CreateReport(name, parent, true, definition, null);
> Any help is greatly appreciated. Thanks!|||I forgot to mention that after you update the parameters you'll need
to call SetReportParameters to save the changes.
Regards,
Shane.
On Apr 19, 2:50 pm, shanejokeeffe <shanejokee...@.gmail.com> wrote:
> The issue with the default parameters not changing is considered a
> feature. They favour server admins over developers. Given that an
> admin might of changed the default values from those that were
> originally deployed they are always preserved.
> What you can do is set the default for the parameters separately after
> you call SetReportDefinition to update your report. I use code similar
> to that below to loop through the parameters of a report and change
> the default values:
> ReportParameter[] objReportParameters => objReportingServer.GetReportParameters(ReportNameGoesHere, null, true,
> null, null);
> foreach (ReportParameter objParameter in objReportParameters)
> {
> if (objParameter.Name == ParameterToChange)
> objParameter.DefaultValues[0] = SomeDefaultValue;
> }
> Hope this helps,
> Shane.
> On Apr 18, 11:55 pm, "lmttag" <lmt...@.newsgroup.nospam> wrote:
> > Here's the situation... We have a report that has been deployed to
> > production a few weeks ago. Since then the report has changed slightly; two
> > parameters have changed--one parameter went from not being marked internal
> > to being marked internal and the other parameter's default value changed
> > (just a simple string change).
> > Now we want to programmatically deploy the updated report to production and
> > overwrite the existing report, including all parameters and parameter
> > properties. However, when we try this, the parameters, as shown through
> > Report Manger, have not changed. They're the same as the original
> > deployment. And, there is no error/exception thrown that might be causing
> > the problem.
> > Here's the code snippet:
> > System.Byte[] definition = null;
> > ReportingService2005.Warning[] warnings = null;
> > string name = (string)dr["Name"]; // Variable that holds the name
> > string file = (string)dr["FullName"]; // Variable that holds the file
> > System.IO.FileStream stream = System.IO.File.OpenRead(file);
> > definition = new System.Byte[stream.Length];
> > stream.Read(definition, 0, (int)stream.Length);
> > stream.Close();
> > warnings = rs.CreateReport(name, parent, true, definition, null);
> > Any help is greatly appreciated. Thanks!|||Thanks for the info Shane!
I'll look into your suggestion. It sounds good.
"shanejokeeffe" <shanejokeeffe@.gmail.com> wrote in message
news:1176991806.345375.95070@.b75g2000hsg.googlegroups.com...
> I forgot to mention that after you update the parameters you'll need
> to call SetReportParameters to save the changes.
> Regards,
> Shane.
> On Apr 19, 2:50 pm, shanejokeeffe <shanejokee...@.gmail.com> wrote:
> > The issue with the default parameters not changing is considered a
> > feature. They favour server admins over developers. Given that an
> > admin might of changed the default values from those that were
> > originally deployed they are always preserved.
> >
> > What you can do is set the default for the parameters separately after
> > you call SetReportDefinition to update your report. I use code similar
> > to that below to loop through the parameters of a report and change
> > the default values:
> >
> > ReportParameter[] objReportParameters => > objReportingServer.GetReportParameters(ReportNameGoesHere, null, true,
> > null, null);
> >
> > foreach (ReportParameter objParameter in objReportParameters)
> > {
> > if (objParameter.Name == ParameterToChange)
> > objParameter.DefaultValues[0] = SomeDefaultValue;
> >
> > }
> >
> > Hope this helps,
> >
> > Shane.
> >
> > On Apr 18, 11:55 pm, "lmttag" <lmt...@.newsgroup.nospam> wrote:
> >
> > > Here's the situation... We have a report that has been deployed to
> > > production a few weeks ago. Since then the report has changed
slightly; two
> > > parameters have changed--one parameter went from not being marked
internal
> > > to being marked internal and the other parameter's default value
changed
> > > (just a simple string change).
> >
> > > Now we want to programmatically deploy the updated report to
production and
> > > overwrite the existing report, including all parameters and parameter
> > > properties. However, when we try this, the parameters, as shown
through
> > > Report Manger, have not changed. They're the same as the original
> > > deployment. And, there is no error/exception thrown that might be
causing
> > > the problem.
> >
> > > Here's the code snippet:
> >
> > > System.Byte[] definition = null;
> > > ReportingService2005.Warning[] warnings = null;
> >
> > > string name = (string)dr["Name"]; // Variable that holds the name
> > > string file = (string)dr["FullName"]; // Variable that holds the file
> >
> > > System.IO.FileStream stream = System.IO.File.OpenRead(file);
> > > definition = new System.Byte[stream.Length];
> > > stream.Read(definition, 0, (int)stream.Length);
> > > stream.Close();
> >
> > > warnings = rs.CreateReport(name, parent, true, definition, null);
> >
> > > Any help is greatly appreciated. Thanks!
>

RS service pack 2 installation failed

Hi all,
I tried to install Reporting services service pack 2 on our production
server but it failed before doing any update.
environnement is windows 2000 & framework dotnet 1.1 service pack 1
the same package was successfull on the developpement server - supposed to
be the same environnement.
The logfile shows an error 1635 and it seem to be linked to a file
sp1patch.msp
I could not find anything usefull on the net
Thanks in advance for any help
because we are using in our report one of the feature that cannot work
without the service pack 2.
herefater the log trace :
-----
=== Verbose logging started: 10/28/2005 19:05:40 Build type: SHIP UNICODE
3.01.4000.2435 Calling process:
e:\6704fbb7257fc7f7594ebb9e1cf255b8\sp2setup.exe === MSI (c) (94:58) [19:05:40:481]: Resetting cached policy values
MSI (c) (94:58) [19:05:40:481]: Machine policy value 'Debug' is 0
MSI (c) (94:58) [19:05:40:481]: ******* RunEngine:
******* Product: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
******* Action:
******* CommandLine: **********
MSI (c) (94:58) [19:05:40:481]: Client-side and UI is none or basic: Running
entire install on the server.
MSI (c) (94:58) [19:05:40:481]: Grabbed execution mutex.
MSI (c) (94:58) [19:05:40:590]: Cloaking enabled.
MSI (c) (94:58) [19:05:40:590]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (94:58) [19:05:40:621]: Incrementing counter to disable shutdown.
Counter after increment: 0
MSI (s) (A8:0C) [19:05:40:668]: Grabbed execution mutex.
MSI (s) (A8:E0) [19:05:40:668]: Resetting cached policy values
MSI (s) (A8:E0) [19:05:40:668]: Machine policy value 'Debug' is 0
MSI (s) (A8:E0) [19:05:40:668]: ******* RunEngine:
******* Product: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
******* Action:
******* CommandLine: **********
MSI (s) (A8:E0) [19:05:40:668]: Machine policy value 'DisableUserInstalls'
is 0
MSI (s) (A8:E0) [19:05:40:684]: Warning: Local cached package
'C:\W2TP\Installer\ba2813.msi' is missing.
MSI (s) (A8:E0) [19:05:40:684]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (A8:E0) [19:05:40:684]: User policy value 'DisableMedia' is 0
MSI (s) (A8:E0) [19:05:40:684]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Media enabled only if package is
safe.
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Looking for sourcelist for
product {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Adding
{33FE9EED-1976-4A51-A7AF-332D9BBB9400}; to potential sourcelist list
(pcode;disk;relpath).
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Now checking product
{33FE9EED-1976-4A51-A7AF-332D9BBB9400}
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Media is enabled for product.
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Attempting to use LastUsedSource
from source list.
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Trying source
D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\.
MSI (s) (A8:E0) [19:05:40:856]: Entering
CMsiConfigurationManager::SetLastUsedSource.
MSI (s) (A8:E0) [19:05:40:856]: Specifed source is already in a list.
MSI (s) (A8:E0) [19:05:40:856]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (A8:E0) [19:05:40:856]: Machine policy value 'DisableBrowse' is 0
MSI (s) (A8:E0) [19:05:40:856]: Machine policy value 'AllowLockdownBrowse'
is 0
MSI (s) (A8:E0) [19:05:40:856]: Adding new sources is allowed.
MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedSource to:
D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\.
MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedType to: n.
MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedIndex to: 1.
MSI (s) (A8:E0) [19:05:40:871]: SOURCEMGMT: Resolved source to:
'D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\'
MSI (s) (A8:E0) [19:05:40:918]: File will have security applied from OpCode.
MSI (s) (A8:E0) [19:05:41:215]: End dialog not enabled
MSI (s) (A8:E0) [19:05:41:215]: Original package ==>
D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\RSRUN.MSI
MSI (s) (A8:E0) [19:05:41:215]: Package we're running from ==>
C:\W2TP\Installer\cbc12.msi
MSI (s) (A8:E0) [19:05:41:418]: APPCOMPAT: looking for appcompat database
entry with ProductCode '{33FE9EED-1976-4A51-A7AF-332D9BBB9400}'.
MSI (s) (A8:E0) [19:05:41:418]: APPCOMPAT: no matching ProductCode found in
database.
MSI (s) (A8:E0) [19:05:41:418]: MSCOREE not loaded loading copy from system32
MSI (s) (A8:E0) [19:05:41:512]: Opening existing patch
'C:\W2TP\Installer\ba290c.msp'.
MSI (s) (A8:E0) [19:05:41:512]: Note: 1: 2203 2:
C:\W2TP\Installer\ba290c.msp 3: -2147287038
MSI (s) (A8:E0) [19:05:41:512]: Couldn't find local patch
'C:\W2TP\Installer\ba290c.msp'. Looking for it at its source.
MSI (s) (A8:E0) [19:05:41:512]: Resolving Patch source.
MSI (s) (A8:E0) [19:05:41:512]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Media enabled only if package is
safe.
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Looking for sourcelist for
product {813A147C-2328-4439-9D40-1486308CB952}
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Adding
{813A147C-2328-4439-9D40-1486308CB952}; to potential sourcelist list
(pcode;disk;relpath).
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Now checking product
{813A147C-2328-4439-9D40-1486308CB952}
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Media is enabled for product.
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Attempting to use LastUsedSource
from source list.
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Processing net source list.
MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Trying source
e:\3d0526d9dd77e601344dcc338f4f\.
MSI (s) (A8:E0) [19:05:41:527]: Note: 1: 2203 2:
e:\3d0526d9dd77e601344dcc338f4f\sp1patch.msp 3: -2147287037
MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Source is invalid due to
missing/inaccessible package.
MSI (s) (A8:E0) [19:05:41:527]: Note: 1: 1706 2: -2147483647 3: sp1patch.msp
MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Processing media source list.
MSI (s) (A8:E0) [19:05:42:652]: SOURCEMGMT: Resolved source to: 'sp1patch.msp'
MSI (s) (A8:E0) [19:06:49:199]: Note: 1: 1314 2: sp1patch.msp
MSI (s) (A8:E0) [19:06:49:199]: Unable to create a temp copy of patch
'sp1patch.msp'.
This patch package could not be opened. Verify that the patch package
exists and that you can access it, or contact the application vendor to
verify that this is a valid Windows Installer patch package.
D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\RSRUN.MSI
MSI (s) (A8:E0) [19:06:49:215]: Note: 1: 1708
MSI (s) (A8:E0) [19:06:49:215]: Note: 1: 2729
MSI (s) (A8:E0) [19:06:49:309]: Note: 1: 2729
MSI (s) (A8:E0) [19:06:49:324]: Product: Microsoft SQL Server 2000 Reporting
Services Enterprise Edition -- Installation failed.
MSI (s) (A8:E0) [19:06:49:340]: MainEngineThread is returning 1635
MSI (c) (94:58) [19:06:49:356]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (94:58) [19:06:49:356]: MainEngineThread is returning 1635
=== Verbose logging stopped: 10/28/2005 19:06:49 ===Hello all
I am still without solution for my trouble describe here after.
Is there any additional inforamtion that could be require to identify the
trouble
Thanks if anyone can help about it
Dominique
"dominique deboise" wrote:
> Hi all,
> I tried to install Reporting services service pack 2 on our production
> server but it failed before doing any update.
> environnement is windows 2000 & framework dotnet 1.1 service pack 1
> the same package was successfull on the developpement server - supposed to
> be the same environnement.
>
> The logfile shows an error 1635 and it seem to be linked to a file
> sp1patch.msp
> I could not find anything usefull on the net
> Thanks in advance for any help
> because we are using in our report one of the feature that cannot work
> without the service pack 2.
>
> herefater the log trace :
> -----
> === Verbose logging started: 10/28/2005 19:05:40 Build type: SHIP UNICODE
> 3.01.4000.2435 Calling process:
> e:\6704fbb7257fc7f7594ebb9e1cf255b8\sp2setup.exe ===> MSI (c) (94:58) [19:05:40:481]: Resetting cached policy values
> MSI (c) (94:58) [19:05:40:481]: Machine policy value 'Debug' is 0
> MSI (c) (94:58) [19:05:40:481]: ******* RunEngine:
> ******* Product: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
> ******* Action:
> ******* CommandLine: **********
> MSI (c) (94:58) [19:05:40:481]: Client-side and UI is none or basic: Running
> entire install on the server.
> MSI (c) (94:58) [19:05:40:481]: Grabbed execution mutex.
> MSI (c) (94:58) [19:05:40:590]: Cloaking enabled.
> MSI (c) (94:58) [19:05:40:590]: Attempting to enable all disabled priveleges
> before calling Install on Server
> MSI (c) (94:58) [19:05:40:621]: Incrementing counter to disable shutdown.
> Counter after increment: 0
> MSI (s) (A8:0C) [19:05:40:668]: Grabbed execution mutex.
> MSI (s) (A8:E0) [19:05:40:668]: Resetting cached policy values
> MSI (s) (A8:E0) [19:05:40:668]: Machine policy value 'Debug' is 0
> MSI (s) (A8:E0) [19:05:40:668]: ******* RunEngine:
> ******* Product: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
> ******* Action:
> ******* CommandLine: **********
> MSI (s) (A8:E0) [19:05:40:668]: Machine policy value 'DisableUserInstalls'
> is 0
> MSI (s) (A8:E0) [19:05:40:684]: Warning: Local cached package
> 'C:\W2TP\Installer\ba2813.msi' is missing.
> MSI (s) (A8:E0) [19:05:40:684]: User policy value 'SearchOrder' is 'nmu'
> MSI (s) (A8:E0) [19:05:40:684]: User policy value 'DisableMedia' is 0
> MSI (s) (A8:E0) [19:05:40:684]: Machine policy value 'AllowLockdownMedia' is 0
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Media enabled only if package is
> safe.
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Looking for sourcelist for
> product {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Adding
> {33FE9EED-1976-4A51-A7AF-332D9BBB9400}; to potential sourcelist list
> (pcode;disk;relpath).
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Now checking product
> {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Media is enabled for product.
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Attempting to use LastUsedSource
> from source list.
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Trying source
> D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\.
> MSI (s) (A8:E0) [19:05:40:856]: Entering
> CMsiConfigurationManager::SetLastUsedSource.
> MSI (s) (A8:E0) [19:05:40:856]: Specifed source is already in a list.
> MSI (s) (A8:E0) [19:05:40:856]: User policy value 'SearchOrder' is 'nmu'
> MSI (s) (A8:E0) [19:05:40:856]: Machine policy value 'DisableBrowse' is 0
> MSI (s) (A8:E0) [19:05:40:856]: Machine policy value 'AllowLockdownBrowse'
> is 0
> MSI (s) (A8:E0) [19:05:40:856]: Adding new sources is allowed.
> MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedSource to:
> D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\.
> MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedType to: n.
> MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedIndex to: 1.
> MSI (s) (A8:E0) [19:05:40:871]: SOURCEMGMT: Resolved source to:
> 'D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\'
> MSI (s) (A8:E0) [19:05:40:918]: File will have security applied from OpCode.
> MSI (s) (A8:E0) [19:05:41:215]: End dialog not enabled
> MSI (s) (A8:E0) [19:05:41:215]: Original package ==>
> D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\RSRUN.MSI
> MSI (s) (A8:E0) [19:05:41:215]: Package we're running from ==>
> C:\W2TP\Installer\cbc12.msi
> MSI (s) (A8:E0) [19:05:41:418]: APPCOMPAT: looking for appcompat database
> entry with ProductCode '{33FE9EED-1976-4A51-A7AF-332D9BBB9400}'.
> MSI (s) (A8:E0) [19:05:41:418]: APPCOMPAT: no matching ProductCode found in
> database.
> MSI (s) (A8:E0) [19:05:41:418]: MSCOREE not loaded loading copy from system32
> MSI (s) (A8:E0) [19:05:41:512]: Opening existing patch
> 'C:\W2TP\Installer\ba290c.msp'.
> MSI (s) (A8:E0) [19:05:41:512]: Note: 1: 2203 2:
> C:\W2TP\Installer\ba290c.msp 3: -2147287038
> MSI (s) (A8:E0) [19:05:41:512]: Couldn't find local patch
> 'C:\W2TP\Installer\ba290c.msp'. Looking for it at its source.
> MSI (s) (A8:E0) [19:05:41:512]: Resolving Patch source.
> MSI (s) (A8:E0) [19:05:41:512]: User policy value 'SearchOrder' is 'nmu'
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Media enabled only if package is
> safe.
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Looking for sourcelist for
> product {813A147C-2328-4439-9D40-1486308CB952}
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Adding
> {813A147C-2328-4439-9D40-1486308CB952}; to potential sourcelist list
> (pcode;disk;relpath).
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Now checking product
> {813A147C-2328-4439-9D40-1486308CB952}
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Media is enabled for product.
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Attempting to use LastUsedSource
> from source list.
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Processing net source list.
> MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Trying source
> e:\3d0526d9dd77e601344dcc338f4f\.
> MSI (s) (A8:E0) [19:05:41:527]: Note: 1: 2203 2:
> e:\3d0526d9dd77e601344dcc338f4f\sp1patch.msp 3: -2147287037
> MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Source is invalid due to
> missing/inaccessible package.
> MSI (s) (A8:E0) [19:05:41:527]: Note: 1: 1706 2: -2147483647 3: sp1patch.msp
> MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Processing media source list.
> MSI (s) (A8:E0) [19:05:42:652]: SOURCEMGMT: Resolved source to: 'sp1patch.msp'
> MSI (s) (A8:E0) [19:06:49:199]: Note: 1: 1314 2: sp1patch.msp
> MSI (s) (A8:E0) [19:06:49:199]: Unable to create a temp copy of patch
> 'sp1patch.msp'.
> This patch package could not be opened. Verify that the patch package
> exists and that you can access it, or contact the application vendor to
> verify that this is a valid Windows Installer patch package.
> D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\RSRUN.MSI
> MSI (s) (A8:E0) [19:06:49:215]: Note: 1: 1708
> MSI (s) (A8:E0) [19:06:49:215]: Note: 1: 2729
> MSI (s) (A8:E0) [19:06:49:309]: Note: 1: 2729
> MSI (s) (A8:E0) [19:06:49:324]: Product: Microsoft SQL Server 2000 Reporting
> Services Enterprise Edition -- Installation failed.
> MSI (s) (A8:E0) [19:06:49:340]: MainEngineThread is returning 1635
> MSI (c) (94:58) [19:06:49:356]: Decrementing counter to disable shutdown. If
> counter >= 0, shutdown will be denied. Counter after decrement: -1
> MSI (c) (94:58) [19:06:49:356]: MainEngineThread is returning 1635
> === Verbose logging stopped: 10/28/2005 19:06:49 ===>