Friday, March 30, 2012

rsInternalError General network error for new report

Running RS2000 on Windows 2003
I published a new report today (copied from an existing report, used same
data source calling different stored procedure, changed parameters, etc.).
It worked fine when run locally.
However, when published and run within Report Manager I get the following
error -
Reporting Services Error
----
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
General network error. Check your network documentation.
I'm not sure I've seen this error before. I've had errors before but they
usually occurred because I forgot to give adequate permissions to the stored
procedure or something like that.
I've search around but haven't figured out how to troubleshoot this problem.
I have looked at the trace logs but I'm still learning how to read them.
Here is what appear to be the relevant portion found in them -
In ReportServer__08_17_2007_06_42_51.log
w3wp!library!1058!08/17/2007-10:54:06:: i INFO: Call to RenderFirst(
'/Development/Ref Des Term Count' )
w3wp!library!1058!08/17/2007-10:54:07:: 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.Data.SqlClient.SqlException: A severe error occurred on
the current command. The results, if any, should be discarded.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.CancelableSqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.ChunkStorage.WriteNewSnapshotToDB(String
effectiveParams, Int32 paramsHash, DateTime createdDate, String description,
Guid snapshotDataID, Boolean isPermanentSnapshot)
at
Microsoft.ReportingServices.Library.ReportSnapshot.WriteNewSnapshotToDB(String effectiveParams, Int32 paramsHash, DateTime createdDate, String description)
at
Microsoft.ReportingServices.Library.RSService.AllocateNewSnapshot(Boolean
isPermanentSnapshot, String effectiveParams, Int32 paramsHash, DateTime
createdDate, String description)
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)
-- End of inner exception stack trace --
w3wp!library!1058!08/17/2007-10:54:07:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!1058!08/17/2007-10:54:08:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal
error occurred on the report server. See the error log for more details. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Data.SqlClient.SqlException: A severe error occurred on
the current command. The results, if any, should be discarded.
In ReportServerService__main_08_17_2007_05_10_24.log
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__main_08_17_2007_05_10_24.log</Path>
<SystemName>IW-SQL</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!servicecontroller!11dc!8/17/2007-05:10:24:: i INFO:
Recycling the service from default domain
ReportingServicesService!servicecontroller!11dc!8/17/2007-05:10:27:: i INFO:
New app domain started
Other existing reports seem to be working with no problem.
Any help troubleshooting this would be greatly appreciated.
KevinWell I've found a solution. Instead of copying an existing report I just
started from scratch. I built a new one from the ground up and it worked
fine.
Apparently there was something in the report I made from the copy that it
didn't like. I thought I went through it pretty thoroughly to make sure
nothing referred to fields, parameters, etc. that didn't apply but I guess I
missed something.
For future reference I would appreciate any recommendations for catching
problems when copying a report. Maybe copying isn't recommended? It usually
seems to save time (except in this case!).
Kevin|||Rats!!! I thought I had it fixed. My report and stored procedure both have
just one parameter. I just made a simple report (data is listed in a table)
and set a default value for the report parameter and it worked.
Thinking that it was fixed, I removed the default and re-published. Now
when I select a value from the list in the prompt and run the report I get
the error.
So, is the problem something to do with my prompt? Any ideas on
troubleshooting would be appreciated. The prompt is just a simple query from
one table -
SELECT DISTINCT r.item AS PromptValue
,r.item AS PromptLabel
FROM dbname.dbo.tablename r
WHERE r.item <> ''
ORDER BY r.item
The stored procedure queries the same table and is as follows -
CREATE PROCEDURE rpt_Ref_DesTermCount
(
@.StockCode VARCHAR(30) = '%'
)
AS
SELECT r.item
,r.ref_des
,r.TermCount
FROM dbname.dbo.tablename r
WHERE r.item LIKE @.StockCode
ORDER BY r.ref_des
GO
Thanks in advance,
Kevin

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

at

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

Item, Property[] Properties)

at

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

at

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

navigator, PermissionsCacheItem cache)

at

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

xmlExpression, INodeInformation source)

at

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

source)

at

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

menuCommand)

at

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

menuCommand)

at

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

items)

at

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

at

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

windowPos)

at

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

m)

at

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

m)

at

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

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

m)

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:

<configuration>

<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 - Urgent please

