Microsoft Dynamics AX (Archived)

Query/Dataprovider not visible in VS

(0) Share

Report

Posted on by Gerard

195

Hi All,

AX2012R2

VS2010 SP1

W2008

All running on the same AOS server

Database is on another server

I'm having a major difficulty with the Queries and dataproviders in VS2010. I'm not sure anymore if I'm doing something wrong, overlooking something, or maybe there is something wrong in the setup ?

There are a number of instructions on the internet on how to do this. For example: http://msdn.microsoft.com/en-us/library/cc636713.aspx. I've gone over this (and other manuals) a number of times, Issue stays.

I create a Query in AX

I go to VS

Start new project

Add Report

Add Dataset

Use the button to select a Query -> The Queries I created are not visible. Although they are visible in the AOT in VS !!! I'm also able to publish from VS to AX. So one would think that the link AX-VS is working OK.

Exactly the same happens when I use a DataProvider class. I see them in the VS-AOT, but I'm not able to select them as a dataset for my report. One of the tests I've done was a simple copy of the salesInvoiceDP class; rename it and see if I can add it, which was not the case. But also with classes build from scratch.

Has anyone evere expirienced this ? Any thoughts/ideas in where I should look for the sollution ?

Thanks for your time !

Regards,

Gerard

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Gerard 195 on at

Like (0)

Report

More info:

I just discovered that this is working as expected on other accounts..... The account where it is working has the same permissions as the one where it is not working..... On NT and AX level.

I will not spent a lot of time on trying to find out why the others arn't working. But is I stumble upon something I will surely post it here. And if someone has a suggestion: Please let me know.

Thanks,

Gerard

Was this reply helpful? Yes No
Syed Zeeshan Haider... 725 on at

Like (0)

Report

Is there multiple configuration of AX in the system?

Regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi All,

I have the same problem as Gerard.

I don't have any configuration setted up on my system; i just connect to ax via a shortcut pointing on

'"C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin\Ax32.exe" C:\AX2012-param\TEX_AX2012_CLI_DEV_CUS.axc

and visual studio is pointing on "C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe" /AxConfig "C:\AX2012-param\TEX_AX2012_CLI_DEV_CUS.axc"

Any idea is welcome.

Best regards,

Thierry

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Gerard

Did you found a solution for this problem?

I'm encountering the same behaviour.

It would be nice to have it fixed!

Thanks for your answer

Hans-Peter

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I solved the problem from a while but as far as i remember, I just reinstalled AX component for VS trough the AX setup.

Regards,

Thierry

Was this reply helpful? Yes No
udaY-ch 5,133 on at

Like (1)

Report

Hello Gerard,

Just try refreshing the Client Configuration by

AxCliCfg-->Connection(Choose the right AOS)-->Refresh Configuration.

kindly share your experience.

Thanks,

Udhaya Chandran R

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Thierry

I fixed this by reinstalling AX Client. But in any case, I will have to look deeper in this matter. I did not yet understand the interaction between the AX Client configuration and VS.

Regards, Hans-Peter

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I think it's just a problem of dll upgrade

Regards,

Thierry

Was this reply helpful? Yes No
Kurt Warner 157 on at

Like (0)

Report

The solution is to run VS from the command line "As administrator" with command like (making sure the axc points to your instance).

"C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\devenv.exe" /AxConfig "C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies\Microsoft.Dynamics.AX.ReportConfiguration.axc"

Was this reply helpful? Yes No
Hajish 460 on at

Like (0)

Report

Are you using aos load balancer?

Was this reply helpful? Yes No