My Products
Help
MagnusHolen
PARTNER

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

by 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"
}
}
9 REPLIES 9
Arnstein By
VISMA

by 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
PARTNER

by MagnusHolen

Thanks, it works now.

SigbjĆørn Eide
CONTRIBUTOR ***

by SigbjĆørn Eide

Looks good in our end now. Thanks!

Arnstein By
VISMA

by 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
VISMA

by 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
VISMA

by 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
CONTRIBUTOR ***

by 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
PARTNER

by MagnusHolen

Yes. 

MagnusHolen
PARTNER

by 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"
}
}