My Products
Help
lars77
CONTRIBUTOR **

Getting consistant error when querying exchangeRate

by lars77

I query several different clients for the same data. I get this error on only one client, and only on the exchangeRate table. I get this error even if I only request the totalCount field.

 

{
    "errors": [
        {
            "message": "Error: Failed to execute operation.",
            "path": [
                "useCompany",
                "exchangeRate",
                "totalCount"
            ],
            "extensions": {
                "data": {
                    "status": 5,
                    "status_name": "failedToExecuteOperation"
                }
            }
        },
        {
            "message": "Error: SQL command no. 3014 failed.",
            "path": [
                "useCompany",
                "exchangeRate",
                "totalCount"
            ],
            "extensions": {
                "data": {
                    "status": 2,
                    "status_name": "databaseError"
                }
            }
        },
        {
            "message": "Error: Failed to execute operation.",
            "path": [
                "useCompany",
                "exchangeRate",
                "totalCount"
            ],
            "extensions": {
                "data": {
                    "status": 5,
                    "status_name": "failedToExecuteOperation"
                }
            }
        }
    ],
    "data": {
        "useCompany": {
            "exchangeRate": {
                "totalCount": 0
            }
        }
    },
    "extensions": {
        "vbnxt-trace-id": "000000000000000055a40c466d9be3f1"
    }
}

 

Can you please help me resolve this issue?

1 REPLY 1
Arnstein By
VISMA

by Arnstein By

@lars77 Our logs indicate that this database is missing a table. Please let me know which company this is by email to arnstein.by@visma.com and I will have a closer look.
Kind regards, Arnstein