After todays maintenance: Error: Illegal query.Illegal query.

[MagnusHolen]

Hi

A lot of our queries return the error: "Error: Illegal query.Illegal query. " after todays maintenance.

There seem to be certain fields that provoke this error.
An exampe is the runningTotalDomestic field in generalLedgerTransaction:

query VBNxtQuery {

useCompany(no: xxxx) {

generalLedgerTransaction(first: 100) {

totalCount

pageInfo {

hasNextPage

endCursor

}

items {

        voucherJournalNo

        accountNo

        voucherDate

        runningTotalDomestic

}}}}


Returns:
{
"errors": [
{
"message": "Error: Illegal query.Illegal query.",
"extensions": {
"data": {
"status": 1,
"status_name": "IllegalQuery"
}
}
}
],
"data": {
"useCompany": {
"generalLedgerTransaction": {
"totalCount": 22,
"pageInfo": {
"hasNextPage": false,
"endCursor": null
},
"items": null
}
}
},
"extensions": {
"vbnxt-trace-id": "00000000000000009d48c6e3a7e95d99"
}
}

[Arnstein By]

The issue should be fixed now and the GraphQL API should work as before. Nice if you can confirm this, @MagnusHolen and @Sigbjørn Eide.

[MagnusHolen]

Thanks, it works now.

[Sigbjørn Eide]

Looks good in our end now. Thanks!

[Arnstein By]

Preliminary feedback from our developers:

• runningTotalDomestic will not return any data when queried through GraphQL, since it is only populated in reports.
  Hence, the advice is to omit this column from the queries.
• Use of orgUnit12 assumes that organisational unit class 12 is named in company information and will fail if so is not the case.

We will of course continue the work to find a better way of handling this on our side.

[Arnstein By]

We have identified the issue and are working on a solution. We will let you know as soon as we know more.

[Arnstein By]

Hi @MagnusHolen, we have had some issues with GraphQL after deployment this morning, but they should be sorted now. Do you still have problems?

[Sigbjørn Eide]

Still problems in our end as well. Not possible to fetch orders/pickinglists which casuses full stop in the warehouse for our customers. 

Example traceIds:

00000000000000007cea51e194ac0b52

0000000000000000070e93f2dff68fda

[MagnusHolen]

Yes. 

[MagnusHolen]

Another example is orgUnit12 in the associate table:

query VBNxtQuery{

useCompany(no: xxx) {

associate(first: 1000) {

totalCount

pageInfo {

hasNextPage

endCursor

}

items {

associateNo

name

orgUnit12

}

}

}

}

{
"errors": [
{
"message": "Error: Illegal query.Illegal query.",
"extensions": {
"data": {
"status": 1,
"status_name": "IllegalQuery"
}
}
}
],
"data": {
"useCompany": {
"associate": {
"totalCount": 5244,
"pageInfo": {
"hasNextPage": false,
"endCursor": null
},
"items": null
}
}
},
"extensions": {
"vbnxt-trace-id": "0000000000000000e504f2767521a153"
}
}