Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX forum / Query Service Not full...
Microsoft Dynamics AX forum
Unanswered

Query Service Not fully loading

(0) ShareShare
ReportReport
Posted on by Community member 2
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
Categories:
Other
Administration and Setup
  • Community member Profile Picture
    Community member 2 on at
    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 Profile Picture
    Kevin Xia Microsoft Employee on at
    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans