How to solve "Error creating bean with name 'importSpeForms' defined in ServletContext resource"?

Case 1:

Solution

This is a known issue and occurs mostly when upgrading OpenSpecimen from a very older version i.e. 2x to newer 3x or later versions.

To get rid of this error, follow the below steps:

1. Rename increment_freeze_thaw column:

   alter table catissue_frozen_event_param rename column increment_freeze_thaw to increment_freeze_thaw_bk;

2. Restart OpenSpecimen

3. We anticipate similar problem to occur when importing Thaw event form. Repeat steps 1 and 2 for catissue_thaw_event_parameters

   alter table catissue_thaw_event_parameters rename column increment_freeze_thaw to increment_freeze_thaw_bk;

4. Restart OpenSpecimen

5. Hopefully, OpenSpecimen should now start functioning normally. As a final step, execute below SQLs to restore original columns

   alter table catissue_frozen_event_param drop column increment_freeze_thaw;
   alter table catissue_frozen_event_param rename column increment_freeze_thaw_bk to increment_freeze_thaw;
   alter table catissue_thaw_event_parameters drop column increment_freeze_thaw;
   alter table catissue_thaw_event_parameters rename column increment_freeze_thaw_bk to increment_freeze_thaw;