RS and HTTPS: following

Showing posts with label following. Show all posts

Friday, March 30, 2012

rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the error:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

We are using SQL server 2005 CTP and .Net 2005 beta 2.
the OS is Win xp and the reporting server is the local host.

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

Navigate to the database page. If there is a database configured, and you get this error, chances are you somehow chose to use an existing database. If you tried to upgrade from a previous RS deployment, this might occur. The May CTP will support upgrade from SQL 2000 RS to the May CTP version.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

|||we used the reporting service config tool to configure the service also we created new database to be used by the reporting service(both reportingservice & reportingservicetemp) ew had also configured the reporting service to use SA account, tried with windows security and also with the service crediantials. still we are getting the same error, when we try to deploy reporting project. we get the same error when we try to create a new data source from the report manager web application.

Thanks a lot for your help.
Thanks & regards

Jayan|||Hi Lukasz,
Thanks for your help, we deleted the earlier databases, then created new using the tool. still when we tried it gave the same error. then we restarted the service and everything worked fine.

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

the fix is:
1. In reporiting services configuration manager-> database setup, make sure you have the correct reporting database selected. In this case it will throw the same err when you try to initialize the reporting services.|||Hi,

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

XML Parsing Error: not well-formed
Location: http://moor-6ftylksqxm/reports/
Line Number 1, Column 2:<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePage" %>
-^

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!sql

rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the error:

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

Thanks a lot for your help.
Thanks & regards

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!

rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the error:

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

Thanks a lot for your help.
Thanks & regards

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!

rsInvalidReportServerDatabase

We are getting the following error when we try to deploy SQL report on to the reporting server
the error:

Thanks a lot in advance.

Thanks & Regards

Jayan

You can use the Reporting Services Configuration tool (available from Start -> SQL Ctp -> Configuration Tools) to look at the configuraiton properties for the report server.

I would recommend creating a new report server database and confguring the report servet use it. The config tool lets you do that.

-Lukasz

Thanks a lot for your help.
Thanks & regards

Thanks a lot for your help.

Thanks & Regards

Jayan.|||I actually think we fixed that bug for the June CTP. It was a problem where we were not picking up configuration file changes that affect the windows service DSN.

This led to problems with backing up the symmetric key. It could also, now that I think about it, cause problems publishing reports due to the need to encrypt information in the report datasources.

Good to hear you're up and running.
-Lukasz|||i got the same err while deploying with sql 2005 reporting services:

I had the same problem you reported, and fixed it by creating a new database.

now when I navigate to http://localhost/reports

I get the following error:

any idea what that's about?

regards

Helen|||I'm experiencing the same problem. Is this more of an IIS issue? Any help would be appreciated.

Thanks!

rsInvalidDataSourceReference

I am getting the following error:

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

All i did is created the datasource in the same location where my report files .rdl files are. instead of datasource folder on the report server.

everything works fine from my project vs2005, but if i run the report via localhost/reports, it gives the above error:

please help, i created this method since i have 5 different sites on the same server, all of the sites has reports with same datasource name many of them are common for that reason.

Thank you very much for the informartion.

Try this:

Open up Report Manager, and drill down to open your report. Click on the Properties tab, then select 'Data Sources' from the left pane. Click the Browse button next to 'Select a shared data source'. From here, navigate to the folder where your report is, and select the data source that is in there (since this is where you deployed to). Click OK, then Apply your changes.

Hope this helps.

Jarret

|||Wow.. Jarret Thank you very much. you gave me two tips since yesterday. thks....|||

Hi,

I am using a rss script to deploy reports and data sources. All my datasources lie in the shared location "Data Sources". With the script the data source and reports are deployed but the it gives the same error as posted by cplusplus1.

Here is the rss script to deploy report and data source that I used. Please help.

'To deploy Data Source

Public Sub CreateDataSource(ByVal name As String, ByVal extension As String, ByVal connectionString As String)
'Define the data source definition.
Dim definition As New DataSourceDefinition()
definition.Extension = extension
definition.ConnectString = connectionString
definition.Enabled = True
definition.EnabledSpecified = True
definition.CredentialRetrieval = CredentialRetrievalEnum.Integrated
definition.WindowsCredentials = True
definition.Prompt = Nothing
definition.ImpersonateUserSpecified = True
Try
rs.CreateDataSource(name, dataSourcePath, overWriteExistingDataSource, definition, Nothing)
Console.WriteLine("Data source {0} created successfully", name)

