rsExecutionNotFound when using ASP State Server

I'm working on an ASP.NET 2.0 project and we are using Reporting Services 2005, the web application is configured to work with a State Server. Our users are getting the following error randomly:

[ReportServerException: No se encuentra la ejecución 'bla bla bla' (rsExecutionNotFound)]

Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() + 367

Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId) + 117

Microsoft.Reporting.WebForms.ServerReport..ctor(SerializationInfo info, StreamingContext context() + 206

[TargetInvocationException: Exception has been thrown by the target invocation]

System.RuntimeMethodHandle._SerializationInvoke(Object target, SignatureStruct& declaringType, ...

...

System.Web.SessionState.SessionStateItemCollection.DeserializeAllItems() + 88

System.Web.SessionState.SessionStateItemCollection.get_Keys() + 9

System.Web.SessionState.HttpSessionStateContainer.get_Keys() + 10

System.Web.SessionState.HttpSessionState.get_Keys() + 10

...

This exception is thrown in a request when we access the session context to get a variable. After some investigation we have found that the report viewer is storing reports in the session context, we supose that when the report execution expires on server this error is thrown and the user must close Internet explorer and reenter the application.

Is there any way to avoid Report viewer storing reports on session context, if not I think that this is a bug because when using a state server this error is not recoverable and the user must close the Internet explorer. This think doesn' like them much ;-)

Any help would be appreciated

thanks in advance

I'm sorry, I'm not currently bringing a solution to your problem, although:

- I did post the issue on MSDN Labs: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=90396e94-e868-4a33-b784-f43dcd5a7393

- There is a solution, although it's a hack: http://groups.google.fr/group/ReportingServices/browse_thread/thread/685274e5aa25310/bae5e060b65863b0?lnk=st&q=rsexecutionnotfound&rnum=3&hl=fr#bae5e060b65863b0

Trace.axd brings nothing useful session-wise.

If you did find a solution, please post it, as I too need one!

|||Microsoft says that this is solved, but I can't find where, may be in Sql Server 2005 SP1?

rsExecutionNotFound when using ASP State Server

I'm working on an ASP.NET 2.0 project and we are using Reporting Services 2005, the web application is configured to work with a State Server. Our users are getting the following error randomly:

[ReportServerException: No se encuentra la ejecución 'bla bla bla' (rsExecutionNotFound)]

Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() + 367

Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId) + 117

Microsoft.Reporting.WebForms.ServerReport..ctor(SerializationInfo info, StreamingContext context() + 206

[TargetInvocationException: Exception has been thrown by the target invocation]

System.RuntimeMethodHandle._SerializationInvoke(Object target, SignatureStruct& declaringType, ...

...

System.Web.SessionState.SessionStateItemCollection.DeserializeAllItems() + 88

System.Web.SessionState.SessionStateItemCollection.get_Keys() + 9

System.Web.SessionState.HttpSessionStateContainer.get_Keys() + 10

System.Web.SessionState.HttpSessionState.get_Keys() + 10

...

This exception is thrown in a request when we access the session context to get a variable. After some investigation we have found that the report viewer is storing reports in the session context, we supose that when the report execution expires on server this error is thrown and the user must close Internet explorer and reenter the application.

Is there any way to avoid Report viewer storing reports on session context, if not I think that this is a bug because when using a state server this error is not recoverable and the user must close the Internet explorer. This think doesn' like them much ;-)

Any help would be appreciated

thanks in advance

I'm sorry, I'm not currently bringing a solution to your problem, although:

- I did post the issue on MSDN Labs: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=90396e94-e868-4a33-b784-f43dcd5a7393

- There is a solution, although it's a hack: http://groups.google.fr/group/ReportingServices/browse_thread/thread/685274e5aa25310/bae5e060b65863b0?lnk=st&q=rsexecutionnotfound&rnum=3&hl=fr#bae5e060b65863b0

Trace.axd brings nothing useful session-wise.

If you did find a solution, please post it, as I too need one!

|||Microsoft says that this is solved, but I can't find where, may be in Sql Server 2005 SP1?

rsExecutionNotFound when using ASP State Server

I'm working on an ASP.NET 2.0 project and we are using Reporting Services 2005, the web application is configured to work with a State Server. Our users are getting the following error randomly:

[ReportServerException: No se encuentra la ejecución 'bla bla bla' (rsExecutionNotFound)]

Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() + 367

Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId) + 117

Microsoft.Reporting.WebForms.ServerReport..ctor(SerializationInfo info, StreamingContext context() + 206

[TargetInvocationException: Exception has been thrown by the target invocation]

System.RuntimeMethodHandle._SerializationInvoke(Object target, SignatureStruct& declaringType, ...

...

System.Web.SessionState.SessionStateItemCollection.DeserializeAllItems() + 88

System.Web.SessionState.SessionStateItemCollection.get_Keys() + 9

System.Web.SessionState.HttpSessionStateContainer.get_Keys() + 10

System.Web.SessionState.HttpSessionState.get_Keys() + 10

...

This exception is thrown in a request when we access the session context to get a variable. After some investigation we have found that the report viewer is storing reports in the session context, we supose that when the report execution expires on server this error is thrown and the user must close Internet explorer and reenter the application.

Is there any way to avoid Report viewer storing reports on session context, if not I think that this is a bug because when using a state server this error is not recoverable and the user must close the Internet explorer. This think doesn' like them much ;-)

Any help would be appreciated

thanks in advance

I'm sorry, I'm not currently bringing a solution to your problem, although:

- I did post the issue on MSDN Labs: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=90396e94-e868-4a33-b784-f43dcd5a7393

- There is a solution, although it's a hack: http://groups.google.fr/group/ReportingServices/browse_thread/thread/685274e5aa25310/bae5e060b65863b0?lnk=st&q=rsexecutionnotfound&rnum=3&hl=fr#bae5e060b65863b0

Trace.axd brings nothing useful session-wise.

If you did find a solution, please post it, as I too need one!

|||Microsoft says that this is solved, but I can't find where, may be in Sql Server 2005 SP1?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>

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>

rsDataExtensionNotFound for using XML

Hi all,

I am using SQL Server 2005 reporting service and I am attempting to create a report via xml returned from a web service. Everything works fine while I am in the report designer of visual studio 2005.

However, when I attempt to deploy the report to the report server, it will complain that the xml data extension is not registered with the report server, giving me a rsDataExtensionNotFound. A check on the report server config file does show the xml data extension with all the microsoft namespaces. I had thought that Reporting Services in SQL Server 2005 does natively support xml data source.

Has anyone encountered a similar problem? Does anyone have any suggestions?

Does it matter that the SQL Server 2005 that I have is the workgroup edition ?

Thanks

HI,krayek:

As far as i know ,XML data sources are not supported in SQL Express:

http://msdn2.microsoft.com/en-us/library/ms365166.aspx

(See "Unsupported Features" section.

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

Thanks for the reply.

However, my SQL version is SQL Server 2005 workgroup edition.

So, I am wondering if this SQL Server 2005 workgroup edition also does not support XML data extension ?

Regards,

David K

|||

HI, David K

No, SQL Server 2005 workgroup edition did not support non relational data source.

Features/Reporting Services Enhancements

EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)SE (32-bit) SE (64-bit)WG (32-bit)SSE (32-bit)SSEA (32-bit)Support for remote and nonrelational data sourcesYesYesNoNoNo

Please refer this article: http://msdn2.microsoft.com/en-us/library/ms143761.aspx

|||

Hi Rex,

Thanks for that info. Darn, looks like I need to get the standard edition then.. =)

Thanks again for the help, appreciate it.

Regards,

David K

|||

You are welcome,David.

It's my pleasure!

RSClientPrint.Print method

Does anyone know the ReportService web service API calls that are made by
this method?
RSClientPrint.Print(ReportServerURL, ReportPath, ShortReportNameForPrinter);
RSClientPrint.Print('http://servername/ReportServer',
'%2fReport1%2fSalesOrders', 'SalesOrders');It is using URL access to render a report (
http://msdn2.microsoft.com/en-us/library/ms154493.aspx )
You can see all those requests in IIS log
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"brian" <brian@.discussions.microsoft.com> wrote in message
news:D3AFC98A-CF64-481B-8936-0366DA032CDC@.microsoft.com...
> Does anyone know the ReportService web service API calls that are made by
> this method?
> RSClientPrint.Print(ReportServerURL, ReportPath,
> ShortReportNameForPrinter);
> RSClientPrint.Print('http://servername/ReportServer',
> '%2fReport1%2fSalesOrders', 'SalesOrders');

RSClientPrint in FireFox

Hi,

We are using the RSClientPrint component to print reports from our web application. When we use it from IE all works fine. But on using the FireFox the print method fails. I am using following code to print

Code Snippet

var oRSClientPrint = window.document.getElementById("RSClientPrint");
alert(oRSClientPrint);
if (typeof oRSClientPrint.Print == "undefined")
{
alert("Unable to load client print control.");
return;
}

In FireFox above code fails by raising error message "Unable to load client print control.". As per me FireFox is not able to use the Print method of object, Can you help me on how we can make it to work with FireFox.

Thanks and Regards,
Nav

The control for printing is an ActiveX control and is not supported in non-IE browsers.

There is a plugin for loading ActiveX controls that you may be able to get for firefox or netscape, if you have control over the client pc.

You will probably have to export the report to an html file, redirect to the html file, and use some javascript to popup the print dialog.

cheers,

Andrew

sql

rsactivate returns error, unable to activate error

Failure starting the web service:
Unexpected database error (-2147159548) 0x80004002Hi, possibly your configuration is bad, try runnig, rsconfig.exe with the
new parameters and then try with this again, in most cases this problem is
for bad configuration.
"hcas" wrote:
> Failure starting the web service:
> Unexpected database error (-2147159548) 0x80004002|||Hi, the problem is because the ASPNet is not reg over IIS, with this command
you can repair this.
c> "%windir%\Microsoft.NET\Framework\v1.0.375\aspnet_regiis.exe" -i
regsvr32 %windir%\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll
the aspnet_regiis.exe is a command of .net Framework
Best Regards
John Bocachica
Colombia|||HI John:
I have already tried quite a few different rsconfig.exe settings and users
with no luck. I also re-registered aspnet (I am using a higher version,
1.1.4322) and its dll. The same error occurs when I attempt to use the
rsactivate command. If I use the server name as opposed to the config file,
I get the following error.
Failure initializing remote NT Service:
Unexpected database error (-2147159548) 0x80004002
"John Bocachica" wrote:
> Hi, the problem is because the ASPNet is not reg over IIS, with this command
> you can repair this.
> c> "%windir%\Microsoft.NET\Framework\v1.0.375\aspnet_regiis.exe" -i
> regsvr32 %windir%\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll
> the aspnet_regiis.exe is a command of .net Framework
> Best Regards
> John Bocachica
> Colombia

RSActivate Error

I am getting the following error when attempting to run RSActivate to add a
server to a web farm:
Failure starting the web service:
The local NT service is not activated
The log file contains the following entries:
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
Activating web service via RPC.
w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80004005): -2147159550
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80004005): -2147159550
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()What error do you see in the Windows service log file?
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> I am getting the following error when attempting to run RSActivate to add
a
> server to a web farm:
> Failure starting the web service:
> The local NT service is not activated
> The log file contains the following entries:
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> Activating web service via RPC.
> w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
Int32
> clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services error
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
Int32
> clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>|||Here is what I see in the Windows service log file:
ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: Exporting
public key
ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: NT Service
not activated
ReportingServicesService!library!764!8/17/2004-10:29:51:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information.
ReportingServicesService!library!764!8/17/2004-10:29:51:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information.
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!764!8/17/2004-10:29:51:: Attempting to
start service again...
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:O0xHpDIhEHA.3540@.TK2MSFTNGP10.phx.gbl...
> What error do you see in the Windows service log file?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
> news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> > I am getting the following error when attempting to run RSActivate to
add
> a
> > server to a web farm:
> >
> > Failure starting the web service:
> > The local NT service is not activated
> >
> > The log file contains the following entries:
> >
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as
user:
> > NT AUTHORITY\NETWORK SERVICE
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> > Activating web service via RPC.
> > w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > ception: The report server installation is not initialized. Check the
> > documentation for more information., ;
> > Info:
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > ception: The report server installation is not initialized. Check the
> > documentation for more information. -->
> > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
mainError,
> > Int32 extendedError)
> > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32
> > clientType)
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > -- End of inner exception stack trace --
> > w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services
error
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > ception: The report server installation is not initialized. Check the
> > documentation for more information. -->
> > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
mainError,
> > Int32 extendedError)
> > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32
> > clientType)
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > at Microsoft.ReportingServices.Library.Storage.get_Connection()
> > at
> > Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> > storedProcedureName)
> > at
> >
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> > ng key)
> > at
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> > (String name)
> > at
> Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > name)
> > at
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> > ng name)
> > at
Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> > at
Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> > source)
> > at
> >
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > path, Boolean validate, Boolean convert, Boolean translate)
> > at
> >
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > path)
> > at
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> > tent()
> > at
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> >
> >
>|||Are you reusing a database from a previous installation? It looks like the
windows service is not activating automatically because it thinks another
report server is using the database. If this is not the case, you can clear
out the old entries by running rskeymgmt -d, then restart the windows and
web service.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:upNDrRJhEHA.3980@.TK2MSFTNGP12.phx.gbl...
> Here is what I see in the Windows service log file:
> ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: NT
Service
> not activated
> ReportingServicesService!library!764!8/17/2004-10:29:51:: e ERROR:
Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information.
> ReportingServicesService!library!764!8/17/2004-10:29:51:: Exception caught
> while starting service. Error:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information.
> at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!764!8/17/2004-10:29:51:: Attempting to
> start service again...
>
> "Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
> news:O0xHpDIhEHA.3540@.TK2MSFTNGP10.phx.gbl...
> > What error do you see in the Windows service log file?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
> > news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> > > I am getting the following error when attempting to run RSActivate to
> add
> > a
> > > server to a web farm:
> > >
> > > Failure starting the web service:
> > > The local NT service is not activated
> > >
> > > The log file contains the following entries:
> > >
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as
> user:
> > > NT AUTHORITY\NETWORK SERVICE
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not
activated
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> > > Activating web service via RPC.
> > > w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > > ception: The report server installation is not initialized. Check the
> > > documentation for more information., ;
> > > Info:
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > > ception: The report server installation is not initialized. Check the
> > > documentation for more information. -->
> > > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
> mainError,
> > > Int32 extendedError)
> > > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> > Int32
> > > clientType)
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > -- End of inner exception stack trace --
> > > w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services
> error
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > > ception: The report server installation is not initialized. Check the
> > > documentation for more information. -->
> > > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
> mainError,
> > > Int32 extendedError)
> > > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> > Int32
> > > clientType)
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > -- End of inner exception stack trace --
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > at
> > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > > at
> > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > > at Microsoft.ReportingServices.Library.Storage.get_Connection()
> > > at
> > >
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> > > storedProcedureName)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> > > ng key)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> > > (String name)
> > > at
> > Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > > name)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> > > ng name)
> > > at
> Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> > > at
> Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> > > source)
> > > at
> > >
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > > path, Boolean validate, Boolean convert, Boolean translate)
> > > at
> > >
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > > path)
> > > at
> > >
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> > > tent()
> > > at
> > >
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> > >
> > >
> >
> >
>

