| Issue Number | 5379 |
|---|---|
| Summary | Nightly Publishing Job Failing |
| Created | 2025-04-02 18:21:07 |
| Issue Type | Task |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Open |
| Resolved | |
| Resolution | |
| Path | /home/bkline/backups/jira/ocecdr/issue.500437 |
For the second day in a row our nightly publishing job failed with a "query timeout".
Job failed: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Query timeout expired (0) (SQLExecDirectW)')Adding ~bkline as a watcher.
Both times the job failed when running a large query to identify new summaries to be published. I tried to run the query manually and it ran successfully.
Now I'm re-running the nightly publishing job and it appears that the query ran fine. My guess is the publishing job will finish without issue.
Elapsed: 0:00:00.002021