HTTP 500 Error Occured when clicked on REPORT MANAGER URL

Question

HTTP 500 Error Occured when clicked on REPORT MANAGER URL

Scott1336

SSC Eights!

Points: 964
More actions
August 29, 2012 at 8:05 am

#280494

Hi,
I installed SQL Server 2012 on Windows Server 2008 R2. And I installed Enterprise Edition. After Configuring Reporting Services Configuration Manager I clicked on the URL and I got the following error in Reports Log File.
appdomainmanager!ReportManager_0-1!1294!08/29/2012-09:55:13:: i INFO: Appdomain:9 ReportManager_MS2012_0-1-129907221069185388 unloading
library!DefaultDomain!1294!08/29/2012-09:55:13:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerAppDomainManagerException: Failed to create Report Server HTTP Runtime, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerAppDomainManagerException: An error occurred when attempting to start the application domain ReportManager within the Report Server service. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MS2012_0. ---> System.Web.HttpException: Could not load file or assembly 'Oracle.Web, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config line 176) ---> System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'Oracle.Web, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. (C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config line 176) ---> System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.Web, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
--- End of inner exception stack trace ---;
rshost!rshost!1294!08/29/2012-09:55:13:: e ERROR: Failed to create HttpRuntime 80131500.
rshost!rshost!1294!08/29/2012-09:55:13:: e ERROR: Failed to get appdomain 80131500, pipeline=0x00000001F80A7410.
rshost!rshost!1294!08/29/2012-09:55:13:: e ERROR: Error state. Internal abort for pipeline=0x00000001F80A7410 ...
appdomainmanager!DefaultDomain!1030!08/29/2012-09:55:18:: i INFO: Appdomain:9 ReportManager_MS2012_0-1-129907221069185388 unregistered.
rshost!rshost!1030!08/29/2012-09:55:18:: i INFO: Application domain type ReportManager statistics: created: 1, unloaded: 1, failed: 0, timed out: 0.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

cporteous SSC Eights! Points: 996 More actions · Answer 1

Could you post your web.config file? Did you have any existing datasource connections to Oracle databases in Report Manager, before upgrade?

ta

Scott1336 SSC Eights! Points: 964 More actions · Answer 2

I couldn't find the config file. But No I don't have any idea that the Oracle Database is added to the connections.

cporteous SSC Eights! Points: 996 More actions · Answer 3

So its the Report Manager URl you are getting the error on?..

