<div dir="ltr"><div dir="ltr">Hi Alfredo,<div><br></div><div>Could you take a look at the date field of your DICOMs? Is it possible that the date of acquisition was removed from the dataset? </div><div><br></div><div>If so, this will be fixed with the release 20.3 of LORIS-MRI that should be released in April. In the meantime, you can take a look at the following PR that resolves all the issues in the insertion pipeline when no dates are available in a DICOM dataset: <a href="https://github.com/aces/Loris-MRI/pull/395">https://github.com/aces/Loris-MRI/pull/395</a></div><div><br></div><div>Hope this helps.</div><div>Let me know how this goes or if you encounter additional issues!</div><div><br></div><div>Cécile </div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Apr 8, 2019 at 6:37 PM Morales Pinzon, Alfredo <<a href="mailto:AMORALESPINZON@bwh.harvard.edu">AMORALESPINZON@bwh.harvard.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Dear LorisDev team,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
I have 2 MRI sessions that could not be uploaded due to the following error:</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
--------------------------</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span>Use of uninitialized value $_ in pattern match (m//) at /AAA/loris_data/IPMSA/bin/mri//batch_uploads_imageuploader line 92.<br>
</span>
<div>DBD::mysql::st execute failed: Incorrect date value: '' for column 'DateAcquired' at row 1 at /AAA/loris_data/IPMSA/bin/mri/dicom-archive/DICOM/DCMSUM.pm line 238.<br>
</div>
<div>DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`IPMSA_LORIS`.`tarchive_series`, CONSTRAINT `tarchive_series_ibfk_1` FOREIGN KEY (`TarchiveID`) REFERENCES `tarchive` (`TarchiveID`) ON DELETE CASCADE) at
/AAA/loris_data/IPMSA/bin/mri/dicom-archive/DICOM/DCMSUM.pm line 324.<br>
</div>
<span>DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`IPMSA_LORIS`.`tarchive_series`, CONSTRAINT `tarchive_series_ibfk_1` FOREIGN KEY (`TarchiveID`) REFERENCES `tarchive` (`TarchiveID`) ON DELETE CASCADE) at
/AAA/loris_data/IPMSA/bin/mri/dicom-archive/DICOM/DCMSUM.pm line 324.</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span style="font-family:Calibri,Arial,Helvetica,sans-serif;background-color:rgb(255,255,255);display:inline">--------------------------</span><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span style="font-family:Calibri,Arial,Helvetica,sans-serif;background-color:rgb(255,255,255);display:inline"><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span style="font-family:Calibri,Arial,Helvetica,sans-serif;background-color:rgb(255,255,255);display:inline">This is what I get in the log file: /AAA/ANOM/CCC//log_batch_imageuploader_AAA10292_850501_w048.txt</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span style="font-family:Calibri,Arial,Helvetica,sans-serif;background-color:rgb(255,255,255);display:inline"><span style="font-family:Calibri,Arial,Helvetica,sans-serif;background-color:rgb(255,255,255);display:inline">--------------------------</span><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span style="font-family:Calibri,Arial,Helvetica,sans-serif;background-color:rgb(255,255,255);display:inline"><span>Running now the following command: /AAA/loris_data/BBB/bin/mri/uploadNeuroDB/<a href="http://imaging_upload_file.pl" target="_blank">imaging_upload_file.pl</a> -profile prod -upload_id
20872 /AAA/ANOM/CCC//AAA10292_850501_w048.tar.gz -verbose<br>
</span>
<div><br>
</div>
<div>/AAA/loris_data/BBB/bin/mri/dicom-archive/dicomTar.pl /tmp/ImagingUpload-12-4-kG9b0L /AAA/loris_data/BBB/data/tarchive -clobber -database -profile prod -verbose<br>
</div>
<div> Source: /tmp/ImagingUpload-12-4-kG9b0L<br>
</div>
<div>Target: /AAA/loris_data/BBB/data/tarchive<br>
</div>
<div><br>
</div>
<div>Testing for database connectivity.<br>
</div>
<div>Database is available.<br>
</div>
<div><br>
</div>
<div>You will archive the dir : ImagingUpload-12-4-kG9b0L<br>
</div>
<div><br>
</div>
<div>You are creating a tar with the following command:<br>
</div>
<div>tar -cf /AAA/loris_data/BBB/data/tarchive/ImagingUpload-12-4-kG9b0L.tar ImagingUpload-12-4-kG9b0L<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>getting md5sums and gzipping!!<br>
</div>
<div><br>
</div>
<div>* Taken from dir : /tmp/ImagingUpload-12-4-kG9b0L<br>
</div>
<div>* Archive target location : /AAA/loris_data/BBB/tarchive/DCM__ImagingUpload-12-4-kG9b0L.tar<br>
</div>
<div>* Name of creating host : 132.216.133.49<br>
</div>
<div>* Name of host OS : Linux<br>
</div>
<div>* Created by user : lorisadmin<br>
</div>
<div>* Archived on : 2019-04-07 12:05:46<br>
</div>
<div>* dicomSummary version : 1<br>
</div>
<div>* dicomTar version : 1<br>
</div>
<div>* md5sum for DICOM tarball : 19fbaf1fcab253c3bdf741f4b7b5d4a2 ImagingUpload-12-4-kG9b0L.tar<br>
</div>
<div>* md5sum for DICOM tarball gzipped : 3611bbab463663880c58fe32def90c8a ImagingUpload-12-4-kG9b0L.tar.gz<br>
</div>
<div>* md5sum for complete archive : 2dc51a007126ad41e8e0195eda37a378 DCM__ImagingUpload-12-4-kG9b0L.tar<br>
</div>
<div><br>
</div>
<div>Adding archive info into database<br>
</div>
<div>Failed running query: INSERT INTO tarchive SET DicomArchiveID = ?, PatientName = ?, PatientID = ?, PatientDoB = ?, PatientGender = ?, DateAcquired = ?, ScannerManufacturer
= ?, ScannerModel = ?, ScannerSerialNumber = ?, ScannerSoftwareVersion = ?, CenterName = ?, AcquisitionCount = ?, NonDicomFileCount = ?, DicomFileCount = ?, CreatingUser = ?, SourceLocation = ?,
sumTypeVersion = ?, AcquisitionMetadata = ?, DateLastArchived = NOW() , tarTypeVersion = ?, md5sumArchive = ?, md5sumDicomOnly = ?, ArchiveLocation = ?, CreateInfo = ? , DateFirstArchived = NOW(),
neurodbCenterName = ?<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Removing temporary files from target location<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>The database command failed<br>
</div>
<div><br>
</div>
<span>The dicomtar execution has failed</span><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span style="font-family:Calibri,Arial,Helvetica,sans-serif;background-color:rgb(255,255,255);display:inline"><span><span style="font-family:Calibri,Arial,Helvetica,sans-serif;background-color:rgb(255,255,255);display:inline">--------------------------</span><br>
</span></span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span style="font-family:Calibri,Arial,Helvetica,sans-serif;background-color:rgb(255,255,255);display:inline"><span><span style="font-family:Calibri,Arial,Helvetica,sans-serif;background-color:rgb(255,255,255);display:inline"><br>
</span></span></span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
This cases were part of a list of 82 cases where 65 were correctly uploaded (15 had another type of error that I just reported in a different email). I can review the files with somebody from your team if required.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Best regards,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Alfredo.</div>
<div id="gmail-m_3179976130728258028signature">
<div class="gmail-m_3179976130728258028BodyFragment"></div>
</div>
</div>
_______________________________________________<br>
Loris-dev mailing list<br>
<a href="mailto:Loris-dev@bic.mni.mcgill.ca" target="_blank">Loris-dev@bic.mni.mcgill.ca</a><br>
<a href="https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev" rel="noreferrer" target="_blank">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a><br>
</blockquote></div>