CDR Tickets

We talked with William in last week's status meeting, and he confirmed that the Person and Org QC reports are still needed.

We did ask the question in OCECDR-4404 if those two filter sets could be removed but it appears I didn't get an answer to it.

There were two deleted filters that needed to be restored:

• CDR000096 - Person QC Report Filter

• CDR000099 - Denormalization Filter (1/1): Person

There were four deleted filter sets that needed to be recreated:

• QC Person Set with the members

  • Denormalization Person Set

  • CDR0000000096: Person QC Report Filter

• Denormalization Person Set with the members

  • CDR0000000099: Denormalization Filter (1/1): Person

  • CDR0000315572: Copy XML for Person

  • CDR0000320534: Remove Parent OrganizationName for Person

  • CDR0000315450: Sort OrganizationName for Postal Address - Person

• QC Organization Set with the members

  • Denormalization Organization Set

  • CDR0000000050: Organization QC Report Filter

• Denormalization Organization Set with the members

  • CDR0000000100: Denormalization Filter (1/1): Organization

  • CDR0000315594: Copy XML for Organization

  • CDR0000315593: Sort OrganizationName for Postal Address - Organization

In addition I needed to make a small change to the following file:

• cdr.py

This has been installed on DEV and is ready for review.

These changes are in my local sandbox:

• cdr-lib [ cdr4513-org]

• cdr-server [ cdr4513-org]

Verified on DEV. Thanks!

Since both, OCECDR-4517 and this ticket include modifications to the program cdr.py we should try to have both tickets fixed on PROD at the same time.

You can install this fix on QA.

The changes have been setup on QA.
Please verify on QA.

The following script will restore the missing filter documents in the database:

UPDATE all_docs SET active_status = 'A'
 WHERE id IN (50, 96, 99, 100, 315593, 315594) 
   AND active_status = 'D'

Verified on QA.

There are some organizations with links to Persons that have been deleted as a result of the database cleanup global. The QC reports for those orgs don't work. You get filtering error: Unable to resolve uri u'CDR0000415887/last'

Removing the links to the non existent person records make the Org QC reports work. I don't think it is a big deal but I will report the problem in the appropriate ticket.

The filters have been restored on STAGE and PROD and the filter sets have been recreated.

I will still need to submit a ticket to have CBIIT to update the file cdr.py on the upper tier servers before these reports are working again.

The changes have been copied to STAGE and PROD:

• cdr.py
  https://github.com/NCIOCPL/cdr-lib/commit/670931f

Please verify on PROD and close this ticket.

Verified on PROD. Thanks!