Issue in opening reports its data in SQL SEERVER

Question

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.
    

BRs,

Lafi

Answer 1

Hello

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.

https://learn.microsoft.com/en-us/sql/reporting-services/report-server/enable-remote-errors-reporting-services?view=sql-server-ver16

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