Name sybfi8_1 is reserved for internal use by Adaptive Server

General Discussion
1

Liquibase is tryign to call “SELECT {SOME COLUMN} from {SOME TABLE} where 0=1” in order to determine if a column is autoincrement. I’m not sure if sybfi8_1 is a table or a column but it must not be liking that SQL. 


Do you know off hand what the table/column is for?


Nathan

2

I am using liquibase-2.0.4 + liquibase-sybase-2.0.4 on RHEL 5.5

I run into the following error whilst trying to generate the initial change log file init.xml

 

[root@server]# java -jar /usr/lib64/liquibase/liquibase.jar --classpath=/usr/lib64/liquibase/lib/jtds-1.2.5.jar --changeLogFile=changes.xml generateChangeLog > init.xml ;

 

INFO 6/8/12 1:06 PM:liquibase: Reading tables for aartfuser @ jdbc:jtds:sybase://ukubs-q01-syb24.uk.ftse.com:5700/world_index10 …
INFO 6/8/12 1:06 PM:liquibase: Reading views for aartfuser @ jdbc:jtds:sybase://ukubs-q01-syb24.uk.ftse.com:5700/world_index10 …
INFO 6/8/12 1:06 PM:liquibase: Reading foreign keys for aartfuser @ jdbc:jtds:sybase://ukubs-q01-syb24.uk.ftse.com:5700/world_index10 …
INFO 6/8/12 1:07 PM:liquibase: Reading primary keys for aartfuser @ jdbc:jtds:sybase://ukubs-q01-syb24.uk.ftse.com:5700/world_index10 …
INFO 6/8/12 1:07 PM:liquibase: Reading columns for aartfuser @ jdbc:jtds:sybase://ukubs-q01-syb24.uk.ftse.com:5700/world_index10 …
Liquibase Update Failed: Name ‘sybfi8_1’ is reserved for internal use by Adaptive Server. Please use a different name.

SEVERE 6/8/12 1:07 PM:liquibase: Name ‘sybfi8_1’ is reserved for internal use by Adaptive Server. Please use a different name.

liquibase.exception.DatabaseException: java.sql.SQLException: Name ‘sybfi8_1’ is reserved for internal use by Adaptive Server. Please use a different name.

        at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:251)
        at liquibase.snapshot.DatabaseSnapshotGeneratorFactory.createSnapshot(DatabaseSnapshotGeneratorFactory.java:69)
        at liquibase.diff.Diff.compare(Diff.java:63)
        at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:145)
        at liquibase.integration.commandline.Main.doMigration(Main.java:756)
        at liquibase.integration.commandline.Main.main(Main.java:134)
Caused by: java.sql.SQLException: Name ‘sybfi8_1’ is reserved for internal use by Adaptive Server. Please use a different name.

        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1304)
        at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.isColumnAutoIncrement(JdbcDatabaseSnapshotGenerator.java:842)
        at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readColumns(JdbcDatabaseSnapshotGenerator.java:369)
        at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:244)
        … 5 more


For more information, use the --logLevel flag)

3

Thanks for responding Nathan,

 

I showed this to a DBA, and he explained to me that liquibase cannot export the Stored Procedures & Funtions from an existing database.

 

I see from other postings in this forum that this functionality is in the pipeline for v2.1.x but has a low priority right now.

 

Thanks.

 

Jay.