CDR Tickets

Issue Number 3779
Summary CTGov download job failure
Created 2014-06-25 16:18:54
Issue Type Bug
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2014-08-04 19:12:17
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.130205
Description

The CTGov download job failed this morning and needs to be investigated. We did not get the email we normally get after the import job is completed.

Comment entered 2014-07-17 13:44:38 by Kline, Bob (NIH/NCI) [C]

I believe the problem has been resolved by increasing the timeout.

Comment entered 2014-07-23 08:10:55 by Osei-Poku, William (NIH/NCI) [C]

It looks like the job failed two days in a row. We haven't received any emails in the last two days.

Comment entered 2014-07-23 18:08:18 by Englisch, Volker (NIH/NCI) [C]

I agree that the job failed again but it appears that the current problem is different from the original one.
Originally, there was an error message indicating that a query didn't finish due to a timeout failure. In this case, however, the process is unable to run a query due to a missing database connection and the CDR server is crashing. I don't know if the server crashes and that's why the process can't connect to the database or if the server crashes because of the missing DB connection.

Comment entered 2014-07-24 08:12:07 by Osei-Poku, William (NIH/NCI) [C]

It ran successfully this morning.

Comment entered 2014-07-24 10:07:27 by Englisch, Volker (NIH/NCI) [C]

I'm glad to hear that since I didn't do anything except for submitting a DBATEAM ticket. Maybe CBIIT did something.
Please let me know the next time it fails.

Comment entered 2014-08-04 19:12:17 by Englisch, Volker (NIH/NCI) [C]

The problem was a network error. A separate ticket has been filed for the webteam.

Comment entered 2014-08-28 11:48:26 by Osei-Poku, William (NIH/NCI) [C]

Verified

Elapsed: 0:00:00.001860