CDR Tickets

Issue Number 3224
Summary [CTGov] force update of ctgov trials that have not been updated recently
Created 2010-09-15 13:06:22
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2010-11-19 11:18:08
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107552
Description

BZISSUE::4912
BZDATETIME::2010-09-15 13:06:22
BZCREATOR::William Osei-Poku
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku

In OCECDR-2769 new elements were added to the CTGov schema but not all existing documents have been updated yet and some of them may never be updated if we don’t force an update. Please, manually make changes to the ctgv_import table to update of the remaining ctgov documents that have not been updated since OCECDR-2769 was promoted.

I have set the priority of this issue to P6 so that we don't do this immediately as it is not necessary to force the updates right away.

Comment entered 2010-09-15 14:03:57 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2010-09-15 14:03:57
BZCOMMENTOR::Bob Kline
BZCOMMENT::1

When do you want me to do this?

Comment entered 2010-09-17 10:17:02 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-09-17 10:17:02
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2

We decided to put this issue on hold to allow enough ctgov documents to be updated the usual way. I will let you know when we should implement this.

Comment entered 2010-09-17 10:23:18 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2010-09-17 10:23:18
BZCOMMENTOR::Bob Kline
BZCOMMENT::3

(In reply to comment #2)
> We decided to put this issue on hold to allow enough ctgov documents to be
> updated the usual way. I will let you know when we should implement this.

That's fine, but changing the status back to "New" isn't the best way to communicate this decision, because Bugzilla will keep sending me reminders to do something about any task I leave in the "New" state.

Comment entered 2010-09-17 10:25:51 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-09-17 10:25:51
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4

(In reply to comment #3)
> (In reply to comment #2)
> > We decided to put this issue on hold to allow enough ctgov documents to be
> > updated the usual way. I will let you know when we should implement this.
>
> That's fine, but changing the status back to "New" isn't the best way to
> communicate this decision, because Bugzilla will keep sending me reminders to
> do something about any task I leave in the "New" state.

My apologies, it was not intentional.

Comment entered 2010-11-16 15:41:02 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2010-11-16 15:41:02
BZCOMMENTOR::Bob Kline
BZCOMMENT::5

Just FYI, I checked this afternoon and there are only 15 trials with disposition of 'imported' and not marked as dropped and for which the latest changes we've received were before September 9, 2010, when the work for task #4444 was installed on the production system.

NCT00002667
NCT00045305
NCT00098787
NCT00262925
NCT00283608
NCT00352638
NCT00387699
NCT00407550
NCT00433511
NCT00538850
NCT00601380
NCT00608478
NCT00609076
NCT00770120
NCT00798629

Comment entered 2010-11-19 11:17:08 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-11-19 11:17:08
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::6

I was looking at the trials on Bach before I closed the issue and found out that by searching with the NCT IDs only, I was getting InScopeProtocol documents only for 6 of the trials. They turned out to be trials that were transferred and we had to reverse the transfers because they weren’t supposed to be transferred in the first place. They are:

NCT00002667 - InScopeProtocol - CDR0000064256
NCT00045305 - InScopeProtocol - CDR0000256928
NCT00098787 - InScopeProtoco - CDR0000398096
NCT00262925 - InScopeProtocol - CDR0000450765
NCT00387699 - InScopeProtocol - CDR0000508653
NCT00770120 - InScopeProtocol - CDR0000616162

The rest are all CTGovProtocol documents and two of them have since been updated:
NCT00283608 - CTGovProtocol - Updated
NCT00407550 - CTGovProtocol - Updated

So essentially, only 6 CTGovProtocol documents have not been updated yet.

NCT00798629 - CTGovProtocol
NCT00609076 - CTGovProtocol
NCT00608478 - CTGovProtocol
NCT00601380 - CTGovProtocol
NCT00538850 - CTGovProtocol
NCT00352638 - CTGovProtocol

Since we decided to allow the trials to be updated through the normal process, I am marking it as resolved and will close it in the next step.

Comment entered 2010-11-19 11:18:08 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-11-19 11:18:08
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::7

>Since we decided to allow the trials to be updated through the normal process,
> I am marking it as resolved and will close it in the next step.

Issue closed. Thanks!

Elapsed: 0:00:00.001749