Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / ms crm 2013 fetchxml r...
Microsoft Dynamics CRM (Archived)

ms crm 2013 fetchxml reports are not working

(0) ShareShare
ReportReport
Posted on by Suresh Sorde 1,075

Hi All

I am using ms crm 2013 onpremise with sql server 2014.

Issue occours after, I restore the old backup of crm in new server. 

Custom fetchxml reports are not working its showing 'Report is generating..' message and then show blank page.

check reporting services configuration manager reports show error 'Cannot create connection to datasource' 

I checked with visual studio it show same error with 'Guid should contain 32 digits with 4 dashes'. When i provide my system credentials it works in VS but in CRM it doesnt.

I googled many sites but issue not resolved.

Kindly help.

Thanks

*This post is locked for comments

  • Suresh Sorde Profile Picture
    Suresh Sorde 1,075 on at
    RE: ms crm 2013 fetchxml reports are not working

    Thanks for reply Aric,

    I am able to connect to datasource and report is working but on visual studio.

    After deploy that report to MS CRM it shows blank page.

    When run report under reporting services manager, it is showing below error -

    Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)

    Microsoft.Crm.CrmConfigObjectNotFoundException: User Was Not Found. User Was Not Found

    when i checked the sql database with query given by you- found domanname is different then the user created with ms crm.

    I mean in CRM user name is added with 'xyz\crmuser' and in Sql server its domain is 'pqr\crmuser'.

    Can this be the cause of issue? If so then, How can i handle this?

    Thanks

  • Suggested answer
    Aric Levin Profile Picture
    Aric Levin 30,188 on at
    RE: ms crm 2013 fetchxml reports are not working

    Check the data sources in Report Server, and make sure you are able to connect to the data source. Once you are able to connect, please retry running the report inside Report Server (Admin mode), and see if you get any additional errors.

    It seems like at this point you are having connection errors.

    Also make sure when running the report you are entering the correct Username and password.

    SELECT systemuserid, organizationid FROM systemuserbase WHERE domainname ={YOURDOMAINNAME}

    Your username is the sytemuserid, the password is the organizationid.

    Hope this helps.

  • Suresh Sorde Profile Picture
    Suresh Sorde 1,075 on at
    RE: ms crm 2013 fetchxml reports are not working

    Thanks,

    Please check the report log below. I am also checking other steps and links and let you know.

    processing!ReportServer_0-5!27d0!10/26/2017-03:13:59:: e ERROR: Data source 'CRM': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source '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-5!27d0!10/26/2017-03:13:59:: e ERROR: An exception has occurred in data source 'CRM'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source '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-5!27d0!10/26/2017-03:13:59:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...

    processing!ReportServer_0-5!27d0!10/26/2017-03:13:59:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source '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-5!27d0!10/26/2017-03:13:59:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source '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).

    library!WindowsService_18!b84!10/26/2017-03:22:49:: i INFO: Call to CleanBatch()

    library!WindowsService_18!b84!10/26/2017-03:22:49:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.

    library!WindowsService_18!b84!10/26/2017-03:22:49:: i INFO: Call to CleanBatch() ends

    library!ReportServer_0-5!27d0!10/26/2017-03:24:16:: i INFO: Call to GetItemTypeAction(/).

    wcfruntime!ReportServer_0-5!27d0!10/26/2017-03:24:16:: i INFO: Entering ExeuteCommand - Command =

    library!ReportServer_0-5!27d0!10/26/2017-03:24:16:: i INFO: Call to ListParentsAction(/).

    library!ReportServer_0-5!27d0!10/26/2017-03:24:16:: i INFO: Call to ListChildrenAction(/, False).

    webserver!ReportServer_0-5!27d0!10/26/2017-03:24:16:: i INFO: Processed folder '/'

    wcfruntime!ReportServer_0-5!27d0!10/26/2017-03:24:20:: i INFO: Entering ExeuteCommand - Command = ListChildren

    library!ReportServer_0-5!27d0!10/26/2017-03:24:20:: i INFO: Call to ListParentsAction(/BSI_MSCRM).

    library!ReportServer_0-5!27d0!10/26/2017-03:24:20:: i INFO: Call to ListChildrenAction(/BSI_MSCRM, False).

    webserver!ReportServer_0-5!27d0!10/26/2017-03:24:20:: i INFO: Processed folder '/BSI_MSCRM'

    wcfruntime!ReportServer_0-5!27d0!10/26/2017-03:24:22:: i INFO: Entering ExeuteCommand - Command = ListChildren

    library!ReportServer_0-5!27d0!10/26/2017-03:24:22:: i INFO: Call to ListParentsAction(/BSI_MSCRM/CustomReports).

    library!ReportServer_0-5!27d0!10/26/2017-03:24:22:: i INFO: Call to ListChildrenAction(/BSI_MSCRM/CustomReports, False).

    webserver!ReportServer_0-5!27d0!10/26/2017-03:24:22:: i INFO: Processed folder '/BSI_MSCRM/CustomReports'

    wcfruntime!ReportServer_0-5!27d0!10/26/2017-03:24:31:: i INFO: Entering ExeuteCommand - Command = StyleSheet

    library!ReportServer_0-5!328c!10/26/2017-03:24:46:: i INFO: RenderForNewSession('/BSI_MSCRM/CustomReports/{3ebc58bc-0d15-e711-8100-00155d007505}')

    processing!ReportServer_0-5!328c!10/26/2017-03:24:47:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source '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).

  • Suggested answer
    JayeshAC Profile Picture
    JayeshAC 1,157 on at
    RE: ms crm 2013 fetchxml reports are not working

    check this link as well:

    social.msdn.microsoft.com/.../an-error-has-occurred-during-report-processing-rsprocessingaborted

  • Verified answer
    JayeshAC Profile Picture
    JayeshAC 1,157 on at
    RE: ms crm 2013 fetchxml reports are not working

    Its a generic error message.

    Try to Enable Remote Errors. check below link to know more on enabling remote errors.

    docs.microsoft.com/.../enable-remote-errors-reporting-services

    Or check the Report Server error logs to get more details about the error.

    You can find Report logs at:

    %programfiles%\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles\

    Also connect Data Source user to the database and run any code/stored procedures that the report is using with the same parameters you're using when running the report, and see if any errors occur.

    Reference link: stackoverflow.com/.../cannot-create-a-connection-to-data-source-error-rserroropeningconnection-in-ss

    Also check the below IE settings

    Enable Internet Explorer to run components signed with Authenticode.

       1. Open Internet Explorer

       2. Click the menu Tools

       3. Click Internet options

       4. Click Security tab

       5. Select Trusted sites zone

       6. Click Custom Level

       7. Check the item Run components signed with Authenticode

       8. Select Enable

       9. Click OK to apply

    Hope this helps!!!

    Regards,

    Jayesh

  • Suresh Sorde Profile Picture
    Suresh Sorde 1,075 on at
    RE: ms crm 2013 fetchxml reports are not working

    Thanks again, All the users are facing the issue including user with admin role not able to access reports. Below is the error i am getting during runnig the report from reporting service manager with admin roles

    5670.Report.png

  • Suggested answer
    JayeshAC Profile Picture
    JayeshAC 1,157 on at
    RE: ms crm 2013 fetchxml reports are not working

    Try to run the report with Admin role.

    Also check if you are facing this issue for particular user or for all users.

    Check if proper security roles are assigned to your users.

    Regards,

    Jayesh

  • Suresh Sorde Profile Picture
    Suresh Sorde 1,075 on at
    RE: ms crm 2013 fetchxml reports are not working

    Hi Jayesh,

    Thanks for your reply.

    1. Yes, Report server is running.

    2. Reporting server url is http://mscrm:80/reportserver and in DM its http://mscrm/reportserver.

    In both the link there is difference of port no. ie.. :80.

    3. How can i check user mapping ?

    Thanks

  • Suggested answer
    JayeshAC Profile Picture
    JayeshAC 1,157 on at
    RE: ms crm 2013 fetchxml reports are not working

    Hi,

    Please check the following:

    1. Check that your report server is up and running.

    2. Configure reporting server URL Properly. You can confirm it by checking the Reporting server URL of existing organizations available in Deployment manager.

    3. Check the user mapping in your org.

    Regards,

    Jayesh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans