Issue in opening reports its data in SQL SEERVER

Lafi Al-Mutairi 0 Reputation points

Dear Microsoft ,

While trying to open the reports in SAP cotact center , the reports are not opening , the data stored in Microsoft SQL Server , as shown below :

  • An error has occurred during report processing. (rsProcessingAborted)
    • Query execution failed for dataset 'WDU_2005_OLAP'. (rsErrorExecutingCommand)
          - For more information about this error navigate to the report server on the local server machine, or enable remote errors.



Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,401 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Limitless Technology 41,586 Reputation points


    Thank you for your question and reaching out.

    To check exact error please check log files or enable Remote errors.

    Please check logs log files on the SSRS server for more detail. They'll be somewhere like: "C:\Program Files (x86)\Microsoft SQL Server\MSRS10_50.DEV\Reporting Services\LogFiles\

    Also : Enable Remote errors for a Reporting Services Service Application

    For a SharePoint mode report server installed with SQL Server 2012 (11.x) or a newer version of Reporting Services, enable the service application setting Enable remote errors. The setting can be configured for each Reporting Services service application.

    In SharePoint Central Administration, click Manage service applications in the Application Management group.

    Find your Reporting Services service application and click the name of your service application.

    Click System Settings.

    Click Enable Remote Errors in the Security section.

    Click OK.

    --If the reply is helpful, please Upvote and Accept as answer--

    0 comments No comments