none
Migration from SSRS 2005 to SSRS 2012

    Question

  • Hi all,

    I have just done an upgrade of our SSRS environment in development from SQL 2005 to SQL 2012 (SP1).

    The process I followed was that documented by Microsoft, basically backup and restore database and encryption key, however we have an issue in that certain reports are not loading.

    Reports created using a data source work without any issues however reports using specific reporting models are not working. The error log is very vague however the stack dump produced does provide this message -

    "library!ReportServer_0-2!13a4!12/02/2013-09:50:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Unsupported object type: System.Uri, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;"

    I've gone over everything a dozen times and I still cant find any issues. Can anyone think of a possible cause here?

    Thanks,

    Nic

    Monday, December 02, 2013 2:23 PM

Answers

  • Hi Alisa,

    We have now found the issue.

    It turns out that in the report model there were some custom properties, in two of these custom properties there were references to a URI which did not support the data types. The URI references were;

    "<Value xsi:type="xsd:anyURI">http://tempuri.org</Value>"

    We removed these two references and the report model then deployed successfully.

    Thanks for your assistance.

    Regards,

    Nic

    • Marked as answer by Nic Hopper Monday, December 09, 2013 2:12 PM
    Monday, December 09, 2013 11:25 AM

All replies

  • I was under the impression that Report Models were deprecated in SSRS 2012?  I could be wrong though.

    I think Report Models you will still need to maintain and deploy from BIDS 2008

    http://technet.microsoft.com/en-us/library/ms143509.aspx

    Tuesday, December 03, 2013 2:44 AM
  • Specifically

    Report Models

    Semantic modeling language (SMDL) report models are deprecated. Although you can you continue to use existing report models as data sources in SQL Server 2012 Reporting Services reports you should consider updating your reports to remove their dependency on report models.

    SQL Server 2012 Reporting Services does not include tools for creating or updating report models. For more information, see Breaking Changes in SQL Server Reporting Services in SQL Server 2012.

    Tuesday, December 03, 2013 2:45 AM
  • Hi Nic,

    This error may be caused by the following situation:

    Please refer to these above options to check. If the issue is persist, could you please post the error log? It is benefit for us to do further analysis.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    Tuesday, December 03, 2013 5:28 AM
  • Hi all,

    Thanks for the replys.

    As for deprecated reporting models, yes I understand that they cant be added but existing ones should continue to work, out of the 10 we have all but this one work.

    Alisa,

    When the report server database was restored it was done so with the same name so this shouldn't be an issue. The second point you make, wouldn't that only be applicable to SQL 2005 and not to 2012?

    Your third point on the hardware is interesting, I'll check this one and get back to you asap.

    This is the error log details;

    <Header>
      <Product>Microsoft SQL Server Reporting Services Version 2011.0110.3000.00 ((SQL11_PCU_Main).121019-1325 )</Product>
      <Locale>English (United Kingdom)</Locale>
      <TimeZone>GMT Standard Time</TimeZone>
      <Path>C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__12_03_2013_11_22_29.log</Path>
      <SystemName>MyMachine</SystemName>
      <OSName>Microsoft Windows NT 6.1.7601 Service Pack 1</OSName>
      <OSVersion>6.1.7601</OSVersion>
      <ProcessID>10580</ProcessID>
      <Virtualization>None</Virtualization>
    </Header>
    rshost!rshost!324c!12/03/2013-11:22:29:: i INFO: CLR runtime is initialized.
    rshost!rshost!324c!12/03/2013-11:22:29:: i INFO: Derived memory configuration based on physical memory as 8342052 KB
    appdomainmanager!DefaultDomain!324c!12/03/2013-11:22:29:: i INFO: Entered managed ServiceMain in DefaultDomain.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing DisableSecureFormsAuthenticationCookie to 'False'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to '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'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing AuthenticationTypes to '4'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing RSWindowsExtendedProtectionLevel to 'Off'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing RSWindowsExtendedProtectionScenario to 'Proxy'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing EnableAuthPersistence to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: w WARN: Initializing UrlRoot to default value of ''  because it was incorrectly specified in Configuration file as ''.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing IsReportManagerEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MaxConnections to '2'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing Timeout to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing AppID to '(Default)'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing CacheLevel to 'Default'  as specified in Configuration file.
    resourceutilities!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Reporting Services starting SKU: Evaluation
    resourceutilities!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Evaluation copy: 176 days left
    configmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Using report server external url http://MyMachine:80/ReportServer.
    configmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Using url root http://MyMachine:80/ReportServer.
    rshost!rshost!2c40!12/03/2013-11:22:29:: i INFO: Configuring maxPhysicalCpu=0, minLogicalCpu=0
    rshost!rshost!2c40!12/03/2013-11:22:29:: i INFO: Logical processor per physical processor 8
    rshost!rshost!2c40!12/03/2013-11:22:29:: i INFO: Logical processor per core 2
    rshost!rshost!2c40!12/03/2013-11:22:29:: i INFO: Logical processor unlimited
    rshost!rshost!2c40!12/03/2013-11:22:29:: i INFO: Maximum logical CPU is 8
    configmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Using report server external url http://MyMachine:80/ReportServer.
    configmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Using url root http://MyMachine:80/ReportServer.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Do not dump on: 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
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Appdomain:2 WindowsService_0 started.
    library!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
    library!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
    library!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
    library!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: Do not dump on: 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
    library!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
    resourceutilities!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: Reporting Services starting SKU: Evaluation
    resourceutilities!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: Evaluation copy: 176 days left
    library!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: Catalog SQL Server Edition = Evaluation
    crypto!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: Initializing crypto as user: domain\nhopper
    crypto!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: Exporting public key
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:31:: i INFO: SPN for the service account is MSSQLSvc/MyMachine.Atrium-uw.com:1433
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:31:: i INFO: SPN for the service account is MSSQLSvc/MyMachine.Atrium-uw.com
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:31:: i INFO: The UserAccountControl value for the service account is 512
    rshost!rshost!2e9c!12/03/2013-11:22:31:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer.
    rshost!rshost!2e9c!12/03/2013-11:22:31:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:31:: i INFO: SPN for the service account is MSSQLSvc/MyMachine.Atrium-uw.com:1433
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:31:: i INFO: SPN for the service account is MSSQLSvc/MyMachine.Atrium-uw.com
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:31:: i INFO: The UserAccountControl value for the service account is 512
    rshost!rshost!980!12/03/2013-11:22:31:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportManager.
    rshost!rshost!980!12/03/2013-11:22:31:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3
    rshost!rshost!2a64!12/03/2013-11:22:31:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.
    rshost!rshost!2c40!12/03/2013-11:22:31:: i INFO: Derived memory configuration based on physical memory as 8342052 KB
    servicecontroller!DefaultDomain!2b64!12/03/2013-11:22:31:: i INFO: Total Physical memory: 8542261248
    rpcserver!DefaultDomain!3098!12/03/2013-11:22:31:: i INFO: Process monitoring started.
    crypto!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: Performing sku validation
    crypto!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: Importing existing encryption key
    dbpolling!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: EventPolling polling service started
    dbpolling!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: NotificationPolling polling service started
    dbpolling!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: SchedulePolling polling service started
    dbpolling!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: UpgradePolling polling service started
    dbpolling!WindowsService_0!2e9c!12/03/2013-11:22:31:: i INFO: PollingMaintenance: Polling started
    rpcserver!DefaultDomain!2ebc!12/03/2013-11:22:31:: i INFO: RPC Server started.
    servicecontroller!DefaultDomain!2ebc!12/03/2013-11:22:31:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS11.MSSQLSERVER'
    appdomainmanager!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: Appdomain:2 WindowsService_0 initialized.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (b53a41e9-bf18-43ea-a4e3-08cfcf25f376) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (678ea767-f957-4de7-b3fe-2c2392cef142) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (68e47c52-df8e-4613-b5db-3c180d83c33e) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (22fc0543-17a7-4dd9-89bc-44bb06b241e9) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (e6298ad3-f6be-4c2e-9428-6b51e498e134) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (24b1819d-c2bc-4c97-96d1-7e5096958a65) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (92f01923-d566-49f7-a01b-97773de66000) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:32:: i INFO: Schedule (84858b02-cca5-4252-8a3b-b7497fd5fe78) altered, being updated.
    library!DefaultDomain!2c40!12/03/2013-11:22:32:: i INFO: Catalog SQL Server Edition = Evaluation
    appdomainmanager!DefaultDomain!2f14!12/03/2013-11:22:37:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-130305433573581023 started.
    appdomainmanager!ReportManager_0-1!2f14!12/03/2013-11:22:38:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/Reports.
    appdomainmanager!DefaultDomain!2f14!12/03/2013-11:22:38:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-130305433573581023 initialized (#1).
    library!ReportManager_0-1!2f14!12/03/2013-11:22:39:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
    library!ReportManager_0-1!2f14!12/03/2013-11:22:39:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
    library!ReportManager_0-1!2f14!12/03/2013-11:22:39:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
    library!ReportManager_0-1!2f14!12/03/2013-11:22:39:: i INFO: Do not dump on: 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
    library!ReportManager_0-1!2f14!12/03/2013-11:22:39:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
    ui!ReportManager_0-1!2f14!12/03/2013-11:22:39:: i INFO: Registering with Software Usage Metrics Product:SQL Server 2012, Role:Microsoft SQL Server Reporting Services, RoleGuid:8cc0ac85-40f7-4886-9dab-021519800418
    ui!ReportManager_0-1!2f14!12/03/2013-11:22:39:: e ERROR: Software Usage Metrics initialize failed
    appdomainmanager!DefaultDomain!1ed8!12/03/2013-11:22:41:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-130305433616481023 started.
    appdomainmanager!ReportServer_0-2!1ed8!12/03/2013-11:22:42:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
    appdomainmanager!DefaultDomain!1ed8!12/03/2013-11:22:43:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-130305433616481023 initialized (#1).
    webserver!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Reporting Web Server started
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Do not dump on: 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
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
    resourceutilities!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Reporting Services starting SKU: Evaluation
    resourceutilities!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Evaluation copy: 176 days left
    ui!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Software Usage Metrics not enabled for Evaluation edition
    library!ReportServer_0-2!2ebc!12/03/2013-11:22:48:: i INFO: Call to GetPermissionsAction(/Finance/Syndicate/609 Event Code Report).
    library!ReportServer_0-2!2ebc!12/03/2013-11:22:48:: i INFO: Catalog SQL Server Edition = Evaluation
    crypto!ReportServer_0-2!2ebc!12/03/2013-11:22:48:: i INFO: Initializing crypto as user: ACUL\nhopper
    crypto!ReportServer_0-2!2ebc!12/03/2013-11:22:48:: i INFO: Exporting public key
    crypto!ReportServer_0-2!2ebc!12/03/2013-11:22:48:: i INFO: Performing sku validation
    crypto!ReportServer_0-2!2ebc!12/03/2013-11:22:48:: i INFO: Importing existing encryption key
    library!ReportServer_0-2!2d38!12/03/2013-11:22:49:: i INFO: Call to GetSystemPropertiesAction().
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:49:: i INFO: Call to GetPropertiesAction(/Finance/Syndicate/609 Event Code Report, PathBased).
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:49:: i INFO: Call to GetSystemPermissionsAction().
    ui!ReportManager_0-1!2f14!12/03/2013-11:22:49:: i INFO: PageCountMode 'Estimate' read from config file
    library!ReportServer_0-2!33e8!12/03/2013-11:22:50:: i INFO: Call to GetSystemPropertiesAction().
    library!ReportServer_0-2!33e8!12/03/2013-11:22:51:: i INFO: Call to GetPermissionsAction(/Finance/Syndicate/609 Event Code Report).
    library!ReportServer_0-2!33e8!12/03/2013-11:22:51:: i INFO: Call to GetSystemPropertiesAction().
    library!ReportServer_0-2!1cc8!12/03/2013-11:22:51:: i INFO: Call to GetPropertiesAction(/Finance/Syndicate/609 Event Code Report, PathBased).
    library!ReportServer_0-2!2f2c!12/03/2013-11:22:51:: i INFO: Call to GetSystemPermissionsAction().
    library!ReportServer_0-2!1cc8!12/03/2013-11:22:51:: i INFO: Call to GetSystemPropertiesAction().
    library!ReportServer_0-2!33e8!12/03/2013-11:22:51:: i INFO: RenderForNewSession('/Finance/Syndicate/609 Event Code Report')
    library!ReportServer_0-2!33e8!12/03/2013-11:22:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Unsupported object type: System.Uri, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;
    library!ReportServer_0-2!33e8!12/03/2013-11:22:55:: i INFO: Dump result: External dump process return code 0x20000001.
    External dump process returned no errors.
    .
    processing!ReportServer_0-2!33e8!12/03/2013-11:22:55:: e ERROR: Data source 'dataSource1': An error has occurred. Details: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
    processing!ReportServer_0-2!33e8!12/03/2013-11:22:55:: e ERROR: An exception has occurred in data source 'dataSource1'. Details: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
    processing!ReportServer_0-2!33e8!12/03/2013-11:22:55:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
    processing!ReportServer_0-2!33e8!12/03/2013-11:22:55:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
       --- End of inner exception stack trace ---;
    library!ReportServer_0-2!33e8!12/03/2013-11:22:55:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
    webserver!ReportServer_0-2!33e8!12/03/2013-11:22:55:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

    and this is the stack dump that goes with it;

    <Header>
      <Product>Microsoft SQL Server Reporting Services Version 2011.0110.3000.00 ((SQL11_PCU_Main).121019-1325 )</Product>
      <Locale>English (United Kingdom)</Locale>
      <TimeZone>GMT Standard Time</TimeZone>
      <Path>C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__12_03_2013_11_22_29.log</Path>
      <SystemName>MyMachine</SystemName>
      <OSName>Microsoft Windows NT 6.1.7601 Service Pack 1</OSName>
      <OSVersion>6.1.7601</OSVersion>
      <ProcessID>10580</ProcessID>
      <Virtualization>None</Virtualization>
    </Header>
    rshost!rshost!324c!12/03/2013-11:22:29:: i INFO: CLR runtime is initialized.
    rshost!rshost!324c!12/03/2013-11:22:29:: i INFO: Derived memory configuration based on physical memory as 8342052 KB
    appdomainmanager!DefaultDomain!324c!12/03/2013-11:22:29:: i INFO: Entered managed ServiceMain in DefaultDomain.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing DisableSecureFormsAuthenticationCookie to 'False'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to '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'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing AuthenticationTypes to '4'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing RSWindowsExtendedProtectionLevel to 'Off'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing RSWindowsExtendedProtectionScenario to 'Proxy'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing EnableAuthPersistence to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: w WARN: Initializing UrlRoot to default value of ''  because it was incorrectly specified in Configuration file as ''.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing IsReportManagerEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing MaxConnections to '2'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing Timeout to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing AppID to '(Default)'  as specified in Configuration file.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Initializing CacheLevel to 'Default'  as specified in Configuration file.
    resourceutilities!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Reporting Services starting SKU: Evaluation
    resourceutilities!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Evaluation copy: 176 days left
    configmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Using report server external url http://MyMachine:80/ReportServer.
    configmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Using url root http://MyMachine:80/ReportServer.
    rshost!rshost!2c40!12/03/2013-11:22:29:: i INFO: Configuring maxPhysicalCpu=0, minLogicalCpu=0
    rshost!rshost!2c40!12/03/2013-11:22:29:: i INFO: Logical processor per physical processor 8
    rshost!rshost!2c40!12/03/2013-11:22:29:: i INFO: Logical processor per core 2
    rshost!rshost!2c40!12/03/2013-11:22:29:: i INFO: Logical processor unlimited
    rshost!rshost!2c40!12/03/2013-11:22:29:: i INFO: Maximum logical CPU is 8
    configmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Using report server external url http://MyMachine:80/ReportServer.
    configmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Using url root http://MyMachine:80/ReportServer.
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Do not dump on: 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
    library!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:29:: i INFO: Appdomain:2 WindowsService_0 started.
    library!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
    library!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
    library!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
    library!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: Do not dump on: 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
    library!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
    resourceutilities!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: Reporting Services starting SKU: Evaluation
    resourceutilities!WindowsService_0!2c40!12/03/2013-11:22:31:: i INFO: Evaluation copy: 176 days left
    library!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: Catalog SQL Server Edition = Evaluation
    crypto!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: Initializing crypto as user: domain\nhopper
    crypto!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: Exporting public key
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:31:: i INFO: SPN for the service account is MSSQLSvc/MyMachine.Atrium-uw.com:1433
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:31:: i INFO: SPN for the service account is MSSQLSvc/MyMachine.Atrium-uw.com
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:31:: i INFO: The UserAccountControl value for the service account is 512
    rshost!rshost!2e9c!12/03/2013-11:22:31:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer.
    rshost!rshost!2e9c!12/03/2013-11:22:31:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:31:: i INFO: SPN for the service account is MSSQLSvc/MyMachine.Atrium-uw.com:1433
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:31:: i INFO: SPN for the service account is MSSQLSvc/MyMachine.Atrium-uw.com
    appdomainmanager!DefaultDomain!2c40!12/03/2013-11:22:31:: i INFO: The UserAccountControl value for the service account is 512
    rshost!rshost!980!12/03/2013-11:22:31:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportManager.
    rshost!rshost!980!12/03/2013-11:22:31:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3
    rshost!rshost!2a64!12/03/2013-11:22:31:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.
    rshost!rshost!2c40!12/03/2013-11:22:31:: i INFO: Derived memory configuration based on physical memory as 8342052 KB
    servicecontroller!DefaultDomain!2b64!12/03/2013-11:22:31:: i INFO: Total Physical memory: 8542261248
    rpcserver!DefaultDomain!3098!12/03/2013-11:22:31:: i INFO: Process monitoring started.
    crypto!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: Performing sku validation
    crypto!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: Importing existing encryption key
    dbpolling!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: EventPolling polling service started
    dbpolling!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: NotificationPolling polling service started
    dbpolling!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: SchedulePolling polling service started
    dbpolling!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: UpgradePolling polling service started
    dbpolling!WindowsService_0!2e9c!12/03/2013-11:22:31:: i INFO: PollingMaintenance: Polling started
    rpcserver!DefaultDomain!2ebc!12/03/2013-11:22:31:: i INFO: RPC Server started.
    servicecontroller!DefaultDomain!2ebc!12/03/2013-11:22:31:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS11.MSSQLSERVER'
    appdomainmanager!WindowsService_0!2ebc!12/03/2013-11:22:31:: i INFO: Appdomain:2 WindowsService_0 initialized.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (b53a41e9-bf18-43ea-a4e3-08cfcf25f376) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (678ea767-f957-4de7-b3fe-2c2392cef142) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (68e47c52-df8e-4613-b5db-3c180d83c33e) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (22fc0543-17a7-4dd9-89bc-44bb06b241e9) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (e6298ad3-f6be-4c2e-9428-6b51e498e134) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (24b1819d-c2bc-4c97-96d1-7e5096958a65) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:31:: i INFO: Schedule (92f01923-d566-49f7-a01b-97773de66000) altered, being updated.
    schedule!WindowsService_0!2f60!12/03/2013-11:22:32:: i INFO: Schedule (84858b02-cca5-4252-8a3b-b7497fd5fe78) altered, being updated.
    library!DefaultDomain!2c40!12/03/2013-11:22:32:: i INFO: Catalog SQL Server Edition = Evaluation
    appdomainmanager!DefaultDomain!2f14!12/03/2013-11:22:37:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-130305433573581023 started.
    appdomainmanager!ReportManager_0-1!2f14!12/03/2013-11:22:38:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/Reports.
    appdomainmanager!DefaultDomain!2f14!12/03/2013-11:22:38:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-130305433573581023 initialized (#1).
    library!ReportManager_0-1!2f14!12/03/2013-11:22:39:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
    library!ReportManager_0-1!2f14!12/03/2013-11:22:39:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
    library!ReportManager_0-1!2f14!12/03/2013-11:22:39:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
    library!ReportManager_0-1!2f14!12/03/2013-11:22:39:: i INFO: Do not dump on: 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
    library!ReportManager_0-1!2f14!12/03/2013-11:22:39:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
    ui!ReportManager_0-1!2f14!12/03/2013-11:22:39:: i INFO: Registering with Software Usage Metrics Product:SQL Server 2012, Role:Microsoft SQL Server Reporting Services, RoleGuid:8cc0ac85-40f7-4886-9dab-021519800418
    ui!ReportManager_0-1!2f14!12/03/2013-11:22:39:: e ERROR: Software Usage Metrics initialize failed
    appdomainmanager!DefaultDomain!1ed8!12/03/2013-11:22:41:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-130305433616481023 started.
    appdomainmanager!ReportServer_0-2!1ed8!12/03/2013-11:22:42:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
    appdomainmanager!DefaultDomain!1ed8!12/03/2013-11:22:43:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-130305433616481023 initialized (#1).
    webserver!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Reporting Web Server started
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Do not dump on: 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
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
    resourceutilities!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Reporting Services starting SKU: Evaluation
    resourceutilities!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Evaluation copy: 176 days left
    ui!ReportServer_0-2!1ed8!12/03/2013-11:22:46:: i INFO: Software Usage Metrics not enabled for Evaluation edition
    library!ReportServer_0-2!2ebc!12/03/2013-11:22:48:: i INFO: Call to GetPermissionsAction(/Finance/Syndicate/609 Event Code Report).
    library!ReportServer_0-2!2ebc!12/03/2013-11:22:48:: i INFO: Catalog SQL Server Edition = Evaluation
    crypto!ReportServer_0-2!2ebc!12/03/2013-11:22:48:: i INFO: Initializing crypto as user: domain\nhopper
    crypto!ReportServer_0-2!2ebc!12/03/2013-11:22:48:: i INFO: Exporting public key
    crypto!ReportServer_0-2!2ebc!12/03/2013-11:22:48:: i INFO: Performing sku validation
    crypto!ReportServer_0-2!2ebc!12/03/2013-11:22:48:: i INFO: Importing existing encryption key
    library!ReportServer_0-2!2d38!12/03/2013-11:22:49:: i INFO: Call to GetSystemPropertiesAction().
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:49:: i INFO: Call to GetPropertiesAction(/Finance/Syndicate/609 Event Code Report, PathBased).
    library!ReportServer_0-2!1ed8!12/03/2013-11:22:49:: i INFO: Call to GetSystemPermissionsAction().
    ui!ReportManager_0-1!2f14!12/03/2013-11:22:49:: i INFO: PageCountMode 'Estimate' read from config file
    library!ReportServer_0-2!33e8!12/03/2013-11:22:50:: i INFO: Call to GetSystemPropertiesAction().
    library!ReportServer_0-2!33e8!12/03/2013-11:22:51:: i INFO: Call to GetPermissionsAction(/Finance/Syndicate/609 Event Code Report).
    library!ReportServer_0-2!33e8!12/03/2013-11:22:51:: i INFO: Call to GetSystemPropertiesAction().
    library!ReportServer_0-2!1cc8!12/03/2013-11:22:51:: i INFO: Call to GetPropertiesAction(/Finance/Syndicate/609 Event Code Report, PathBased).
    library!ReportServer_0-2!2f2c!12/03/2013-11:22:51:: i INFO: Call to GetSystemPermissionsAction().
    library!ReportServer_0-2!1cc8!12/03/2013-11:22:51:: i INFO: Call to GetSystemPropertiesAction().
    library!ReportServer_0-2!33e8!12/03/2013-11:22:51:: i INFO: RenderForNewSession('/Finance/Syndicate/609 Event Code Report')
    library!ReportServer_0-2!33e8!12/03/2013-11:22:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Unsupported object type: System.Uri, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;

    The bit I find interesting is in the stack dump where at the end it says "Unsupported object type: System.Uri" - I wondered if this could be something in the report model that was using an assembly or something that wasn't moved to the new machine. Although I've no idea how to confirm that and determine the missing assembly.
    • Edited by Nic Hopper Tuesday, December 03, 2013 11:42 AM Comments
    Tuesday, December 03, 2013 11:28 AM
  • Hi,

    I've gone back to basics on this, this is the process I followed.

    1) installed SQL 2005 on the machine and configured SSRS - all works

    2) Updated to SQL 2005 SP2 and restored the report server databases from live - all reports are now visible in SSRS and load correctly - this is as live is.

    3) Updated to SQL 2005 SP4 to ensure that it works at this point - everything works correctly.

    4) Run the upgrade advisor, it complained about a HTML3.2 extension being used so I've removed this from the config, this warning is then removed. The only other warning was "SQL Server 2005 Report Server Web Service group detected". I don't believe this is an issue so I've proceeded.

    5) Backup the databases and key

    6) Install SQL 2012 SP1 and set up the SSRS - all works.

    7) Restore the databases and key - the reports appear everything works EXCEPT the reports related to one specific report model which throws out the same error as above.

    Logins on the machines match up, everything seems fine. With regards to processors, the live servers are Intel Xeon and the development machine for this test has Intel i7's.

    Any idea's? Anyone?

    Thanks,

    Nic

    Wednesday, December 04, 2013 10:04 AM
  • Hi Nic,

    Thank you for your detail information.

    According to the error log, it has error in dataSource1. Did you use report model as datasource in the report? Please redeploy the report model to report server. And recreate the report.

    Please feel free to let me know if your issue is persist.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    Thursday, December 05, 2013 2:19 AM
  • Hi,

    Thanks for the reply Alisa.

    We are indeed using a report model as the datasource. We have just tried to re-deploy the report model to the server from Visual Studio 2005 and it throws the same 'unsupported object' error.

    This is from the log;

    rtServer_0-2!32c!12/05/2013-09:28:56:: i INFO: Call to GetItemTypeAction(/Data Sources).
    library!ReportServer_0-2!cd4!12/05/2013-09:28:56:: i INFO: Call to GetItemTypeAction(/Data Sources/DataSourceName).
    library!ReportServer_0-2!1430!12/05/2013-09:28:57:: i INFO: Call to GetItemTypeAction(/Models/Reporting Model).
    library!ReportServer_0-2!658!12/05/2013-09:28:57:: i INFO: Call to GetItemDataSourcesAction(/Models/Reporting Model).
    library!ReportServer_0-2!32c!12/05/2013-09:28:57:: i INFO: Call to SetModelDefinitionAction(/Models/Reporting Model).
    library!ReportServer_0-2!32c!12/05/2013-09:29:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Unsupported object type: System.Uri, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;
    library!ReportServer_0-2!32c!12/05/2013-09:29:02:: i INFO: Dump result: External dump process return code 0x20000001.
    External dump process returned no errors.
    .
    library!WindowsService_0!ab8!12/05/2013-09:29:20:: i INFO: Call to CleanBatch()
    library!WindowsService_0!ab8!12/05/2013-09:29:22:: i INFO: Cleaned 0 batch records, 0 policies, 3 sessions, 0 cache entries, 1 snapshots, 1 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_0!ab8!12/05/2013-09:29:22:: i INFO: Call to CleanBatch() ends"                    

    And this is from the stack dump that is generated;

    library!ReportServer_0-2!658!12/05/2013-09:27:46:: i INFO: Call to GetPermissionsAction(/Models/Release).

    library!ReportServer_0-2!32c!12/05/2013-09:27:46:: i INFO: Call to GetPropertiesAction(/Models/Release, PathBased).

    library!ReportServer_0-2!1110!12/05/2013-09:27:46:: i INFO: Call to GetPropertiesAction(/Models/Release, PathBased).

    library!ReportServer_0-2!32c!12/05/2013-09:27:46:: i INFO: Call to GetSystemPermissionsAction().

    library!ReportServer_0-2!1110!12/05/2013-09:27:46:: i INFO: Call to ListChildrenAction(/Models/Release, False).

    library!ReportServer_0-2!658!12/05/2013-09:27:46:: i INFO: Call to GetSystemPropertiesAction().

    library!ReportServer_0-2!32c!12/05/2013-09:27:46:: i INFO: Call to GetSystemPropertiesAction().

    library!ReportServer_0-2!cd4!12/05/2013-09:27:46:: i INFO: Call to GetSystemPropertiesAction().

    library!ReportServer_0-2!658!12/05/2013-09:28:56:: i INFO: Call to GetItemTypeAction(/Models).

    library!ReportServer_0-2!32c!12/05/2013-09:28:56:: i INFO: Call to GetItemTypeAction(/Data Sources).

    library!ReportServer_0-2!cd4!12/05/2013-09:28:56:: i INFO: Call to GetItemTypeAction(/Data Sources/DataSourceName).

    library!ReportServer_0-2!1430!12/05/2013-09:28:57:: i INFO: Call to GetItemTypeAction(/Models/Reporting Model).

    library!ReportServer_0-2!658!12/05/2013-09:28:57:: i INFO: Call to GetItemDataSourcesAction(/Models/Reporting Model).

    library!ReportServer_0-2!32c!12/05/2013-09:28:57:: i INFO: Call to SetModelDefinitionAction(/Models/Reporting Model).

    library!ReportServer_0-2!32c!12/05/2013-09:29:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Unsupported object type: System.Uri, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;

    I’ve gone over everything I can think of from the SSRS side and I’m fairly confident that it’s ok so to me that would mean it would have to be something in the model (also the fact that other models work) but I don’t know how to determine what exactly it is that is the problem in the model.

    Thanks,

    Nic

    Thursday, December 05, 2013 10:04 AM
  • Hi Nic,

    Thank you for your reply.

    In SQL Server Reporting Services (SSRS), because it have back compatibility, we can deploy SSRS 2012 reports to SSRS 2005 Report Server. However, there may be some erratic behaviors when we deploy a SSRS 2005 report to SSRS 2012 server.

    I recommend you try to open those projects in SSDT, it will upgrade to SSRS 2012 instance automatically. Then redeploy it to report server.

    Please feel free to let me know if your issue is persist.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    Friday, December 06, 2013 1:16 AM
  • Hi Alisa,

    Opening the project in SSDT does not work, whilst it upgrades the project it is not possible to open the report model definition as you receive an error saying;

    "...can not be opened because it's project type (.smdlproj) is not supported by this version of the application".

    Also I'm a little confused on the compatibility, I would have expected it to be that I can open SSRS 2005 reports in SSRS 2012 as they are upgraded when they are opened. If this is not the case then it would mean that every upgrade from 2005 to 2012 would be require every report to be re-created in SSRS 2012.

    I wouldn't have expected to be able to open SSRS 2012 reports in SSRS 2005 and this isn't what we would be doing in this case. All we are doing is upgrading from SSRS 2005 to SSRS 2012, and it's only this one report model which has the issue.

    Thanks,

    Nic

    Friday, December 06, 2013 9:11 AM
  • Hi Nic,

    If we are used SQL Server 2000 or SQL Server 2005 running in 8.0 compatibility mode, we must upgrade the Database Engine or choose another Database Engine instance. More detail information, please refer to the articel below:

    http://technet.microsoft.com/en-us/library/ms143724.aspx 

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    Monday, December 09, 2013 2:10 AM
  • Hi Alisa,

    The ReportServer and ReportServer tempdb databases were in 9.0 (2005) mode on the original server. These were then backed up and transferred to the SQL 2012 instance and restored there were they remain in 9.0 mode although I have tried changing the compatibility mode to 10 (2008) and 11 (2011).

    The upgrade advisor gave only 1 warning, relating to moving the ACL's although I don't believe this to be a problem. As I said this is only affecting one report model, it is not affecting other reports or report models and is therefore not widespread.

    Is there anyway for us to determine the exact part of the report model which is causing the issue, the logs state - 'unsupported object' so something in there must not be supported anymore, is that correct?

    Thanks,

    Nic

    Monday, December 09, 2013 8:24 AM
  • Hi,

    Looking at it from a different perspective, I've opened the report model solution in BIDS 2008, a build of the project is successful however an attempt to deploy it to the server fails with the error;

    "Error 136 An internal error occurred on the report server. See the error log for more details. C:\Users\me\Documents\Visual Studio 2008\Projects\ReportModel\MyProject\Reporting Model 2.smdl 0 0 "

    The log however does not contain anything for this time.

    There are also a number of messages in BIDS, a sample of these are below;

    Message 1 Could not find schema information for the element 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling:SemanticModel'. C:\Users\me\Documents\Visual Studio 2008\Projects\ReportModel\MyProject\Reporting Model 2.smdl 2 2 Reporting Model
    Message 2 Could not find schema information for the attribute 'ID'. C:\Users\me\Documents\Visual Studio 2008\Projects\ReportModel\MyProject\Reporting Model 2.smdl 2 16 Reporting Model
    Message 3 Could not find schema information for the element 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling:Culture'. C:\Users\me\Documents\Visual Studio 2008\Projects\ReportModel\MyProject\Reporting Model 2.smdl 3 4 Reporting Model
    Message 4 Could not find schema information for the element 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling:Entities'. C:\Users\me\Documents\Visual Studio 2008\Projects\ReportModel\MyProject\Reporting Model 2.smdl 4 4 Reporting Model
    Message 5 Could not find schema information for the element 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling:Entity'. C:\Users\me\Documents\Visual Studio 2008\Projects\ReportModel\MyProject\Reporting Model 2.smdl 5 6 Reporting Model

    There are also then roughly 30 warnings, a sample of one of these is below;

    "The Relation property of the Role "BPR / Claims Reference" refers to the Target end of the Relation "<View name>", which is not bound to a set of uniquely constrained columns for the Table "<Another view name>". Roles with Cardinality of One or OptionalOne require relations bound to uniquely constrained columns of the table. Reporting Model 2.smdl 0 0 "

    I don't believe these warnings are stopping the deployment but I'm not so sure on the messages? Could these be causing the issue?

    Thanks for your help with this.

    Regards,

    Nic

    Monday, December 09, 2013 9:43 AM
  • Hi Alisa,

    We have now found the issue.

    It turns out that in the report model there were some custom properties, in two of these custom properties there were references to a URI which did not support the data types. The URI references were;

    "<Value xsi:type="xsd:anyURI">http://tempuri.org</Value>"

    We removed these two references and the report model then deployed successfully.

    Thanks for your assistance.

    Regards,

    Nic

    • Marked as answer by Nic Hopper Monday, December 09, 2013 2:12 PM
    Monday, December 09, 2013 11:25 AM