Catch e As Exception
Console.WriteLine(e.Message)
End Try

End Sub

' TO DEPLOY Report

Public Sub PublishReport(ByVal reportName As String)
Try
Dim stream As FileStream = File.OpenRead(filePath + reportName + ".rdl")
definition = New [Byte](stream.Length) {}
stream.Read(definition, 0, CInt(stream.Length))
stream.Close()

Catch e As IOException
Console.WriteLine(e.Message)
End Try

Try
warnings = rs.CreateReport(reportName, parentPath, False, definition, Nothing)

Dim dataSources() As DataSource = rs.GetItemDataSources(parentPath + "/" + reportName)

Dim ds As DataSource
For Each ds In dataSources
If (ds.Item.GetType() Is Type.GetType("InvalidDataSourceReference")) Then
Dim NewDS As DataSource = New DataSource()
Dim dsRef As DataSourceReference = New DataSourceReference()

dsRef.Reference = dataSourcePath + "/" + dataSourceName
NewDS.Item = dsRef
NewDS.Name = ds.Name
Dim NewDataSources() As DataSource = New DataSource() {NewDS}

rs.SetItemDataSources(parentPath + "/" + reportName, NewDataSources)
End If
Next

If Not (warnings Is Nothing) Then
Dim warning As Warning
For Each warning In warnings
Console.WriteLine(warning.Message)
Next warning
Else
Console.WriteLine("Report: {0} published successfully with no warnings", reportName)
End If
Catch e As Exception
Console.WriteLine(e.Message)
End Try
End Sub

rsInvalidDataSourceReference

I am getting the following error:

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

All i did is created the datasource in the same location where my report files .rdl files are. instead of datasource folder on the report server.

everything works fine from my project vs2005, but if i run the report via localhost/reports, it gives the above error:

please help, i created this method since i have 5 different sites on the same server, all of the sites has reports with same datasource name many of them are common for that reason.

Thank you very much for the informartion.

Try this:

Hope this helps.

Jarret

|||Wow.. Jarret Thank you very much. you gave me two tips since yesterday. thks....|||

Hi,

Here is the rss script to deploy report and data source that I used. Please help.

'To deploy Data Source

Catch e As Exception
Console.WriteLine(e.Message)
End Try

End Sub

' TO DEPLOY Report

Catch e As IOException
Console.WriteLine(e.Message)
End Try

Try
warnings = rs.CreateReport(reportName, parentPath, False, definition, Nothing)

Dim dataSources() As DataSource = rs.GetItemDataSources(parentPath + "/" + reportName)

dsRef.Reference = dataSourcePath + "/" + dataSourceName
NewDS.Item = dsRef
NewDS.Name = ds.Name
Dim NewDataSources() As DataSource = New DataSource() {NewDS}

rs.SetItemDataSources(parentPath + "/" + reportName, NewDataSources)
End If
Next

sql

rsInternalError (RSClientCOnnection.GetProperties)

Hello,

We are converting from 2000 to 2005 and are getting the following error when attempting to run any RS reports. Any help would be greatly appreciated.

************** Exception Text **************

Microsoft.SqlServer.ReportingServices2005.ReportServiceDetailsException:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) >

Microsoft.SqlServer.ReportingServices2005.ReportServiceMoreInformationException:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

