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, ... / Unable to connect to F...
Finance | Project Operations, Human Resources, ...
Suggested answer

Unable to connect to Financial Reporting

(0) ShareShare
ReportReport
Posted on by MARVIN CASTANEDA 35

Hi everyone does any body experience to deploy onprem and it sucessfull but when you open financial report and run the financial report designer cannot connect to server below is the error of my MRBIN server log

Metadata service communication retry attempts failed to resolve issues with the following settings AX7CertificateUserName: FRServiceUser@dynamics.com; AX7CertificateThumbprint: 7F8239989D8FA8A4215DDD49C284CF5A7EB4E65F; AX7FederationRealm: spn:00000015-0000-0000-c000-000000000000; AX7ProviderName: mintedtoken.dynamics.com; AX7TokenIssuer: fakeacs.accesscontrol.windows.net/
Component: Microsoft.Dynamics.Integration.Common.TraceLog
User: KWPOLYMER\svc-frps$
Machine: MRBIN1

Categories:
Management Reporter
  • imokhtar Profile Picture
    imokhtar on at
    RE: Unable to connect to Financial Reporting

    can you please check in your SQL AX database

    Select ID, SID, NETWORKALIAS
    from UserInfo
    where ID='FRServiceUser'
    it should return a value , if it is not equal to S-1-19-1241925437-3719476898-4060767950-17831512-2104045269-3825046075-1325424976-928167439-1769986175-660289321
    you will need to run the below script to update the right value

    update USERINFO set SID = 'S-1-19-1241925437-3719476898-4060767950-17831512-2104045269-3825046075-1325424976-928167439-1769986175-660289321' where ID = 'FRServiceUser'

    pastedimage1585648692903v1.png

  • MARVIN CASTANEDA Profile Picture
    MARVIN CASTANEDA 35 on at
    RE: Unable to connect to Financial Reporting

    Hi everyone this is an On-Prem Deployment

  • MARVIN CASTANEDA Profile Picture
    MARVIN CASTANEDA 35 on at
    RE: Unable to connect to Financial Reporting

    Hi Sir no i cannot access the site

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,010 on at
    RE: Unable to connect to Financial Reporting

    if possible try installing and use the service principal account on local machine

    last resort could be opening support ticket

  • MARVIN CASTANEDA Profile Picture
    MARVIN CASTANEDA 35 on at
    RE: Unable to connect to Financial Reporting

    Hi Sir Rahul i run this command and get this error

    PS C:\Files> .\RegisterETW.ps1 -ManifestsAndDll @{"\\AOS1\agent\wp\MYMDC-KP\StandaloneSetup-424560\Apps\ETWManifests\Microsoft.Dynamics.Reporting.Instrumentation.man" = "\\AOS1\agent\wp\MYMDC-KP\StandaloneSetup-424560\Apps\ETW

    Manifests\Microsoft.Dynamics.Reporting.Instrumentation.dll"}

    Starting RegisterETW script.

    De-duplicating files and adding search folders.

    Adding search folder \\AOS1\agent\wp\MYMDC-KP\StandaloneSetup-424560\Apps\ETWManifests

    Unregistering ETW manifest Microsoft.PowerShell.Core\FileSystem::\\AOS1\agent\wp\MYMDC-KP\StandaloneSetup-424560\Apps\ETWManifests\Microsoft.Dynamics.Reporting.Instrumentation.man

    Microsoft.PowerShell.Core\FileSystem::\\AOS1\agent\wp\MYMDC-KP\StandaloneSetup-424560\Apps\ETWManifests\Microsoft.Dynamics.Reporting.Instrumentation.man(0): Error 0x8007007b: At column=0, The filename, directory name, or volum

    e label syntax is incorrect.

    Failed to load xml document Microsoft.PowerShell.Core\FileSystem::\\AOS1\agent\wp\MYMDC-KP\StandaloneSetup-424560\Apps\ETWManifests\Microsoft.Dynamics.Reporting.Instrumentation.man. Incorrect function.

    Registering ETW Manifest Microsoft.PowerShell.Core\FileSystem::\\AOS1\agent\wp\MYMDC-KP\StandaloneSetup-424560\Apps\ETWManifests\Microsoft.Dynamics.Reporting.Instrumentation.man with Microsoft.PowerShell.Core\FileSystem::\\AOS

    1\agent\wp\MYMDC-KP\StandaloneSetup-424560\Apps\ETWManifests\Microsoft.Dynamics.Reporting.Instrumentation.dll

    Microsoft.PowerShell.Core\FileSystem::\\AOS1\agent\wp\MYMDC-KP\StandaloneSetup-424560\Apps\ETWManifests\Microsoft.Dynamics.Reporting.Instrumentation.man(0): Error 0x8007007b: At column=0, The filename, directory name, or volum

    e label syntax is incorrect.

    Failed to load xml document Microsoft.PowerShell.Core\FileSystem::\\AOS1\agent\wp\MYMDC-KP\StandaloneSetup-424560\Apps\ETWManifests\Microsoft.Dynamics.Reporting.Instrumentation.man. Incorrect function.

           Enabling channel Microsoft-Dynamics-MR-Sql/Admin

    Failed to read configuration for log Microsoft-Dynamics-MR-Sql/Admin. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Sql/Operational

    Failed to read configuration for log Microsoft-Dynamics-MR-Sql/Operational. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Sql/Analytic

    Failed to read configuration for log Microsoft-Dynamics-MR-Sql/Analytic. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Sql/Debug

    Failed to read configuration for log Microsoft-Dynamics-MR-Sql/Debug. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Client/Admin

    Failed to read configuration for log Microsoft-Dynamics-MR-Client/Admin. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Client/Operational

    Failed to read configuration for log Microsoft-Dynamics-MR-Client/Operational. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Client/Analytic

    Failed to read configuration for log Microsoft-Dynamics-MR-Client/Analytic. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Client/Debug

    Failed to read configuration for log Microsoft-Dynamics-MR-Client/Debug. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Logger/Admin

    Failed to read configuration for log Microsoft-Dynamics-MR-Logger/Admin. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Logger/Operational

    Failed to read configuration for log Microsoft-Dynamics-MR-Logger/Operational. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Logger/Analytic

    Failed to read configuration for log Microsoft-Dynamics-MR-Logger/Analytic. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Logger/Debug

    Failed to read configuration for log Microsoft-Dynamics-MR-Logger/Debug. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-TraceManager/Admin

    Failed to read configuration for log Microsoft-Dynamics-MR-TraceManager/Admin. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-TraceManager/Operational

    Failed to read configuration for log Microsoft-Dynamics-MR-TraceManager/Operational. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-TraceManager/Analytic

    Failed to read configuration for log Microsoft-Dynamics-MR-TraceManager/Analytic. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-TraceManager/Debug

    Failed to read configuration for log Microsoft-Dynamics-MR-TraceManager/Debug. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-SchedulerTasks/Admin

    Failed to read configuration for log Microsoft-Dynamics-MR-SchedulerTasks/Admin. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-SchedulerTasks/Operational

    Failed to read configuration for log Microsoft-Dynamics-MR-SchedulerTasks/Operational. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-SchedulerTasks/Analytic

    Failed to read configuration for log Microsoft-Dynamics-MR-SchedulerTasks/Analytic. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-SchedulerTasks/Debug

    Failed to read configuration for log Microsoft-Dynamics-MR-SchedulerTasks/Debug. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Integration/Admin

    Failed to read configuration for log Microsoft-Dynamics-MR-Integration/Admin. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Integration/Operational

    Failed to read configuration for log Microsoft-Dynamics-MR-Integration/Operational. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Integration/Analytic

    Failed to read configuration for log Microsoft-Dynamics-MR-Integration/Analytic. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Integration/Debug

    Failed to read configuration for log Microsoft-Dynamics-MR-Integration/Debug. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Reporting/Admin

    Failed to read configuration for log Microsoft-Dynamics-MR-Reporting/Admin. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Reporting/Operational

    Failed to read configuration for log Microsoft-Dynamics-MR-Reporting/Operational. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Reporting/Analytic

    Failed to read configuration for log Microsoft-Dynamics-MR-Reporting/Analytic. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Reporting/Debug

    Failed to read configuration for log Microsoft-Dynamics-MR-Reporting/Debug. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-DVT/Admin

    Failed to read configuration for log Microsoft-Dynamics-MR-DVT/Admin. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-DVT/Operational

    Failed to read configuration for log Microsoft-Dynamics-MR-DVT/Operational. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-DVT/Analytic

    Failed to read configuration for log Microsoft-Dynamics-MR-DVT/Analytic. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-DVT/Debug

    Failed to read configuration for log Microsoft-Dynamics-MR-DVT/Debug. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Provider/Admin

    Failed to read configuration for log Microsoft-Dynamics-MR-Provider/Admin. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Provider/Operational

    Failed to read configuration for log Microsoft-Dynamics-MR-Provider/Operational. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Provider/Analytic

    Failed to read configuration for log Microsoft-Dynamics-MR-Provider/Analytic. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Provider/Debug

    Failed to read configuration for log Microsoft-Dynamics-MR-Provider/Debug. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Owin/Admin

    Failed to read configuration for log Microsoft-Dynamics-MR-Owin/Admin. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Owin/Operational

    Failed to read configuration for log Microsoft-Dynamics-MR-Owin/Operational. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Owin/Analytic

    Failed to read configuration for log Microsoft-Dynamics-MR-Owin/Analytic. The specified channel could not be found. Check channel configuration.

           Enabling channel Microsoft-Dynamics-MR-Owin/Debug

    Failed to read configuration for log Microsoft-Dynamics-MR-Owin/Debug. The specified channel could not be found. Check channel configuration.

    Completed RegisterETW script.

    Thanks

  • imokhtar Profile Picture
    imokhtar on at
    RE: Unable to connect to Financial Reporting

    can you please try to open the metadata URL https:/<your environment link>/services/MetadataService

    is it open like this or gives an error

    pastedimage1585647057619v1.png

  • MARVIN CASTANEDA Profile Picture
    MARVIN CASTANEDA 35 on at
    RE: Unable to connect to Financial Reporting

    Hi Sir Ibrahim

    FRserviceUser is Enable as per your instruction but still no luck

  • Suggested answer
    imokhtar Profile Picture
    imokhtar on at
    RE: Unable to connect to Financial Reporting

    Basic things:

    1. Make sure FRServiceUser is Enabled in D365O under System administration | Users | Users

                a- In Users go to:

     

                             pastedimage1585604010840v6.png

                       b- Change "Criteria" from "False" to "True"

                              pastedimage1585604070162v7.png

                   c- Search for user.

                              pastedimage1585604101763v8.png

                          d- Edit and enable to user if needed.

                           e- Change settings back to FALSE

                                pastedimage1585604149843v9.png

     

     

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,010 on at
    RE: Unable to connect to Financial Reporting

    was provider registered?

    .\RegisterETW.ps1 -ManifestsAndDll @{"C:\Files\ETWManifest\Microsoft.Dynamics.Reporting.Instrumentation.man" = "C:\Files\ETWManifest\Microsoft.Dynamics.Reporting.Instrumentation.dll"}

    link for more details

    https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/deployment/troubleshoot-on-prem

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

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

Last month Overall leaderboard

Featured topics

Test Comment 26-09-2024 16:14pm

Product updates

Dynamics 365 release plans