Finance | Project Operations, Human Resources, ...

Report Service working on a single AOS

(0) Share

Report

Posted on by zero00roma

i have 3 AOS instances and my report service working with just one of them, so if any user connect to other instance report service will not work, so how to allow 3 of them to provide report service ?

All responses (14)

Answers (0)

nmaenpaa 101,156 on at

Like (0)

Report

RE: Report Service working on a single AOS

Did you try to follow the suggestion in the error message? In general if you get a message that instructs you how to get more information, it's a good idea to try it.
zero00roma 37 on at

Like (0)

Report

RE: Report Service working on a single AOS

thanks for your reply, but after all this steps ( docs.microsoft.com/.../create-a-new-microsoft-dynamics-ax-configuration)i am facing a new error:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

The request failed with the error message:

--

<!DOCTYPE html>

<html>

<head>

<title>Runtime Error</title>

<meta name="viewport" content="width=device-width" />

<style>

body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}

p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}

b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}

H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }

H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }

pre {font-family:"Consolas","Lucida Console",Monospace;font-size:11pt;margin:0;padding:0.5em;line-height:14pt}

.marker {font-weight: bold; color: black;text-decoration: none;}

.version {color: gray;}

.error {margin-bottom: 10px;}

.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }

@media screen and (max-width: 639px) {

pre { width: 440px; overflow: auto; white-space: pre-wrap; word-wrap: break-word; }

}

@media screen and (max-width: 479px) {

pre { width: 280px; }

}

</style>

</head>

<body bgcolor="white">

<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Runtime Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

<br><br>

<b>Details:</b> To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".<br><br>

<table width=100% bgcolor="#ffffcc">

<tr>

<td>

<code><pre>



<configuration>

<system.web>

<customErrors mode="Off"/>

</system.web>

</configuration></pre></code>

</td>

</tr>

</table>

<br>

<b>Notes:</b> The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.<br><br>

<table width=100% bgcolor="#ffffcc">

<tr>

<td>

<code><pre>



<configuration>

<system.web>

<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>

</system.web>

</configuration></pre></code>

</td>

</tr>

</table>

<br>

</body>

</html>

--.
Suggested answer

Anup Shah MSFT on at

Like (0)

Report

RE: Report Service working on a single AOS

Ensure you have created a new AX configuration file and added it to the report server as per docs.microsoft.com/.../create-a-new-microsoft-dynamics-ax-configuration
zero00roma 37 on at

Like (0)

Report

RE: Report Service working on a single AOS

same error

For more information about this error navigate to the report server on the local server machine, or enable remote errors
Suggested answer

Jay Barot 1,502 on at

Like (0)

Report

RE: Report Service working on a single AOS

After setting up this, have you restarted all you AOS and SSRS service.? If not then please do that to and check.
zero00roma 37 on at

Like (0)

Report

RE: Report Service working on a single AOS

Please make sure that you have ticked default configuration for all the AOS instances:

DONE

please do that and validate settings and check:

DONE

if Reporting Services is running in SharePoint integrated mode:

NO

enter URL of the report folder:

We are not using this option

after all this steps i still face this errors:

(For more information about this error navigate to the report server on the local server machine, or enable remote errors)
Suggested answer

Jay Barot 1,502 on at

Like (0)

Report

RE: Report Service working on a single AOS

Hi,

Please make sure that you have ticked default configuration for all the AOS instances. If not please do that and validate settings and check.

Also please check Select this check box (SharePoint integrated mode), if Reporting Services is running in SharePoint integrated mode. and enter URL of the report folder.
nmaenpaa 101,156 on at

Like (1)

Report

RE: Report Service working on a single AOS

That's much more helpful than the previous message. You could try to search the web for this issue, and also run docs.microsoft.com/.../test-axreportserverconfiguration on the AOS to try to get more information.
zero00roma 37 on at

Like (0)

Report

RE: Report Service working on a single AOS

thanks for your replay

on SSRS server i found this events:

Log Name: Application

Source: Microsoft.Dynamics.AX.Framework.Reports.Shared

Date: 6/28/2020 9:57:25 AM

Event ID: 1000

Task Category: None

Level: Error

Keywords: Classic

User: N/A

Computer: XXXXXX

Description:

AXRDCE The AXRDCE extension caught an unexpected exception for report CustListReport.Report.

The error message was:

A call to the Microsoft Dynamics AX SRSFrameworkService service failed. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 000.000.00.00:8201.

