<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Dear LorisDev Team,
<div class=""><br class="">
</div>
<div class="">I recently removed all the UploadIDs from a study using the script “<font face="Helvetica Neue" class=""><span style="color: rgba(0, 0, 0, 0.85);" class="">delete_imaging_upload.pl</span><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class="">”</span><span style="color: rgba(0, 0, 0, 0.85);" class="">.
However, in the front-end I can see some </span><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class="">imaging visits for some candidates of the study. </span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class="">Here is an example for one visit:</span></font></div>
<div class=""><br class="">
</div>
<div class="">Here is the imaging session for one the Candidates with the issue:</div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class="">===</span></font></div>
<div class="">
<div class=""><font face="Menlo" class="">select * from session where CandID in (450030) \G;</font></div>
<div class=""><font face="Menlo" class="">*************************** 1. row ***************************</font></div>
<div class=""><font face="Menlo" class=""> <font color="#ff1f00" class="">
ID: 845</font></font></div>
<div class=""><font face="Menlo" class=""> CandID: 450030</font></div>
<div class=""><font face="Menlo" class=""> CenterID: 60</font></div>
<div class=""><font face="Menlo" class=""> VisitNo: 1</font></div>
<div class=""><font face="Menlo" class=""> Visit_label: m00</font></div>
<div class=""><font face="Menlo" class=""> SubprojectID: 2</font></div>
<div class=""><font face="Menlo" class=""> Submitted: N</font></div>
<div class=""><font face="Menlo" class=""> Current_stage: Not Started</font></div>
<div class=""><font face="Menlo" class=""> Date_stage_change: NULL</font></div>
<div class=""><font face="Menlo" class=""> Screening: NULL</font></div>
<div class=""><font face="Menlo" class=""> Date_screening: NULL</font></div>
<div class=""><font face="Menlo" class=""> Visit: NULL</font></div>
<div class=""><font face="Menlo" class=""> Date_visit: NULL</font></div>
<div class=""><font face="Menlo" class=""> Approval: NULL</font></div>
<div class=""><font face="Menlo" class=""> Date_approval: NULL</font></div>
<div class=""><font face="Menlo" class=""> Active: Y</font></div>
<div class=""><font face="Menlo" class=""> Date_active: 2017-11-10</font></div>
<div class=""><font face="Menlo" class=""> RegisteredBy: 5216-ICR_dataman</font></div>
<div class=""><font face="Menlo" class=""> UserID: 5216-ICR_dataman</font></div>
<div class=""><font face="Menlo" class=""> Date_registered: 2017-11-10</font></div>
<div class=""><font face="Menlo" class=""> Testdate: 2017-11-30 11:07:25</font></div>
<div class=""><font face="Menlo" class=""> Hardcopy_request: -</font></div>
<div class=""><font face="Menlo" class=""> BVLQCStatus: NULL</font></div>
<div class=""><font face="Menlo" class=""> BVLQCType: NULL</font></div>
<div class=""><font face="Menlo" class=""> BVLQCExclusion: NULL</font></div>
<div class=""><font face="Menlo" class=""> QCd: NULL</font></div>
<div class=""><font face="Menlo" class=""> <font color="#ff1f00" class="">
Scan_done: Y</font></font></div>
<div class=""><font face="Menlo" class=""> MRIQCStatus:</font></div>
<div class=""><font face="Menlo" class=""> MRIQCPending: N</font></div>
<div class=""><font face="Menlo" class="">MRIQCFirstChangeTime: NULL</font></div>
<div class=""><font face="Menlo" class=""> MRIQCLastChangeTime: NULL</font></div>
<div class=""><font face="Menlo" class=""> MRICaveat: false</font></div>
</div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class="">===</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class="">However, there is no TarchiveID associated with the session id in the mri_upload table</span></font></div>
<div class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class=""><font face="Menlo" class="">===</font></span></div>
<div class=""><span style="caret-color: rgba(0, 0, 0, 0.85);" class=""><font face="Menlo" class="">
<div class=""><span style="color: rgba(0, 0, 0, 0.85);" class="">select TarchiveID from mri_upload where SessionID=</span><font color="#ff1f00" class="">845</font><span style="color: rgba(0, 0, 0, 0.85);" class=""> \G;</span></div>
<div style="color: rgba(0, 0, 0, 0.85);" class="">Empty set (0.00 sec)</div>
</font></span></div>
<div class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class=""><font face="Menlo" class="">===</font></span></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class="">Any ideas on how can I fix this.</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class="">Thank you in advance for your help.</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class="">Regards,</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class="">Alfredo.</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue" class=""><span style="caret-color: rgba(0, 0, 0, 0.85); color: rgba(0, 0, 0, 0.85);" class=""><br class="">
</span></font></div>
</body>
</html>