CDR Tickets

Issue Number 5113
Summary Prune obsolete groups/actions
Created 2022-05-26 11:37:23
Issue Type Task
Submitted By Kline, Bob (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2022-06-10 15:34:23
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.319065
Description

Unless someone can present reasons why this shouldn't happen, I plan to remove the following groups, which appear to no longer be used by the software:

  • BatchCTGovMapping Notification

  • CTGov Duplicate Notification

  • CTGov Export Arms Notification

  • CTGov Export Notification

  • CTGov Link Fix Notification

  • CTGOV Maintainers

  • CTGov Orphan Report

  • CTGov Publishers

  • CTGov Transfer Notification

  • CTGov Transfer Notification NoUS

  • Emailer Tracker Update

  • External Imports

  • Force CTGov Download

  • GP Mailers

  • GP Notification Test Recips

  • GPImport

  • Mailer Report Recipients

  • NCT ID Remappers

  • NLM Duplicate Maintainers

  • Person/Org Mailers

  • Prot  Participant Maintainers

  • Report 4825

  • Verification Mailers

... and the following (apparently) unused actions:

  • EDIT CTGOV MAP

  • EDIT CTRP MAP

  • EDIT RSS MAP

  • FORCE CTGOV DOWNLOAD

  • GP MAILERS

  • IMPORT GP DOC

  • MARK NLM DUPLICATES

  • ORGANIZATION MAILERS

  • PHYSICIAN MAILERS

  • PROTOCOL MAILERS

  • RECEIVE MAILER REPORTS

  • REPORT 4825

  • REPORT CTGOV ORPHANS

  • SWAP NCT IDS

Comment entered 2022-05-26 15:03:07 by Kline, Bob (NIH/NCI) [C]

Removed from PROD. Let me know when you have identified the other actions/groups you said could be dropped, .

Comment entered 2022-06-09 10:27:41 by Osei-Poku, William (NIH/NCI) [C]

In the Manage Actions category we can remove:

UPLOAD ZIP CODES

In the Manage Query Term Definitions category we can remove all the query terms that begin with 

/CTGovProtocol/

/InScopeProtocol/

/OutOfScopeProtocol/

 /GENETICSPROFESSIONAL/ID

 

I have attached the list as copied from the interface. 

admin interface pruning.txt

Comment entered 2022-06-09 12:00:41 by Kline, Bob (NIH/NCI) [C]

I have removed the UPLOAD ZIP CODES action (as well as the ZIP CODE MAINTAINERS group, for which that was the only action), and the query term definitions you listed (as well as the '/ScientificProtocol%' query term definitions). This is all done on PRODUCTION, and my plan it to let the results of the pruning flow down to the lower tiers as part of refreshes (which we will be testing on QA shortly as part of the SQL Server upgrade), rather than doing the pruning manually on each of the lower tiers.

Comment entered 2022-06-10 10:33:50 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. This is has been completed on PROD. I will proceed to close the ticket. Thanks!

Comment entered 2022-06-10 14:58:18 by Osei-Poku, William (NIH/NCI) [C]

I just realized that there are more items we can remove from the Manage Groups interface so I am re-opening this ticket.

CTGov Duplicate Notification
CTGov Export Arms Notification
CTGov Export Notification
CTGov Link Fix Notification
CTGOV Maintainers
CTGov Orphan Report
CTGov Publishers
CTGov Transfer Notification
CTGov Transfer Notification NoUS

Comment entered 2022-06-10 15:19:19 by Kline, Bob (NIH/NCI) [C]

Didn't I already remove those? Perhaps you're not looking at CDR PROD.

Comment entered 2022-06-10 15:26:06 by Kline, Bob (NIH/NCI) [C]

Of course, you're welcome to do the manual pruning on the lower tiers if you want, but see my earlier comment on letting the refresh take care of it.

Comment entered 2022-06-10 15:34:06 by Osei-Poku, William (NIH/NCI) [C]

You're right. I was looking at them on  DEV. Sorry about the confusion.  Thanks!

Attachments
File Name Posted User
admin interface pruning.txt 2022-06-09 10:27:35 Osei-Poku, William (NIH/NCI) [C]

Elapsed: 0:00:00.001345