CDR Tickets

Issue Number 3546
Summary [CTGov] Trials imported without review
Created 2012-09-24 15:17:34
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2012-10-04 10:32:20
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107874
Description

BZISSUE::5242
BZDATETIME::2012-09-24 15:17:34
BZCREATOR::William Osei-Poku
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku

It appears that the following CTGov protocols were imported on 9/21 into the CDR without being reviewed. When we attempt to retrieve these trials for processing, they come up with a "Text not allowed here" error.
740481
740482
740483
740484
740485
740486
740487
740488
740489
740490
740491
740492

Comment entered 2012-09-25 16:33:32 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2012-09-25 16:33:32
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::1

About 20 trials we downloaded yesterday also come up with the same error. Those are ones we downloaded manually but they also came up with what appears to be a schema error "Text not allowed here" (same error as reported earlier). We are unable to publish these trials because of the validation issue.

Comment entered 2012-09-25 18:43:37 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2012-09-25 18:43:37
BZCOMMENTOR::Bob Kline
BZCOMMENT::2

The problem was introduced on Friday when I made the change to the CT.gov import filter to preserve the CTRPInfo block. I inadvertently added the placeholder to all imported documents, when it should only have been added to existing ones. I have corrected the filter, and ran a global change to fix the 30 documents affected. Please confirm tomorrow morning that newly processed documents are OK.

Comment entered 2012-09-26 18:34:35 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2012-09-26 18:34:35
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::3

(In reply to comment #2)
> Please confirm tomorrow morning that newly processed
> documents are OK.

The documents are now okay. Thanks!

Comment entered 2012-09-27 10:56:00 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2012-09-27 10:56:00
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4

We are seeing the same error message in transferred trials that came in this morning. The regular CTGov imports are fine.
64684
64690
65521
65523
65605
66327
66457
66461
66494
66497

Comment entered 2012-09-27 12:56:38 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2012-09-27 12:56:38
BZCOMMENTOR::Bob Kline
BZCOMMENT::5

Filter modified to avoid inserting @@CTRPInfo@@ placeholder into newly transferred trials. Global change run to strip the placeholder from the 78 affected documents. Here's the end of the logs for the live run:

2012-09-27 12:49:00: Processing CDR0000724621 [pub:5/last:7/cwd:7]
2012-09-27 12:49:01: saveDoc(724621, ver='Y' pub='N' val='Y' new ver)
2012-09-27 12:49:01: Warning for CDR0000724621: No match found in content model for type CTGovOwnershipTransferInfo with child elements of CTGovOwnershipTransferInfo element (CTGovOwnerOrganization,PRSUserName); stopped at element CTGovOwnerOrganization
2012-09-27 12:49:01: Run completed.
Docs examined = 78
Docs changed = 78
Versions changed = 156
Could not lock = 0
Errors = 0
Time (hh:mm:ss) = 00:01:46
Specific versions saved:
new ver = 78

Comment entered 2012-10-04 10:31:51 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2012-10-04 10:31:51
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::6

Verified. Marked as Resolved - Fixed.

Comment entered 2012-10-04 10:32:20 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2012-10-04 10:32:20
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::7

Issue Closed.

Elapsed: 0:00:00.001352