|
A partire da gennaio 2021, i tipi di file classici non potranno più essere utilizzati. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

Chain error log

Con risposta
Richiedi una demo

Hello,

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

Commenti

1 commento

Data Voti
  • Jeff Hickey

    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.

    0

Accedi per aggiungere un commento.