Hi Steve,

Any chance you can provide us with the full stack error?

Also, have you considered trying this on LabKey 17.2? It's possible you're encountering a bug from 17.1 that was fixed in the later version.

Regards,

Jon

(sighs)

Before I posted, I tried to generate cohorts this several times, stopped and restarted both tomcat and the postgres database all to no avail. Then I had a couple of days of panic preparing reports for a steering group meeting, only returning to it today to get you the java log.

And of course, it worked first time making me lots of nice disease centred cohorts for the whole genome study I'm working on.

Many apologies

Steve

Ok. It recurred.

500: Unexpected server error

ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column d.sequencenummin does not exist Hint: Perhaps you meant to reference the column "d.sequencenum". Position: 244

HOME BACK FOLDER
org.springframework.jdbc.BadSqlGrammarException: ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column d.sequencenummin does not exist
  Hint: Perhaps you meant to reference the column "d.sequencenum".
  Position: 244
       at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
       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:280)
       at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:140)
       at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:175)
       at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:159)
       at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:154)
       at org.labkey.study.model.CohortManager.updateCohorts(CohortManager.java:430)
       at org.labkey.study.model.CohortManager.updateParticipantCohorts(CohortManager.java:342)
       at org.labkey.study.model.CohortManager.setAutomaticCohortAssignment(CohortManager.java:84)
       at org.labkey.study.controllers.CohortController$ManageCohortsAction.handlePost(CohortController.java:206)
       at org.labkey.study.controllers.CohortController$ManageCohortsAction.handlePost(CohortController.java:113)
       at org.labkey.api.action.FormViewAction.handleRequest(FormViewAction.java:101)
       at org.labkey.api.action.FormViewAction.handleRequest(FormViewAction.java:80)
       at org.labkey.api.action.BaseViewAction.handleRequest(BaseViewAction.java:177)
       at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:415)
       at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:1213)
       at org.labkey.api.view.ViewServlet._service(ViewServlet.java:193)
       at org.labkey.api.view.ViewServlet.service(ViewServlet.java:127)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:38)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:1145)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:206)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
       at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
       at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
       at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
       at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
       at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
       at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
       at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
       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: column d.sequencenummin does not exist
  Hint: Perhaps you meant to reference the column "d.sequencenum".
  Position: 244
       at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
       at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
       at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
       at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
       at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
       at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
       at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)
       at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
       at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
       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:261)
       ... 51 more
DialectSQL = SELECT P.ParticipantId, -1 AS VisitRowId, -1 AS CohortId, D.casedisease
    FROM study.participant P
     LEFT OUTER JOIN studydataset.c52d619_participant_list D ON P.ParticipantId = D.participantid
    WHERE P.Container = ?
    ORDER BY P.ParticipantId, D.SequenceNumMin

request attributes
LABKEY.OriginalURL = http://localhost:8080/labkey/HICF2/Samples/cohort-manageCohorts.view?
LABKEY.StartTime = 1508414457309
LABKEY.action = manageCohorts
org.springframework.web.servlet.DispatcherServlet.CONTEXT = Study WebApplicationContext: startup date [Thu Oct 19 12:59:17 BST 2017]; parent: Root WebApplicationContext
LABKEY.controller = cohort
LABKEY.Counter = 0
X-LABKEY-CSRF = 657946aac71fb82443b321aef1da76be
LABKEY.container = /HICF2/Samples
LABKEY.RequestURL = /labkey/HICF2/Samples/cohort-manageCohorts.view?
LABKEY.OriginalURLHelper = /labkey/HICF2/Samples/cohort-manageCohorts.view?

core schema database configuration
Server URL    jdbc:postgresql://localhost/labkey
Product Name    PostgreSQL
Product Version    9.6.5
Driver Name    PostgreSQL Native Driver
Driver Version    PostgreSQL 9.4.1212

Hi Steve,

Thanks for providing the full stack.

Are you working with a Visit-Based, Date-Based, or Continuous Study here?

Regards,

Jon