Fixing query forms

The old caTissue or OpenSpecimen v1.1 query forms are not compatible with v2x or later version query forms. As a result, when upgrading from v1.1 to later versions, following error occurs during application bootstrap: Error creating bean with name 'importQueryForms'

To fix this problem, follow below steps:

1. Delete old query form associations

   delete from 
     catissue_form_context 
   where 
     container_id in (
       select
         identifier
       from
         dyextn_containers
       where
         name in ('CollectionProtocol', 'Participant', 'SpecimenCollectionGroup', 'Specimen', 'Order', 'Shipment')
     ) and
     entity_type = 'Query';

2. Delete incompatible query form definitions

   delete from 
     dyextn_containers 
   where 
     name in ('CollectionProtocol', 'Participant', 'SpecimenCollectionGroup', 'Specimen', 'Order', 'Shipment');

3. Delete all form import change logs. This step needs to be carried out iff os_import_forms_log table exists in the schema.

   delete from os_import_forms_log;

4. Restart OpenSpecimen