End of inner exception stack trace

Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GetProperties(String

Item, Property[] Properties)

Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.PermissionsCacheItem.get_ItemProperties()

Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.EvaluateNode(XPathNavigator

navigator, PermissionsCacheItem cache)

Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.Evaluate(String

xmlExpression, INodeInformation source)

Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.Visible(INodeInformation

source)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItemBase.UpdateMenuCommandStatus(MenuCommand

menuCommand)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DefaultMenuHandler.UpdateMenuCommandsStatus(MenuCommand

menuCommand)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DefaultMenuHandler.GetMenuItems(ArrayList

items)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DefaultMenuHandler.GetMenuItems()

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.ShowContextMenu(Point

windowPos)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WmContextMenu(Message&

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WndProc(Message&

System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies ************** mscorlib

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

AppIDPackage

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL

System

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

Microsoft.SqlServer.SqlTools.VSIntegration

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL

Microsoft.VisualStudio.Shell.Interop

Assembly Version: 7.1.40304.0

Win32 Version: 7.0.4054

CodeBase:

file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll

Microsoft.VisualStudio.OLE.Interop

Assembly Version: 7.1.40304.0

Win32 Version: 7.0.4054

CodeBase:

file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll

System.Windows.Forms

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System.Drawing

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

Microsoft.SqlServer.SqlTDiagM

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll

Microsoft.DataWarehouse.SQM

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL

Microsoft.SqlServer.Instapi

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll

ObjectExplorer

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL

ConnectionDlg

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL

SqlWorkbench.Interfaces

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL

Microsoft.SqlServer.CustomControls

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll

Accessibility

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

SqlMgmt

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL

Microsoft.SqlServer.RegSvrEnum

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll

EnvDTE

Assembly Version: 8.0.0.0

Win32 Version: 8.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll

Microsoft.NetEnterpriseServers.ExceptionMessageBox

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll

System.Data

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

Microsoft.SqlServer.ConnectionInfo

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll

Microsoft.SqlServer.Management.UI.RSClient

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UI.RSClient.DLL

System.Xml

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.SqlServer.SmoEnum

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SmoEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SmoEnum.dll

System.Management

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll

System.Web.Services

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll

System.Configuration

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

zhphbr91

Assembly Version: 9.0.242.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

Microsoft.SqlServer.Management.UI.RSUserInterface

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UI.RSUserInterface.DLL

Microsoft.SqlServer.SqlEnum

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll

Microsoft.ReportViewer.WinForms

Assembly Version: 8.0.0.0

Win32 Version: 8.0.50727.42

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.ReportViewer.WinForms/8.0.0.0__b03f5f7f11d50a3a/Microsoft.ReportViewer.WinForms.dll

Microsoft.SqlServer.Smo

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll

Microsoft.SqlServer.Management.UI.RSWrapper

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UI.RSWrapper.DLL

************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging enabled.

For example:

<system.windows.forms jitDebugging="true" /> </configuration>

When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.

Not quite sure if this will help, but I do not what this method Is. Basically its a method on the Data Extension to retrieve the properties of the command object, within the Report Designer.

Do you know which Data extension the report is using (SQL Server, Oracle or maybe a Custom data extension?)

|||

We are using SQL Server.

It appears that we may have solved this issue by reinstalling RS SP1. I'm unsure why we were receiving this error though but it is gone now.

Thanks for your help.

Dan

rsInternalError

I have reporting services installed on my xp laptop and haven't used it for a
while. Now when I try to run a report I get the following error message.
@.AwaitingFirstExecution is not a parameter for procedure CreateSession
Anybody seen this before? I can't find any information about this.
Thanks
MGSounds like the report is calling a stored procedure called "CreateSession".
Is that a datasource of your report? If not, make sure you have enough
permission to run the report.
Ed
"Mardy" wrote:
> I have reporting services installed on my xp laptop and haven't used it for a
> while. Now when I try to run a report I get the following error message.
> @.AwaitingFirstExecution is not a parameter for procedure CreateSession
> Anybody seen this before? I can't find any information about this.
> Thanks
> MG|||Thanks Ed but no it's not using a stored procedure. Actually all the reports
that I try to run return this same message. All work fine when I run from
visual studio. I've tested and reloaded the data sources but no success.
"Ed" wrote:
> Sounds like the report is calling a stored procedure called "CreateSession".
> Is that a datasource of your report? If not, make sure you have enough
> permission to run the report.
> Ed
> "Mardy" wrote:
> > I have reporting services installed on my xp laptop and haven't used it for a
> > while. Now when I try to run a report I get the following error message.
> > @.AwaitingFirstExecution is not a parameter for procedure CreateSession
> >
> > Anybody seen this before? I can't find any information about this.
> >
> > Thanks
> > MG|||Not sure if it is related. We were getting the rsinternalerror as well.
After working with Microsoft, they determined that the error had to do with
the AMD processor on our server. Are you using an AMD processor?
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:B555F393-D1B1-421B-9DE8-9686F305FE06@.microsoft.com...
>I have reporting services installed on my xp laptop and haven't used it for
>a
> while. Now when I try to run a report I get the following error message.
> @.AwaitingFirstExecution is not a parameter for procedure CreateSession
> Anybody seen this before? I can't find any information about this.
> Thanks
> MG|||Thanks Chris
I have reporting services loaded on a Dell Inspiron with an Intel Pentium M
processor.
"Chris" wrote:
> Not sure if it is related. We were getting the rsinternalerror as well.
> After working with Microsoft, they determined that the error had to do with
> the AMD processor on our server. Are you using an AMD processor?
>
> "Mardy" <Mardy@.discussions.microsoft.com> wrote in message
> news:B555F393-D1B1-421B-9DE8-9686F305FE06@.microsoft.com...
> >I have reporting services installed on my xp laptop and haven't used it for
> >a
> > while. Now when I try to run a report I get the following error message.
> > @.AwaitingFirstExecution is not a parameter for procedure CreateSession
> >
> > Anybody seen this before? I can't find any information about this.
> >
> > Thanks
> > MG
>
>

rsInternalError

I recently installed SQL Reporting Services on a Windows Server 2003.
Whenever i try to open the repot Manager, i get the following error :
An internal error occured on the report Server. See error log for more
details (rsInternalError). The system cannot find the file specified.
Attached is my log file.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__07_22_2005_09_31_30.log</Path>
<SystemName>QA-DMPWIN01</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!208!7/22/2005-09:31:30:: i INFO: Reporting Web Server
started
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
ConnectionType to '0' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
IsEventService to 'True' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing MemoryLimit
to '60' percent as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing RecycleTime
to '720' minute(s) as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration
file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration
file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing InstanceName
to 'MSSQLSERVER' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration
file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration
file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it
was not specified in Configuration file.
w3wp!resourceutilities!208!7/22/2005-09:31:31:: i INFO: Running on 2
physical processors, 2 logical processors
w3wp!resourceutilities!208!7/22/2005-09:31:31:: i INFO: Reporting
Services starting SKU: Standard
w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Database Cleanup (Web
Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Running Requests
Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Running Requests DB
timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Memory stats update
timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!crypto!208!07/22/2005-09:31:32:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!07/22/2005-09:31:32:: i INFO: Exporting public key
w3wp!webserver!208!07/22/2005-09:31:32:: e ERROR: Internal error:
System.IO.FileNotFoundException: The system cannot find the file
specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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(String
key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
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.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!208!07/22/2005-09:31:32:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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(String
key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
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.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
w3wp!crypto!5d0!7/22/2005-09:32:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!5d0!7/22/2005-09:32:31:: i INFO: Exporting public key
w3wp!library!5d0!7/22/2005-09:32:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!5d0!7/22/2005-09:33:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!5d0!7/22/2005-09:33:31:: i INFO: Exporting public key
w3wp!library!5d0!7/22/2005-09:33:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:34:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:34:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:34:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:35:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:35:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:35:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:36:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:36:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:36:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!db4!7/22/2005-09:37:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!db4!7/22/2005-09:37:31:: i INFO: Exporting public key
w3wp!library!db4!7/22/2005-09:37:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:38:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:38:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:38:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:39:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:39:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:39:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:40:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:40:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:40:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:41:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:41:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:41:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error doing timer action for Database Cleanup (Web
Service);
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.CleanBatchRecords()
at Microsoft.ReportingServices.Library.RSService.CleanBatch()
at
Microsoft.ReportingServices.Library.DatabaseCleanupTimer.DoTimerAction()
at
Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object
unused)
-- End of inner exception stack trace --
w3wp!crypto!8e8!7/22/2005-09:41:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!8e8!7/22/2005-09:41:31:: i INFO: Exporting public key
w3wp!library!8e8!7/22/2005-09:41:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:42:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:42:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:42:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!b50!7/22/2005-09:43:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!b50!7/22/2005-09:43:31:: i INFO: Exporting public key
w3wp!library!b50!7/22/2005-09:43:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!d70!7/22/2005-09:44:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!d70!7/22/2005-09:44:31:: i INFO: Exporting public key
w3wp!library!d70!7/22/2005-09:44:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:45:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:45:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:45:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:46:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:46:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:46:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!a38!7/22/2005-09:47:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!a38!7/22/2005-09:47:31:: i INFO: Exporting public key
w3wp!library!a38!7/22/2005-09:47:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:48:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:48:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:48:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!9f0!7/22/2005-09:49:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!9f0!7/22/2005-09:49:31:: i INFO: Exporting public key
w3wp!library!9f0!7/22/2005-09:49:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!crypto!208!7/22/2005-09:50:31:: i INFO: Initializing crypto as
user: ENC\modssa
w3wp!crypto!208!7/22/2005-09:50:31:: i INFO: Exporting public key
w3wp!library!208!7/22/2005-09:50:31:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., Error getting running jobs;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
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.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!webserver!3fc!7/22/2005-09:51:24:: i INFO: Reporting Web Server
stopped
Please help me in resolving the above issue.
Thanks,The best recommendation I have is to remove each item one at a time and test
your report. Make sure to undo your delet if its removal does not solve the
problem. I had this same error and found that one of my charts was causing
the issue. Some setting that I could never find was causing the problem. I
had to recreate the chart and all was well.
=====================Thanks!
Keith
p.s. Get off the couch and exercise!
"sss" wrote:
> I recently installed SQL Reporting Services on a Windows Server 2003.
> Whenever i try to open the repot Manager, i get the following error :
> An internal error occured on the report Server. See error log for more
> details (rsInternalError). The system cannot find the file specified.
> Attached is my log file.
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.1038.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Pacific Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServer__07_22_2005_09_31_30.log</Path>
> <SystemName>QA-DMPWIN01</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> w3wp!webserver!208!7/22/2005-09:31:30:: i INFO: Reporting Web Server
> started
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> ConnectionType to '0' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> IsSchedulingService to 'True' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> IsNotificationService to 'True' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> IsEventService to 'True' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> PollingInterval to '10' second(s) as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing MemoryLimit
> to '60' percent as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing RecycleTime
> to '720' minute(s) as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> MaximumMemoryLimit to '80' percent as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration
> file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> MaxQueueThreads to '0' thread(s) as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> MaxScheduleWait to '5' second(s) as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> DatabaseQueryTimeout to '120' second(s) as specified in Configuration
> file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing InstanceName
> to 'MSSQLSERVER' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> ProcessRecycleOptions to '0' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> RunningRequestsScavengerCycle to '60' second(s) as specified in
> Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> RunningRequestsDbCycle to '60' second(s) as specified in Configuration
> file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> RunningRequestsAge to '30' second(s) as specified in Configuration
> file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> CleanupCycleMinutes to '10' minute(s) as specified in Configuration
> file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> SecureConnectionLevel to '0' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> DisplayErrorLink to 'True' as specified in Configuration file.
> w3wp!library!208!7/22/2005-09:31:30:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it
> was not specified in Configuration file.
> w3wp!resourceutilities!208!7/22/2005-09:31:31:: i INFO: Running on 2
> physical processors, 2 logical processors
> w3wp!resourceutilities!208!7/22/2005-09:31:31:: i INFO: Reporting
> Services starting SKU: Standard
> w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Database Cleanup (Web
> Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
> w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Running Requests
> Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
> w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Running Requests DB
> timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
> w3wp!runningjobs!208!7/22/2005-09:31:31:: i INFO: Memory stats update
> timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
> w3wp!crypto!208!07/22/2005-09:31:32:: i INFO: Initializing crypto as
> user: ENC\modssa
> w3wp!crypto!208!07/22/2005-09:31:32:: i INFO: Exporting public key
> w3wp!webserver!208!07/22/2005-09:31:32:: e ERROR: Internal error:
> System.IO.FileNotFoundException: The system cannot find the file
> specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> 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(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> 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.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> w3wp!library!208!07/22/2005-09:31:32:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> 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(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> 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.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> w3wp!crypto!5d0!7/22/2005-09:32:31:: i INFO: Initializing crypto as
> user: ENC\modssa
> w3wp!crypto!5d0!7/22/2005-09:32:31:: i INFO: Exporting public key
> w3wp!library!5d0!7/22/2005-09:32:31:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., Error getting running jobs;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> 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.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> w3wp!crypto!5d0!7/22/2005-09:33:31:: i INFO: Initializing crypto as
> user: ENC\modssa
> w3wp!crypto!5d0!7/22/2005-09:33:31:: i INFO: Exporting public key
> w3wp!library!5d0!7/22/2005-09:33:31:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., Error getting running jobs;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> 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.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> w3wp!crypto!208!7/22/2005-09:34:31:: i INFO: Initializing crypto as
> user: ENC\modssa
> w3wp!crypto!208!7/22/2005-09:34:31:: i INFO: Exporting public key
> w3wp!library!208!7/22/2005-09:34:31:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., Error getting running jobs;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> 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.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> w3wp!crypto!208!7/22/2005-09:35:31:: i INFO: Initializing crypto as
> user: ENC\modssa
> w3wp!crypto!208!7/22/2005-09:35:31:: i INFO: Exporting public key
> w3wp!library!208!7/22/2005-09:35:31:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., Error getting running jobs;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> 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.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> w3wp!crypto!208!7/22/2005-09:36:31:: i INFO: Initializing crypto as
> user: ENC\modssa
> w3wp!crypto!208!7/22/2005-09:36:31:: i INFO: Exporting public key
> w3wp!library!208!7/22/2005-09:36:31:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., Error getting running jobs;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot

rsFailedToDecryptConfigInformation unable to initialize

I am getting the following error: rsFailedToDecryptConfigInformation

Please help, When i am trying to initialize the RS.

Thank you very much..

OK, found it.

All i did is detached the deatabases both reportserver and also temp.

and then attached it back and gave permissions for the windows acct. under sql server database.

And then closed the sql manager.

opened the report server configuration utility and i see it got initialized by itself.

you can also check my previous post about initialization problem, under that i mentioned all the issues i had configuring rs via configuration utility.

sql

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

Wednesday, March 28, 2012

RSException on Matrix report rendering to PDF

I'm receiving the following exception (+stack trace) when trying to
render to PDF, but it works fine when rendering to all other formats.
Ideas?
~Lance
-- Error/Stack trace--
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. -->
Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. -->
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. --> System.NullReferenceException: Object reference not
set to an instance of an object.
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Matrix.FindHeaderRowsForVerticalResize(Int32
headerRowRow, Int32 level, Int32 lastRowForLevel, Int32& startRow,
Int32& endRow, Double& startTop)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Matrix.ResizeCellsVertically(ReAdjustments&
itemReAdjustment)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Matrix.CalculateItemMeasurement(Orientation
orientation, Double childrenMaximumDistance, ReAdjustments
itemReAdjustment, ItemContext savedContext)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32
startPage, Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot,
DataSourceInfoCollection thisReportDataSources, Boolean
cachingRequested, Warning[]& warnings, ReportSnapshot&
resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session,
JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection&
effectiveParameters, String[]& secondaryStreamNames)
at
Microsoft.ReportingServices.WebServer.ReportingService.Render(String
Report, String Format, String HistoryID, String DeviceInfo,
ParameterValue[] Parameters, DataSourceCredentials[] Credentials,
String ShowHideToggle, Byte[]& Result, String& Encoding, String&
MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
String[]& StreamIds)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService.Render(String
Report, String Format, String HistoryID, String DeviceInfo,
ParameterValue[] Parameters, DataSourceCredentials[] Credentials,
String ShowHideToggle, Byte[]& Result, String& Encoding, String&
MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
String[]& StreamIds)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)Anybody have an idea/suggestion?

Friday, March 30, 2012

rsInvalidReportServerDatabase

rsInvalidReportServerDatabase

rsInvalidReportServerDatabase

rsInvalidReportServerDatabase

rsInvalidDataSourceReference

rsInvalidDataSourceReference

rsInternalError (RSClientCOnnection.GetProperties)

rsInternalError

rsInternalError

rsFailedToDecryptConfigInformation unable to initialize

rsExecutionNotFound

Wednesday, March 28, 2012

RSException on Matrix report rendering to PDF

RS and HTTPS

Blog Archive

About Me