[Loris-dev] [IPMSA] Error: DBD::mysql::st execute failed: Incorrect date value: '' for column 'DateAcquired'

[Morales Pinzon, Alfredo]

Dear LorisDev team,

I have 2 MRI sessions that could not be uploaded due to the following error:

--------------------------
Use of uninitialized value $_ in pattern match (m//) at /AAA/loris_data/IPMSA/bin/mri//batch_uploads_imageuploader line 92.
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.
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.
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.
--------------------------

This is what I get in the log file: /AAA/ANOM/CCC//log_batch_imageuploader_AAA10292_850501_w048.txt
--------------------------
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

/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
 Source: /tmp/ImagingUpload-12-4-kG9b0L
Target: /AAA/loris_data/BBB/data/tarchive

Testing for database connectivity.
Database is available.

You will archive the dir                : ImagingUpload-12-4-kG9b0L

You are creating a tar with the following command:
tar -cf /AAA/loris_data/BBB/data/tarchive/ImagingUpload-12-4-kG9b0L.tar ImagingUpload-12-4-kG9b0L


getting md5sums and gzipping!!

* Taken from dir                   :    /tmp/ImagingUpload-12-4-kG9b0L
* Archive target location          :    /AAA/loris_data/BBB/tarchive/DCM__ImagingUpload-12-4-kG9b0L.tar
* Name of creating host            :    132.216.133.49
* Name of host OS                  :    Linux
* Created by user                  :    lorisadmin
* Archived on                      :    2019-04-07 12:05:46
* dicomSummary version             :    1
* dicomTar version                 :    1
* md5sum for DICOM tarball         :    19fbaf1fcab253c3bdf741f4b7b5d4a2  ImagingUpload-12-4-kG9b0L.tar
* md5sum for DICOM tarball gzipped :    3611bbab463663880c58fe32def90c8a  ImagingUpload-12-4-kG9b0L.tar.gz
* md5sum for complete archive      :    2dc51a007126ad41e8e0195eda37a378  DCM__ImagingUpload-12-4-kG9b0L.tar

Adding archive info into database
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 = ?



Removing temporary files from target location


The database command failed

The dicomtar execution has failed
--------------------------

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.

Best regards,
Alfredo.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20190408/fe54f6f5/attachment-0001.html>