# generateChangeLog problem

**URL:** <https://forum.liquibase.org/t/generatechangelog-problem/1276>\
**Category:** General Discussion\
**Created:** [May 17, 2011, 9:15pm UTC](https://forum.liquibase.org/t/generatechangelog-problem/1276 "2011-05-17T21:15:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [May 17, 2011, 9:15pm UTC](https://forum.liquibase.org/t/generatechangelog-problem/1276/1 "2011-05-17T21:15:00Z")

</div>

I have a very simple Sqlite3 database

one table, schema below

sqlite\> .tables

parameters

sqlite\> .schema parameters

CREATE TABLE parameters (

&nbsp; &nbsp; &nbsp; &nbsp; id INTEGER NOT NULL,

&nbsp; &nbsp; &nbsp; &nbsp; name VARCHAR NOT NULL,

&nbsp; &nbsp; &nbsp; &nbsp; fo\_transaction\_number INTEGER NOT NULL,

&nbsp; &nbsp; &nbsp; &nbsp; bo\_transaction\_number INTEGER NOT NULL,

&nbsp; &nbsp; &nbsp; &nbsp; max\_logon\_attempts INTEGER,

&nbsp; &nbsp; &nbsp; &nbsp; PRIMARY KEY (id)

);

I’m trying to do a generateChangeLog and I get the following

Any ideas?

H:\workspace\Perf\database\>“C:/Program Files/liquibase/liquibase.bat” --driver=o

rg.sqlite.JDBC --changeLogFile=changelog2.xml --url=jdbc:sqlite:test.db --classp

ath=sqlitejdbc-v056.jar generateChangeLog

INFO 17/05/11 13:34:liquibase: Reading tables for null @ jdbc:sqlite:test.db …

INFO 17/05/11 13:34:liquibase: Reading tables for null @ jdbc:sqlite:test.db …

INFO 17/05/11 13:34:liquibase: Reading foreign keys for null @ jdbc:sqlite:test.

db …

INFO 17/05/11 13:34:liquibase: Reading primary keys for null @ jdbc:sqlite:test.

db …

INFO 17/05/11 13:34:liquibase: Reading columns for null @ jdbc:sqlite:test.db …

.

Liquibase Update Failed: no such column: ‘DECIMAL\_POINTS’

SEVERE 17/05/11 13:34:liquibase: no such column: ‘DECIMAL\_POINTS’

liquibase.exception.DatabaseException: java.sql.SQLException: no such column: 'D

ECIMAL\_POINTS’

&nbsp; &nbsp; &nbsp; &nbsp; at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(J

dbcDatabaseSnapshotGenerator.java:251)

&nbsp; &nbsp; &nbsp; &nbsp; at liquibase.snapshot.DatabaseSnapshotGeneratorFactory.createSnapshot(Da

tabaseSnapshotGeneratorFactory.java:69)

&nbsp; &nbsp; &nbsp; &nbsp; at liquibase.diff.Diff.compare(Diff.java:63)

&nbsp; &nbsp; &nbsp; &nbsp; at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLo

g(CommandLineUtils.java:145)

&nbsp; &nbsp; &nbsp; &nbsp; at liquibase.integration.commandline.Main.doMigration(Main.java:624)

&nbsp; &nbsp; &nbsp; &nbsp; at liquibase.integration.commandline.Main.main(Main.java:116)

Caused by: java.sql.SQLException: no such column: ‘DECIMAL\_POINTS’

&nbsp; &nbsp; &nbsp; &nbsp; at org.sqlite.RS.findColumn(RS.java:116)

&nbsp; &nbsp; &nbsp; &nbsp; at org.sqlite.RS.getInt(RS.java:232)

&nbsp; &nbsp; &nbsp; &nbsp; at liquibase.snapshot.jvm.SQLiteDatabaseSnapshotGenerator.readColumnInfo

(SQLiteDatabaseSnapshotGenerator.java:291)

&nbsp; &nbsp; &nbsp; &nbsp; at liquibase.snapshot.jvm.SQLiteDatabaseSnapshotGenerator.readColumns(SQ

LiteDatabaseSnapshotGenerator.java:219)

&nbsp; &nbsp; &nbsp; &nbsp; at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(J

dbcDatabaseSnapshotGenerator.java:244)

&nbsp; &nbsp; &nbsp; &nbsp; … 5 more

For more information, use the --logLevel flag)

H:\workspace\Perf\database\>

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [May 17, 2011, 9:15pm UTC](https://forum.liquibase.org/t/generatechangelog-problem/1276/2 "2011-05-17T21:15:00Z")

</div>

I have same issue, does somebody know about it. After run:

java -jar liquibase-1.9.3.jar --driver=org.sqlite.JDBC --classpath=lib/sqlite-jdbc-3.7.2.jar --changeLogFile=core.xml&nbsp; --url=jdbc:sqlite:test.db&nbsp; generateChangeLog

&nbsp;

and I got:

Migration Failed: no such column: ‘DECIMAL\_POINTS’

&nbsp;

&nbsp;

Thanks a lot,

&nbsp;

yh