Liquibase rollback failing

Liquibase Development
1

getting the same exception when rollback is executed

For eG:

String tracingFilePath = "tracing_data_15.xml";
            SearchPathResourceAccessor resourceAccessor = new SearchPathResourceAccessor(
                    new DirectoryResourceAccessor(Paths.get("C:\\SIU_1011_RC3\\var\\").toAbsolutePath().toFile()));
            Liquibase liquibase = new Liquibase(tracingFilePath, resourceAccessor, database);
            liquibase.validate();
            liquibase.rollback("tracing_data_15_create", "");

when executed throws exception as below

Jun 20, 2023 3:31:28 PM liquibase
INFO: Parsed changelog file ‘tracing_data_15.xml’
Jun 20, 2023 3:31:28 PM liquibase.changelog
INFO: Reading from siu20.DATABASECHANGELOG
Jun 20, 2023 3:31:29 PM liquibase.lockservice
INFO: Successfully acquired change log lock
Jun 20, 2023 3:31:29 PM liquibase.lockservice
INFO: Successfully released change log lock
Jun 20, 2023 3:31:29 PM liquibase.command
INFO: Command execution complete
Error updating database: liquibase.exception.ChangeLogParseException: The file tracing_data_15.xml was not found in the configured search path:
More locations can be added with the ‘searchPath’ parameter.
liquibase.exception.CommandExecutionException: liquibase.exception.ChangeLogParseException: The file tracing_data_15.xml was not found in the configured search path:
More locations can be added with the ‘searchPath’ parameter.
at liquibase.command.CommandScope.execute(CommandScope.java:235)
at liquibase.Liquibase.rollback(Liquibase.java:734)
at liquibase.Liquibase.rollback(Liquibase.java:717)
at liquibase.Liquibase.rollback(Liquibase.java:712)
at liquibase.Liquibase.rollback(Liquibase.java:696)
at TestProg3.main(TestProg3.java:44)
Caused by: liquibase.exception.ChangeLogParseException: The file tracing_data_15.xml was not found in the configured search path:
More locations can be added with the ‘searchPath’ parameter.
at liquibase.parser.core.xml.XMLChangeLogSAXParser.parseToNode(XMLChangeLogSAXParser.java:114)
at liquibase.parser.core.xml.AbstractChangeLogParser.parse(AbstractChangeLogParser.java:15)
at liquibase.command.core.helpers.DatabaseChangelogCommandStep.getDatabaseChangeLog(DatabaseChangelogCommandStep.java:100)
at liquibase.command.core.helpers.DatabaseChangelogCommandStep.run(DatabaseChangelogCommandStep.java:77)
at liquibase.command.CommandScope.execute(CommandScope.java:212)
… 5 more

could you please help

2

Hi @sachin234s,

I think you are right, this is related to the search path issue from your other thread. See the answer I included there: