Chain error log
AnsweredHello,
I have a chain that normally runs fine with no errors, but periodically it will error out. Given that this only errors out sometimes, I feel the issue is not with the query itself. Does anyone know what this error message means, and what can be done to avoid this error in the future?
Thanks
🔌 Workiva BizApp 1.0.0
⚙️ Run Query Configuration:
Admin Host Override:
Run Asynchronously: false
Client ID: 80ecc6369edc4228b04eff9e121993a7
Client Secret: ENCRYPTED 🔐
Graph DB Host Override:
Query ID: ea2a0da23ca1491eb5809afac53a6715
Params: []
Command description: Runs a query and immediately returns a query result entity. This entity has an id that can be used to download to export the results.
Query was run successfully, polling until complete.
Checking status....
Current Status: RUNNING
Checking status....
Current Status: RUNNING
Checking status....
Current Status: RUNNING
Checking status....
Current Status: RUNNING
Checking status....
Current Status: RUNNING
Checking status....
Current Status: RUNNING
Checking status....
Current Status: RUNNING
Checking status....
Current Status: RUNNING
Checking status....
Current Status: RUNNING
Checking status....
Current Status: RUNNING
Checking status....
Current Status: ERROR
There was an error running this query: "Query failed (#20200925_120433_01631_ij23k): null (Service: AWSGlue; Status Code: 502; Error Code: null; Request ID: null)"
Query result metadata:
{
"bytesScanned": 0,
"columns": [],
"created": "2020-09-25T12:04:33.000Z",
"duration": 0,
"error": "Query failed (#20200925_120433_01631_ij23k): null (Service: AWSGlue; Status Code: 502; Error Code: null; Request ID: null)",
"id": "cc20b56abec6432993a94d02e828a4e6",
"queryId": "ea2a0da23ca1491eb5809afac53a6715",
"queryParameters": [],
"queryText": "SELECT\n posting_month\n, Account_Title\n, sub_network\n, \"sum\"(\"VOL_INTX_REVSHARE_TABLE\".\"amount\") \"Amount\"\nFROM\n \"QWNjb3VudB80Njk2NTYyODE2OTA5MzEy\".\"54b7219e07c64ae693535147c2064914\" \"VOL_INTX_REVSHARE_TABLE\"\nWHERE (Account_number = 99100)\nGROUP BY 1, 2, 3\nLIMIT 1000000\n",
"status": "ERROR",
"updated": "2020-09-25T12:04:33.000Z",
"userId":
}
Result: "Query failed (#20200925_120433_01631_ij23k): null (Service: AWSGlue; Status Code: 502; Error Code: null; Request ID: null)"
0
-
Trying adding a few retry attempts with a 15 to 30 second pause between attempts. This should mitigate the 502 error assuming that there are no errors in your query.
0Please sign in to leave a comment.
Comments
1 comment