(IE. http://blahblah/Reports)

Have you tried the reportServer URL (looks like a basic FTP interface (text))

(IE. http://blahblah/ReportServer)

Any errors showing is RS Configuration Manager?

You should find the Web.config for Report Manager here:

<Installation directory> \Reporting Services \ReportManager\Web.config

You may have an assembly reference to Oracle from the 2008 version that you'd need to remove. Not sure yet though. If you can post its contents *and backup before making changes*

ta

Scott1336 SSC Eights! Points: 964 More actions · Answer 4

I am getting the same error for both ReportMangerURL and WebServiceURL.

Below is what Web.Config content is

<?xml version="1.0" encoding="utf-8"?>

</configSections>

<system.net>

</system.net>

<system.web>

</securityPolicy>

</httpHandlers>

</httpModules>

</system.web>

</appSettings>

</dependentAssembly>

</assemblyBinding>

</runtime>

</configuration>

cporteous SSC Eights! Points: 996 More actions · Answer 5

Hmm looks ok. Might actually be the RSReportServer.config file.

it should be one folder level up. Sorry

Ta

cporteous SSC Eights! Points: 996 More actions · Answer 6

Check this out - see if that helps:

https://anindita9.wordpress.com/2011/12/15/troubleshooting-sql-server-2008-r2-reporting-services-report-manager-url-shows-500-internal-server-error-in-internet-explorer/

Scott1336 SSC Eights! Points: 964 More actions · Answer 7

Here is the RSReportServer.Config file..

<Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAAR49Wq3/ykOPdse5Zih3hgQAAAAiAAAAUgBlAHAAbwBy

AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAADAAAAAEAAAAF5trN8bXISfrROSi6E+NEoAAAAA

BIAAAKAAAAAQAAAAPHEzVpxXXSbycWviyRDN+QABAAADgEDOm4xpSaRQCgBHJQeqvuov14kQgw1L

qQVKPJbknL1DO/PM+B9nPxH2AnOGD+EVLV3avZhcJtyUeM/htBdxlSefrwU3lC5LiC+uGxRxCRz6

1wGTV8I2iMwL+4KAejFp0kVbXX71vTcxMCeerB8CrP1elftmtbdgSkFX4Hk2Jdl01ByeiFWHvBpN

fQEgvLvJmtpLRtacchChSPVOPSxxNmmL9D3t27loDykPXhH3J5xe3cIU1BY2M5gDDAJJlgnZpy6F

D88w4ABlQR0p8y17hlgKleX3o4Q+z1nSociS61qlgSX3wWolqWt8BHJ/DJY+hxxStgdrLlC5SVmf

u3XYFAAAADkcGHdZJs7DVR6+GSKQAhsAgYK6

</Dsn>

<ConnectionType>Default</ConnectionType>

<Name>ReportServerWebService</Name>

<VirtualDirectory>ReportServer_MS2012</VirtualDirectory>

<URLs>

<URL>

<AccountName>NT Service\ReportServer$MS2012</AccountName>

</URL>

</URLs>

</Application>

<Name>ReportManager</Name>

<VirtualDirectory>Reports_MS2012</VirtualDirectory>

<URLs>

<URL>

<AccountName>NT Service\ReportServer$MS2012</AccountName>

</URL>

</URLs>

</Application>

</URLReservations>

</AuthenticationTypes>

<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>

</Authentication>

<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>

</UrlRoot>

</UnattendedExecutionAccount>

<PolicyLevel>rssrvpolicy.config</PolicyLevel>

<Path>

</Path>

</FileShareStorageLocation>

</Service>

<UI>

</ReportServerUrl>

<PageCountMode>Estimate</PageCountMode>

</UI>

<RenderingExtension>HTMLOWC</RenderingExtension>

</ExcludedRenderFormats>

</FileShareConfiguration>

</Configuration>

</Extension>

</SMTPServerPort>

</SMTPAccountName>

</SMTPConnectionTimeout>

</SMTPServerPickupDirectory>

</SMTPUseSSL>

</SMTPAuthenticate>

<RenderingExtension>MHTML</RenderingExtension>

</EmbeddedRenderFormats>

</PrivilegedUserRenderFormats>

<RenderingExtension>HTMLOWC</RenderingExtension>

</ExcludedRenderFormats>

</DefaultHostName>

</PermittedHosts>

</RSEmailDPConfiguration>

</Configuration>

</Extension>

<RenderingExtension>HTMLOWC</RenderingExtension>

</ExcludedRenderFormats>

</DocumentLibraryConfiguration>

</Configuration>

</Extension>

</Delivery>

<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>

</RSEmailDPConfiguration>

</Configuration>

</Extension>

</DeliveryUI>

<DataVisualizationFitSizing>Approximate</DataVisualizationFitSizing>

</DeviceInfo>

</Configuration>

</Extension>

<DataVisualizationFitSizing>Approximate</DataVisualizationFitSizing>

</DeviceInfo>

</Configuration>

</Extension>

</Render>

<Data>

</Data>

<EnableMathOpCasting>False</EnableMathOpCasting>

</Configuration>

</Extension>

<EnableMathOpCasting>False</EnableMathOpCasting>

</Configuration>

</Extension>

<EnableMathOpCasting>False</EnableMathOpCasting>

</Configuration>

</Extension>

<DisableNO_MERGEInLeftOuters>False</DisableNO_MERGEInLeftOuters>

<EnableUnistr>False</EnableUnistr>

<DisableTSTruncation>False</DisableTSTruncation>

</Configuration>

</Extension>

<ReplaceFunctionName>oREPLACE</ReplaceFunctionName>

</Configuration>

</Extension>

</SemanticQuery>

</ModelGeneration>

</Security>

</Authentication>

<Event>

<Type>ReportHistorySnapshotCreated</Type>

</Event>

</Extension>

<Event>

<Type>TimedSubscription</Type>

</Event>

</Extension>

<Event>

<Type>RefreshCache</Type>

</Event>

</Extension>

<Event>

<Type>SnapshotUpdated</Type>

</Event>

</Extension>

</EventProcessing>

</Extensions>

<AppID>(Default)</AppID>

<CacheLevel>Default</CacheLevel>

</MapTileServerConfiguration>

</Configuration>

cporteous SSC Eights! Points: 996 More actions · Answer 8

I'll have a wee search through that but check my post above - possible solution.

Cheers