PDQ Issues

Issue Number	4659
Summary	Refresh CDR DEV from production
Created	2019-08-26 12:58:25
Issue Type	Task
Submitted By	Kline, Bob (NIH/NCI) [C]
Assigned To	Englisch, Volker (NIH/NCI) [C]
Status	Closed
Resolved	2019-08-30 16:03:25
Resolution	Fixed
Path	/home/bkline/backups/jira/ocecdr/issue.248912

Description

The cdr_archived_versions database also has to be pulled down. The stored procedure works for that database, too (I confirmed on QA). I can work with you on this, ~volker (or you can reassign back to me if you prefer that I do it, though I think it likely that you have more stuff – filters and such – that you have a vested interest in preserving than I do on DEV).

Comment entered 2019-08-30 15:56:24 by Englisch, Volker (NIH/NCI) [C]

The two databases cdr and cdr_archived_versions have been restored on DEV using the backups from PROD.

Comment entered 2019-08-30 15:59:15 by Englisch, Volker (NIH/NCI) [C]

DEV😃:\cdr\DevTools\Utilities>\Python\python.exe PushDevData.py volker "" DevData-20190830124718
session 5D695DFD-5BEFEE-107-JTSJTND1E0MS
using data preserved in DevData-20190830124718
restoring docs for control doctypes
restoring 'Filter' docs
updating 'Filter' document u'Module: InLine Markup Formatter' (CDR339576)
updating 'Filter' document u'Denormalization Filter: DrugInfoSummary' (CDR486313)
updating 'Filter' document u'Module: Global Filter Templates' (CDR306482)
updating 'Filter' document u'Vendor Filter: GlossaryTermName' (CDR616048)
updating 'Filter' document u'DrugInformationSummary QC Report Filter' (CDR486311)
updating 'Filter' document u'DocTitle for xxtest' (CDR792339)
updating 'Filter' document u'Module: STYLE Default' (CDR335169)
updating 'Filter' document u'Vendor Filter: DrugInfoSummary' (CDR505580)
updating 'Filter' document u'Revision Markup Filter' (CDR93)
restoring 'PublishingSystem' docs
updating 'PublishingSystem' document u'Mailers' (CDR176)
restoring 'Schema' docs
updating 'Schema' document u'GlossarySchema.xml' (CDR205)
updating 'Schema' document u'ctrp.xml' (CDR708123)
adding 'Schema' document u'GP.xml'
updating 'Schema' document u'xxtest.xml' (CDR531741)
adding 'Schema' document u'EmailerRecipient.xml'
adding 'Schema' document u'EmailerManifest.xml'
updating 'Schema' document u'PatientSummary.xml' (CDR201)
adding 'Schema' document u'EligibilityCriterion.xml'
adding 'Schema' document u'HereditaryCancerSyndrome.xml'
adding 'Schema' document u'SubmittedTrial.xml'
adding 'Schema' document u'EmailerDocument.xml'
restoring new document types
restoration complete

Comment entered 2019-08-30 16:02:23 by Englisch, Volker (NIH/NCI) [C]

Nonqualified transactions are being rolled back.

Estimated rollback completion: 0%.

Nonqualified transactions are being rolled back.

Estimated rollback completion: 100%.
5 percent processed.
10 percent processed.
15 percent processed.
20 percent processed.
25 percent processed.
30 percent processed.
35 percent processed.
40 percent processed.
45 percent processed.
50 percent processed.
55 percent processed.
60 percent processed.
65 percent processed.
70 percent processed.
75 percent processed.
80 percent processed.
85 percent processed.
90 percent processed.
95 percent processed.
100 percent processed.

Processed 12776264 pages for database 'cdr', file 'cdr' on file 1.

Processed 136 pages for database 'cdr', file 'cdr_log' on file 1.

RESTORE DATABASE successfully processed 12776400 pages in 435.261 seconds (229.323 MB/sec).

The row for user 'CdrGuest' will be fixed by updating its login link to a login already in existence.

The number of orphaned users fixed by updating users was 1.