Hi
I am getting an error like An internal error occurred on the report
server.(rsInternalError) The timeout period elapsed prior to obtaining a
connection from the pool. This may have occurred because all pooled
connections were in use max pool size was reached
Could anyone please solve this problem.
Help is strongly appreciated.
Thanks & Best Regards
MukeshThis link might help,
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=290788
daw
"mukesh" wrote:
> Hi
> I am getting an error like An internal error occurred on the report
> server.(rsInternalError) The timeout period elapsed prior to obtaining a
> connection from the pool. This may have occurred because all pooled
> connections were in use max pool size was reached
> Could anyone please solve this problem.
> Help is strongly appreciated.
> Thanks & Best Regards
> Mukesh
>
>sql

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 get this error message while deploying report:
An internal error occurred on the report server.
See the error log for more details. (rsInternalError)
Invalid text, ntext, or image pointer value
0xFDFF7F5F000000000303000001000200.
The statement has been terminated.
This happens to all reports I am trying to deploy either through VS.NET or
froom rds file
How do I resolve it?
Thanks,
-StanHI,
Did you ever resolve this issue? I'm getting the same message. Just
started during my last attempt to deploy.
thanks
"Stan" wrote:
> I get this error message while deploying report:
> An internal error occurred on the report server.
> See the error log for more details. (rsInternalError)
> Invalid text, ntext, or image pointer value
> 0xFDFF7F5F000000000303000001000200.
> The statement has been terminated.
> This happens to all reports I am trying to deploy either through VS.NET or
> froom rds file
> How do I resolve it?
>
> Thanks,
> -Stan
>
>

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

rsinternal error The profile for the user is a temporary profile.

HI,
When I type http://w2kserver1/Reports
I get rsInternalerror with msg
The profile for the user is a temporary profile
and the same for http://w2kserver1/Reportserver.
I'm not sure where to start to try to solve this issue.
I am new to SQL Reporting Services, but plan to use it extensively.
I didn't install it originally, so I'm not sure where to start.
What should I check first? What profile they are talking about?
All help is very greatly appreciated.
Bob Hansen
--
Robert HansenI have the same problem and I still haven't found a solution, but I'll pass
all the info I've got so far:
I am assuming that you are installing on a W2K SP4 machine, now, according
to this forum: http://dbforumz.com/-Report-Server-ftopict70733.html the
problem is the IWAM account on the machine, the SP4 changed the security
settings for this account and cannot impersonate
Check this two KB articles from Microsoft about how to change the settings
on the IWAM account:
http://support.microsoft.com/kb/821546/EN-US/
http://support.microsoft.com/kb/824308/en-us
I'm currently at this point. The idea is: once you have changed the account
settings, try to activate the RS (rsactivate.exe) and see if it helps. Check
the discussion in the forum for anything else I may have missed.
If your W2K machine is a domain controller or a backup domain controller...
well you are in the same situation as I am. I cannot see (let alone modify)
the domain policy
Hope anything of this helps
Regards,
--
MCAD Miguel Rodriguez
MW Consulting S.A. de C.V.
Microsoft Gold Certified Partner
www.mexware.com
"Bob Hansen" escribió:
> HI,
> When I type http://w2kserver1/Reports
> I get rsInternalerror with msg
> The profile for the user is a temporary profile
> and the same for http://w2kserver1/Reportserver.
> I'm not sure where to start to try to solve this issue.
> I am new to SQL Reporting Services, but plan to use it extensively.
> I didn't install it originally, so I'm not sure where to start.
> What should I check first? What profile they are talking about?
> All help is very greatly appreciated.
> Bob Hansen
> --
> Robert Hansen|||The tips I gave you worked for me, but I was installing RS on a Domain
Controller.. However, I came up with the UPDATED documentation of RS (at
www.msdn.com) and worked like a champ.
I encourage you to read the intallation section of the RS books online,
specially the new section "Preparing to Install" it saved my life
Regards
--
MCAD Miguel Rodriguez
MW Consulting S.A. de C.V.
Microsoft Gold Certified Partner
www.mexware.com
"Mike Rod" escribió:
> I have the same problem and I still haven't found a solution, but I'll pass
> all the info I've got so far:
> I am assuming that you are installing on a W2K SP4 machine, now, according
> to this forum: http://dbforumz.com/-Report-Server-ftopict70733.html the
> problem is the IWAM account on the machine, the SP4 changed the security
> settings for this account and cannot impersonate
> Check this two KB articles from Microsoft about how to change the settings
> on the IWAM account:
> http://support.microsoft.com/kb/821546/EN-US/
> http://support.microsoft.com/kb/824308/en-us
> I'm currently at this point. The idea is: once you have changed the account
> settings, try to activate the RS (rsactivate.exe) and see if it helps. Check
> the discussion in the forum for anything else I may have missed.
> If your W2K machine is a domain controller or a backup domain controller...
> well you are in the same situation as I am. I cannot see (let alone modify)
> the domain policy
> Hope anything of this helps
> Regards,
> --
> MCAD Miguel Rodriguez
> MW Consulting S.A. de C.V.
> Microsoft Gold Certified Partner
> www.mexware.com
>
> "Bob Hansen" escribió:
> > HI,
> >
> > When I type http://w2kserver1/Reports
> > I get rsInternalerror with msg
> > The profile for the user is a temporary profile
> >
> > and the same for http://w2kserver1/Reportserver.
> >
> > I'm not sure where to start to try to solve this issue.
> > I am new to SQL Reporting Services, but plan to use it extensively.
> > I didn't install it originally, so I'm not sure where to start.
> >
> > What should I check first? What profile they are talking about?
> > All help is very greatly appreciated.
> >
> > Bob Hansen
> >
> > --
> > Robert Hansen