Server error upon automatic cohort creation | WayneH | 2017-10-11 10:54 |
Status: Closed | ||
When we try to run automatic cohort creation in one of our projects we get the follow error. Cannot determine why the system is throwing the error or how to solve it. Any thoughts? ----------------------------------------------- 500: Unexpected server error ExecutingSelector; bad SQL grammar []; nested exception is java.sql.SQLException: Invalid column name 'SequenceNumMin'. ... Caused by: java.sql.SQLException: Invalid column name 'SequenceNumMin'. ... DialectSQL = SELECT P.ParticipantId, -1 AS VisitRowId, -1 AS CohortId, D.SF_ID FROM study.Participant P LEFT OUTER JOIN studyDataset.c192d2018_ehas_hhq_y1_v2 D ON P.ParticipantId = D.participantid WHERE P.Container = ? ORDER BY P.ParticipantId, D.SequenceNumMin request attributes LABKEY.StartTime = 1507738377833 org.springframework.web.servlet.DispatcherServlet.CONTEXT = Study WebApplicationContext: startup date [Tue Oct 10 14:28:24 EDT 2017]; parent: Root WebApplicationContext org.apache.tomcat.util.net.secure_protocol_version = TLSv1.2 LABKEY.Counter = 0 javax.servlet.request.key_size = 0 LABKEY.container = /DHO_Healthy Aging_Workspace/Petek LABKEY.RequestURL = /cohort/DHO_Healthy%20Aging_Workspace/Petek/manageCohorts.view? javax.servlet.request.cipher_suite = TLS_DHE_RSA_WITH_AES_128_GCM_SHA256 javax.servlet.request.ssl_session_id = 59de423a4d73764c18388ad10081980b4856c769d34aa680568ffe7565803504 LABKEY.OriginalURL = https://labkeydev.emory.edu/cohort/DHO_Healthy%20Aging_Workspace/Petek/manageCohorts.view? LABKEY.action = manageCohorts LABKEY.controller = cohort javax.servlet.request.ssl_session = 59de423a4d73764c18388ad10081980b4856c769d34aa680568ffe7565803504 X-LABKEY-CSRF = c8c52fb8915ea679e401534fe0cd8888 LABKEY.OriginalURLHelper = /cohort/DHO_Healthy%20Aging_Workspace/Petek/manageCohorts.view? javax.servlet.request.ssl_session_mgr = org.apache.tomcat.util.net.jsse.JSSESupport@7acb3d01 ... |
||