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 |
||