liquibase.exception.ChangeLogParseException: Error parsing line 382 column 247 of liquibase-test5023383955145225864.xml: cvc-complex-type.3.2.2: Attribute 'deleteRule' is not allowed to appear in element 'addForeignKeyConstraint'.

JIRA | Oleg Taranenko | 8 years ago
  1. 0

    Launch one of the java-dbtest, it does not matter what exactly by running method testRerunDiffChangeLog getting follows: liquibase.exception.ChangeLogParseException: Error parsing line 382 column 247 of liquibase-test5023383955145225864.xml: cvc-complex-type.3.2.2: Attribute 'deleteRule' is not allowed to appear in element 'addForeignKeyConstraint'. at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:96) at liquibase.Liquibase.update(Liquibase.java:106) at liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.testRerunDiffChangeLog(AbstractSimpleChangeLogRunnerTest.java:298) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at junit.framework.TestCase.runTest(TestCase.java:164) at junit.framework.TestCase.runBare(TestCase.java:130) at junit.framework.TestResult$1.protect(TestResult.java:110) at junit.framework.TestResult.runProtected(TestResult.java:128) at junit.framework.TestResult.run(TestResult.java:113) at junit.framework.TestCase.run(TestCase.java:120) at junit.framework.TestSuite.runTest(TestSuite.java:228) at junit.framework.TestSuite.run(TestSuite.java:223) at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: org.xml.sax.SAXParseException: cvc-complex-type.3.2.2: Attribute 'deleteRule' is not allowed to appear in element 'addForeignKeyConstraint'. at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:195) at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:131) at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:384) at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:318) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator$XSIErrorReporter.reportError(XMLSchemaValidator.java:410) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.reportSchemaError(XMLSchemaValidator.java:3165) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.processAttributes(XMLSchemaValidator.java:2630) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.handleStartElement(XMLSchemaValidator.java:2037) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyElement(XMLSchemaValidator.java:705) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:377) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:140) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205) at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522) at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:88) ... 21 more looking in the generated xml: <changeSet author="otaranenko (generated)" id="1244202031187-53"> <addForeignKeyConstraint baseColumnNames="state" baseTableName="address" constraintName="FK_ADDRESS_STATE" deferrable="false" deleteRule="3" initiallyDeferred="false" referencedColumnNames="id" referencedTableName="state" updateRule="3"/> </changeSet> deleteRule and UpdateRule are obviously wrong attributes, while excerption from dbchangelog-1.10.xsd <xsd:attributeGroup name="addForeignKeyConstraintAttrib"> <xsd:attribute name="baseTableSchemaName" type="xsd:string"/> <xsd:attribute name="baseTableName" type="xsd:string" use="required"/> <xsd:attribute name="baseColumnNames" type="xsd:string" use="required"/> <xsd:attribute name="constraintName" type="xsd:string" use="required"/> <xsd:attribute name="referencedTableSchemaName" type="xsd:string"/> <xsd:attribute name="referencedTableName" type="xsd:string" use="required"/> <xsd:attribute name="referencedColumnNames" type="xsd:string" use="required"/> <xsd:attribute name="deferrable" type="xsd:boolean"/> <xsd:attribute name="initiallyDeferred" type="xsd:boolean"/> <xsd:attribute name="deleteCascade" type="xsd:boolean"/> <xsd:attribute name="onDelete" type="fkCascadeActionOptions"/> <xsd:attribute name="onUpdate" type="fkCascadeActionOptions"/> </xsd:attributeGroup>

    JIRA | 8 years ago | Oleg Taranenko
    liquibase.exception.ChangeLogParseException: Error parsing line 382 column 247 of liquibase-test5023383955145225864.xml: cvc-complex-type.3.2.2: Attribute 'deleteRule' is not allowed to appear in element 'addForeignKeyConstraint'.
  2. 0

    Launch one of the java-dbtest, it does not matter what exactly by running method testRerunDiffChangeLog getting follows: liquibase.exception.ChangeLogParseException: Error parsing line 382 column 247 of liquibase-test5023383955145225864.xml: cvc-complex-type.3.2.2: Attribute 'deleteRule' is not allowed to appear in element 'addForeignKeyConstraint'. at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:96) at liquibase.Liquibase.update(Liquibase.java:106) at liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.testRerunDiffChangeLog(AbstractSimpleChangeLogRunnerTest.java:298) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at junit.framework.TestCase.runTest(TestCase.java:164) at junit.framework.TestCase.runBare(TestCase.java:130) at junit.framework.TestResult$1.protect(TestResult.java:110) at junit.framework.TestResult.runProtected(TestResult.java:128) at junit.framework.TestResult.run(TestResult.java:113) at junit.framework.TestCase.run(TestCase.java:120) at junit.framework.TestSuite.runTest(TestSuite.java:228) at junit.framework.TestSuite.run(TestSuite.java:223) at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: org.xml.sax.SAXParseException: cvc-complex-type.3.2.2: Attribute 'deleteRule' is not allowed to appear in element 'addForeignKeyConstraint'. at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:195) at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:131) at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:384) at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:318) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator$XSIErrorReporter.reportError(XMLSchemaValidator.java:410) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.reportSchemaError(XMLSchemaValidator.java:3165) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.processAttributes(XMLSchemaValidator.java:2630) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.handleStartElement(XMLSchemaValidator.java:2037) at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyElement(XMLSchemaValidator.java:705) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:377) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:140) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205) at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522) at liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:88) ... 21 more looking in the generated xml: <changeSet author="otaranenko (generated)" id="1244202031187-53"> <addForeignKeyConstraint baseColumnNames="state" baseTableName="address" constraintName="FK_ADDRESS_STATE" deferrable="false" deleteRule="3" initiallyDeferred="false" referencedColumnNames="id" referencedTableName="state" updateRule="3"/> </changeSet> deleteRule and UpdateRule are obviously wrong attributes, while excerption from dbchangelog-1.10.xsd <xsd:attributeGroup name="addForeignKeyConstraintAttrib"> <xsd:attribute name="baseTableSchemaName" type="xsd:string"/> <xsd:attribute name="baseTableName" type="xsd:string" use="required"/> <xsd:attribute name="baseColumnNames" type="xsd:string" use="required"/> <xsd:attribute name="constraintName" type="xsd:string" use="required"/> <xsd:attribute name="referencedTableSchemaName" type="xsd:string"/> <xsd:attribute name="referencedTableName" type="xsd:string" use="required"/> <xsd:attribute name="referencedColumnNames" type="xsd:string" use="required"/> <xsd:attribute name="deferrable" type="xsd:boolean"/> <xsd:attribute name="initiallyDeferred" type="xsd:boolean"/> <xsd:attribute name="deleteCascade" type="xsd:boolean"/> <xsd:attribute name="onDelete" type="fkCascadeActionOptions"/> <xsd:attribute name="onUpdate" type="fkCascadeActionOptions"/> </xsd:attributeGroup>

    JIRA | 8 years ago | Oleg Taranenko
    liquibase.exception.ChangeLogParseException: Error parsing line 382 column 247 of liquibase-test5023383955145225864.xml: cvc-complex-type.3.2.2: Attribute 'deleteRule' is not allowed to appear in element 'addForeignKeyConstraint'.
  3. 0

    Liferay starts up with errors on tomcat 6

    Stack Overflow | 4 years ago | user1782634
    org.xml.sax.SAXParseException: The markup in the document preceding the root element must be well-formed.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Update JasperReports Library in ATR to test for collateral damage to reports

    GitHub | 5 years ago | shreyanshvaghela
    org.xml.sax.SAXParseException: cvc-complex-type.2.4.d: Invalid content was found starting with element 'paragraph'. No child element is expected at this point.
  6. 0

    Manager crashes behind proxy

    GitHub | 2 years ago | halverneus
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase-core' defined in URL [jar:file:/var/lib/cattle/lib/0.5.0-SNAPSHOT-9050b644e12dc0c2e41870d2968b0327f3099a97-ccd6cde9-0076-4c48-ad29-a61eb5fcf9ee/WEB-INF/lib/cattle-framework-db-loader-0.5.0-SNAPSHOT.jar!/META-INF/cattle/system/spring-db-loader-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.ChangeLogParseException: Error parsing line 2 column 427 of db/core-020.xml: schema_reference.4: Failed to read schema document 'http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.2.xsd', because 1) could not find the document; 2) the document could not be read; 3) the root element of the document is not <xsd:schema>.

  1. mauritius 2 times, last 1 month ago
  2. rp 1 times, last 5 months ago
