org.springframework.jdbc.BadSqlGrammarException

ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "bogustable" does not exist   Position: 1871

Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web292

  • via labkey.org by Unknown author, 10 months ago
    ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "bogustable" does not exist   Position: 1871
  • via labkey.org by Unknown author, 1 year ago
    ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "bogustable" does not exist   Position: 1871
  • via labkey.org by Unknown author, 11 months ago
    ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "bogustable" does not exist   Position: 1871
  • Stack trace

    • org.springframework.jdbc.BadSqlGrammarException: ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "bogustable" does not exist   Position: 1871 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276) at org.labkey.api.data.ExceptionFramework$1.translate(ExceptionFramework.java:37) at org.labkey.api.data.ExceptionFramework$1.translate(ExceptionFramework.java:31) at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.handleSqlException(SqlExecutingSelector.java:441) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:268) at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:121) at org.labkey.api.data.TableSelector.getResults(TableSelector.java:274) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:289) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:286) at org.labkey.api.data.AsyncQueryRequest$1.run(AsyncQueryRequest.java:109) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: ERROR: relation "bogustable" does not exist   Position: 1871 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:286) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.labkey.api.data.dialect.StatementWrapper.executeQuery(StatementWrapper.java:916) at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.executeQuery(SqlExecutingSelector.java:372) at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.getResultSet(SqlExecutingSelector.java:322) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:254) ... 6 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Once, 1 month ago
    Unknown user
    2 times, 5 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    2 times, 10 months ago
    94 more bugmates