org.springframework.jdbc.BadSqlGrammarException: ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "comm.Threads" does not exist Position: 681

LabKey Support Forum
org.springframework.jdbc.BadSqlGrammarException: ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "comm.Threads" does not exist Position: 681 atul sharma  2017-06-12 04:30
Status: Closed
 
org.springframework.jdbc.BadSqlGrammarException: ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "comm.Threads" does not exist
  Position: 681
       at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
       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:450)
       at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:277)
       at org.labkey.api.data.BaseSelector.getArrayList(BaseSelector.java:99)
       at org.labkey.api.data.BaseSelector.getArrayList(BaseSelector.java:94)
       at org.labkey.api.data.BaseSelector.getArray(BaseSelector.java:64)
       at org.labkey.announcements.model.AnnouncementManager.getBareAnnouncements(AnnouncementManager.java:156)
       at org.labkey.announcements.model.DiscussionServiceImpl.getDiscussions(DiscussionServiceImpl.java:112)
       at org.labkey.announcements.model.DiscussionServiceImpl.getDisussionArea(DiscussionServiceImpl.java:148)
       at org.labkey.announcements.model.DiscussionServiceImpl.getDisussionArea(DiscussionServiceImpl.java:141)
       at org.labkey.wiki.WikiController.getDiscussionView(WikiController.java:1277)
       at org.labkey.wiki.WikiController.access$1300(WikiController.java:131)
       at org.labkey.wiki.WikiController$PageAction.getView(WikiController.java:1233)
       at org.labkey.wiki.WikiController$PageAction.getView(WikiController.java:1144)
       at org.labkey.api.action.SimpleViewAction.handleRequest(SimpleViewAction.java:80)
       at org.labkey.api.action.BaseViewAction.handleRequest(BaseViewAction.java:178)
       at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:409)
       at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:1281)
       at org.labkey.api.view.ViewServlet._service(ViewServlet.java:190)
       at org.labkey.api.view.ViewServlet.service(ViewServlet.java:124)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
       at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
       at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:38)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
       at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
       at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:1144)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
       at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:205)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
       at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
       at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
       at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
       at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
       at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2517)
       at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2506)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
       at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
       at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "comm.Threads" does not exist
  Position: 681
       at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
       at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
       at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
       at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:622)
       at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:472)
       at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:386)
       at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
       at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
       at org.labkey.api.data.dialect.StatementWrapper.executeQuery(StatementWrapper.java:1157)
       at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.executeQuery(SqlExecutingSelector.java:391)
       at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.getResultSet(SqlExecutingSelector.java:331)
       at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:258)
       ... 51 more
DialectSQL = SELECT *
    FROM (
    SELECT
    Threads.RowId AS RowId,
    Threads.EntityId AS EntityId,
    Threads.CreatedBy AS CreatedBy,
    Threads.Created AS Created,
    Threads.ResponseCreatedBy AS ResponseCreatedBy,
    Threads.ResponseCreated AS ResponseCreated,
    Threads.AssignedTo AS AssignedTo,
    Threads.Container AS Container,
    Threads.Title AS Title,
    Threads.Body AS Body,
    Threads.RendererType AS RendererType,
    Threads.Expires AS Expires,
    Threads.Status AS Status,
    Threads.LatestId AS LatestId,
    Threads.discussionsrcidentifier AS discussionsrcidentifier,
    Threads.discussionsrcurl AS discussionsrcurl,
    Threads.ResponseCount AS ResponseCount,
    Threads.Modified AS Modified,
    Threads.LastIndexed AS LastIndexed
    FROM comm."Threads" Threads ) x
    WHERE (discussionsrcidentifier = ?) AND (Container = ?)
    ORDER BY Created ASC

request attributes
LABKEY.OriginalURL = http://172.21.34.151:8080/labkey/wiki/I2B2Demo1/page.view?name=default
LABKEY.StartTime = 1497266713804
LABKEY.action = page
LABKEY.controller = wiki
LABKEY.Counter = 0
X-LABKEY-CSRF = eebf3e22aa7eba4a21a10bb6b5d23718
LABKEY.container = /I2B2Demo1
LABKEY.RequestURL = /labkey/wiki/I2B2Demo1/page.view?name=default
LABKEY.OriginalURLHelper = /labkey/wiki/I2B2Demo1/page.view?name=default

core schema database configuration
Server URL    jdbc:postgresql://localhost:5432/labkey
Product Name    PostgreSQL
Product Version    9.5.3
Driver Name    PostgreSQL Native Driver
Driver Version    PostgreSQL 9.4.1207
 
 
Jon (LabKey DevOps) responded:  2017-06-12 12:18
Hello Atul,

What version and build of LabKey are you running?

Do you recall what you were doing before the error appeared? Are you able to retrigger the error to appear again? If so, can you give us the steps you took?

Regards,

Jon
 
Jon (LabKey DevOps) responded:  2017-06-12 12:48
Additionally, can you also provide us with your labkey.log file as well?

Regards,

Jon