RS2005 Web ReportViewer: Unable to set parameters and ReportServerCredentials

Hey guys,
I'm using the report viewer web control in my web application. I got it
somewhat working but now I'm stuck:
1) I can't set the parameters for the report. When I call SetParameters and
pass a ReportParameter array, it complains that this report doesn't have
parameter 'XYZ'. But in reality it does. My suspicion was that the
ServerReport object is not filled with report data yet.
So I called GetParameters beforehand to see if it would initialize the
parameters collection. Then I found out that the parameters collection is
set to read-only, which means I can't set parameter values in an initialized
parameter collection.
Last try was to call SetParameters after calling GetParameters but I got the
same exception as when calling w/o GetParameters.
2) I need to pass ReportServerCredentials to RS because of course ASPNET
does not have access rights to RS. The only property that is not read-only
underneath the ReportServerCredentials property is the
ReportServerCredentials itself, which is of type IReportServerCredentials.
So far I couldn't find any credentials object that implements this
interface.
Anybody any idea?
Thanks, ChristophI have the same problem, did anyone ever respond to you?
"Christoph Wienands" wrote:
> Hey guys,
> I'm using the report viewer web control in my web application. I got it
> somewhat working but now I'm stuck:
> 1) I can't set the parameters for the report. When I call SetParameters and
> pass a ReportParameter array, it complains that this report doesn't have
> parameter 'XYZ'. But in reality it does. My suspicion was that the
> ServerReport object is not filled with report data yet.
> So I called GetParameters beforehand to see if it would initialize the
> parameters collection. Then I found out that the parameters collection is
> set to read-only, which means I can't set parameter values in an initialized
> parameter collection.
> Last try was to call SetParameters after calling GetParameters but I got the
> same exception as when calling w/o GetParameters.
> 2) I need to pass ReportServerCredentials to RS because of course ASPNET
> does not have access rights to RS. The only property that is not read-only
> underneath the ReportServerCredentials property is the
> ReportServerCredentials itself, which is of type IReportServerCredentials.
> So far I couldn't find any credentials object that implements this
> interface.
> Anybody any idea?
> Thanks, Christoph
>
>

