Microsoft Dynamics 365 Blog

Some time ago we run into the issue when Dynamics report which were based on cubes sudenly stopped working. Ie. CFOProfabilityAnalysis.RoleCenter report was raising following error

“An error has occurred during report processing. (rsProcessingAborted)

      Query execution failed for dataset “Company” (rsErrorExecutingCommand)

         A connection cannot be made.Ensure that the service is running.

              No such host is known”


The problem was that the Data Source which is used by Dynamics SSRS reporting had the connection string which was not correct.

After navigating Report Manager and changing the connection string for DataSource DynamicsAXOLAP to correct on the issue has disappeared.

What probably happened was that during deployment of reports the OLAP database was located on different server, later on the OLAP database was moved to different location and Dynamics SSRS stopped to work

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!