6 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.xml.sax.SAXParseException

    cvc-complex-type.3.2.2: Attribute 'deleteRule' is not allowed to appear in element 'addForeignKeyConstraint'.

    at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException()
  2. Java RT
    SAXParserImpl$JAXPSAXParser.parse
    1. com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:195)
    2. com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:131)
    3. com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:384)
    4. com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:318)
    5. com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator$XSIErrorReporter.reportError(XMLSchemaValidator.java:410)
    6. com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.reportSchemaError(XMLSchemaValidator.java:3165)
    7. com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.processAttributes(XMLSchemaValidator.java:2630)
    8. com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.handleStartElement(XMLSchemaValidator.java:2037)
    9. com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyElement(XMLSchemaValidator.java:705)
    10. com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:377)
    11. com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747)
    12. com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
    13. com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:140)
    14. com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
    15. com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807)
    16. com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
    17. com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)
    18. com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
    19. com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
    19 frames
  3. liquibase.parser.xml
    XMLChangeLogParser.parse
    1. liquibase.parser.xml.XMLChangeLogParser.parse(XMLChangeLogParser.java:88)
    1 frame
  4. Liquibase Core
    Liquibase.update
    1. liquibase.Liquibase.update(Liquibase.java:106)
    1 frame
  5. liquibase.dbtest
    AbstractSimpleChangeLogRunnerTest.testRerunDiffChangeLog
    1. liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.testRerunDiffChangeLog(AbstractSimpleChangeLogRunnerTest.java:298)
    1 frame
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  7. JUnit
    OldTestClassRunner.run
    1. junit.framework.TestCase.runTest(TestCase.java:164)
    2. junit.framework.TestCase.runBare(TestCase.java:130)
    3. junit.framework.TestResult$1.protect(TestResult.java:110)
    4. junit.framework.TestResult.runProtected(TestResult.java:128)
    5. junit.framework.TestResult.run(TestResult.java:113)
    6. junit.framework.TestCase.run(TestCase.java:120)
    7. junit.framework.TestSuite.runTest(TestSuite.java:228)
    8. junit.framework.TestSuite.run(TestSuite.java:223)
    9. org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
    9 frames
  8. JUnit4 Runner
    JUnit4TestReference.run
    1. org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
    1 frame
  9. JUnit3 Runner
    RemoteTestRunner.main
    1. org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    2. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
    3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
    4. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
    5. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
    5 frames