# Rollback of the included SQL changeset does not work

**URL:** <https://forum.liquibase.org/t/rollback-of-the-included-sql-changeset-does-not-work/6995>\
**Category:** General Discussion\
**Created:** [June 20, 2022, 12:57pm UTC](https://forum.liquibase.org/t/rollback-of-the-included-sql-changeset-does-not-work/6995 "2022-06-20T12:57:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sperchenko](https://avatars.discourse-cdn.com/v4/letter/s/ad7895/32.png) [@sperchenko](https://forum.liquibase.org/u/sperchenko)\
**Post date:** [June 20, 2022, 12:57pm UTC](https://forum.liquibase.org/t/rollback-of-the-included-sql-changeset-does-not-work/6995/1 "2022-06-20T12:57:21Z")

</div>

Hey. I have a master changelog in XML format, where multiple changesets in raw SQL are included.  
And yes, this is mandatory requirement.  
So, when I try to setup rollback statement in those included files, the Liquibase does not see them.

This is the example of my changeset

– changeset creator.name:1 context:1.4.10-add\_imagefilename\_room  
CREATE OR REPLACE VIEW `MYSCHEMA`.`V_ROOM` AS  
SELECT  
`R`.`ID_ROOM` AS `ID_ROOM`,  
`R`.`ID_FACILITY` AS `ID_FACILITY`,  
`F`.`NAME` AS `FACILITY_NAME`,  
`R`.`ID_ROOM_TYPE` AS `ID_ROOM_TYPE`,  
`R`.`NAME` AS `NAME`,  
`R`.`DESCRIPTION` AS `DESCRIPTION`,  
`R`.`NUMBER` AS `NUMBER`,  
`R`.`FLOOR` AS `FLOOR`,  
`R`.`IMAGE_FILE_NAME` AS `IMAGE_FILE_NAME`,  
`R`.`DISABLED` AS `DISABLED`,  
`R`.`DISABLED_SINCE` AS `DISABLED_SINCE`  
FROM  
(`MYSCHEMA`.`ROOM` `R`  
JOIN `MYSCHEMA`.`FACILITY` `F` ON (((`R`.`ID_FACILITY` = `F`.`ID_FACILITY`)  
AND (`F`.`DISABLED` = 0))));  
– rollback DROP VIEW `MYSCHEMA`.`V_ROOM`;

And this is the result of using liquibase via maven plugin:

[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:4.11.0:rollback (default-cli) on project myproject-webportal:  
[ERROR] Error setting up or running Liquibase:  
[ERROR] liquibase.exception.RollbackFailedException: liquibase.exception.RollbackImpossibleException: No inverse to liquibase.change.core.RawSQLChange created

---

<div class="post-metadata">

**Author:** ![rakhi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/rakhi/32/288_2.png) [@rakhi](https://forum.liquibase.org/u/rakhi)\
**Post date:** [June 22, 2022, 9:22am UTC](https://forum.liquibase.org/t/rollback-of-the-included-sql-changeset-does-not-work/6995/2 "2022-06-22T09:22:47Z")

</div>

Hi @sperchenko ,  
Please confirm if all your changesets have rollback statements provided. As per Steve’s reply on [this SO post](https://stackoverflow.com/questions/32166653/no-inverse-to-liquibase-change-core-rawsqlchange-created) it seems could be some issue with the changelog you are executing.

Thanks,  
Rakhi Agrawal

---

<div class="post-metadata">

**Author:** ![rakhi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/rakhi/32/288_2.png) [@rakhi](https://forum.liquibase.org/u/rakhi)\
**Post date:** [June 22, 2022, 9:23am UTC](https://forum.liquibase.org/t/rollback-of-the-included-sql-changeset-does-not-work/6995/3 "2022-06-22T09:23:53Z")

</div>

Could you also provide details about the liquibase version you are using, this will help us to setup similar environment for reproducing the issue.

Thanks,  
Rakhi Agrawal