[Loris-dev] Imaging visits in front-end but no UploadIDs in the database

[Nicolas Brossard]

Hi Alfredo,

I am curious to see the actual records that the delete script removed from
your mri_upload table. Since the delete script backs up what it deletes,
you can have a look inside the backup file it created. By default, this
file is named imaging_upload_backup.tar.gz. Inside, you'll find an SQL file
that should contain all the entries in mri_upload that were deleted. Can
you check if all of them have a sessionID set to 845 (they should)? Can you
also check in the same file the UPDATE statement that was issued on the
session table? We'll start with these checks first.


Best,
Nicolas


On Mon, Apr 13, 2020 at 8:16 PM Morales Pinzon, Alfredo <
AMORALESPINZON at bwh.harvard.edu> wrote:

> Dear LorisDev Team,
>
> I recently removed all the UploadIDs from a study using the script “
> delete_imaging_upload.pl”. However, in the front-end I can see some imaging
> visits for some candidates of the study.
>
> Here is an example for one visit:
>
> Here is the imaging session for one the Candidates with the issue:
> ===
> select * from session where CandID in (450030) \G;
> *************************** 1. row ***************************
>                   ID: 845
>               CandID: 450030
>             CenterID: 60
>              VisitNo: 1
>          Visit_label: m00
>         SubprojectID: 2
>            Submitted: N
>        Current_stage: Not Started
>    Date_stage_change: NULL
>            Screening: NULL
>       Date_screening: NULL
>                Visit: NULL
>           Date_visit: NULL
>             Approval: NULL
>        Date_approval: NULL
>               Active: Y
>          Date_active: 2017-11-10
>         RegisteredBy: 5216-ICR_dataman
>               UserID: 5216-ICR_dataman
>      Date_registered: 2017-11-10
>             Testdate: 2017-11-30 11:07:25
>     Hardcopy_request: -
>          BVLQCStatus: NULL
>            BVLQCType: NULL
>       BVLQCExclusion: NULL
>                  QCd: NULL
>            Scan_done: Y
>          MRIQCStatus:
>         MRIQCPending: N
> MRIQCFirstChangeTime: NULL
>  MRIQCLastChangeTime: NULL
>            MRICaveat: false
> ===
>
> However, there is no TarchiveID associated with the session id in the
> mri_upload table
> ===
> select TarchiveID from mri_upload where SessionID=845 \G;
> Empty set (0.00 sec)
> ===
>
> Any ideas on how can I fix this.
>
> Thank you in advance for your help.
>
> Regards,
> Alfredo.
>
>
> _______________________________________________
> Loris-dev mailing list
> Loris-dev at bic.mni.mcgill.ca
> https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20200413/671f23df/attachment-0001.html>