<div dir="ltr">Hi Alfredo,<div><br></div><div>That is strange. Maybe the date in the DICOM files is weird. Are you planning on coming to the LORIS meeting on Tuesday? If so, maybe we could meet before the meeting and try to see what is going on?</div><div><br></div><div>Let me know. Thanks!</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Apr 12, 2019 at 11:48 AM 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 Cécile,</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 checked the dicoms and we do have the Acquisition Date in every dicom file. Is there anything else I should check?</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)">
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_-7773592213957488597signature">
<div class="gmail-m_-7773592213957488597BodyFragment"></div>
</div>
<div id="gmail-m_-7773592213957488597appendonsend"></div>
<hr style="display:inline-block;width:98%">
<div id="gmail-m_-7773592213957488597divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Cecile Madjar <<a href="mailto:cecile.madjar@mcin.ca" target="_blank">cecile.madjar@mcin.ca</a>><br>
<b>Sent:</b> Tuesday, April 9, 2019 10:08 AM<br>
<b>To:</b> Morales Pinzon, Alfredo<br>
<b>Cc:</b> <a href="mailto:loris-dev@bic.mni.mcgill.ca" target="_blank">loris-dev@bic.mni.mcgill.ca</a>; Sridar Narayanan, Dr.; Marciniak, Andrzej; Rozie Arnaoutelis, Ms.; Zografos Caramanos; Douglas Arnold, Dr.; Guttmann, Charles,M.D.<br>
<b>Subject:</b> Re: [Loris-dev] [IPMSA] Error: DBD::mysql::st execute failed: Incorrect date value: '' for column 'DateAcquired'</font>
<div> </div>
</div>
<div>
<p><span style="padding:3px 10px;border-radius:5px;color:rgb(255,255,255);font-weight:bold;display:inline-block;background-color:rgb(255,0,0)"> External Email - Use Caution </span></p>
<p></p>
<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" target="_blank">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-m_-7773592213957488597x_gmail_quote">
<div dir="ltr" class="gmail-m_-7773592213957488597x_gmail_attr">On Mon, Apr 8, 2019 at 6:37 PM Morales Pinzon, Alfredo <<a href="mailto:AMORALESPINZON@bwh.harvard.edu" target="_blank">AMORALESPINZON@bwh.harvard.edu</a>> wrote:<br>
</div>
<blockquote class="gmail-m_-7773592213957488597x_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_-7773592213957488597x_gmail-m_3179976130728258028signature">
<div class="gmail-m_-7773592213957488597x_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>
</div>
<p></p>
<p>The information in this e-mail is intended only for the person to whom it is<br>
addressed. If you believe this e-mail was sent to you in error and the e-mail<br>
contains patient information, please contact the Partners Compliance HelpLine at<br>
<a href="http://www.partners.org/complianceline" target="_blank">http://www.partners.org/complianceline</a> . If the e-mail was sent to you in error<br>
but does not contain patient information, please contact the sender and properly<br>
dispose of the e-mail.</p></div>
</blockquote></div>