Showing posts with label display. Show all posts
Showing posts with label display. Show all posts

Friday, March 30, 2012

rsFailedToDecryptConfigInformation

I have Windows XP(SP1) With Framework v1.1.4322
- When I build a Report the application display this message:
Build complete -- 0 errors, 0 warnings
- When I deploy a Report the application display this message:
Deploying to http://localhost/ReportServer?%2fReportesSINPHOS
Error rsFailedToDecryptConfigInformation :
The encrypted value for configuration setting Dsn cannot be decrypted.
Deploy complete -- 1 errors, 0 warnings
I also delete and create a new data environment and still send me this
messages.
What can I do, to solve this?Sounds like your configuration file DSN element has become invalid. Running
rsconfig should solve this problem.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"vonpatogm" <vonpatogm@.discussions.microsoft.com> wrote in message
news:1F87BF5B-1366-4B05-9771-33AA80E86434@.microsoft.com...
> I have Windows XP(SP1) With Framework v1.1.4322
> - When I build a Report the application display this message:
> Build complete -- 0 errors, 0 warnings
> - When I deploy a Report the application display this message:
> Deploying to http://localhost/ReportServer?%2fReportesSINPHOS
> Error rsFailedToDecryptConfigInformation :
> The encrypted value for configuration setting Dsn cannot be decrypted.
> Deploy complete -- 1 errors, 0 warnings
> I also delete and create a new data environment and still send me this
> messages.
> What can I do, to solve this?|||Tks.
But, I did run this batch:
rsconfig -c -s11.254.16.11 -dDBSINPHOS -aSQL -uusr_siaish -pimss -t
It send this follow error:
System.Exception: Error: HRESULT=0x8004F992 For more information, see the
event log in the Event Viewer.
at
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
How do u see it?
"Daniel Reib [MSFT]" wrote:
> Sounds like your configuration file DSN element has become invalid. Running
> rsconfig should solve this problem.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "vonpatogm" <vonpatogm@.discussions.microsoft.com> wrote in message
> news:1F87BF5B-1366-4B05-9771-33AA80E86434@.microsoft.com...
> > I have Windows XP(SP1) With Framework v1.1.4322
> >
> > - When I build a Report the application display this message:
> > Build complete -- 0 errors, 0 warnings
> >
> > - When I deploy a Report the application display this message:
> > Deploying to http://localhost/ReportServer?%2fReportesSINPHOS
> > Error rsFailedToDecryptConfigInformation :
> > The encrypted value for configuration setting Dsn cannot be decrypted.
> > Deploy complete -- 1 errors, 0 warnings
> >
> > I also delete and create a new data environment and still send me this
> > messages.
> >
> > What can I do, to solve this?
>
>|||Go to the administrator tools and click on event log.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"vonpatogm" <vonpatogm@.discussions.microsoft.com> wrote in message
news:4E148DAA-CE6D-443D-8F83-C861408D768E@.microsoft.com...
> Tks.
> But, I did run this batch:
> rsconfig -c -s11.254.16.11 -dDBSINPHOS -aSQL -uusr_siaish -pimss -t
> It send this follow error:
> System.Exception: Error: HRESULT=0x8004F992 For more information, see the
> event log in the Event Viewer.
> at
> Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[]
args,
> BaseCmdLine instance)
> How do u see it?
> "Daniel Reib [MSFT]" wrote:
> > Sounds like your configuration file DSN element has become invalid.
Running
> > rsconfig should solve this problem.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "vonpatogm" <vonpatogm@.discussions.microsoft.com> wrote in message
> > news:1F87BF5B-1366-4B05-9771-33AA80E86434@.microsoft.com...
> > > I have Windows XP(SP1) With Framework v1.1.4322
> > >
> > > - When I build a Report the application display this message:
> > > Build complete -- 0 errors, 0 warnings
> > >
> > > - When I deploy a Report the application display this message:
> > > Deploying to http://localhost/ReportServer?%2fReportesSINPHOS
> > > Error rsFailedToDecryptConfigInformation :
> > > The encrypted value for configuration setting Dsn cannot be decrypted.
> > > Deploy complete -- 1 errors, 0 warnings
> > >
> > > I also delete and create a new data environment and still send me this
> > > messages.
> > >
> > > What can I do, to solve this?
> >
> >
> >

