Informix generateChangeLog issue

un1382561729492r88id · February 17, 2015, 3:04pm

Unlikely to be a Liquibase bug. Try running with --logLevel=debug. If you can’t figure out the problem with that, make sure your reply has details on what command you did as well as the debug output.

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

siddharthmoona · February 17, 2015, 3:04pm

I am using Liquibase version 3.3.2 to create a changelog for my existing Informix DB using the generateChangeLog command.

The changelog.xml (483 Kb) is created successfully but contains no changesets! I have tried using other versions of Liquibase but no success. Is it a Liquibase bug?

Thanks in advance for the help.

Here is how the changelog.xml looks like -

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

un1424155090489r35id · February 17, 2015, 3:04pm

Hi Steve,

Here is the command -

liquibase --changeLogFile=changelog.xml --url=“jdbc:informix-sqli://172.28.137.182:9088/glsnextgen:informixserver=testgif” --username=abc --password=abc --logLevel=debug --logFile=log.txt generateChangeLog

Liquibase ‘generateChangeLog’ Successful

Here is the debug output -

DEBUG 18/2/15 10:37 AM: liquibase: Connected to santhosh@jdbc:informix-sqli://172.28.137.182:9088/glsnextgen:informixserver=testgif

DEBUG 18/2/15 10:37 AM: liquibase: Setting auto commit to false from true

DEBUG 18/2/15 10:37 AM: liquibase: Executing EXECUTE database command: EXECUTE PROCEDURE IFX_ALLOW_NEWLINE(‘T’);

INFO 18/2/15 10:37 AM: liquibase: Error getting default schema

liquibase.exception.DatabaseException: Error executing SQL call current_schema: A syntax error has occurred.

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:103)

at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:132)

at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:143)

at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:151)

at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:166)

at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:161)

at liquibase.database.AbstractJdbcDatabase.getConnectionSchemaName(AbstractJdbcDatabase.java:318)

at liquibase.database.AbstractJdbcDatabase.getDefaultSchemaName(AbstractJdbcDatabase.java:301)

at liquibase.CatalogAndSchema.customize(CatalogAndSchema.java:132)

at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:116)

at liquibase.command.DiffCommand.createReferenceSnapshot(DiffCommand.java:190)

at liquibase.command.DiffCommand.createDiffResult(DiffCommand.java:140)

at liquibase.command.GenerateChangeLogCommand.run(GenerateChangeLogCommand.java:45)

at liquibase.command.AbstractCommand.execute(AbstractCommand.java:8)

at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:153)

at liquibase.integration.commandline.Main.doMigration(Main.java:939)

at liquibase.integration.commandline.Main.run(Main.java:177)

at liquibase.integration.commandline.Main.main(Main.java:96)

Caused by: java.sql.SQLException: A syntax error has occurred.

at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)

at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3208)

at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518)

at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2353)

at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2269)

at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1153)

at com.informix.jdbc.IfxPreparedStatement.e(IfxPreparedStatement.java:318)

at com.informix.jdbc.IfxCallableStatement.(IfxCallableStatement.java:132)

at com.informix.jdbc.IfxSqliConnect.i(IfxSqliConnect.java:5932)

at com.informix.jdbc.IfxSqliConnect.prepareCall(IfxSqliConnect.java:2140)

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:95)

… 17 more

Caused by: java.sql.SQLException

at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)

at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3523)

… 25 more

DEBUG 18/2/15 10:37 AM: liquibase: Computed checksum for 1424236030375 as 9bac50feef8f4d4b1c1f6d291ac63b0a