RS2005 web reference produces "C2234: Array of References illegal"

Hello,
I'm new to RS2005 and have begun going through the Tutorials in SQLServer 2005 Books Online. I'm currently attempting to add "reportingservices2005.asmx" as a web reference to my VS2003 C#.NET project and I keep getting this compile time error:

error C2234: 'Warnings' : arrays of references are illegal

How do I get rid of this compile time error? This error appears in the generated file representing the RS2005.wsdl. Aside from the generated web reference files the other files of the VS2003 C#.NET project are the default project files by the wizard.

Thanks in advance for the help
ZeroVerticalUpgrading to VS2005 C#.NET got rid of the error. I must have overlooked this requirement. I just upgraded to VS2005 C#.NET and everything works fine now.|||It shouldn't really be a requirement. Not sure why it is happening. You should file a bug on the feedback center.

RS2005 ReportViewer

Is it possible to use the ReportViewer user control in an ASP.NET 1.1 Web App? All the tutorials I have found integrates the reportviewer control from RS2000 and not RS2005.I don't think so. The Report Viewer Control is new to ASP.NET 2.0.

RS2005 Print Legal

Hello,
I'm trying to automate printing to legal size paper from the web
ReportViewer control.
In my Report Properties / Layout I have Page Width= 14in and Page
Height= 8.5in.
When the report renders I hit the print icon. It shows that the report
will print to landscape,
but the paper size is set to Letter.
Is there a way to programatically set the paper size to legal?
TIA,
JimNo you can not set this on the fly, and there have been bugs regarding the
portrait/landscape issue..
However you may have the settings backward... Width should be 8.5in and
height should be 14in...(myabe you just typed it backward in your post.)
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"jhcorey@.yahoo.com" wrote:
> Hello,
> I'm trying to automate printing to legal size paper from the web
> ReportViewer control.
> In my Report Properties / Layout I have Page Width= 14in and Page
> Height= 8.5in.
> When the report renders I hit the print icon. It shows that the report
> will print to landscape,
> but the paper size is set to Letter.
> Is there a way to programatically set the paper size to legal?
> TIA,
> Jim
>

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

