[Loris-dev] MINC insertion

[Cecile Madjar]

Thank you Alfredo.

I wonder whether the variable $centerID is null when provided to the query
here
<https://github.com/SPINEProject/Loris-MRI/blob/19f469cce904ebe93ba5f641533e4c0ef39fadab/uploadNeuroDB/NeuroDB/MRI.pm#L1012>
in your case.

Could you add in MRI.pm line 1018 the following print statements and let me
know what you get? (Right before the $dbh->do($query);
print($centerID);
print($query);

Thank you!

Cécile

On Fri, Nov 26, 2021 at 10:55 AM Morales Pinzon, Alfredo <
AMORALESPINZON at bwh.harvard.edu> wrote:

> Hi Cécile,
>
> This is the branch that we are using in the IPMSA project:
>
> https://github.com/SPINEProject/Loris-MRI/tree/v23.0.3_IPMSA
>
> Best,
> Alfredo.
>
> On Nov 26, 2021, at 9:55 AM, Cecile Madjar <cecile.madjar at mcin.ca> wrote:
>
>         External Email - Use Caution
>
> Hi Alfredo,
>
> Could you point me to the version of the code you are using on GitHub so I
> can take a look at the correct MRI.pm file.
>
> Thank you!
>
> Cécile
>
> On Thu, Nov 25, 2021 at 8:09 PM Morales Pinzon, Alfredo <
> AMORALESPINZON at bwh.harvard.edu> wrote:
>
>> Hi Cécile,
>>
>> I’m getting the following error when inserting a minc file using the
>> minc_insertion.pl
>> <http://secure-web.cisco.com/1TzLj0luctz8Wb38Vv2psbWhbcU-f__EKvLSSaDYgEXmz5b0aqjDuEoOYgCDeNvO_wd_jY7vbVfBPyzukTp8u3bszcvl9RlzkffyCB96NEJ6ldbRDtpB5Dm1t3H6zAKfXwb47TCFKN4jo2cTx22wsEoMCjd40dMRoMr5y7-MMPE_rF9MBpp5uEB4y849W6nkPHoaERmNpP67XVRUarntyB3RrW-aH-TPtdYKd6qDPGkllZKISL3hlhs7AG4CCOQdZEVjiW6N9fr5aaSxBevb9TptNEJgPfB3dj-0XRNXWAt9bp6fvmGUwjIXEdKZVASmz/http%3A%2F%2Fminc_insertion.pl>
>> script:
>>
>> ===
>> $ perl minc_insertion.pl
>> <http://secure-web.cisco.com/1TzLj0luctz8Wb38Vv2psbWhbcU-f__EKvLSSaDYgEXmz5b0aqjDuEoOYgCDeNvO_wd_jY7vbVfBPyzukTp8u3bszcvl9RlzkffyCB96NEJ6ldbRDtpB5Dm1t3H6zAKfXwb47TCFKN4jo2cTx22wsEoMCjd40dMRoMr5y7-MMPE_rF9MBpp5uEB4y849W6nkPHoaERmNpP67XVRUarntyB3RrW-aH-TPtdYKd6qDPGkllZKISL3hlhs7AG4CCOQdZEVjiW6N9fr5aaSxBevb9TptNEJgPfB3dj-0XRNXWAt9bp6fvmGUwjIXEdKZVASmz/http%3A%2F%2Fminc_insertion.pl>
>> -profile prod -force -mincPath /data/BGI102001_207019_screening.mnc
>> -verbose -acquisition_protocol t1c -create_minc_pics
>>
>> DBD::mysql::db do failed: Cannot add or update a child row: a foreign key
>> constraint fails (`IPMSA_LORIS`.`candidate`, CONSTRAINT `FK_candidate_1`
>> FOREIGN KEY (`RegistrationCenterID`) REFERENCES `psc` (`CenterID`)) at
>> /data_/ipmsa/loris_data/IPMSA/bin/mri/uploadNeuroDB/NeuroDB/MRI.pm line
>> 1018.
>>
>> ERROR: Failed to insert record in table mri_scanner:
>>
>> The following database commands failed:
>> PREPARE s FROM 'INSERT INTO mri_scanner
>> (Serial_number,Software,Manufacturer,Model,CandID) VALUES (?,?,?,?,?)';
>> SET @x1='syngo_MR_2004A_4VA25A', at x2='Siemens', at x3='Sonata', at x4='247660';
>> EXECUTE s USING @x1, at x2, at x3, at x4, at x5;
>>
>> Error obtained:Cannot add or update a child row: a foreign key constraint
>> fails (`IPMSA_LORIS`.`mri_scanner`, CONSTRAINT `FK_mri_scanner_1` FOREIGN
>> KEY (`CandID`) REFERENCES `candidate` (`CandID`)) (error code 1452)
>> ===
>>
>> Could you help me figuring out what is happening? Is there something I
>> should add to the minc headers?
>>
>> Best,
>> Alfredo.
>>
>> 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 Mass General
>> Brigham Compliance HelpLine at
>> http://www.massgeneralbrigham.org/complianceline
>> <http://secure-web.cisco.com/10DEfcj-Ova6W7NFLUPao--zc_ba_3Yk63CTqhSG5Ca4FJWekd8J8afbwCr_p31UYqWdlWd2rAqSBE3jLmNtkj6jzu0Deh3bP7WsUj3yX1B4Iv_RzcWr2nfZ7f8_OUQvlNL5D_jqwZyNdyv_JUiP0dLvm0NprWoJtFmmA4jwKQ4X8BKNoa6LBbiWMVYizEQDtUP5c9bc0XDPr-wYz3SlyBzIrLOxha8XYY4l8tLxS_skKp_uX_4jMesLtI_DCQza3WckhpQ7-43tcveIJ9vz-wKKRp31RbQkfDcbgexXsRG1oCpy-6zP8ggtvzNLZ0VSxSBDRZD7ti7dI0bPJXah5pg/http%3A%2F%2Fwww.massgeneralbrigham.org%2Fcomplianceline>
>> . 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.
>>
>> Please note that this e-mail is not secure (encrypted).  If you do not
>> wish to continue communication over unencrypted e-mail, please notify the
>> sender of this message immediately.  Continuing to send or respond to
>> e-mail after receiving this message means you understand and accept this
>> risk and wish to continue to communicate over unencrypted e-mail.
>>
>
> 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 Mass General
> Brigham Compliance HelpLine at
> http://www.massgeneralbrigham.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.
>
> Please note that this e-mail is not secure (encrypted).  If you do not
> wish to continue communication over unencrypted e-mail, please notify the
> sender of this message immediately.  Continuing to send or respond to
> e-mail after receiving this message means you understand and accept this
> risk and wish to continue to communicate over unencrypted e-mail.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20211126/ca8c99fa/attachment.html>