AIF ODATA query service access outside the server

(0) Share

Report

Posted on by Community Member

Hi guys,

Maybe you know about this nice (i'd say a bit hidden) feature in AX 2012 AIF framework. If not, I recommend to read this blog post: OData Query Service

SO, I have created a very simple Query in AOT, activated it as Document data source under Organization Administration > Setup > Document management > Document data sources, and then opened this URL in Internet Explorer directly on the server:

http://MYSERVER:8101/DynamicsAx/Services/ODataQueryService/InventOnHandUCT

And I am getting the data back. Looks good. It doesn't even ask me for credentials.

However, when I try to open the URL from another machine, I am being prompted for credentials (looks like basic HTTP authentication or forms authentication), I am getting the error HTTP 400 Bad request.

There is no firewall between the machines
I am using same credentials
In the event log on the server, I am getting following info message:
Object Server 01: RPC error: RPC exception 1702 occurred in session 20 process is Ax32Serv.exe thread is 22496(User: wpross, ClientType: Worker)

Thanks for your help!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Iulian Cordobin 8,201 on at

Like (0)

Report
Copy link

Link copied!

I would assume the second machine you are trying to connect from is in the same (sub)network. You should try to add in Internet Explorer your AOS's name (or IP) to the list of Security -> Local intranet sites (using the Advanced button, and while disabling the Automatically detect).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Iulian. Unfortunately this didn't help. I will post the resolution separately.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi all. I resolved th problem by changing the authentication of the binding name="ODataQueryServiceBinding" in Ax32Serv.exe.config to basic.

Similar to this:

blogs.msdn.microsoft.com/.../how-to-implement-basic-authentication-with-dynamics-ax-2012-web-services

Was this reply helpful? Yes No
Suggested answer

_MGP 506 on at

Like (0)

Report
Copy link

Link copied!

OK for the benefit of other users... I did try the binding changes suggested in this post and although it worked via IE on remote PCs, it then didn't work to call the data via PowerPivot so I ended up changing them back.

However, changing the server name for the IP address worked for me as per this other post on the same topic.

https://community.dynamics.com/ax/f/33/t/162045

Was this reply helpful? Yes No