RS2005 June CTP Reserved.ReportViewerWebControl.axd - what is it?

Running a simple report in Report Manager. Try to export to Web Archive and
it wants to download Reserved.ReportViewerWebControl.axd but I can't seem to
find any information about how to use this file. What is AXD - it's not
listed on the internet.Most likely this is happening because you don't have any application
registered for the .MHTML file extension on the machine where you are
exporting. You should still be able to export by just typing in a file name
with a .mhtml file extension.
This should be fixed in later RS 2005 builds.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris McGuigan" <ChrisMcGuigan@.discussions.microsoft.com> wrote in message
news:96E0FDED-02A1-49BA-AB1E-37DDAF4B84BA@.microsoft.com...
> Running a simple report in Report Manager. Try to export to Web Archive
> and
> it wants to download Reserved.ReportViewerWebControl.axd but I can't seem
> to
> find any information about how to use this file. What is AXD - it's not
> listed on the internet.|||Thanks for the reply. However I've tried this on 2 machines now both with
MHTML as a registered file type.
On the server (Win2003), MHTML is registered to iexplore. On my own dev PC
(Win XP) it's msohtmed. The symptoms remain the same on both.
I do have another issue with url access crashing (bug 564712370)
Exception type: InvalidConfigFileTypeException
Exception message: The type
Microsoft.ReportingServices.UI.WebControlConnection,
ReportingServicesWebUserInterface
Could these be related?
Chris
"Robert Bruckner [MSFT]" wrote:
> Most likely this is happening because you don't have any application
> registered for the .MHTML file extension on the machine where you are
> exporting. You should still be able to export by just typing in a file name
> with a .mhtml file extension.
> This should be fixed in later RS 2005 builds.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Chris McGuigan" <ChrisMcGuigan@.discussions.microsoft.com> wrote in message
> news:96E0FDED-02A1-49BA-AB1E-37DDAF4B84BA@.microsoft.com...
> > Running a simple report in Report Manager. Try to export to Web Archive
> > and
> > it wants to download Reserved.ReportViewerWebControl.axd but I can't seem
> > to
> > find any information about how to use this file. What is AXD - it's not
> > listed on the internet.
>
>

