<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 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 !important">--------------------------</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 !important"><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 !important">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 !important"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important">--------------------------</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 !important"><span>Running now the following command: /AAA/loris_data/BBB/bin/mri/uploadNeuroDB/imaging_upload_file.pl -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 !important"><span><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important">--------------------------</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 !important"><span><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><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="signature">
<div class="BodyFragment"></div>
</div>
</body>
</html>