Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Unable to add dataset to a SSRS Report.

Posted on by Microsoft Employee

Hi ,

I have installed the VS 2013 version recently in my local machine and connected to one of my dev server. When I am trying to add a dataset and select a query class I am getting a weird error.  "Exception occurred on the metadata service on client or server. See exception details below > Unable to log on to Microsoft Dynamics AX"

8473.Error1.png

Attached the screen shot of it.

And below is more details from the log.

Unable to get version information using existing WCF configuration from local storage.

 

Exception details:

Microsoft.Dynamics.AX.Framework.Services.Client.MetadataServiceException: Exception occurred on the metadata service on client or server. See exception details below:

>Unable to log on to Microsoft Dynamics AX. ---> System.ServiceModel.FaultException: Unable to log on to Microsoft Dynamics AX.

 

Server stack trace:

   at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)

   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)

   at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)

   at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

I tried the below things, to get rid of this error. But no luck.

1) I created a new axc config and refreshed the WXF configs multiple times.

2) I am a local admin to the SSRS server and have full access to the reporting folder. Able to validate the settings too.

And when I try to deploy any standard reports from my VS, the VS is crashing. Below is the logs 

Faulting application name: devenv.exe, version: 12.0.40629.0, time stamp: 0x5590c8a4

Faulting module name: MSVCR120_CLR0400.dll, version: 12.0.52519.0, time stamp: 0x5849f912

Exception code: 0xc00000fd

Fault offset: 0x0007e22c

Faulting process id: 0x2aa4

Faulting application start time: 0x01d46fc730e57706

Faulting application path: C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\devenv.exe

Faulting module path: C:\WINDOWS\SYSTEM32\MSVCR120_CLR0400.dll

Report Id: 259ae06b-5c94-4b7a-808c-72385ac8b408

Faulting package full name:

Faulting package-relative application ID:

Thanks in advance.

*This post is locked for comments

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Unable to add dataset to a SSRS Report.

    You should always run the AX client and Visual Studio with elevated rights, otherwise it may cause issues. Again, give it a try by temporarily granting you local admin rights and see if the issue is fixed if it is running in elevated mode.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to add dataset to a SSRS Report.

    Unfortunately that didn't work.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to add dataset to a SSRS Report.

    Hi Vilmos,

    I am not a local admin to my machine. But I am a local admin to the reporting server and AX sys admin.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to add dataset to a SSRS Report.

    Looks the error is just specifying the location of VS , not the target path nor AOS config I believe.

    The target path is pointing to correct AOS, when I open my VS through start menu I am able to connect to correct AOS. But When I open the VS from the file location I am unable to connect to

    AOS.

    Is that a issue ?

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Unable to add dataset to a SSRS Report.

    Make sure you are running VS with elevated rights (it should read Administrator on the window title).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to add dataset to a SSRS Report.

    Hi Crispin,

    I have configured the VS target path correctly, I am able to connect to specific AOS. But as per your statement it looks like something might referring incorrectly. Could you please help me with diagnoses the problem?

    Raghu

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to add dataset to a SSRS Report.

    Hi Vilmos,

    Yes I have created configuration pointing to the correct instance both in Local client and Business connector and refreshed both the WCF services. 

    And the code is error free and successfully generated full CIL.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans