web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Report Service working...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Report Service working on a single AOS

(0) ShareShare
ReportReport
Posted on by zero00roma 37

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 ?

I have the same question (0)
  • Suggested answer
    Jay Barot Profile Picture
    Jay Barot 1,502 on at

    Hi,

    Please go to system administrator >> setup >> Reporting Services >> Report Servers >> Create 2 new records for remaining AOS servers as same as current one. >> Validate settings.

    Do as above and check.

  • zero00roma Profile Picture
    zero00roma 37 on at

    thanks a lot for your replay, but what about this option (default configuration check box)

    do i need to uncheck or check all profile as a default or what ?

  • Suggested answer
    Jay Barot Profile Picture
    Jay Barot 1,502 on at

    It will not  create any issue if You have ticked default configuration for all.

  • zero00roma Profile Picture
    zero00roma 37 on at

    i still getting this error on the main AOS:

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

    and on other servers after creating new profiles:

    (Parameter _reportName cannot be null or empty.)

    (The AssetBasisRdlContract.getAttributes() reflection API could not create and return the SrsReportNameAttribute object. Please check the parameters.)

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at

    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.

  • zero00roma Profile Picture
    zero00roma 37 on at

    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>

  • nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at

    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.

  • Suggested answer
    Jay Barot Profile Picture
    Jay Barot 1,502 on at

    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.

  • zero00roma Profile Picture
    zero00roma 37 on at

    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 Profile Picture
    Jay Barot 1,502 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans