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