liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission.

JIRA | Björn Engel | 3 years ago
  1. 0

    Running Liquibase 3.0.2 on Informix fails. The same execution with Liquibase 2.0.5 works... jdbc-url: jdbc:informix-sqli://<server>:<port>/<database>:INFORMIXSERVER=<informix-server>;DB_LOCALE=en_us.utf8;GL_DATE=Y4MD-;DBDATE=Y4MD-; INFO 17.07.13 10:42:liquibase: Successfully released change log lock SEVERE 17.07.13 10:42:liquibase: Unable to release lock: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission. [ERROR] java.sql.SQLException: Database not found or no system permission. liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission. at liquibase.snapshot.jvm.TableSnapshotGenerator.snapshotObject(TableSnapshotGenerator.java:45) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:59) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:75) at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:128) at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:139) at liquibase.snapshot.SnapshotGeneratorFactory.getDatabaseChangeLogTable(SnapshotGeneratorFactory.java:146) at liquibase.database.core.InformixDatabase.checkDatabaseChangeLogTable(InformixDatabase.java:191) at liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:602) at liquibase.Liquibase.forceReleaseLocks(Liquibase.java:640) at org.liquibase.maven.plugins.AbstractLiquibaseMojo.cleanup(AbstractLiquibaseMojo.java:475) at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:331) at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59) at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183) at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156) at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537) at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196) at org.apache.maven.cli.MavenCli.main(MavenCli.java:141) 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 org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352) Caused by: java.sql.SQLException: Database not found or no system permission. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397) at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3244) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3553) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2380) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2295) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1461) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1434) at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:205) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1228) at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:243) at com.informix.jdbc.IfxDatabaseMetaData.getTables(IfxDatabaseMetaData.java:2967) at liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getTables(JdbcDatabaseSnapshot.java:173) at liquibase.snapshot.jvm.TableSnapshotGenerator.snapshotObject(TableSnapshotGenerator.java:33) ... 44 more Caused by: java.sql.SQLException: ISAM error: no record found. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3558) ... 54 more

    JIRA | 3 years ago | Björn Engel
    liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission.
  2. 0

    Running Liquibase 3.0.2 on Informix fails. The same execution with Liquibase 2.0.5 works... jdbc-url: jdbc:informix-sqli://<server>:<port>/<database>:INFORMIXSERVER=<informix-server>;DB_LOCALE=en_us.utf8;GL_DATE=Y4MD-;DBDATE=Y4MD-; INFO 17.07.13 10:42:liquibase: Successfully released change log lock SEVERE 17.07.13 10:42:liquibase: Unable to release lock: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission. [ERROR] java.sql.SQLException: Database not found or no system permission. liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission. at liquibase.snapshot.jvm.TableSnapshotGenerator.snapshotObject(TableSnapshotGenerator.java:45) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:59) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:75) at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:128) at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:139) at liquibase.snapshot.SnapshotGeneratorFactory.getDatabaseChangeLogTable(SnapshotGeneratorFactory.java:146) at liquibase.database.core.InformixDatabase.checkDatabaseChangeLogTable(InformixDatabase.java:191) at liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:602) at liquibase.Liquibase.forceReleaseLocks(Liquibase.java:640) at org.liquibase.maven.plugins.AbstractLiquibaseMojo.cleanup(AbstractLiquibaseMojo.java:475) at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:331) at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59) at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183) at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156) at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537) at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196) at org.apache.maven.cli.MavenCli.main(MavenCli.java:141) 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 org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352) Caused by: java.sql.SQLException: Database not found or no system permission. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397) at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3244) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3553) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2380) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2295) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1461) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1434) at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:205) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1228) at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:243) at com.informix.jdbc.IfxDatabaseMetaData.getTables(IfxDatabaseMetaData.java:2967) at liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getTables(JdbcDatabaseSnapshot.java:173) at liquibase.snapshot.jvm.TableSnapshotGenerator.snapshotObject(TableSnapshotGenerator.java:33) ... 44 more Caused by: java.sql.SQLException: ISAM error: no record found. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3558) ... 54 more

    JIRA | 3 years ago | Björn Engel
    liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission.
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Informix: Error - Code set not supported

    schemaspy | 1 decade ago | rkraeutle
    java.sql.SQLException: Encoding or code set not supported.
  5. 0

    JPA Transactions on Informix

    Stack Overflow | 4 years ago | Alejandro Hdez. Angeles
    java.sql.SQLException: Transactions not supported Error Code: -79744 Query: DataModifyQuery(sql="update tg_proteccion_cv set i_eq_validados=?, i_eq_a_protegidos=? where v_id_proteccion=? and v_cve_cliente=?")

    9 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. java.sql.SQLException

      ISAM error: no record found.

      at com.informix.util.IfxErrMsg.getSQLException()
    2. com.informix.util
      IfxErrMsg.getSQLException
      1. com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397)
      1 frame
    3. com.informix.jdbc
      IfxDatabaseMetaData.getTables
      1. com.informix.jdbc.IfxSqli.E(IfxSqli.java:3558)
      2. com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2380)
      3. com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2295)
      4. com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1461)
      5. com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1434)
      6. com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:205)
      7. com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1228)
      8. com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:243)
      9. com.informix.jdbc.IfxDatabaseMetaData.getTables(IfxDatabaseMetaData.java:2967)
      9 frames
    4. Liquibase Core
      Liquibase.forceReleaseLocks
      1. liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getTables(JdbcDatabaseSnapshot.java:173)
      2. liquibase.snapshot.jvm.TableSnapshotGenerator.snapshotObject(TableSnapshotGenerator.java:33)
      3. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:59)
      4. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      5. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62)
      6. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      7. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62)
      8. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      9. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62)
      10. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      11. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62)
      12. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      13. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62)
      14. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      15. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62)
      16. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      17. liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:75)
      18. liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:128)
      19. liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:139)
      20. liquibase.snapshot.SnapshotGeneratorFactory.getDatabaseChangeLogTable(SnapshotGeneratorFactory.java:146)
      21. liquibase.database.core.InformixDatabase.checkDatabaseChangeLogTable(InformixDatabase.java:191)
      22. liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:602)
      23. liquibase.Liquibase.forceReleaseLocks(Liquibase.java:640)
      23 frames
    5. org.liquibase.maven
      AbstractLiquibaseMojo.execute
      1. org.liquibase.maven.plugins.AbstractLiquibaseMojo.cleanup(AbstractLiquibaseMojo.java:475)
      2. org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:331)
      2 frames
    6. Maven Plugin
      DefaultBuildPluginManager.executeMojo
      1. org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)
      1 frame
    7. Maven Core
      DefaultMaven.execute
      1. org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
      2. org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
      3. org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
      4. org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
      5. org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
      6. org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
      7. org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
      8. org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
      9. org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
      9 frames
    8. M3 Interceptor
      MavenCli.main
      1. org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
      2. org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
      3. org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
      3 frames
    9. 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
    10. Plexus
      Launcher.main
      1. org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
      2. org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
      3. org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
      4. org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
      4 frames