Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Labels not shown when ...
Finance | Project Operations, Human Resources, ...
Answered

Labels not shown when opening any SSRS Report in AX2012 after AOS reinstall

(0) ShareShare
ReportReport
Posted on by CBNestor 44

Hello all.

I needed to reinstall our AOS-01 (the one connected to SSRS) because was conflicting with another testing environment in our organization with the same TCP/IP 2712 | WSDL 8201 ports.

So I successfully uninstalled and installed the AOS01 with new ports (e.g 2717 , 8207) using the same database that was before.

After installed, I open the client again but when I want to see any report it pops up an error with: "No connection could be made because the target machine actively refused it ip xxx.xxx.xxx.xxx:8201"

So I look on the internet about a workaround and made a AX Client configuration with the new ports and pasted in the SSRS folder:  MSRS13.MSSQLSERVER\Reporting Services\ReportServer\bin\Microsoft.Dynamics.AX.ReportConfiguration.axc

now all the reports are opening but the labels are not being translated to the correct language: 

Full CIL has been made. What else am I missing?

pastedimage1619519865550v1.png

  • Suggested answer
    CBNestor Profile Picture
    CBNestor 44 on at
    RE: Labels not shown when opening any SSRS Report in AX2012 after AOS reinstall

    Hi Kevin,

    Finally the problem is fixed.

    I still don't know why the labels where showing before reinstalling the AOS. But I Install the "Foundation Labes" model that comes in the AX setup installation folder . made synchronizations and everything is working now.

    I will give you the credit for supporting me all the way.

    Thanks a lot for your time!

  • CBNestor Profile Picture
    CBNestor 44 on at
    RE: Labels not shown when opening any SSRS Report in AX2012 after AOS reinstall

    Hi Kevin,

    When looking on the Label Files in AOT I see I am missing almost all lenguages exept for the en-US

    almost all companies are set to EN-GB. So when I create a new order the report is taking the EN-GB labels which are not installed thats why is showing the @SYS. Which is strange because it was working before reinstalling the AOS.

    I have made a test with a purchase confirmation to a purchse order set to en-Us and is working. Showing = "Purchase Order"

    and when looking on the Models installed It says they are installed. 

    any Idea?.

    pastedimage1620999979641v2.png

  • zhifeng Profile Picture
    zhifeng on at
    RE: Labels not shown when opening any SSRS Report in AX2012 after AOS reinstall

    I would suggest raise a ticket to MS so that we can help on this.

  • CBNestor Profile Picture
    CBNestor 44 on at
    RE: Labels not shown when opening any SSRS Report in AX2012 after AOS reinstall

    Hi Kevin,

    I realized that the client configuration target "Business connector" and Configuration:"DebugNotInOption" was pointing to a wrong Instance Name.

    Now I have changed it to be blank (since it is optional) . saved the client configuration again in the MSRS13 folder. Opened the AX client again-> but reports are still showing the @sys labels :(

    **History**

    Original AOS-01 on server Srv01:

    TCP/IP : 2712

    WSDL: 8101

    After Reinstall AOS-01 on same server Srv01:

    Tcp/Ip: 2717

    WSDL: 8107

    opened any ssrs report and error shows up with: "No connection could be made because the target machine actively refused it ip xxx.xxx.xxx.xxx:8201"

    later I copied the client configuration to the Srs installation folder:

    MSRS13.MSSQLSERVER\Reporting Services\ReportServer\bin\Microsoft.Dynamics.AX.ReportConfiguration.axc

    Now:

    all reports are opening. but labels are not showing correctly.

    did I miss any configuration?

  • zhifeng Profile Picture
    zhifeng on at
    RE: Labels not shown when opening any SSRS Report in AX2012 after AOS reinstall

    Does SSRS point to new AOS server? And does AX client configuration(business connector) point to new AOS with correct port? 

  • CBNestor Profile Picture
    CBNestor 44 on at
    RE: Labels not shown when opening any SSRS Report in AX2012 after AOS reinstall

    Hi Kevin,

    Thanks for your kind reply,

    I follow all those steps but still not working. unfortunately it is still the same

    I just want to remind that this happened after reinstalling the AOS with different port Numbers than the ports used originally when the SRSS was installed.

    Some redirection that must be done??

    thanks a lot for your time!

  • Verified answer
    zhifeng Profile Picture
    zhifeng on at
    RE: Labels not shown when opening any SSRS Report in AX2012 after AOS reinstall

    The SSRS Service Account password could be invalid.

    From the Start menu, point to All Programs, click the SQL Server folder, click the Configuration Tools folder, and then click Reporting Services Configuration Manager.

    In Reporting Services Configuration Manager click Connect and then click Service Account.

    Set the password and then click Apply. The account and password should be the same as the Microsoft Dynamics AX proxy account. For more information, see Before you install the Reporting Services extensions.

    Click the ServerName/MSSQLSERVER and then click Stop. Then click Start to restart the server. Always check with the SQL administrator and make sure no other users are connected to the server before you restart the server.

    docs.microsoft.com/.../troubleshooting-report-definition-issues

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans