1
During SSRS extension installation, the config file only connects to one AOS Server. SSRS working based on WCF service for query/metadata service. Because of this if the AOS server which is defined in SSRS configuration is down then the reports are not printing.
We have tried adding multiple AOS instance in the client configuration in the reporting server and shut down first AOS. Tried to run the report found following exception:
webserver!ReportServer_0-6!5ab0!06/13/2018-21:02:52:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'CustListReportDS'. ---> Microsoft.Dynamics.AX.Framework.Services.Client.QueryServiceException: Could not connect to net.tcp://dax2012r3:8201/DynamicsAx/Services/QueryService. The connection attempt lasted for a time span of 00:00:02.0162012. TCP error code 10061: No connection could be made because the target machine actively refused it 192.168.2.50:8201. ---> System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://dax2012r3:8201/DynamicsAx/Services/QueryService. The connection attempt lasted for a time span of 00:00:02.0162012. TCP error code 10061: No connection could be made because the target machine actively refused it 192.168.2.50:8201. ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 192.168.2.50:8201
Based above error, we can see even we setup multiple AOS in config file, it doesn't help in this case. The query service still connects to first AOS server defined during SSRS installation. The report server configuration in ax which is used for the load balancing while the report logic executes (X++ logic). So if we will add multiple report server configuration for each AOS will not help in this case.
Customers would like to have this ability to switch the AOS server if the AOS server defined during reporting configuration is down.
We have tried adding multiple AOS instance in the client configuration in the reporting server and shut down first AOS. Tried to run the report found following exception:
webserver!ReportServer_0-6!5ab0!06/13/2018-21:02:52:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'CustListReportDS'. ---> Microsoft.Dynamics.AX.Framework.Services.Client.QueryServiceException: Could not connect to net.tcp://dax2012r3:8201/DynamicsAx/Services/QueryService. The connection attempt lasted for a time span of 00:00:02.0162012. TCP error code 10061: No connection could be made because the target machine actively refused it 192.168.2.50:8201. ---> System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://dax2012r3:8201/DynamicsAx/Services/QueryService. The connection attempt lasted for a time span of 00:00:02.0162012. TCP error code 10061: No connection could be made because the target machine actively refused it 192.168.2.50:8201. ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 192.168.2.50:8201
Based above error, we can see even we setup multiple AOS in config file, it doesn't help in this case. The query service still connects to first AOS server defined during SSRS installation. The report server configuration in ax which is used for the load balancing while the report logic executes (X++ logic). So if we will add multiple report server configuration for each AOS will not help in this case.
Customers would like to have this ability to switch the AOS server if the AOS server defined during reporting configuration is down.
STATUS DETAILS
Needs Votes