RS2005 email delivery problem

We started using RS 2005 web farm a month ago. Since then we have
problem delivering reports trough email. When using shared
subscription with several reports some reports are sent and some are
not.
Errors displayed by various parts of system are below:
Subscription Last Status text:
The delivery extension for this subscription could not be loaded.
Windows Application event log:
Report Server (MSSQLSERVER) cannot load the Report Server
DocumentLibrary
extension.
At first we thought that problem is our postfix mail server so we
transferred from directly sending mail to sending mail to local SMTP
which then sends mail to postfix. One problem was a connection
timeout. It seems that connection with mail server is opened at the
same time the shared schedule execution has started. With SMTP service
standard time-out of 10 minutes or so reports lasting more than that
have no chance to be sent. So my solution was installing local SMTP
Service from windows components setup and setting its timeout to
timeout needed by our reports. But the problem didn't go away. I was
hoping that unsent mail will be in badmail SMTP folder or that I will
find it in drop folder as unsent mail. Strange thing is that all the
folders are empty. There is no bad mail. My SRS can't send mail to my
local SMTP! When shared subscription with several reports is fired
connection to local SMTP is created. I can see it in Current Sessions.
If subscription is shared I suppose that reports, belonging to shared
subscription, are being executed one by one and sent to SMTP server as
they are finished. Time out of my SMTP is 180 minutes. All the reports
executed one by one take about 30 minutes so I guess now time out is
not a problem. I think that there are 2 possible reasons:
1. Opened connection to SMTP somehow brakes between two reports being
sent and can't be reestablished
2. SRS successfully execute some reports and send them to SMTP and
when next report is finished and have to be sent, SRS can't load DLL
needed to send mail.
Every suggestion will be appreciated!Any ideas?
ijeremi...@.gmail.com wrote:
> We started using RS 2005 web farm a month ago. Since then we have
> problem delivering reports trough email. When using shared
> subscription with several reports some reports are sent and some are
> not.
> Errors displayed by various parts of system are below:
> Subscription Last Status text:
> The delivery extension for this subscription could not be loaded.
> Windows Application event log:
> Report Server (MSSQLSERVER) cannot load the Report Server
> DocumentLibrary
> extension.
> At first we thought that problem is our postfix mail server so we
> transferred from directly sending mail to sending mail to local SMTP
> which then sends mail to postfix. One problem was a connection
> timeout. It seems that connection with mail server is opened at the
> same time the shared schedule execution has started. With SMTP service
> standard time-out of 10 minutes or so reports lasting more than that
> have no chance to be sent. So my solution was installing local SMTP
> Service from windows components setup and setting its timeout to
> timeout needed by our reports. But the problem didn't go away. I was
> hoping that unsent mail will be in badmail SMTP folder or that I will
> find it in drop folder as unsent mail. Strange thing is that all the
> folders are empty. There is no bad mail. My SRS can't send mail to my
> local SMTP! When shared subscription with several reports is fired
> connection to local SMTP is created. I can see it in Current Sessions.
> If subscription is shared I suppose that reports, belonging to shared
> subscription, are being executed one by one and sent to SMTP server as
> they are finished. Time out of my SMTP is 180 minutes. All the reports
> executed one by one take about 30 minutes so I guess now time out is
> not a problem. I think that there are 2 possible reasons:
> 1. Opened connection to SMTP somehow brakes between two reports being
> sent and can't be reestablished
> 2. SRS successfully execute some reports and send them to SMTP and
> when next report is finished and have to be sent, SRS can't load DLL
> needed to send mail.
> Every suggestion will be appreciated!|||If no-one responds here I suggest trying the web based forums. That is where
MS people hang out and the other RS MVP.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ijeremicyu@.gmail.com> wrote in message
news:1184243847.242957.320910@.w3g2000hsg.googlegroups.com...
> Any ideas?
> ijeremi...@.gmail.com wrote:
>> We started using RS 2005 web farm a month ago. Since then we have
>> problem delivering reports trough email. When using shared
>> subscription with several reports some reports are sent and some are
>> not.
>> Errors displayed by various parts of system are below:
>> Subscription Last Status text:
>> The delivery extension for this subscription could not be loaded.
>> Windows Application event log:
>> Report Server (MSSQLSERVER) cannot load the Report Server
>> DocumentLibrary
>> extension.
>> At first we thought that problem is our postfix mail server so we
>> transferred from directly sending mail to sending mail to local SMTP
>> which then sends mail to postfix. One problem was a connection
>> timeout. It seems that connection with mail server is opened at the
>> same time the shared schedule execution has started. With SMTP service
>> standard time-out of 10 minutes or so reports lasting more than that
>> have no chance to be sent. So my solution was installing local SMTP
>> Service from windows components setup and setting its timeout to
>> timeout needed by our reports. But the problem didn't go away. I was
>> hoping that unsent mail will be in badmail SMTP folder or that I will
>> find it in drop folder as unsent mail. Strange thing is that all the
>> folders are empty. There is no bad mail. My SRS can't send mail to my
>> local SMTP! When shared subscription with several reports is fired
>> connection to local SMTP is created. I can see it in Current Sessions.
>> If subscription is shared I suppose that reports, belonging to shared
>> subscription, are being executed one by one and sent to SMTP server as
>> they are finished. Time out of my SMTP is 180 minutes. All the reports
>> executed one by one take about 30 minutes so I guess now time out is
>> not a problem. I think that there are 2 possible reasons:
>> 1. Opened connection to SMTP somehow brakes between two reports being
>> sent and can't be reestablished
>> 2. SRS successfully execute some reports and send them to SMTP and
>> when next report is finished and have to be sent, SRS can't load DLL
>> needed to send mail.
>> Every suggestion will be appreciated!
>sql

