You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
run perl BackPopulateSNRAndAcquisitionOrder.pl -h and ensure the help of the script is up to date
pick a tarchive ID and delete SNR parameter_file entries and set AcqOrderPerModality field of the files table to NULL. Example for tarchive ID 27:
UPDATE files SET AcqOrderPerModality=NULL WHERE TarchiveSource=27;
UPDATE parameter_file SET Value=NULL WHERE FileID IN (SELECT FileID FROM files WHERE TarchiveSource=27) AND ParameterTypeID=(SELECT ParameterTypeID FROM parameter_type WHERE Name='SNR');
mysql> SELECT TarchiveSource, SessionID, AcqOrderPerModality, Value FROM files JOIN parameter_file USING (FileID) JOIN parameter_type USING (ParameterTypeID) WHERE Name='SNR' AND TarchiveSource=27;
+----------------+-----------+---------------------+-------+
| TarchiveSource | SessionID | AcqOrderPerModality | Value |
+----------------+-----------+---------------------+-------+
| 27 | 1053 | NULL | NULL |
| 27 | 1053 | NULL | NULL |
+----------------+-----------+---------------------+-------+
run perl BackPopulateSNRAndAcquisitionOrder.pl -profile prod -tarchive_id 27 and check that the AcqOrderPerModality and SNR value have been repopulated.
The text was updated successfully, but these errors were encountered:
perl BackPopulateSNRAndAcquisitionOrder.pl -h
and ensure the help of the script is up to dateperl BackPopulateSNRAndAcquisitionOrder.pl -profile prod -tarchive_id 27
and check that theAcqOrderPerModality
andSNR
value have been repopulated.The text was updated successfully, but these errors were encountered: