Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com
How to solve "Error creating bean with name 'importSpeForms' defined in ServletContext resource"?
Case 1:
Caused by: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [ALTER TABLE CATISSUE_FROZEN_EVENT_PARAM ADD (INCREMENT_FREEZE_THAW NUMBER(19, 6))]; SQL state [72000]; error code [1430]; ORA-01430: column being added already exists in table ; nested exception is java.sql.SQLException: ORA-01430: column being added already exists in table |
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:
Rename
increment_freeze_thaw
column:alter table catissue_frozen_event_param rename column increment_freeze_thaw to increment_freeze_thaw_bk;
Restart OpenSpecimen
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;
Restart OpenSpecimen
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;
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com