Asked by:
System.FormatException: Guid should contain 32 digits with 4 dashes

Question
-
Perform migration to CRM 2011 CRM 2013 OnPremise, but reports do not run me send me the following error:
Failed to process the report. (rsProcessingAborted)
Can not create a connection to data source 'CRM'. (rsErrorOpeningConnection)
System.FormatException: Guid Should Contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
Guid Should Contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).Q help me I appreciate.
regards
Thursday, January 16, 2014 8:17 PM
All replies
-
sending them log reporting service
<Header>
<Product>Microsoft SQL Server Reporting Services Version 2011.0110.3000.00 ((SQL11_PCU_Main).121019-1325 )</Product>
<Locale>English (United States)</Locale>
<TimeZone></TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__01_16_2014_13_47_04.log</Path>
<SystemName>CRM2013SQL</SystemName>
<OSName>Microsoft Windows NT 6.2.9200</OSName>
<OSVersion>6.2.9200</OSVersion>
<ProcessID>4544</ProcessID>
<Virtualization>None</Virtualization>
</Header>
rshost!rshost!1bb4!01/16/2014-13:47:04:: i INFO: CLR runtime is initialized.
rshost!rshost!1bb4!01/16/2014-13:47:04:: i INFO: Derived memory configuration based on physical memory as 33518856 KB
appdomainmanager!DefaultDomain!1bb4!01/16/2014-13:47:04:: i INFO: Entered managed ServiceMain in DefaultDomain.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing DisableSecureFormsAuthenticationCookie to 'False' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: 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!14ac!01/16/2014-13:47:05:: 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!14ac!01/16/2014-13:47:05:: i INFO: Initializing AuthenticationTypes to '4' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing RSWindowsExtendedProtectionLevel to 'Off' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing RSWindowsExtendedProtectionScenario to 'Proxy' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing EnableAuthPersistence to 'True' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: w WARN: Initializing UrlRoot to default value of '' because it was incorrectly specified in Configuration file as ''.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing IsReportManagerEnabled to 'True' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing MaxConnections to '2' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing Timeout to '10' second(s) as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing AppID to '(Default)' as specified in Configuration file.
library!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Initializing CacheLevel to 'Default' as specified in Configuration file.
resourceutilities!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Reporting Services starting SKU: Enterprise
configmanager!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Using report server internal url http://localhost:80/ReportServer.
configmanager!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Using report server external url http://CRM2013SQL:80/ReportServer.
configmanager!DefaultDomain!14ac!01/16/2014-13:47:05:: i INFO: Using url root http://CRM2013SQL:80/ReportServer.
rshost!rshost!14ac!01/16/2014-13:47:05:: i INFO: Configuring maxPhysicalCpu=20, minLogicalCpu=0
rshost!rshost!14ac!01/16/2014-13:47:05:: i INFO: Logical processor per physical processor 12
rshost!rshost!14ac!01/16/2014-13:47:05:: i INFO: Logical processor per core 2
rshost!rshost!14ac!01/16/2014-13:47:05:: i INFO: Maximum logical CPU is 24
configmanager!DefaultDomain!14ac!01/16/2014-13:47:06:: i INFO: Using report server internal url http://localhost:80/ReportServer.
configmanager!DefaultDomain!14ac!01/16/2014-13:47:06:: i INFO: Using report server external url http://CRM2013SQL:80/ReportServer.
configmanager!DefaultDomain!14ac!01/16/2014-13:47:06:: i INFO: Using url root http://CRM2013SQL:80/ReportServer.
library!DefaultDomain!14ac!01/16/2014-13:47:06:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!DefaultDomain!14ac!01/16/2014-13:47:06:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!DefaultDomain!14ac!01/16/2014-13:47:06:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!DefaultDomain!14ac!01/16/2014-13:47:06:: 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!14ac!01/16/2014-13:47:06:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
appdomainmanager!DefaultDomain!14ac!01/16/2014-13:47:06:: i INFO: Appdomain:2 WindowsService_0 started.
library!WindowsService_0!14ac!01/16/2014-13:47:09:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!WindowsService_0!14ac!01/16/2014-13:47:09:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!WindowsService_0!14ac!01/16/2014-13:47:09:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!WindowsService_0!14ac!01/16/2014-13:47:09:: 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!14ac!01/16/2014-13:47:09:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
resourceutilities!WindowsService_0!14ac!01/16/2014-13:47:09:: i INFO: Reporting Services starting SKU: Enterprise
library!WindowsService_0!b88!01/16/2014-13:47:10:: i INFO: Catalog SQL Server Edition = Enterprise
crypto!WindowsService_0!b88!01/16/2014-13:47:10:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
crypto!WindowsService_0!b88!01/16/2014-13:47:10:: i INFO: Exporting public key
crypto!WindowsService_0!b88!01/16/2014-13:47:10:: i INFO: Performing sku validation
crypto!WindowsService_0!b88!01/16/2014-13:47:10:: i INFO: Importing existing encryption key
rshost!rshost!139c!01/16/2014-13:47:10:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer.
rshost!rshost!139c!01/16/2014-13:47:10:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
rshost!rshost!ff4!01/16/2014-13:47:10:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportManager.
rshost!rshost!ff4!01/16/2014-13:47:10:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3
rshost!rshost!1f9c!01/16/2014-13:47:10:: 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!14ac!01/16/2014-13:47:10:: i INFO: Derived memory configuration based on physical memory as 33518856 KB
servicecontroller!DefaultDomain!17d8!01/16/2014-13:47:10:: i INFO: Total Physical memory: 34323308544
rpcserver!DefaultDomain!1f80!01/16/2014-13:47:10:: i INFO: Process monitoring started.
dbpolling!WindowsService_0!b88!01/16/2014-13:47:10:: i INFO: EventPolling polling service started
dbpolling!WindowsService_0!b88!01/16/2014-13:47:10:: i INFO: NotificationPolling polling service started
dbpolling!WindowsService_0!b88!01/16/2014-13:47:10:: i INFO: SchedulePolling polling service started
dbpolling!WindowsService_0!b88!01/16/2014-13:47:10:: i INFO: UpgradePolling polling service started
dbpolling!WindowsService_0!1fa0!01/16/2014-13:47:10:: i INFO: PollingMaintenance: Polling started
rpcserver!DefaultDomain!b88!01/16/2014-13:47:10:: i INFO: RPC Server started.
servicecontroller!DefaultDomain!b88!01/16/2014-13:47:10:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS11.MSSQLSERVER'
appdomainmanager!WindowsService_0!b88!01/16/2014-13:47:10:: i INFO: Appdomain:2 WindowsService_0 initialized.
library!DefaultDomain!14ac!01/16/2014-13:48:09:: i INFO: Catalog SQL Server Edition = Enterprise
appdomainmanager!DefaultDomain!1f8c!01/16/2014-13:48:14:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-130343752943305752 started.
appdomainmanager!ReportManager_0-1!1f8c!01/16/2014-13:48:18:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/Reports.
appdomainmanager!DefaultDomain!1f8c!01/16/2014-13:48:18:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-130343752943305752 initialized (#1).
library!ReportManager_0-1!1f8c!01/16/2014-13:48:20:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!ReportManager_0-1!1f8c!01/16/2014-13:48:20:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!ReportManager_0-1!1f8c!01/16/2014-13:48:20:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!ReportManager_0-1!1f8c!01/16/2014-13:48:20:: 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!1f8c!01/16/2014-13:48:20:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
ui!ReportManager_0-1!1f8c!01/16/2014-13:48:20:: i INFO: Registering with Software Usage Metrics Product:SQL Server 2012, Role:Microsoft SQL Server Reporting Services, RoleGuid:8cc0ac85-40f7-4886-9dab-021519800418
appdomainmanager!DefaultDomain!1f8c!01/16/2014-13:48:27:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-130343753074402890 started.
appdomainmanager!ReportServer_0-2!1f8c!01/16/2014-13:48:30:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
appdomainmanager!DefaultDomain!1f8c!01/16/2014-13:48:31:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-130343753074402890 initialized (#1).
webserver!ReportServer_0-2!1f8c!01/16/2014-13:48:38:: i INFO: Reporting Web Server started
library!ReportServer_0-2!1f8c!01/16/2014-13:48:39:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!ReportServer_0-2!1f8c!01/16/2014-13:48:39:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!ReportServer_0-2!1f8c!01/16/2014-13:48:39:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!ReportServer_0-2!1f8c!01/16/2014-13:48: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!ReportServer_0-2!1f8c!01/16/2014-13:48:39:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
resourceutilities!ReportServer_0-2!1f8c!01/16/2014-13:48:39:: i INFO: Reporting Services starting SKU: Enterprise
ui!ReportServer_0-2!1f8c!01/16/2014-13:48:39:: i INFO: Software Usage Metrics not enabled for Enterprise edition
library!ReportServer_0-2!1f8c!01/16/2014-13:48:44:: i INFO: Call to GetPermissionsAction(/).
library!ReportServer_0-2!1f8c!01/16/2014-13:48:45:: i INFO: Catalog SQL Server Edition = Enterprise
crypto!ReportServer_0-2!1f8c!01/16/2014-13:48:46:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
crypto!ReportServer_0-2!1f8c!01/16/2014-13:48:46:: i INFO: Exporting public key
crypto!ReportServer_0-2!1f8c!01/16/2014-13:48:46:: i INFO: Performing sku validation
crypto!ReportServer_0-2!1f8c!01/16/2014-13:48:46:: i INFO: Importing existing encryption key
library!ReportServer_0-2!1c94!01/16/2014-13:48:46:: i INFO: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-2!1f8c!01/16/2014-13:48:46:: i INFO: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-2!1f8c!01/16/2014-13:48:46:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!7c8!01/16/2014-13:48:46:: i INFO: Call to ListChildrenAction(/, False).
library!ReportServer_0-2!1cd0!01/16/2014-13:48:47:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1f8c!01/16/2014-13:48:47:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1f8c!01/16/2014-13:48:47:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!fbc!01/16/2014-13:48:49:: i INFO: Call to GetPermissionsAction(/Alfanumeric_MSCRM).
library!ReportServer_0-2!1e04!01/16/2014-13:48:49:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM, PathBased).
library!ReportServer_0-2!1cd0!01/16/2014-13:48:49:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM, PathBased).
library!ReportServer_0-2!1214!01/16/2014-13:48:49:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1cd0!01/16/2014-13:48:49:: i INFO: Call to ListChildrenAction(/Alfanumeric_MSCRM, False).
library!ReportServer_0-2!1d68!01/16/2014-13:48:50:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1e04!01/16/2014-13:48:50:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1cd0!01/16/2014-13:48:50:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1cd0!01/16/2014-13:48:50:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1f8c!01/16/2014-13:48:53:: i INFO: Call to GetPermissionsAction(/Alfanumeric_MSCRM).
library!ReportServer_0-2!fbc!01/16/2014-13:48:53:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM, PathBased).
library!ReportServer_0-2!1f8c!01/16/2014-13:48:53:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM, PathBased).
library!ReportServer_0-2!7c8!01/16/2014-13:48:53:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1f8c!01/16/2014-13:48:53:: i INFO: Call to ListChildrenAction(/Alfanumeric_MSCRM, False).
library!ReportServer_0-2!7c8!01/16/2014-13:48:53:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!fbc!01/16/2014-13:48:53:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1f8c!01/16/2014-13:48:53:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1f8c!01/16/2014-13:48:53:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1cd0!01/16/2014-13:48:55:: i INFO: Call to GetPermissionsAction(/Alfanumeric_MSCRM/CustomReports).
library!ReportServer_0-2!1d68!01/16/2014-13:48:55:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM/CustomReports, PathBased).
library!ReportServer_0-2!1c94!01/16/2014-13:48:55:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM/CustomReports, PathBased).
library!ReportServer_0-2!1fcc!01/16/2014-13:48:55:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!7c8!01/16/2014-13:48:55:: i INFO: Call to ListChildrenAction(/Alfanumeric_MSCRM/CustomReports, False).
library!ReportServer_0-2!fbc!01/16/2014-13:48:55:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1c94!01/16/2014-13:48:55:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1e04!01/16/2014-13:48:55:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1c48!01/16/2014-13:48:55:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1c94!01/16/2014-13:48:57:: i INFO: Call to GetPermissionsAction(/Alfanumeric_MSCRM/CustomReports).
library!ReportServer_0-2!1d68!01/16/2014-13:48:57:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM/CustomReports, PathBased).
library!ReportServer_0-2!139c!01/16/2014-13:48:57:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM/CustomReports, PathBased).
library!ReportServer_0-2!1ca4!01/16/2014-13:48:57:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1cd0!01/16/2014-13:48:57:: i INFO: Call to ListChildrenAction(/Alfanumeric_MSCRM/CustomReports, False).
library!ReportServer_0-2!1c94!01/16/2014-13:48:57:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1cd0!01/16/2014-13:48:57:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1d68!01/16/2014-13:48:57:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1e94!01/16/2014-13:48:57:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!139c!01/16/2014-13:48:59:: i INFO: Call to GetPermissionsAction(/Alfanumeric_MSCRM/CustomReports).
library!ReportServer_0-2!1d68!01/16/2014-13:48:59:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM/CustomReports, PathBased).
library!ReportServer_0-2!7c8!01/16/2014-13:48:59:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM/CustomReports, PathBased).
library!ReportServer_0-2!1c48!01/16/2014-13:48:59:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1c94!01/16/2014-13:48:59:: i INFO: Call to ListChildrenAction(/Alfanumeric_MSCRM/CustomReports, False).
library!ReportServer_0-2!1fcc!01/16/2014-13:48:59:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1d68!01/16/2014-13:49:00:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1cd0!01/16/2014-13:49:00:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1cd0!01/16/2014-13:49:00:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1f8c!01/16/2014-13:49:02:: i INFO: Call to GetPermissionsAction(/Alfanumeric_MSCRM/CustomReports/{f29ad1f0-c27e-e311-93f6-1cc1dee6d12a}).
library!ReportServer_0-2!fbc!01/16/2014-13:49:02:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1c94!01/16/2014-13:49:02:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM/CustomReports/{f29ad1f0-c27e-e311-93f6-1cc1dee6d12a}, PathBased).
library!ReportServer_0-2!b88!01/16/2014-13:49:19:: i INFO: Call to GetSystemPermissionsAction().
ui!ReportManager_0-1!1cd0!01/16/2014-13:49:19:: i INFO: PageCountMode 'Estimate' read from config file
library!ReportServer_0-2!1c94!01/16/2014-13:49:20:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1f8c!01/16/2014-13:49:34:: i INFO: Call to GetPermissionsAction(/Alfanumeric_MSCRM/CustomReports/{f29ad1f0-c27e-e311-93f6-1cc1dee6d12a}).
library!ReportServer_0-2!7c8!01/16/2014-13:49:34:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!7c8!01/16/2014-13:49:34:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM/CustomReports/{f29ad1f0-c27e-e311-93f6-1cc1dee6d12a}, PathBased).
library!ReportServer_0-2!1f8c!01/16/2014-13:49:34:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1f8c!01/16/2014-13:49:35:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!1f8c!01/16/2014-13:49:36:: i INFO: Call to GetPermissionsAction(/Alfanumeric_MSCRM/CustomReports/{f29ad1f0-c27e-e311-93f6-1cc1dee6d12a}).
library!ReportServer_0-2!7c8!01/16/2014-13:49:36:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!7c8!01/16/2014-13:49:36:: i INFO: Call to GetPropertiesAction(/Alfanumeric_MSCRM/CustomReports/{f29ad1f0-c27e-e311-93f6-1cc1dee6d12a}, PathBased).
library!ReportServer_0-2!1f8c!01/16/2014-13:49:36:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1f8c!01/16/2014-13:49:36:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!7c8!01/16/2014-13:49:37:: i INFO: RenderForNewSession('/Alfanumeric_MSCRM/CustomReports/{f29ad1f0-c27e-e311-93f6-1cc1dee6d12a}')
CLR version v4.0.30319 loaded. processing!ReportServer_0-2!7c8!01/16/2014-13:49:40:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: No se puede crear una conexión al origen de datos 'CRM'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
at System.Guid.GuidResult.SetFailure(ParseFailureKind failure, String failureMessageID, Object failureMessageFormatArgument, String failureArgumentName, Exception innerException)
at System.Guid.TryParseGuidWithNoStyle(String guidString, GuidResult& result)
at System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult& result)
at System.Guid..ctor(String g)
at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.Initialize(SecurityIdentifier user)
at Microsoft.Crm.Reporting.DataExtension.Server.Fetch.FetchDataExtensionConnection.Initialize(SecurityIdentifier user)
at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.<>c__DisplayClass1.<Open>b__0()
at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
at System.Guid.GuidResult.SetFailure(ParseFailureKind failure, String failureMessageID, Object failureMessageFormatArgument, String failureArgumentName, Exception innerException)
at System.Guid.TryParseGuidWithNoStyle(String guidString, GuidResult& result)
at System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult& result)
at System.Guid..ctor(String g)
at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.Initialize(SecurityIdentifier user)
at Microsoft.Crm.Reporting.DataExtension.Server.Fetch.FetchDataExtensionConnection.Initialize(SecurityIdentifier user)
at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.<>c__DisplayClass1.<Open>b__0()
at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
--- End of inner exception stack trace ---
at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
at Microsoft.Crm.Reporting.DataExtensionShim.Common.ICrmDbConnectionExtension.Open(String userSid)
at Microsoft.Crm.Reporting.DataExtensionShim.Common.SrsExtConnectionBase.Open()
at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenConnection(IProcessingDataSource dataSourceObj, DataSourceInfo dataSourceInfo, IDbConnection conn)
--- End of inner exception stack trace ---;
processing!ReportServer_0-2!7c8!01/16/2014-13:49:40:: e ERROR: Data source 'CRM': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: No se puede crear una conexión al origen de datos 'CRM'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
processing!ReportServer_0-2!7c8!01/16/2014-13:49:40:: e ERROR: An exception has occurred in data source 'CRM'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: No se puede crear una conexión al origen de datos 'CRM'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
processing!ReportServer_0-2!7c8!01/16/2014-13:49:40:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
processing!ReportServer_0-2!7c8!01/16/2014-13:49:40:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Error al procesar el informe. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: No se puede crear una conexión al origen de datos 'CRM'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
--- End of inner exception stack trace ---;
library!ReportServer_0-2!7c8!01/16/2014-13:49:41:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Error al procesar el informe. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: No se puede crear una conexión al origen de datos 'CRM'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
webserver!ReportServer_0-2!7c8!01/16/2014-13:49:41:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Error al procesar el informe. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Error al procesar el informe. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: No se puede crear una conexión al origen de datos 'CRM'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).Thursday, January 16, 2014 8:18 PM -
It is sql based report or fetchxml based. if it sql based go to your reporting server and in open report via report server url and run report.
Hope this helps. ----------------------------------------------------------------------- Santosh Bhagat If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"
Friday, January 17, 2014 4:01 AM -
Is the problem with just one report, or all reports ?
If the problem is with all reports, it looks like the Data Source in Reporting Services is incorrectly configured. If you use the Reporting Services extension, try removing and reinstaling it, as this will rebuild the Data Sources
Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk
Friday, January 17, 2014 8:30 AMModerator -
This problem only gives me reports FETCH NO OTHERFriday, January 17, 2014 2:04 PM
-
I believe this will be your answer: Cannot create a connection to data source 'CRM' error occurs when you run a Microsoft Dynamics CRM report in the SRS Report Manager or SRS Report Server
To quote:
You receive the following errors when you run a Microsoft Dynamics CRM report in the SRS Report Manager or SRS Report Server:An error has occurred during report processing (rsProcessingAborted) Cannot create a connection to data source ‘CRM.’ (rsErrorOpeningConnection) Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors.This error occurs in Microsoft Dynamics CRM 4.0 because the Microsoft Dynamics CRM Data Connector for Microsoft SQL Server Reporting Services requires the user's SystemUserId value as the Log in name and the user's OrganizationId value as the password.
This error occurs in Microsoft Dynamics CRM 2011 because the Microsoft Dynamics CRM Reporting Extensions requires the user's SystemUserId value as the Log in name and the user's OrganizationId value as the password.
When a report runs inside Microsoft Dynamics CRM, these values are passed automatically. These values must be entered manually when the report is run directly from SQL Server Reporting Services.
Thursday, April 23, 2015 9:31 AM