version control - Unable to tag the database using Liquibase for future rollback -
i trying tag database future rollback using getting below error:
applying updates database. may take few minutes ... unexpected error running liquibase: error parsing line 12 column 6 of ppsdb/ebidb_lb_upgrade_c43_sql_1.xml: cvc-complex-type.2.4.a: invalid content found starting element 'sql'. 1 of '{"http://www.liquibase.org/xml/ns/dbchangelog/1.9":modifysql}' expected.
here changeset file:
cat ebidb_lb_upgrade_c43_sql_1.xml
<?xml version="1.0" encoding="utf-8"?> <databasechangelog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd"> <changeset author="avnish_plsql_upgrade" id="1"> <tagdatabase tag="version_1.3"/> <sql stripcomments="false" > create table test (id number); </sql> </changeset> </databasechangelog>
when removing tagdatabase tag file, not getting error. when adding tag, getting above error. please let me know, if missing thing or making mistake here.
i think issue may using outdated xsd. in header of xml file, replace instances of 1.9
3.6
here example 1 of recent environments:
<databasechangelog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.6.xsd">
Comments
Post a Comment