| Issue Number | 4729 |
|---|---|
| Summary | Nightly Publishing Job Fails |
| Created | 2019-11-20 19:08:39 |
| Issue Type | Improvement |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2019-11-23 09:43:28 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.252637 |
The nightly publishing job fails during its push phase with the following error:
2019-11-20 19:02:02.105 [INFO] [2019-11-20 19:01:58.169502] ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Query timeout expired (0) (SQLExecDirectW)')
2019-11-20 19:02:02.105 [ERROR] *** Error - Program stopped with failure ***
Traceback (most recent call last):
{{ File "D:/cdr/publishing/SubmitPubJob.py", line 475, in
<module>}}
{{ sys.exit(1)}}
SystemExit: 1
I believe I have seen this error message for the past 3-4 days. Prior to that the nightly publishing job has worked OK. However, it it possible that I didn't see any error because there haven't been any documents to be pushed until recently.
Apparently cdrpub.py is failing at the step where it is
clearing out the pub_proc_cg_work table. If have modified
the script to use a separate connection with a very long
timeout (over 16 minutes). Can you try a publishing job with something
to push?
The nightly job ran and pushed 2 documents successfully. It can't finish yet because the GK job is waiting for another long running job to finish first.
Volker is still testing.
Elapsed: 0:00:00.001526