[Loris-dev] [IPMSA] Error: DBD::mysql::st execute failed: Incorrect date value: '' for column 'DateAcquired'
Morales Pinzon, Alfredo
AMORALESPINZON at bwh.harvard.edu
Fri Apr 12 11:48:04 EDT 2019
Dear Cécile,
I checked the dicoms and we do have the Acquisition Date in every dicom file. Is there anything else I should check?
Regards,
Alfredo.
________________________________
From: Cecile Madjar <cecile.madjar at mcin.ca>
Sent: Tuesday, April 9, 2019 10:08 AM
To: Morales Pinzon, Alfredo
Cc: loris-dev at bic.mni.mcgill.ca; Sridar Narayanan, Dr.; Marciniak, Andrzej; Rozie Arnaoutelis, Ms.; Zografos Caramanos; Douglas Arnold, Dr.; Guttmann, Charles,M.D.
Subject: Re: [Loris-dev] [IPMSA] Error: DBD::mysql::st execute failed: Incorrect date value: '' for column 'DateAcquired'
External Email - Use Caution
Hi Alfredo,
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?
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: https://github.com/aces/Loris-MRI/pull/395
Hope this helps.
Let me know how this goes or if you encounter additional issues!
Cécile
On Mon, Apr 8, 2019 at 6:37 PM Morales Pinzon, Alfredo <AMORALESPINZON at bwh.harvard.edu<mailto:AMORALESPINZON at bwh.harvard.edu>> wrote:
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<http://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.
_______________________________________________
Loris-dev mailing list
Loris-dev at bic.mni.mcgill.ca<mailto:Loris-dev at bic.mni.mcgill.ca>
https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev
The information in this e-mail is intended only for the person to whom it is
addressed. If you believe this e-mail was sent to you in error and the e-mail
contains patient information, please contact the Partners Compliance HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you in error
but does not contain patient information, please contact the sender and properly
dispose of the e-mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20190412/bfdc558d/attachment.html>
More information about the Loris-dev
mailing list