rsExecutionNotFound

I wrote a Custom Web App using ASP.NET for reports built using SSRS 2005. The web application uses report viewer control to display the reports. The Report Viewer processing mode is set to "Remote". The session timeout for web application is 30 minutes.

Reports autorefresh property is set to 15 minutes. when the web page thats displaying the reports is running continously, I am occassionally seeing "rsExecutionNotFound" error. The error is not going away even if I refresh the page.

Thanks for u'r help.

Dear NR01,

There could be a possibility that the session of reporting services is timing out.

Try this post

HTH,

Suprotim Agarwal

|||

Hi,

I tried the post you mentioned. when I run the reports continously, still I am seeing rsExecutionNotFound error but not as frequent as before.

I set the timeout to 30 min.

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="1800"

I am refreshing the reports every 15min.

Thanks for u'r help.

-NR01

|||

I also did the same and set the timeout=1800.

I still get many of these failures. I didn't notice any changes going from 600 to 1800.

This is a typical error:

w3wp!ui!7!7/23/2007-04:52:49:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Execution 'c14v5l45yikbbo55d5vk1jj3' cannot be found (rsExecutionNotFound)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

I can't imagine that people are sitting on a page for more than 30 minutes. Could there be another cause?

Neil

|||

I've solved the same issue.

I'm viewing reports with asp.net reportviewer; on production server, my aspx load correctly the report at first time, but any postback returns "rsExecutionNotFound" error.

I realized my aspx code contains hard-coded reportserverurl and reportpath values, which are different for development and production envs. So when I dynamically set up thoses settings in my page, reportviewer kill its client session since I'm changing the report path from one server to another.

So change :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport ReportServerUrl="http://DEVSERVER/ReportServer" ReportPath="/MyPath" />

</rsweb:ReportViewer>

To :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport />

</rsweb:ReportViewer>

sql

rsExecutionNotFound

I wrote a Custom Web App using ASP.NET for reports built using SSRS 2005. The web application uses report viewer control to display the reports. The Report Viewer processing mode is set to "Remote". The session timeout for web application is 30 minutes.

Reports autorefresh property is set to 15 minutes. when the web page thats displaying the reports is running continously, I am occassionally seeing "rsExecutionNotFound" error. The error is not going away even if I refresh the page.

Thanks for u'r help.

Dear NR01,

There could be a possibility that the session of reporting services is timing out.

Try this post

HTH,

Suprotim Agarwal

|||

Hi,

I tried the post you mentioned. when I run the reports continously, still I am seeing rsExecutionNotFound error but not as frequent as before.

I set the timeout to 30 min.

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="1800"

I am refreshing the reports every 15min.

Thanks for u'r help.

-NR01

|||

I also did the same and set the timeout=1800.

I still get many of these failures. I didn't notice any changes going from 600 to 1800.

This is a typical error:

w3wp!ui!7!7/23/2007-04:52:49:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Execution 'c14v5l45yikbbo55d5vk1jj3' cannot be found (rsExecutionNotFound)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

I can't imagine that people are sitting on a page for more than 30 minutes. Could there be another cause?

Neil

|||

I've solved the same issue.

I'm viewing reports with asp.net reportviewer; on production server, my aspx load correctly the report at first time, but any postback returns "rsExecutionNotFound" error.

I realized my aspx code contains hard-coded reportserverurl and reportpath values, which are different for development and production envs. So when I dynamically set up thoses settings in my page, reportviewer kill its client session since I'm changing the report path from one server to another.

So change :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport ReportServerUrl="http://DEVSERVER/ReportServer" ReportPath="/MyPath" />

