EBMS Tickets

Issue Number 408
Summary [Admin] Refresh Journal List - is this process automated?
Created 2016-10-27 17:11:18
Issue Type Inquiry
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2017-06-19 07:02:51
Resolution Fixed
Path /home/bkline/backups/jira/oceebms/issue.197325
Description

Please investigate whether this is performed as an automated task. If so, with what frequency is it performed? Is the manual process still needed?

Comment entered 2016-10-28 06:45:14 by Kline, Bob (NIH/NCI) [C]

I checked, and it's only available as a manual task. As far as I can tell, there was never a request for it to be automated.

Comment entered 2016-10-28 12:31:55 by Juthe, Robin (NIH/NCI) [E]

Thanks, Bob. I think we should discuss making this process automated.

Comment entered 2017-06-07 08:20:31 by Kline, Bob (NIH/NCI) [C]

How often would you like it to run, and when?

Comment entered 2017-06-07 08:53:20 by Kline, Bob (NIH/NCI) [C]

Scheduled job created to run Sunday mornings at 5 am.

Comment entered 2017-06-07 09:03:32 by Juthe, Robin (NIH/NCI) [E]

That seems reasonable. Thanks, Bob. How should we test this one?

Comment entered 2017-06-07 09:18:09 by Kline, Bob (NIH/NCI) [C]

You could find a journal which you know is new or has changed its title recently, and verify that it's correct in the EBMS on Monday morning. If that's impossible (or tedious) you could let me check the logs to verify that the job ran. Another possibility is that you could compare the journal lists on DEV (where the job was run by the cron scheduler) with those on QA or PROD (but not STAGE, where I have run the refresh from the admin menus).

Comment entered 2017-06-16 17:06:07 by Juthe, Robin (NIH/NCI) [E]

Bob, could you please create an ad-hoc diff report comparing the journal lists on DEV and QA so we can more easily see the differences? Thank you!

Comment entered 2017-06-19 07:02:51 by Kline, Bob (NIH/NCI) [C]

Diff report attached. The lines beginning with "<" represent values from the QA database, for which the refresh has not been run in a while. The lines beginning with ">" come from the DEV database, where the refresh job runs on a scheduled basis.

Comment entered 2017-06-27 17:58:01 by Juthe, Robin (NIH/NCI) [E]

The refresh seems to have gone well on QA - I've checked several journal names that hadn't been updated at the time of the diff report and they now show the correct and current journal name on QA.

When was the refresh last done on PROD? I haven't been able to find any journals that aren't showing the current names already so this may be harder to test once we get to PROD.

Comment entered 2017-06-27 18:10:28 by Kline, Bob (NIH/NCI) [C]

Last run on PROD was January 10.

Comment entered 2017-06-28 17:10:11 by Juthe, Robin (NIH/NCI) [E]

Verified on QA.

Comment entered 2017-08-22 15:47:11 by Juthe, Robin (NIH/NCI) [E]

, are you able to confirm that this job is running on Sundays at 5am? If so, then I think we can close this ticket. Thanks.

Comment entered 2017-08-22 16:03:55 by Kline, Bob (NIH/NCI) [C]

Yes, I just checked the logs and confirmed that it's been running each week.

Comment entered 2017-08-22 16:10:23 by Juthe, Robin (NIH/NCI) [E]

Great, thanks!

Attachments
File Name Posted User
oceebms-408.diff 2017-06-19 07:00:56 Kline, Bob (NIH/NCI) [C]

Elapsed: 0:00:00.000746