Query Service Not fully loading

(0) Share

Report

Posted on by Community member

Hello!

We notice quite frequently when restarting our AOS's that the query service pages will not /load/ completely. For example the XML at AOSDNS:8101/dynamicsax/services/queryservice?xsd=xsd8 will only show a handful of lines vs what is typically 1000+ lines. To resolve the issue, we restart the AOS. Recently we had the page stop working out of the blue not related to any specific AOS service restart.

Was hoping someone might be able to provide insights to this functionality and why might be causing it to crash or fail to fully load in the first place.

Thanks!
Ben

All responses (2)

Answers (0)

Community member 2 on at

Like (0)

Report

Query Service Not fully loading

There is not an error, but I can share out troubleshooting steps. It happens regularly enough that we have automated checking for it.
To do it manually we open a browser window and browse to the query service page
http://AOS:8101/dynamicsax/services/queryservice?xsd=xsd8
A fully functioning AOS will load an XML file with all of our functions and their details. For example:

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://schemas.datacontract.org/2004/07/XppClasses" elementFormDefault="qualified" targetNamespace="http://schemas.datacontract.org/2004/07/XppClasses">
<xs:import schemaLocation="http://AOS:8101/DynamicsAx/Services/QueryService?xsd=xsd4" namespace="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/>
<xs:import schemaLocation="http://AOS:8101/DynamicsAx/Services/QueryService?xsd=xsd7" namespace="http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.AX.Framework.Services.QueryService"/>
<xs:complexType name="KanbanOverviewQueryBuilderArgs">
<xs:complexContent mixed="false">
<xs:extension xmlns:q1="http://schemas.datacontract.org/2004/07/Microsoft.Dynamics.AX.Framework.Services.QueryService" base="q1:QueryBuilderArgs">
<xs:sequence>
<xs:element minOccurs="0" name="parmActiveDateTime" type="xs:dateTime"/>
<xs:element xmlns:q2="http://schemas.microsoft.com/2003/10/Serialization/Arrays" minOccurs="0" name="parmQueryArgs" nillable="true" type="q2:ArrayOfanyType"/>
</xs:sequence>
</xs:extension>
</xs:complexContent>
</xs:complexType>
<xs:element name="KanbanOverviewQueryBuilderArgs" nillable="true" type="tns:KanbanOverviewQueryBuilderArgs"/>

This is repeated for each function and in total ours is approximately 16k lines.

When it fails to work the page still loads but the XML contains no functions and instead looks like this:

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://schemas.microsoft.com/Message" elementFormDefault="qualified" targetNamespace="http://schemas.microsoft.com/Message">
<xs:simpleType name="StreamBody">
<xs:restriction base="xs:base64Binary"/>
</xs:simpleType>
</xs:schema>

We typically see this during AOS startup but occasionally this page will “crash” and we get the “short” XML out of the blue.

To automate checking this we run PowerShell to count the lines of the XML file and report back anytime the number of lines is “Short”

Hopefully that helps please let me know if you need further details.
Kevin Xia Microsoft Employee on at

Like (0)

Report

Query Service Not fully loading

Hi,

You can provide us with more information, such as your steps or screenshots, to help us better resolve the issue for you. At this time, the information you provide is not sufficient for us to determine what the problem is.

Best regards,

Kevin