Error: changeSet -> preConditions and tagDatabase

General Discussion
1

What command(s) did you use?

What did you expect to happen?

What actually happened?

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/

2

It appears that liquibase is saying there is an XML syntax error in your changelog. It says the error is on line 17, but it doesn’t look like your changelog is 17 lines long. 

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/

3

OK - as with your previous stack trace, this is telling you what the problem is.

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/

4

Sorry, the error message was another file.

Now, correct trace …

INFO 10/03/16 15:15: liquibase: Successfully released change log lock Unexpected error running Liquibase: Error parsing line 15 column 51 of schema/sgrusr01_seq.xml: cvc-complex-type.2.4.a: Foi detectado um conteúdo inválido começando com o elemento ‘createSequence’. Era esperado um dos ‘{“http://www.liquibase.org/xml/ns/dbchangelog”:modifySql}’. SEVERE 10/03/16 15:15: liquibase: Error parsing line 15 column 51 of schema/sgrusr01_seq.xml: cvc-complex-type.2.4.a: Foi detectado um conteúdo inválido começando com o elemento ‘createSequence’. Era esperado um dos ‘{“http://www.liquibase.org/xml/ns/dbchangelog”:modifySql}’. liquibase.exception.ChangeLogParseException: liquibase.exception.SetupException: Error parsing line 15 column 51 of schema/sgrusr01_seq.xml: cvc-complex-type.2.4.a: Foi detectado um conteúdo inválido começando com o elemento ‘createSequence’. Era esperado um dos ‘{“http://www.liquibase.org/xml/ns/dbchangelog”:modifySql}’. at liquibase.parser.core.xml.AbstractChangeLogParser.parse(AbstractChangeLogParser.java:27) at liquibase.Liquibase.getDatabaseChangeLog(Liquibase.java:227) at liquibase.Liquibase.update(Liquibase.java:202) at liquibase.Liquibase.update(Liquibase.java:192) at liquibase.integration.commandline.Main.doMigration(Main.java:1096) at liquibase.integration.commandline.Main.run(Main.java:180) at liquibase.integration.commandline.Main.main(Main.java:99) Caused by: liquibase.exception.SetupException: Error parsing line 15 column 51 of schema/sgrusr01_seq.xml: cvc-complex-type.2.4.a: Foi detectado um conteúdo inválido começando com o elemento ‘createSequence’. Era esperado um dos ‘{“http://www.liquibase.org/xml/ns/dbchangelog”:modifySql}’. at liquibase.changelog.DatabaseChangeLog.handleChildNode(DatabaseChangeLog.java:269) at liquibase.changelog.DatabaseChangeLog.load(DatabaseChangeLog.java:230) at liquibase.parser.core.xml.AbstractChangeLogParser.parse(AbstractChangeLogParser.java:25) … 6 more

5

The file is in the first post …

6

I can not use changeSet > preConditions and tagDatabase! I do not understand why not use !

<?xml version="1.0" encoding="UTF-8"?> http://www.liquibase.org/xml/ns/dbchangelog"         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"         xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"         xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd         http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">                                                                         
7

What command(s) did you use?
liquibase.bat --changeLogFile=schema/latest.xml update

What did you expect to happen?
I hope to set a tagDatabase using changeSet and preconditions

What actually happened?
Unexpected error running Liquibase: Error parsing line 17 column 49 of /liquibase/schema/latest/sequences/sgrusr01_seq.xml: cvc-complex-type.2.4.a: Foi detectado um conteúdo inválido começando com o elemento ‘createSequence’. Era esperado um dos ‘{“http://www.liquibase.org/xml/ns/dbchangelog”:modifySql}’.

8

OK. So google translate says that this message:


" 
Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/