RS2005 Crashed After Editing and Restoring Config Files

Dear Anyone,

Here's what happened. We backed up the web.config and the rsreportserver.config. We messed around with it trying to make an assumption worked. When we finally gave up, we deleted these files and renamed back the web.config and the rsreportserver.config files. To our surprise when we tried to open our report manager, the error below showed up. We tried to reconfigure the report server using the reporting services configuration tool to no avail.

Any insights to what had happened and how to resolve it?

Thanks,
Joseph

Error message:

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

check that reportserver service is running|||Yup, report service is running.|||

Hi Joseph,

I have seen something similar if the xml in the config files were mal formed. Open the config file in IE and see if there is a tag missing or something.

David

|||

Thanks for the reply. I have been told that one of the config files is not really an xml file. We've verified this with all of our reporting services installations. Aparently they have some sort of an encrypted data within it. I wonder if this is really true?

|||

We rely on ASP.NET and CLR Security to parse config files (rsReportServer.Config and rssrvpolicy.config).
Unfortunately these things use simplified xml parsers that may not properly handle some of xml features. It is a known fact that rssrvpolicy.config does not handle xml comments.
So whenever you modify config file make sure it is well formed.

RSReportServer.Config contains credentials for connecting to the RS Catalog database. These credentials are encrypted. To change them use Reporting Services Configuration Manager.

