Post reply

HTTP 500 Error Occured when clicked on REPORT MANAGER URL

  • 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.

  • August 29, 2012 at 8:29 am

    #1531428

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

    ta

  • August 29, 2012 at 8:39 am

    #1531436

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

  • August 29, 2012 at 8:45 am

    #1531441

    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

  • August 29, 2012 at 8:56 am

    #1531445

    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"?>

    <configuration>

    <configSections>

    <section name="MicrosoftWebControls" type="System.Configuration.NameValueSectionHandler, System, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL" />

    <section name="UIConfig" type="Microsoft.ReportingServices.UI.UIConfigSectionHandler,ReportingServicesWebUserInterface" />

    </configSections>

    <system.net>

    <defaultProxy enabled="false" />

    </system.net>

    <system.web>

    <pages validateRequest="false" />

    <compilation defaultLanguage="c#" debug="false" tempDirectory="C:\Program Files\Microsoft SQL Server\MSRS11.MS2012\Reporting Services\RSTempFiles\" />

    <customErrors mode="RemoteOnly" />

    <authentication mode="Windows" />

    <identity impersonate="true" />

    <trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />

    <sessionState mode="InProc" cookieless="false" timeout="20" />

    <globalization requestEncoding="utf-8" responseEncoding="utf-8" />

    <httpRuntime executionTimeout="9000" />

    <securityPolicy>

    <trustLevel name="RosettaMgr" policyFile="rsmgrpolicy.config" />

    </securityPolicy>

    <trust level="RosettaMgr" originUrl="" />

    <httpHandlers>

    <add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebUserInterface, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

    <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false" />

    </httpHandlers>

    <httpModules>

    <clear />

    <add name="OutputCache" type="System.Web.Caching.OutputCacheModule" />

    <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" />

    <add name="FormsAuthentication" type="System.Web.Security.FormsAuthenticationModule" />

    <add name="PassportAuthentication" type="System.Web.Security.PassportAuthenticationModule" />

    <add name="RoleManager" type="System.Web.Security.RoleManagerModule" />

    <add name="UrlAuthorization" type="System.Web.Security.UrlAuthorizationModule" />

    <add name="FileAuthorization" type="System.Web.Security.FileAuthorizationModule" />

    <add name="AnonymousIdentification" type="System.Web.Security.AnonymousIdentificationModule" />

    <add name="Profile" type="System.Web.Profile.ProfileModule" />

    <add name="ErrorHandlerModule" type="System.Web.Mobile.ErrorHandlerModule, System.Web.Mobile, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

    </httpModules>

    </system.web>

    <appSettings>

    <add key="ReportViewerServerConnection" value="Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

    <add key="ReportViewerTemporaryStorage" value="Microsoft.ReportingServices.UI.ReportViewerTemporaryStorage, ReportingServicesWebUserInterface, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

    </appSettings>

    <runtime>

    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

    <dependentAssembly>

    <assemblyIdentity name="Microsoft.ReportingServices.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral" />

    <bindingRedirect oldVersion="8.0.242.0" newVersion="11.0.0.0" />

    <bindingRedirect oldVersion="9.0.242.0" newVersion="11.0.0.0" />

    <bindingRedirect oldVersion="10.0.0.0" newVersion="11.0.0.0" />

    </dependentAssembly>

    </assemblyBinding>

    </runtime>

    </configuration>

  • August 29, 2012 at 9:16 am

    #1531457

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

    it should be one folder level up. Sorry

    Ta

  • August 29, 2012 at 9:31 am

    #1531467

    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/

  • August 29, 2012 at 9:41 am

    #1531481

    Here is the RSReportServer.Config file..

    <Configuration>

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

    <LogonUser></LogonUser>

    <LogonDomain></LogonDomain>

    <LogonCred></LogonCred>

    <InstanceId>MSRS11.MS2012</InstanceId>

    <InstallationID>{1e54db69-9134-4993-9ff5-837bab8c8be8}</InstallationID>

    <Add Key="SecureConnectionLevel" Value="0"/>

    <Add Key="DisableSecureFormsAuthenticationCookie" Value="false"/>

    <Add Key="CleanupCycleMinutes" Value="10"/>

    <Add Key="MaxActiveReqForOneUser" Value="20"/>

    <Add Key="DatabaseQueryTimeout" Value="120"/>

    <Add Key="RunningRequestsScavengerCycle" Value="60"/>

    <Add Key="RunningRequestsDbCycle" Value="60"/>

    <Add Key="RunningRequestsAge" Value="30"/>

    <Add Key="MaxScheduleWait" Value="5"/>

    <Add Key="DisplayErrorLink" Value="true"/>

    <Add Key="WebServiceUseFileShareStorage" Value="false"/>

    <!-- <Add Key="ProcessTimeout" Value="150" /> -->

    <!-- <Add Key="ProcessTimeoutGcExtension" Value="30" /> -->

    <!-- <Add Key="WatsonFlags" Value="0x0430" /> full dump-->

    <!-- <Add Key="WatsonFlags" Value="0x0428" /> minidump -->

    <!-- <Add Key="WatsonFlags" Value="0x0002" /> no dump-->

    <Add Key="WatsonFlags" Value="0x0428"/>

    <Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException"/>

    <Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException"/>

    <URLReservations>

    <Application>

    <Name>ReportServerWebService</Name>

    <VirtualDirectory>ReportServer_MS2012</VirtualDirectory>

    <URLs>

    <URL>

    <UrlString>http://+:80</UrlString&gt;

    <AccountSid>S-1-5-80-2134820107-3650659568-841196424-2983550718-1472432473</AccountSid>

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

    </URL>

    </URLs>

    </Application>

    <Application>

    <Name>ReportManager</Name>

    <VirtualDirectory>Reports_MS2012</VirtualDirectory>

    <URLs>

    <URL>

    <UrlString>http://+:80</UrlString&gt;

    <AccountSid>S-1-5-80-2134820107-3650659568-841196424-2983550718-1472432473</AccountSid>

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

    </URL>

    </URLs>

    </Application>

    </URLReservations>

    <Authentication>

    <AuthenticationTypes>

    <RSWindowsNTLM/>

    </AuthenticationTypes>

    <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>

    <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>

    <EnableAuthPersistence>true</EnableAuthPersistence>

    </Authentication>

    <Service>

    <IsSchedulingService>True</IsSchedulingService>

    <IsNotificationService>True</IsNotificationService>

    <IsEventService>True</IsEventService>

    <PollingInterval>10</PollingInterval>

    <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>

    <MemorySafetyMargin>80</MemorySafetyMargin>

    <MemoryThreshold>90</MemoryThreshold>

    <RecycleTime>720</RecycleTime>

    <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>

    <MaxQueueThreads>0</MaxQueueThreads>

    <UrlRoot>

    </UrlRoot>

    <UnattendedExecutionAccount>

    <UserName></UserName>

    <Password></Password>

    <Domain></Domain>

    </UnattendedExecutionAccount>

    <PolicyLevel>rssrvpolicy.config</PolicyLevel>

    <IsWebServiceEnabled>True</IsWebServiceEnabled>

    <IsReportManagerEnabled>True</IsReportManagerEnabled>

    <FileShareStorageLocation>

    <Path>

    </Path>

    </FileShareStorageLocation>

    </Service>

    <UI>

    <ReportServerUrl>

    </ReportServerUrl>

    <PageCountMode>Estimate</PageCountMode>

    </UI>

    <Extensions>

    <Delivery>

    <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">

    <MaxRetries>3</MaxRetries>

    <SecondsBeforeRetry>900</SecondsBeforeRetry>

    <Configuration>

    <FileShareConfiguration>

    <ExcludedRenderFormats>

    <RenderingExtension>HTMLOWC</RenderingExtension>

    <RenderingExtension>NULL</RenderingExtension>

    <RenderingExtension>RGDI</RenderingExtension>

    </ExcludedRenderFormats>

    </FileShareConfiguration>

    </Configuration>

    </Extension>

    <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">

    <MaxRetries>3</MaxRetries>

    <SecondsBeforeRetry>900</SecondsBeforeRetry>

    <Configuration>

    <RSEmailDPConfiguration>

    <SMTPServer></SMTPServer>

    <SMTPServerPort>

    </SMTPServerPort>

    <SMTPAccountName>

    </SMTPAccountName>

    <SMTPConnectionTimeout>

    </SMTPConnectionTimeout>

    <SMTPServerPickupDirectory>

    </SMTPServerPickupDirectory>

    <SMTPUseSSL>

    </SMTPUseSSL>

    <SendUsing>2</SendUsing>

    <SMTPAuthenticate>

    </SMTPAuthenticate>

    <From></From>

    <EmbeddedRenderFormats>

    <RenderingExtension>MHTML</RenderingExtension>

    </EmbeddedRenderFormats>

    <PrivilegedUserRenderFormats>

    </PrivilegedUserRenderFormats>

    <ExcludedRenderFormats>

    <RenderingExtension>HTMLOWC</RenderingExtension>

    <RenderingExtension>NULL</RenderingExtension>

    <RenderingExtension>RGDI</RenderingExtension>

    </ExcludedRenderFormats>

    <SendEmailToUserAlias>True</SendEmailToUserAlias>

    <DefaultHostName>

    </DefaultHostName>

    <PermittedHosts>

    </PermittedHosts>

    </RSEmailDPConfiguration>

    </Configuration>

    </Extension>

    <Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider,ReportingServicesSharePointDeliveryExtension">

    <MaxRetries>3</MaxRetries>

    <SecondsBeforeRetry>900</SecondsBeforeRetry>

    <Configuration>

    <DocumentLibraryConfiguration>

    <ExcludedRenderFormats>

    <RenderingExtension>HTMLOWC</RenderingExtension>

    <RenderingExtension>NULL</RenderingExtension>

    <RenderingExtension>RGDI</RenderingExtension>

    </ExcludedRenderFormats>

    </DocumentLibraryConfiguration>

    </Configuration>

    </Extension>

    <Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>

    </Delivery>

    <DeliveryUI>

    <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">

    <DefaultDeliveryExtension>True</DefaultDeliveryExtension>

    <Configuration>

    <RSEmailDPConfiguration>

    <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>

    </RSEmailDPConfiguration>

    </Configuration>

    </Extension>

    <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>

    </DeliveryUI>

    <Render>

    <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering"/>

    <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>

    <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/>

    <Extension Name="ATOM" Type="Microsoft.ReportingServices.Rendering.DataRenderer.AtomDataReport,Microsoft.ReportingServices.DataRendering" Visible="false"/>

    <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/>

    <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/>

    <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false">

    <Configuration>

    <DeviceInfo>

    <DataVisualizationFitSizing>Approximate</DataVisualizationFitSizing>

    </DeviceInfo>

    </Configuration>

    </Extension>

    <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering">

    <Configuration>

    <DeviceInfo>

    <DataVisualizationFitSizing>Approximate</DataVisualizationFitSizing>

    </DeviceInfo>

    </Configuration>

    </Extension>

    <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false"/>

    <Extension Name="EXCELOPENXML" Type="Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.ExcelOpenXmlRenderer,Microsoft.ReportingServices.ExcelRendering"/>

    <Extension Name="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="false" LogAllExecutionRequests="false"/>

    <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"/>

    <Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering" Visible="false"/>

    <Extension Name="WORDOPENXML" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordOpenXmlRenderer.WordOpenXmlDocumentRenderer,Microsoft.ReportingServices.WordRendering"/>

    </Render>

    <Data>

    <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.DataExtensions.SqlAzureConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.DataExtensions.SqlDwConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="SHAREPOINTLIST" Type="Microsoft.ReportingServices.DataExtensions.SharePointList.SPListConnection,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/>

    <Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/>

    <Extension Name="TERADATA" Type="Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    </Data>

    <SemanticQuery>

    <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">

    <Configuration>

    <EnableMathOpCasting>False</EnableMathOpCasting>

    </Configuration>

    </Extension>

    <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">

    <Configuration>

    <EnableMathOpCasting>False</EnableMathOpCasting>

    </Configuration>

    </Extension>

    <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQLADW.MSSqlAdwSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">

    <Configuration>

    <EnableMathOpCasting>False</EnableMathOpCasting>

    </Configuration>

    </Extension>

    <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">

    <Configuration>

    <EnableMathOpCasting>True</EnableMathOpCasting>

    <DisableNO_MERGEInLeftOuters>False</DisableNO_MERGEInLeftOuters>

    <EnableUnistr>False</EnableUnistr>

    <DisableTSTruncation>False</DisableTSTruncation>

    </Configuration>

    </Extension>

    <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">

    <Configuration>

    <EnableMathOpCasting>True</EnableMathOpCasting>

    <ReplaceFunctionName>oREPLACE</ReplaceFunctionName>

    </Configuration>

    </Extension>

    <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand,Microsoft.AnalysisServices.Modeling"/>

    </SemanticQuery>

    <ModelGeneration>

    <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>

    <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>

    <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>

    <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>

    <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.Generation.ModelGeneratorExtention,Microsoft.AnalysisServices.Modeling"/>

    </ModelGeneration>

    <Security>

    <Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization"/>

    </Security>

    <Authentication>

    <Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization"/>

    </Authentication>

    <EventProcessing>

    <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">

    <Event>

    <Type>ReportHistorySnapshotCreated</Type>

    </Event>

    </Extension>

    <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">

    <Event>

    <Type>TimedSubscription</Type>

    </Event>

    </Extension>

    <Extension Name="Cache Refresh Plan Extension" Type="Microsoft.ReportingServices.Library.CacheRefreshPlanHandler,ReportingServicesLibrary">

    <Event>

    <Type>RefreshCache</Type>

    </Event>

    </Extension>

    <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">

    <Event>

    <Type>SnapshotUpdated</Type>

    </Event>

    </Extension>

    </EventProcessing>

    </Extensions>

    <MapTileServerConfiguration>

    <MaxConnections>2</MaxConnections>

    <Timeout>10</Timeout>

    <AppID>(Default)</AppID>

    <CacheLevel>Default</CacheLevel>

    </MapTileServerConfiguration>

    </Configuration>

  • August 29, 2012 at 9:45 am

    #1531488

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

    Cheers

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

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