</rsweb:ReportViewer>

To :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport />

</rsweb:ReportViewer>

Wednesday, March 28, 2012

RSClientPrint issue and its resolution

For the record, and for anyone else this issue might affect...
We have an intranet application that uses RSClientPrint to display a
variety of reports from a particular web application. The
RSClientPrint object worked properly on some people's PCs, but on
others it would appear to hang for 15 minutes or more before finally
giving an error message "An error occured during printing.
(0x800C000B).
After scratching our heads over this for 3 business days, we
investigated the difference between those PCs where RSClientPrint
works, and those where it did not work.
The solution is that in IE, HTTP 1.1 must be enabled. In IE, go to
Tools - Options, Advanced tab, and scroll down to HTTP 1.1 settings.
Make sure that "Use 1.1" is checked.Interesting. I'm saving this posting. Not intuitive at all. Thanks for
letting us know.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rod" <RodEarly@.gmail.com> wrote in message
news:1169568932.741442.177430@.l53g2000cwa.googlegroups.com...
> For the record, and for anyone else this issue might affect...
> We have an intranet application that uses RSClientPrint to display a
> variety of reports from a particular web application. The
> RSClientPrint object worked properly on some people's PCs, but on
> others it would appear to hang for 15 minutes or more before finally
> giving an error message "An error occured during printing.
> (0x800C000B).
> After scratching our heads over this for 3 business days, we
> investigated the difference between those PCs where RSClientPrint
> works, and those where it did not work.
> The solution is that in IE, HTTP 1.1 must be enabled. In IE, go to
> Tools - Options, Advanced tab, and scroll down to HTTP 1.1 settings.
> Make sure that "Use 1.1" is checked.
>|||Hi Rod,
I am having the EXACT same problem you were having except that I have
"Use HTTP 1.1" already checked. Any other ideas?
Thanks,
Brian
"Rod" wrote:
> For the record, and for anyone else this issue might affect...
> We have an intranet application that uses RSClientPrint to display a
> variety of reports from a particular web application. The
> RSClientPrint object worked properly on some people's PCs, but on
> others it would appear to hang for 15 minutes or more before finally
> giving an error message "An error occured during printing.
> (0x800C000B).
> After scratching our heads over this for 3 business days, we
> investigated the difference between those PCs where RSClientPrint
> works, and those where it did not work.
> The solution is that in IE, HTTP 1.1 must be enabled. In IE, go to
> Tools - Options, Advanced tab, and scroll down to HTTP 1.1 settings.
> Make sure that "Use 1.1" is checked.
>

Friday, March 23, 2012

RS2k - Display text to say there are no rows?

Hi,

This is probably an easy one, but its been bugging me.

If I have no rows for a particular table, is there any way that I can simply display some text saying something like 'no data available for report' ?

Similarly, I was thinking I could hider certain controls on the report if there are no rows available by using an expression in the Visible property of the control.

Any suggestions are appreciated.

Regards.

MrPeds

In the VS Properties (not the Properties from the context menu) there is a NoRows property that is the Text you want displayed when the dataset returns no rows. There is not a way to determine from the table at run time if there are any rows or not, but you can get a row count on DataSet1 like:

Code Snippet

=CountRows("DataSet1")

Hope this helps.

Larry

Wednesday, March 21, 2012

RS2005 languages support

Hi All,
My application is a web base application.
I should display the report table header in defrent languages: Engalsh,
French,German and more .
How RS 2005 handle with translation to the headers ?
Can I change the header after I deploy the report ?
10x,
Shachar.> My application is a web base application.
> I should display the report table header in defrent languages:
> Engalsh,
> French,German and more .
> How RS 2005 handle with translation to the headers ?
> Can I change the header after I deploy the report ?
> 10x,
Hello Shachar,
I assume you already have the translations stored in a database somewhere.
You can create a report parameter that lets the user select which language,
and use that parameter to query the proper table headers from the database.
-Chrissql