RS2005 configuration problem ASPNET account and DBs

Hi all,
I have instaled SQL Server 2005 on my W2K SP4 machine. When I go to RS
configuration I get problems in two areas. First under "Web Service
Identity" no account is listed. ASPNET account is set up on my machine
correctly. Second, under "Database Setup" I can't set up dbs. When I
click "New" and create ReportServer db and then click "Apply" I get an
error that says something like "Virtual Directories have to be crated
first." Under IIS I have ReportServer and Reports directories.
What may be the problem?
Thanks,
StanHi, Stan
just for fun...try running the command line tool "aspnet_regiis -i"
(you can get to it from the VS.NET Command Prompt, or by opening a
regular cmd window and browsing to
c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\)
Once that's run, open your IIS Manager, and check the virtual
directories for Reports and ReportServer web apps. Make sure that they
are running and that the .net mappings are setup appropriately in the
Configuration... > Mappings tab, and also check the security for those
2 folders (use windows auth).
Then try running the RS2005 config tool again, and setup the virtual
directories and apply changes before moving along the different steps
in the tool.
Hope that works.
Regards,
Thiago Silva
MCAD.NET
suslikovich wrote:
> Hi all,
> I have instaled SQL Server 2005 on my W2K SP4 machine. When I go to RS
> configuration I get problems in two areas. First under "Web Service
> Identity" no account is listed. ASPNET account is set up on my machine
> correctly. Second, under "Database Setup" I can't set up dbs. When I
> click "New" and create ReportServer db and then click "Apply" I get an
> error that says something like "Virtual Directories have to be crated
> first." Under IIS I have ReportServer and Reports directories.
> What may be the problem?
> Thanks,
> Stan|||Hi Thiago,
Thanks for the quick reply. I forgot to mention I ran 'aspnet_regiis
-i' but I need to look at othet things you mentioned about mappings and
security. I will do that tonight.
Thanks again,
Stan
tafs7 wrote:
> Hi, Stan
> just for fun...try running the command line tool "aspnet_regiis -i"
> (you can get to it from the VS.NET Command Prompt, or by opening a
> regular cmd window and browsing to
> c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\)
> Once that's run, open your IIS Manager, and check the virtual
> directories for Reports and ReportServer web apps. Make sure that they
> are running and that the .net mappings are setup appropriately in the
> Configuration... > Mappings tab, and also check the security for those
> 2 folders (use windows auth).
> Then try running the RS2005 config tool again, and setup the virtual
> directories and apply changes before moving along the different steps
> in the tool.
> Hope that works.
> Regards,
> Thiago Silva
> MCAD.NET
> suslikovich wrote:
> > Hi all,
> > I have instaled SQL Server 2005 on my W2K SP4 machine. When I go to RS
> > configuration I get problems in two areas. First under "Web Service
> > Identity" no account is listed. ASPNET account is set up on my machine
> > correctly. Second, under "Database Setup" I can't set up dbs. When I
> > click "New" and create ReportServer db and then click "Apply" I get an
> > error that says something like "Virtual Directories have to be crated
> > first." Under IIS I have ReportServer and Reports directories.
> > What may be the problem?
> >
> > Thanks,
> >
> > Stan|||I did "aspnet_regiis -i" once again. Looked at IIS directories.
Mappings look ok. I am quite puzzled about where to check
authentication. In any case, the problem remains. Any other
suggestions?
Thanks,
Stan
suslikovich wrote:
> Hi Thiago,
> Thanks for the quick reply. I forgot to mention I ran 'aspnet_regiis
> -i' but I need to look at othet things you mentioned about mappings and
> security. I will do that tonight.
> Thanks again,
> Stan
> tafs7 wrote:
> > Hi, Stan
> >
> > just for fun...try running the command line tool "aspnet_regiis -i"
> > (you can get to it from the VS.NET Command Prompt, or by opening a
> > regular cmd window and browsing to
> > c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\)
> >
> > Once that's run, open your IIS Manager, and check the virtual
> > directories for Reports and ReportServer web apps. Make sure that they
> > are running and that the .net mappings are setup appropriately in the
> > Configuration... > Mappings tab, and also check the security for those
> > 2 folders (use windows auth).
> >
> > Then try running the RS2005 config tool again, and setup the virtual
> > directories and apply changes before moving along the different steps
> > in the tool.
> >
> > Hope that works.
> >
> > Regards,
> > Thiago Silva
> > MCAD.NET
> >
> > suslikovich wrote:
> > > Hi all,
> > > I have instaled SQL Server 2005 on my W2K SP4 machine. When I go to RS
> > > configuration I get problems in two areas. First under "Web Service
> > > Identity" no account is listed. ASPNET account is set up on my machine
> > > correctly. Second, under "Database Setup" I can't set up dbs. When I
> > > click "New" and create ReportServer db and then click "Apply" I get an
> > > error that says something like "Virtual Directories have to be crated
> > > first." Under IIS I have ReportServer and Reports directories.
> > > What may be the problem?
> > >
> > > Thanks,
> > >
> > > Stansql

RS-2000 Report Manager time out(?)

I have a query that takes about 2 minutes to complete, but Report Manager displays the Web Page Cannot be Found message at precisely 1 minute after submitting. I'm assuming that this is a time limit that is set somewhere. Is there a setting I can change, either in IIS or in Reporting Services, to extend this time limit? I have looked and whatever I have changed doesn't seem to make any difference?

Thanks,

Al

There are settings on both individual reports and on the server as a whole.

You can get to the system wide settings by going to 'Site Settings' in Report Manager.

Individual reports can be changed by going to the report properties, then 'Execution' within Report Manager.

Regards

Paul