java.sql.SQLSyntaxErrorException: Table/View 'PEPTIDESHAKER_EXPERIMENT_SETTINGS' does not exist.

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • GitHub comment 95#149990730
    via GitHub by cdlawless
    ,
  • Derby Table Not Being Created
    via Stack Overflow by taraloca
    ,
  • hive 1.2.1 error on delete command
    via Stack Overflow by irakli2692
    ,
  • Derby "&" is not working
    via Stack Overflow by Dhruv Gurjar
    ,
  • From http://forum.liquibase.org/topic/broken-updatesql-functionality#49382000001007002 Generate SQL fails on 3.0.8/3.1.1 when the database is created from scratch(applying all changes on empty database). It works well on 3.0.3. Command : liquibase --logLevel=info --changeLogFile="changelog/changelog-master.xml" updateSQL Trace: INFO 1/30/14 11:21 AM:liquibase: Shutting down derby connection: jdbc:derby:/home/rraj/workspace/xyz;shutdown=true Liquibase updateSQL Failed: liquibase.exception.DatabaseException: Error executing SQL select min(locked) as test from APP.DATABASECHANGELOGLOCK fetch first row only: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. SEVERE 1/30/14 11:21 AM:liquibase: liquibase.exception.DatabaseException: Error executing SQL select min(locked) as test from APP.DATABASECHANGELOGLOCK fetch first row only: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL select min(locked) as test from APP.DATABASECHANGELOGLOCK fetch first row only: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:209) at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:148) at liquibase.Liquibase.update(Liquibase.java:249) at liquibase.Liquibase.update(Liquibase.java:236) at liquibase.integration.commandline.Main.doMigration(Main.java:894) at liquibase.integration.commandline.Main.main(Main.java:133) Caused by: liquibase.exception.DatabaseException: Error executing SQL select min(locked) as test from APP.DATABASECHANGELOGLOCK fetch first row only: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:61) at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:119) at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:127) at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:135) at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:146) at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:141) at liquibase.executor.LoggingExecutor.queryForObject(LoggingExecutor.java:118) at liquibase.lockservice.StandardLockService.init(StandardLockService.java:98) at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:182) ... 5 more Caused by: java.sql.SQLSyntaxErrorException: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source) at liquibase.executor.jvm.JdbcExecutor$QueryStatementCallback.doInStatement(JdbcExecutor.java:332) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:54) ... 13 more Caused by: java.sql.SQLException: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 23 more Caused by: ERROR 42X05: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source) at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ... 17 more
    via by Nathan Voxland,
  • Table/View STUDENT does not exist | DaniWeb
    via by Unknown author,
  • From http://forum.liquibase.org/topic/broken-updatesql-functionality#49382000001007002 Generate SQL fails on 3.0.8/3.1.1 when the database is created from scratch(applying all changes on empty database). It works well on 3.0.3. Command : liquibase --logLevel=info --changeLogFile="changelog/changelog-master.xml" updateSQL Trace: INFO 1/30/14 11:21 AM:liquibase: Shutting down derby connection: jdbc:derby:/home/rraj/workspace/xyz;shutdown=true Liquibase updateSQL Failed: liquibase.exception.DatabaseException: Error executing SQL select min(locked) as test from APP.DATABASECHANGELOGLOCK fetch first row only: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. SEVERE 1/30/14 11:21 AM:liquibase: liquibase.exception.DatabaseException: Error executing SQL select min(locked) as test from APP.DATABASECHANGELOGLOCK fetch first row only: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL select min(locked) as test from APP.DATABASECHANGELOGLOCK fetch first row only: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:209) at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:148) at liquibase.Liquibase.update(Liquibase.java:249) at liquibase.Liquibase.update(Liquibase.java:236) at liquibase.integration.commandline.Main.doMigration(Main.java:894) at liquibase.integration.commandline.Main.main(Main.java:133) Caused by: liquibase.exception.DatabaseException: Error executing SQL select min(locked) as test from APP.DATABASECHANGELOGLOCK fetch first row only: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:61) at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:119) at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:127) at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:135) at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:146) at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:141) at liquibase.executor.LoggingExecutor.queryForObject(LoggingExecutor.java:118) at liquibase.lockservice.StandardLockService.init(StandardLockService.java:98) at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:182) ... 5 more Caused by: java.sql.SQLSyntaxErrorException: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source) at liquibase.executor.jvm.JdbcExecutor$QueryStatementCallback.doInStatement(JdbcExecutor.java:332) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:54) ... 13 more Caused by: java.sql.SQLException: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 23 more Caused by: ERROR 42X05: Table/View 'APP.DATABASECHANGELOGLOCK' does not exist. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source) at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ... 17 more
    via by Nathan Voxland,
    • java.sql.SQLSyntaxErrorException: Table/View 'PEPTIDESHAKER_EXPERIMENT_SETTINGS' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source) at com.compomics.util.db.ObjectsDB.retrieveObjectSynchronized(ObjectsDB.java:801) at com.compomics.util.db.ObjectsDB.retrieveObject(ObjectsDB.java:750) at eu.isas.peptideshaker.fileimport.CpsFileImporter.getPeptideShakerSettings(CpsFileImporter.java:78) at eu.isas.peptideshaker.utils.CpsParent.loadCpsFile(CpsParent.java:245) at eu.isas.peptideshaker.gui.PeptideShakerGUI$104.run(PeptideShakerGUI.java:5461) Caused by: java.sql.SQLException: Table/View 'PEPTIDESHAKER_EXPERIMENT_SETTINGS' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 13 more

    Users with the same issue

    jf-ast
    jf-ast1 times, last one,
    stigkj
    stigkj1 times, last one,
    andyglick
    andyglick1 times, last one,
    davidvanlaatum
    davidvanlaatum1 times, last one,
    muffinmannen
    muffinmannen81 times, last one,
    1 more bugmates