<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body 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="signature">
<div class="BodyFragment"></div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Cecile Madjar <cecile.madjar@mcin.ca><br>
<b>Sent:</b> Tuesday, April 9, 2019 10:08 AM<br>
<b>To:</b> Morales Pinzon, Alfredo<br>
<b>Cc:</b> loris-dev@bic.mni.mcgill.ca; 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:#ffffff; font-weight:bold; display:inline-block; background-color:#ff0000"> 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">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="x_gmail_quote">
<div dir="ltr" class="x_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="x_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="x_gmail-m_3179976130728258028signature">
<div class="x_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>
http://www.partners.org/complianceline . 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></body>
</html>