at Microsoft.Dynamics.AX.Framework.Services.Client.ServiceClientHelper.InvokeChannelOperation[TResult,TChannel](IServiceClient`1 client, Func`2 operationInvoker, Func`2 exceptionWrapper)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.SRSFrameworkServiceProxy.Microsoft.Dynamics.AX.Framework.Reporting.Shared.IXppSRSFrameworkService.getRelationLinkTargetList(SRSFrameworkServiceGetRelationLinkTargetListRequest request)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.SRSFrameworkServiceClient.Microsoft.Dynamics.AX.Framework.Reporting.Shared.ISRSFrameworkService.GetRelationLinkTargetList(String tableFieldsListEncodedStr)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.TableFieldMenuItemService.Resolve(String encodedString)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.AutomaticDrillThroughStep.Transform(XDocument report, ILocalReportContext reportContext, ILocalUserContext userContext)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.CustomizationExtensionImplementation.ProcessReportDefinition(Byte[] reportDefinition, ILocalReportContext reportContext, ILocalUserContext userContext, Byte[]& reportDefinitionProcessed)

A call to the Microsoft Dynamics AX SRSFrameworkService service failed. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 000.000.00.22:8201.

Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportException

at Microsoft.Dynamics.AX.Framework.Services.Client.ServiceClientHelper.InvokeChannelOperation[TResult,TChannel](IServiceClient`1 client, Func`2 operationInvoker, Func`2 exceptionWrapper)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.SRSFrameworkServiceProxy.Microsoft.Dynamics.AX.Framework.Reporting.Shared.IXppSRSFrameworkService.getRelationLinkTargetList(SRSFrameworkServiceGetRelationLinkTargetListRequest request)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.SRSFrameworkServiceClient.Microsoft.Dynamics.AX.Framework.Reporting.Shared.ISRSFrameworkService.GetRelationLinkTargetList(String tableFieldsListEncodedStr)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.TableFieldMenuItemService.Resolve(String encodedString)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.AutomaticDrillThroughStep.Transform(XDocument report, ILocalReportContext reportContext, ILocalUserContext userContext)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.CustomizationExtensionImplementation.ProcessReportDefinition(Byte[] reportDefinition, ILocalReportContext reportContext, ILocalUserContext userContext, Byte[]& reportDefinitionProcessed)

Event Xml:

<Event xmlns="schemas.microsoft.com/.../event">

<System>

<Provider Name="Microsoft.Dynamics.AX.Framework.Reports.Shared" />

<EventID Qualifiers="0">1000</EventID>

<Level>2</Level>

<Task>0</Task>

<Keywords>0x80000000000000</Keywords>

<TimeCreated SystemTime="2020-06-28T06:57:25.825355600Z" />

<EventRecordID>491645</EventRecordID>

<Channel>Application</Channel>

<Computer>SQL-DBA01.ELFALEH.LOCAL</Computer>

<Security />

</System>

<EventData>

<Data>AXRDCE The AXRDCE extension caught an unexpected exception for report CustListReport.Report.

The error message was:

A call to the Microsoft Dynamics AX SRSFrameworkService service failed. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 000.000.00.22:8201.

at Microsoft.Dynamics.AX.Framework.Services.Client.ServiceClientHelper.InvokeChannelOperation[TResult,TChannel](IServiceClient`1 client, Func`2 operationInvoker, Func`2 exceptionWrapper)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.SRSFrameworkServiceProxy.Microsoft.Dynamics.AX.Framework.Reporting.Shared.IXppSRSFrameworkService.getRelationLinkTargetList(SRSFrameworkServiceGetRelationLinkTargetListRequest request)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.SRSFrameworkServiceClient.Microsoft.Dynamics.AX.Framework.Reporting.Shared.ISRSFrameworkService.GetRelationLinkTargetList(String tableFieldsListEncodedStr)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.TableFieldMenuItemService.Resolve(String encodedString)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.AutomaticDrillThroughStep.Transform(XDocument report, ILocalReportContext reportContext, ILocalUserContext userContext)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.CustomizationExtensionImplementation.ProcessReportDefinition(Byte[] reportDefinition, ILocalReportContext reportContext, ILocalUserContext userContext, Byte[]& reportDefinitionProcessed)

A call to the Microsoft Dynamics AX SRSFrameworkService service failed. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 192.168.12.22:8201.

Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportException

at Microsoft.Dynamics.AX.Framework.Services.Client.ServiceClientHelper.InvokeChannelOperation[TResult,TChannel](IServiceClient`1 client, Func`2 operationInvoker, Func`2 exceptionWrapper)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.SRSFrameworkServiceProxy.Microsoft.Dynamics.AX.Framework.Reporting.Shared.IXppSRSFrameworkService.getRelationLinkTargetList(SRSFrameworkServiceGetRelationLinkTargetListRequest request)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.SRSFrameworkServiceClient.Microsoft.Dynamics.AX.Framework.Reporting.Shared.ISRSFrameworkService.GetRelationLinkTargetList(String tableFieldsListEncodedStr)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.TableFieldMenuItemService.Resolve(String encodedString)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.AutomaticDrillThroughStep.Transform(XDocument report, ILocalReportContext reportContext, ILocalUserContext userContext)

at Microsoft.Dynamics.AX.Framework.Reporting.Shared.CustomizationExtensionImplementation.ProcessReportDefinition(Byte[] reportDefinition, ILocalReportContext reportContext, ILocalUserContext userContext, Byte[]& reportDefinitionProcessed)

</Data>

</EventData>

</Event>
Suggested answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: Report Service working on a single AOS

Did you try to what the system instructed: enable remote errors on the SSRS instance or check event log on SSRS server? If not, please start by doing that.