Issue with Change Set db/drop/db-changeLog-dropFilter.xml added in Ikasan 3.2.x version and causing issues when migrating a Ikasan 3.1.x module

[selvra]

Seems like 2 change log files introduced in kasan 3.2.x version is causing issues when migrating a module from Ikasan 3.1.x version.

<!-- 3.2.x table drop -->
<include file="db/drop/db-changeLog-dropRoleFilter.xml" relativeToChangelogFile="true" />
<include file="db/drop/db-changeLog-dropFilter.xml" relativeToChangelogFile="true" />

The above change set files is actually causing issues when migrating a Ikasan 3.1.x module to Ikasan 3.2.2 as H2 DB would have been created already by 3.1.x version and migrating to Ikasan 3.2.x + or 3.2.3 we encounter the below issue (See error log for detail)

so workaround is

1. Login to H2 DB via command line or H2 console 
2. select * from FILTER; ->> check no rows there (you shouldn't have any)
3. DROP TABLE FILTER ->> manually drop it
4. Now start the module with Ikasan 3.2.3 version and it should work OK.

Error log - when starting up module after migrating to Ikasan 3.2.x

#22-04-20 14:19:42,531 INFO liquibase.logging.core.Slf4jLogger [main] New row inserted into SecurityPolicy
2022-04-20 14:19:42,532 INFO liquibase.logging.core.Slf4jLogger [main] ChangeSet db/data/db-changelog-entity-search-all-modules-policies.xml::entitySearchAllModulesPolicies::ikasan dev ran successfully in 12ms
2022-04-20 14:19:42,540 INFO liquibase.logging.core.Slf4jLogger [main] Table RoleFilter dropped
2022-04-20 14:19:42,540 INFO liquibase.logging.core.Slf4jLogger [main] ChangeSet db/drop/db-changeLog-dropRoleFilter.xml::dropRoleFilter::ikasan dev ran successfully in 6ms
2022-04-20 14:19:42,548 ERROR liquibase.logging.core.Slf4jLogger [main] Change Set db/drop/db-changeLog-dropFilter.xml::dropFilter::ikasan dev failed. Error: Table "Filter" not found; SQL statement:
DROP TABLE PUBLIC."Filter" [42102-200] [Failed SQL: (42102) DROP TABLE PUBLIC."Filter"]
2022-04-20 14:19:42,550 INFO liquibase.logging.core.Slf4jLogger [main] Successfully released change log lock
2022-04-20 14:19:42,555 ERROR org.springframework.boot.web.embedded.tomcat.TomcatStarter [main] Error starting Tomcat context. Exception: org.springframework.beans.factory.UnsatisfiedDependencyException. Message: Error creating bean with name 'org.springframework.security.config.annotation.web.configuration.WebSecurityConfiguration': Unsatisfied dependency expressed through method 'setFilterChainProxySecurityConfigurer' parameter 1; nested exception is org.springframework.beans.factory.BeanExpressionException: Expression parsing failed