liquibase.exception.ChangeLogParseException: Error parsing line 205 column 100 of sql/Release-Migration/Release-Delta.xml: src-resolve: Cannot resolve the name 'MaterializedViewRefreshType' to a(n) 'type definition' component.

JIRA | Dmitriy Korobskiy | 1 year ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    The documentation (http://www.liquibase.org/documentation/xml_format.html) says: {quote} Liquibase Extension XSDs If you use a Liquibase extension that includes additional change tags, check the extension documentation to find out if they provide a XSD. If they do not, you can use the xsd at http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd which allows any nested tag and attribute.{quote} Custom XSDs are very handy in order to use auto-complete in XML editors. However, when I actually try to use one for Oracle Extensions (https://raw.githubusercontent.com/liquibase/liquibase-oracle/master/src/main/java/liquibase/ext/ora/xml/dbchangelog-ext.xsd), Liquibase fails: DEBUG 4/14/16 10:49 AM: liquibase: Local path for https://raw.githubusercontent.com/liquibase/liquibase-oracle/master/src/main/java/liquibase/ext/ora/xml/dbchangelog-ext.xsd is null DEBUG 4/14/16 10:49 AM: liquibase: Attempting to load https://raw.githubusercontent.com/liquibase/liquibase-oracle/master/src/main/java/liquibase/ext/ora/xml/dbchangelog-ext.xsd from resourceAccessor as sql/Release-Migration/https:/raw.githubusercontent.com/liquibase/liquibase-oracle/master/src/main/java/liquibase/ext/ora/xml/dbchangelog-ext.xsd DEBUG 4/14/16 10:49 AM: liquibase: Could not load https://raw.githubusercontent.com/liquibase/liquibase-oracle/master/src/main/java/liquibase/ext/ora/xml/dbchangelog-ext.xsd from resourceAccessor as sql/Release-Migration/https:/raw.githubusercontent.com/liquibase/liquibase-oracle/master/src/main/java/liquibase/ext/ora/xml/dbchangelog-ext.xsd DEBUG 4/14/16 10:49 AM: liquibase: Unable to resolve XML entity locally. Will load from network. SEVERE 4/14/16 10:49 AM: liquibase: src-resolve: Cannot resolve the name 'MaterializedViewRefreshType' to a(n) 'type definition' component. DEBUG 4/14/16 10:49 AM: liquibase: Release Database Lock DEBUG 4/14/16 10:49 AM: liquibase: Executing UPDATE database command: UPDATE LINK_OD_IREPORT.DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1 INFO 4/14/16 10:49 AM: liquibase: Successfully released change log lock Unexpected error running Liquibase: src-resolve: Cannot resolve the name 'MaterializedViewRefreshType' to a(n) 'type definition' component. SEVERE 4/14/16 10:49 AM: liquibase: src-resolve: Cannot resolve the name 'MaterializedViewRefreshType' to a(n) 'type definition' component. liquibase.exception.ChangeLogParseException: Error parsing line 205 column 100 of sql/Release-Migration/Release-Delta.xml: src-resolve: Cannot resolve the name 'MaterializedViewRefreshType' to a(n) 'type definition' component. at liquibase.parser.core.xml.XMLChangeLogSAXParser.parseToNode(XMLChangeLogSAXParser.java:114) at liquibase.parser.core.xml.AbstractChangeLogParser.parse(AbstractChangeLogParser.java:17) at liquibase.Liquibase.getDatabaseChangeLog(Liquibase.java:227)}} I'm attaching the extracted test case.

    JIRA | 1 year ago | Dmitriy Korobskiy
    liquibase.exception.ChangeLogParseException: Error parsing line 205 column 100 of sql/Release-Migration/Release-Delta.xml: src-resolve: Cannot resolve the name 'MaterializedViewRefreshType' to a(n) 'type definition' component.

    Root Cause Analysis

    1. liquibase.exception.ChangeLogParseException

      Error parsing line 205 column 100 of sql/Release-Migration/Release-Delta.xml: src-resolve: Cannot resolve the name 'MaterializedViewRefreshType' to a(n) 'type definition' component.

      at liquibase.parser.core.xml.XMLChangeLogSAXParser.parseToNode()
    2. Liquibase Core
      Liquibase.getDatabaseChangeLog
      1. liquibase.parser.core.xml.XMLChangeLogSAXParser.parseToNode(XMLChangeLogSAXParser.java:114)
      2. liquibase.parser.core.xml.AbstractChangeLogParser.parse(AbstractChangeLogParser.java:17)
      3. liquibase.Liquibase.getDatabaseChangeLog(Liquibase.java:227)
      3 frames