500: Unexpected server error SqlExecutor.execute(); SQL []; ERROR: functions cannot have more than 100 arguments; nested exception is org.postgresql.util.PSQLException: ERROR: functions cannot have more than 100 arguments org.springframework.dao.DataAccessResourceFailureException: SqlExecutor.execute(); SQL []; ERROR: functions cannot have more than 100 arguments; nested exception is org.postgresql.util.PSQLException: ERROR: functions cannot have more than 100 arguments at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:117) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322) at org.labkey.api.data.ExceptionFramework$1.translate(ExceptionFramework.java:38) at org.labkey.api.data.ExceptionFramework$1.translate(ExceptionFramework.java:32) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:94) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:64) at org.labkey.api.data.StatementUtils.createStatement(StatementUtils.java:840) at org.labkey.api.data.StatementUtils.mergeStatement(StatementUtils.java:111) at org.labkey.api.etl.TableInsertDataIterator.init(TableInsertDataIterator.java:148) at org.labkey.api.etl.TableInsertDataIterator.onFirst(TableInsertDataIterator.java:179) at org.labkey.api.etl.StatementDataIterator._next(StatementDataIterator.java:216) at org.labkey.api.etl.StatementDataIterator.next(StatementDataIterator.java:192) at org.labkey.api.etl.TableInsertDataIterator.next(TableInsertDataIterator.java:41) at org.labkey.api.etl.Pump.run(Pump.java:63) at org.labkey.study.model.DataSetDefinition.insertData(DataSetDefinition.java:2392) at org.labkey.study.model.DataSetDefinition.importDatasetData(DataSetDefinition.java:1684) at org.labkey.study.model.StudyManager.importDatasetData(StudyManager.java:3076) at org.labkey.study.dataset.DatasetSnapshotProvider.createSnapshot(DatasetSnapshotProvider.java:221) at org.labkey.study.dataset.DatasetSnapshotProvider.createSnapshot(DatasetSnapshotProvider.java:332) at org.labkey.study.controllers.StudyController$CreateSnapshotAction.handlePost(StudyController.java:4957) at org.labkey.study.controllers.StudyController$CreateSnapshotAction.handlePost(StudyController.java:4776) at org.labkey.api.action.FormViewAction.handleRequest(FormViewAction.java:91) at org.labkey.api.action.FormViewAction.handleRequest(FormViewAction.java:75) at org.labkey.api.action.BaseViewAction.handleRequestInternal(BaseViewAction.java:178) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:370) at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:1007) at org.labkey.api.view.ViewServlet._service(ViewServlet.java:188) at org.labkey.api.view.ViewServlet.service(ViewServlet.java:122) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:1010) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:744) Caused by: org.postgresql.util.PSQLException: ERROR: functions cannot have more than 100 arguments at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.labkey.api.data.dialect.StatementWrapper.execute(StatementWrapper.java:1015) at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:121) at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:109) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:89) ... 56 more DialectSQL = CREATE FUNCTION temp.fn_31fc4b639fdb657b943e56c9e010e27b( _$p1createdBy INTEGER ,_$p2created TIMESTAMP ,_$p3lsid VARCHAR ,_$p4sequencenum DECIMAL ,_$p5sourcelsid VARCHAR ,_$p6qcstate INTEGER ,_$p7modifiedBy INTEGER ,_$p8date TIMESTAMP ,_$p9participantid VARCHAR ,_$p10_key VARCHAR ,_$p11participantsequencenum VARCHAR ,_$p12modified TIMESTAMP ,_$p13container VARCHAR ,_$p14specimenid VARCHAR ,_$p15rowid INTEGER ,_$p16stimcondition VARCHAR ,_$p17count DOUBLE PRECISION ,_$p18fscasscasubset_ct DOUBLE PRECISION ,_$p19fscasscasubset_pp DOUBLE PRECISION ,_$p20fscasscasubset_singlets_ct DOUBLE PRECISION ,_$p21fscasscasubset_singlets_pp DOUBLE PRECISION ,_$p22fscasscasubset_singlets_cd235p_ct DOUBLE PRECISION ,_$p23fscasscasubset_singlets_cd235p_pp DOUBLE PRECISION ,_$p24f605046457set_singlets_cd235nlndnlive_ct DOUBLE PRECISION ,_$p25f605046856set_singlets_cd235nlndnlive_pp DOUBLE PRECISION ,_$p26f1496190764s_cd235nlndnlive_cd3pcd14n_ct DOUBLE PRECISION ,_$p27f1496191163s_cd235nlndnlive_cd3pcd14n_pp DOUBLE PRECISION ,_$p28_cd4p_ct DOUBLE PRECISION ,_$p29_cd4p_pp DOUBLE PRECISION ,_$p30_cd4p_cd28pcd27pexcd27hi_ct DOUBLE PRECISION ,_$p31_cd4p_cd28pcd27pexcd27hi_pp DOUBLE PRECISION ,_$p32_cd4p_cd28pcd27pexcd27hi_cd45rapccr7p_ct DOUBLE PRECISION ,_$p33_cd4p_cd28pcd27pexcd27hi_cd45rapccr7p_pp DOUBLE PRECISION ,_$p34_cd4p_cd28pcd27pexcd27hi_cd45rapccr7n_ct DOUBLE PRECISION ,_$p35_cd4p_cd28pcd27pexcd27hi_cd45rapccr7n_pp DOUBLE PRECISION ,_$p36_cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_ct DOUBLE PRECISION ,_$p37_cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_pp DOUBLE PRECISION ,_$p38_66222561excd27hi_cd45ranccr7p_cxcr5p_ct DOUBLE PRECISION ,_$p39_66222960excd27hi_cd45ranccr7p_cxcr5p_pp DOUBLE PRECISION ,_$p40_cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_ct DOUBLE PRECISION ,_$p41_cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_pp DOUBLE PRECISION ,_$p42_1512641631cd27hi_cd45ranccr7n_cxcr5p_ct DOUBLE PRECISION ,_$p43_1512642030cd27hi_cd45ranccr7n_cxcr5p_pp DOUBLE PRECISION ,_$p44_cd4p_cd28pcd27pexcd27hi_ki67p_ct DOUBLE PRECISION ,_$p45_cd4p_cd28pcd27pexcd27hi_ki67p_pp DOUBLE PRECISION ,_$p46_cd4p_cd28pcd27pexcd27hi_ki67n_ct DOUBLE PRECISION ,_$p47_cd4p_cd28pcd27pexcd27hi_ki67n_pp DOUBLE PRECISION ,_$p48_cd4p_cd28ncd27n_ct DOUBLE PRECISION ,_$p49_cd4p_cd28ncd27n_pp DOUBLE PRECISION ,_$p50_cd4p_cd28ncd27n_cd45rapccr7p_ct DOUBLE PRECISION ,_$p51_cd4p_cd28ncd27n_cd45rapccr7p_pp DOUBLE PRECISION ,_$p52_cd4p_cd28ncd27n_cd45rapccr7n_ct DOUBLE PRECISION ,_$p53_cd4p_cd28ncd27n_cd45rapccr7n_pp DOUBLE PRECISION ,_$p54_cd4p_cd28ncd27n_cd45ranccr7p_ct DOUBLE PRECISION ,_$p55_cd4p_cd28ncd27n_cd45ranccr7p_pp DOUBLE PRECISION ,_$p56_cd4p_cd28ncd27n_cd45ranccr7p_cxcr5p_ct DOUBLE PRECISION ,_$p57_cd4p_cd28ncd27n_cd45ranccr7p_cxcr5p_pp DOUBLE PRECISION ,_$p58_cd4p_cd28ncd27n_cd45ranccr7n_ct DOUBLE PRECISION ,_$p59_cd4p_cd28ncd27n_cd45ranccr7n_pp DOUBLE PRECISION ,_$p60_cd4p_cd28ncd27n_cd45ranccr7n_cxcr5p_ct DOUBLE PRECISION ,_$p61_cd4p_cd28ncd27n_cd45ranccr7n_cxcr5p_pp DOUBLE PRECISION ,_$p62_cd4p_cd28ncd27n_ki67p_ct DOUBLE PRECISION ,_$p63_cd4p_cd28ncd27n_ki67p_pp DOUBLE PRECISION ,_$p64_cd4p_cd28ncd27n_ki67n_ct DOUBLE PRECISION ,_$p65_cd4p_cd28ncd27n_ki67n_pp DOUBLE PRECISION ,_$p66_cd4p_ki67p_ct DOUBLE PRECISION ,_$p67_cd4p_ki67p_pp DOUBLE PRECISION ,_$p68_cd4p_ki67n_ct DOUBLE PRECISION ,_$p69_cd4p_ki67n_pp DOUBLE PRECISION ,_$p70_cd8p_ct DOUBLE PRECISION ,_$p71_cd8p_pp DOUBLE PRECISION ,_$p72_cd8p_cd28pcd27pexcd27hi_ct DOUBLE PRECISION ,_$p73_cd8p_cd28pcd27pexcd27hi_pp DOUBLE PRECISION ,_$p74_cd8p_cd28pcd27pexcd27hi_cxcr3pccr7p_ct DOUBLE PRECISION ,_$p75_cd8p_cd28pcd27pexcd27hi_cxcr3pccr7p_pp DOUBLE PRECISION ,_$p76_cd8p_cd28pcd27pexcd27hi_cxcr3pccr7n_ct DOUBLE PRECISION ,_$p77_cd8p_cd28pcd27pexcd27hi_cxcr3pccr7n_pp DOUBLE PRECISION ,_$p78_cd8p_cd28pcd27pexcd27hi_cxcr3nccr7p_ct DOUBLE PRECISION ,_$p79_cd8p_cd28pcd27pexcd27hi_cxcr3nccr7p_pp DOUBLE PRECISION ,_$p80_cd8p_cd28pcd27pexcd27hi_cxcr3nccr7n_ct DOUBLE PRECISION ,_$p81_cd8p_cd28pcd27pexcd27hi_cxcr3nccr7n_pp DOUBLE PRECISION ,_$p82_cd8p_cd28pcd27pexcd27hi_ki67p_ct DOUBLE PRECISION ,_$p83_cd8p_cd28pcd27pexcd27hi_ki67p_pp DOUBLE PRECISION ,_$p84_cd8p_cd28pcd27pexcd27hi_ki67n_ct DOUBLE PRECISION ,_$p85_cd8p_cd28pcd27pexcd27hi_ki67n_pp DOUBLE PRECISION ,_$p86_cd8p_cd28ncd27n_ct DOUBLE PRECISION ,_$p87_cd8p_cd28ncd27n_pp DOUBLE PRECISION ,_$p88_cd8p_cd28ncd27n_cxcr3pccr7p_ct DOUBLE PRECISION ,_$p89_cd8p_cd28ncd27n_cxcr3pccr7p_pp DOUBLE PRECISION ,_$p90_cd8p_cd28ncd27n_cxcr3pccr7n_ct DOUBLE PRECISION ,_$p91_cd8p_cd28ncd27n_cxcr3pccr7n_pp DOUBLE PRECISION ,_$p92_cd8p_cd28ncd27n_cxcr3nccr7p_ct DOUBLE PRECISION ,_$p93_cd8p_cd28ncd27n_cxcr3nccr7p_pp DOUBLE PRECISION ,_$p94_cd8p_cd28ncd27n_cxcr3nccr7n_ct DOUBLE PRECISION ,_$p95_cd8p_cd28ncd27n_cxcr3nccr7n_pp DOUBLE PRECISION ,_$p96_cd8p_cd28ncd27n_ki67p_ct DOUBLE PRECISION ,_$p97_cd8p_cd28ncd27n_ki67p_pp DOUBLE PRECISION ,_$p98_cd8p_cd28ncd27n_ki67n_ct DOUBLE PRECISION ,_$p99_cd8p_cd28ncd27n_ki67n_pp DOUBLE PRECISION ,_$p100_cd8p_perforinpcd27n_ct DOUBLE PRECISION ,_$p101_cd8p_perforinpcd27n_pp DOUBLE PRECISION ,_$p102_cd8p_perforinpcd27n_gm DOUBLE PRECISION ,_$p103f250575660nglets_cd235nlndnlive_cd14p_ct DOUBLE PRECISION ,_$p104f250576059nglets_cd235nlndnlive_cd14p_pp DOUBLE PRECISION ) RETURNS void AS $$ BEGIN UPDATE studydataset."c31885358flow_tphe_gatesubset01_snapshot" SET createdby = _$p1createdBy, created = _$p2created, sequencenum = _$p4sequencenum, sourcelsid = _$p5sourcelsid, qcstate = _$p6qcstate, modifiedby = _$p7modifiedBy, date = _$p8date, participantid = _$p9participantid, _key = _$p10_key, participantsequencenum = _$p11participantsequencenum, modified = _$p12modified, specimenid = _$p14specimenid, rowid = _$p15rowid, stimcondition = _$p16stimcondition, count = _$p17count, fscasscasubset_ct = _$p18fscasscasubset_ct, fscasscasubset_pp = _$p19fscasscasubset_pp, fscasscasubset_singlets_ct = _$p20fscasscasubset_singlets_ct, fscasscasubset_singlets_pp = _$p21fscasscasubset_singlets_pp, fscasscasubset_singlets_cd235p_ct = _$p22fscasscasubset_singlets_cd235p_ct, fscasscasubset_singlets_cd235p_pp = _$p23fscasscasubset_singlets_cd235p_pp, fscasscasubset_singlets_cd235nlndnlive_ct = _$p24f605046457set_singlets_cd235nlndnlive_ct, fscasscasubset_singlets_cd235nlndnlive_pp = _$p25f605046856set_singlets_cd235nlndnlive_pp, fscasscasubset_singlets_cd235nlndnlive_cd3pcd14n_ct = _$p26f1496190764s_cd235nlndnlive_cd3pcd14n_ct, fscasscasubset_singlets_cd235nlndnlive_cd3pcd14n_pp = _$p27f1496191163s_cd235nlndnlive_cd3pcd14n_pp, _cd4p_ct = _$p28_cd4p_ct, _cd4p_pp = _$p29_cd4p_pp, _cd4p_cd28pcd27pexcd27hi_ct = _$p30_cd4p_cd28pcd27pexcd27hi_ct, _cd4p_cd28pcd27pexcd27hi_pp = _$p31_cd4p_cd28pcd27pexcd27hi_pp, _cd4p_cd28pcd27pexcd27hi_cd45rapccr7p_ct = _$p32_cd4p_cd28pcd27pexcd27hi_cd45rapccr7p_ct, _cd4p_cd28pcd27pexcd27hi_cd45rapccr7p_pp = _$p33_cd4p_cd28pcd27pexcd27hi_cd45rapccr7p_pp, _cd4p_cd28pcd27pexcd27hi_cd45rapccr7n_ct = _$p34_cd4p_cd28pcd27pexcd27hi_cd45rapccr7n_ct, _cd4p_cd28pcd27pexcd27hi_cd45rapccr7n_pp = _$p35_cd4p_cd28pcd27pexcd27hi_cd45rapccr7n_pp, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_ct = _$p36_cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_ct, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_pp = _$p37_cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_pp, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_cxcr5p_ct = _$p38_66222561excd27hi_cd45ranccr7p_cxcr5p_ct, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_cxcr5p_pp = _$p39_66222960excd27hi_cd45ranccr7p_cxcr5p_pp, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_ct = _$p40_cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_ct, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_pp = _$p41_cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_pp, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_cxcr5p_ct = _$p42_1512641631cd27hi_cd45ranccr7n_cxcr5p_ct, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_cxcr5p_pp = _$p43_1512642030cd27hi_cd45ranccr7n_cxcr5p_pp, _cd4p_cd28pcd27pexcd27hi_ki67p_ct = _$p44_cd4p_cd28pcd27pexcd27hi_ki67p_ct, _cd4p_cd28pcd27pexcd27hi_ki67p_pp = _$p45_cd4p_cd28pcd27pexcd27hi_ki67p_pp, _cd4p_cd28pcd27pexcd27hi_ki67n_ct = _$p46_cd4p_cd28pcd27pexcd27hi_ki67n_ct, _cd4p_cd28pcd27pexcd27hi_ki67n_pp = _$p47_cd4p_cd28pcd27pexcd27hi_ki67n_pp, _cd4p_cd28ncd27n_ct = _$p48_cd4p_cd28ncd27n_ct, _cd4p_cd28ncd27n_pp = _$p49_cd4p_cd28ncd27n_pp, _cd4p_cd28ncd27n_cd45rapccr7p_ct = _$p50_cd4p_cd28ncd27n_cd45rapccr7p_ct, _cd4p_cd28ncd27n_cd45rapccr7p_pp = _$p51_cd4p_cd28ncd27n_cd45rapccr7p_pp, _cd4p_cd28ncd27n_cd45rapccr7n_ct = _$p52_cd4p_cd28ncd27n_cd45rapccr7n_ct, _cd4p_cd28ncd27n_cd45rapccr7n_pp = _$p53_cd4p_cd28ncd27n_cd45rapccr7n_pp, _cd4p_cd28ncd27n_cd45ranccr7p_ct = _$p54_cd4p_cd28ncd27n_cd45ranccr7p_ct, _cd4p_cd28ncd27n_cd45ranccr7p_pp = _$p55_cd4p_cd28ncd27n_cd45ranccr7p_pp, _cd4p_cd28ncd27n_cd45ranccr7p_cxcr5p_ct = _$p56_cd4p_cd28ncd27n_cd45ranccr7p_cxcr5p_ct, _cd4p_cd28ncd27n_cd45ranccr7p_cxcr5p_pp = _$p57_cd4p_cd28ncd27n_cd45ranccr7p_cxcr5p_pp, _cd4p_cd28ncd27n_cd45ranccr7n_ct = _$p58_cd4p_cd28ncd27n_cd45ranccr7n_ct, _cd4p_cd28ncd27n_cd45ranccr7n_pp = _$p59_cd4p_cd28ncd27n_cd45ranccr7n_pp, _cd4p_cd28ncd27n_cd45ranccr7n_cxcr5p_ct = _$p60_cd4p_cd28ncd27n_cd45ranccr7n_cxcr5p_ct, _cd4p_cd28ncd27n_cd45ranccr7n_cxcr5p_pp = _$p61_cd4p_cd28ncd27n_cd45ranccr7n_cxcr5p_pp, _cd4p_cd28ncd27n_ki67p_ct = _$p62_cd4p_cd28ncd27n_ki67p_ct, _cd4p_cd28ncd27n_ki67p_pp = _$p63_cd4p_cd28ncd27n_ki67p_pp, _cd4p_cd28ncd27n_ki67n_ct = _$p64_cd4p_cd28ncd27n_ki67n_ct, _cd4p_cd28ncd27n_ki67n_pp = _$p65_cd4p_cd28ncd27n_ki67n_pp, _cd4p_ki67p_ct = _$p66_cd4p_ki67p_ct, _cd4p_ki67p_pp = _$p67_cd4p_ki67p_pp, _cd4p_ki67n_ct = _$p68_cd4p_ki67n_ct, _cd4p_ki67n_pp = _$p69_cd4p_ki67n_pp, _cd8p_ct = _$p70_cd8p_ct, _cd8p_pp = _$p71_cd8p_pp, _cd8p_cd28pcd27pexcd27hi_ct = _$p72_cd8p_cd28pcd27pexcd27hi_ct, _cd8p_cd28pcd27pexcd27hi_pp = _$p73_cd8p_cd28pcd27pexcd27hi_pp, _cd8p_cd28pcd27pexcd27hi_cxcr3pccr7p_ct = _$p74_cd8p_cd28pcd27pexcd27hi_cxcr3pccr7p_ct, _cd8p_cd28pcd27pexcd27hi_cxcr3pccr7p_pp = _$p75_cd8p_cd28pcd27pexcd27hi_cxcr3pccr7p_pp, _cd8p_cd28pcd27pexcd27hi_cxcr3pccr7n_ct = _$p76_cd8p_cd28pcd27pexcd27hi_cxcr3pccr7n_ct, _cd8p_cd28pcd27pexcd27hi_cxcr3pccr7n_pp = _$p77_cd8p_cd28pcd27pexcd27hi_cxcr3pccr7n_pp, _cd8p_cd28pcd27pexcd27hi_cxcr3nccr7p_ct = _$p78_cd8p_cd28pcd27pexcd27hi_cxcr3nccr7p_ct, _cd8p_cd28pcd27pexcd27hi_cxcr3nccr7p_pp = _$p79_cd8p_cd28pcd27pexcd27hi_cxcr3nccr7p_pp, _cd8p_cd28pcd27pexcd27hi_cxcr3nccr7n_ct = _$p80_cd8p_cd28pcd27pexcd27hi_cxcr3nccr7n_ct, _cd8p_cd28pcd27pexcd27hi_cxcr3nccr7n_pp = _$p81_cd8p_cd28pcd27pexcd27hi_cxcr3nccr7n_pp, _cd8p_cd28pcd27pexcd27hi_ki67p_ct = _$p82_cd8p_cd28pcd27pexcd27hi_ki67p_ct, _cd8p_cd28pcd27pexcd27hi_ki67p_pp = _$p83_cd8p_cd28pcd27pexcd27hi_ki67p_pp, _cd8p_cd28pcd27pexcd27hi_ki67n_ct = _$p84_cd8p_cd28pcd27pexcd27hi_ki67n_ct, _cd8p_cd28pcd27pexcd27hi_ki67n_pp = _$p85_cd8p_cd28pcd27pexcd27hi_ki67n_pp, _cd8p_cd28ncd27n_ct = _$p86_cd8p_cd28ncd27n_ct, _cd8p_cd28ncd27n_pp = _$p87_cd8p_cd28ncd27n_pp, _cd8p_cd28ncd27n_cxcr3pccr7p_ct = _$p88_cd8p_cd28ncd27n_cxcr3pccr7p_ct, _cd8p_cd28ncd27n_cxcr3pccr7p_pp = _$p89_cd8p_cd28ncd27n_cxcr3pccr7p_pp, _cd8p_cd28ncd27n_cxcr3pccr7n_ct = _$p90_cd8p_cd28ncd27n_cxcr3pccr7n_ct, _cd8p_cd28ncd27n_cxcr3pccr7n_pp = _$p91_cd8p_cd28ncd27n_cxcr3pccr7n_pp, _cd8p_cd28ncd27n_cxcr3nccr7p_ct = _$p92_cd8p_cd28ncd27n_cxcr3nccr7p_ct, _cd8p_cd28ncd27n_cxcr3nccr7p_pp = _$p93_cd8p_cd28ncd27n_cxcr3nccr7p_pp, _cd8p_cd28ncd27n_cxcr3nccr7n_ct = _$p94_cd8p_cd28ncd27n_cxcr3nccr7n_ct, _cd8p_cd28ncd27n_cxcr3nccr7n_pp = _$p95_cd8p_cd28ncd27n_cxcr3nccr7n_pp, _cd8p_cd28ncd27n_ki67p_ct = _$p96_cd8p_cd28ncd27n_ki67p_ct, _cd8p_cd28ncd27n_ki67p_pp = _$p97_cd8p_cd28ncd27n_ki67p_pp, _cd8p_cd28ncd27n_ki67n_ct = _$p98_cd8p_cd28ncd27n_ki67n_ct, _cd8p_cd28ncd27n_ki67n_pp = _$p99_cd8p_cd28ncd27n_ki67n_pp, _cd8p_perforinpcd27n_ct = _$p100_cd8p_perforinpcd27n_ct, _cd8p_perforinpcd27n_pp = _$p101_cd8p_perforinpcd27n_pp, _cd8p_perforinpcd27n_gm = _$p102_cd8p_perforinpcd27n_gm, fscasscasubset_singlets_cd235nlndnlive_cd14p_ct = _$p103f250575660nglets_cd235nlndnlive_cd14p_ct, fscasscasubset_singlets_cd235nlndnlive_cd14p_pp = _$p104f250576059nglets_cd235nlndnlive_cd14p_pp WHERE (container = _$p13container OR container IS NULL AND _$p13container IS NULL) AND (lsid = _$p3lsid OR lsid IS NULL AND _$p3lsid IS NULL); IF NOT FOUND THEN INSERT INTO studydataset."c31885358flow_tphe_gatesubset01_snapshot" (createdby, created, lsid, sequencenum, sourcelsid, qcstate, modifiedby, date, participantid, _key, participantsequencenum, modified, container, specimenid, rowid, stimcondition, count, fscasscasubset_ct, fscasscasubset_pp, fscasscasubset_singlets_ct, fscasscasubset_singlets_pp, fscasscasubset_singlets_cd235p_ct, fscasscasubset_singlets_cd235p_pp, fscasscasubset_singlets_cd235nlndnlive_ct, fscasscasubset_singlets_cd235nlndnlive_pp, fscasscasubset_singlets_cd235nlndnlive_cd3pcd14n_ct, fscasscasubset_singlets_cd235nlndnlive_cd3pcd14n_pp, _cd4p_ct, _cd4p_pp, _cd4p_cd28pcd27pexcd27hi_ct, _cd4p_cd28pcd27pexcd27hi_pp, _cd4p_cd28pcd27pexcd27hi_cd45rapccr7p_ct, _cd4p_cd28pcd27pexcd27hi_cd45rapccr7p_pp, _cd4p_cd28pcd27pexcd27hi_cd45rapccr7n_ct, _cd4p_cd28pcd27pexcd27hi_cd45rapccr7n_pp, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_ct, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_pp, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_cxcr5p_ct, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_cxcr5p_pp, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_ct, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_pp, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_cxcr5p_ct, _cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_cxcr5p_pp, _cd4p_cd28pcd27pexcd27hi_ki67p_ct, _cd4p_cd28pcd27pexcd27hi_ki67p_pp, _cd4p_cd28pcd27pexcd27hi_ki67n_ct, _cd4p_cd28pcd27pexcd27hi_ki67n_pp, _cd4p_cd28ncd27n_ct, _cd4p_cd28ncd27n_pp, _cd4p_cd28ncd27n_cd45rapccr7p_ct, _cd4p_cd28ncd27n_cd45rapccr7p_pp, _cd4p_cd28ncd27n_cd45rapccr7n_ct, _cd4p_cd28ncd27n_cd45rapccr7n_pp, _cd4p_cd28ncd27n_cd45ranccr7p_ct, _cd4p_cd28ncd27n_cd45ranccr7p_pp, _cd4p_cd28ncd27n_cd45ranccr7p_cxcr5p_ct, _cd4p_cd28ncd27n_cd45ranccr7p_cxcr5p_pp, _cd4p_cd28ncd27n_cd45ranccr7n_ct, _cd4p_cd28ncd27n_cd45ranccr7n_pp, _cd4p_cd28ncd27n_cd45ranccr7n_cxcr5p_ct, _cd4p_cd28ncd27n_cd45ranccr7n_cxcr5p_pp, _cd4p_cd28ncd27n_ki67p_ct, _cd4p_cd28ncd27n_ki67p_pp, _cd4p_cd28ncd27n_ki67n_ct, _cd4p_cd28ncd27n_ki67n_pp, _cd4p_ki67p_ct, _cd4p_ki67p_pp, _cd4p_ki67n_ct, _cd4p_ki67n_pp, _cd8p_ct, _cd8p_pp, _cd8p_cd28pcd27pexcd27hi_ct, _cd8p_cd28pcd27pexcd27hi_pp, _cd8p_cd28pcd27pexcd27hi_cxcr3pccr7p_ct, _cd8p_cd28pcd27pexcd27hi_cxcr3pccr7p_pp, _cd8p_cd28pcd27pexcd27hi_cxcr3pccr7n_ct, _cd8p_cd28pcd27pexcd27hi_cxcr3pccr7n_pp, _cd8p_cd28pcd27pexcd27hi_cxcr3nccr7p_ct, _cd8p_cd28pcd27pexcd27hi_cxcr3nccr7p_pp, _cd8p_cd28pcd27pexcd27hi_cxcr3nccr7n_ct, _cd8p_cd28pcd27pexcd27hi_cxcr3nccr7n_pp, _cd8p_cd28pcd27pexcd27hi_ki67p_ct, _cd8p_cd28pcd27pexcd27hi_ki67p_pp, _cd8p_cd28pcd27pexcd27hi_ki67n_ct, _cd8p_cd28pcd27pexcd27hi_ki67n_pp, _cd8p_cd28ncd27n_ct, _cd8p_cd28ncd27n_pp, _cd8p_cd28ncd27n_cxcr3pccr7p_ct, _cd8p_cd28ncd27n_cxcr3pccr7p_pp, _cd8p_cd28ncd27n_cxcr3pccr7n_ct, _cd8p_cd28ncd27n_cxcr3pccr7n_pp, _cd8p_cd28ncd27n_cxcr3nccr7p_ct, _cd8p_cd28ncd27n_cxcr3nccr7p_pp, _cd8p_cd28ncd27n_cxcr3nccr7n_ct, _cd8p_cd28ncd27n_cxcr3nccr7n_pp, _cd8p_cd28ncd27n_ki67p_ct, _cd8p_cd28ncd27n_ki67p_pp, _cd8p_cd28ncd27n_ki67n_ct, _cd8p_cd28ncd27n_ki67n_pp, _cd8p_perforinpcd27n_ct, _cd8p_perforinpcd27n_pp, _cd8p_perforinpcd27n_gm, fscasscasubset_singlets_cd235nlndnlive_cd14p_ct, fscasscasubset_singlets_cd235nlndnlive_cd14p_pp) VALUES (_$p1createdBy, _$p2created, _$p3lsid, _$p4sequencenum, _$p5sourcelsid, _$p6qcstate, _$p7modifiedBy, _$p8date, _$p9participantid, _$p10_key, _$p11participantsequencenum, _$p12modified, _$p13container, _$p14specimenid, _$p15rowid, _$p16stimcondition, _$p17count, _$p18fscasscasubset_ct, _$p19fscasscasubset_pp, _$p20fscasscasubset_singlets_ct, _$p21fscasscasubset_singlets_pp, _$p22fscasscasubset_singlets_cd235p_ct, _$p23fscasscasubset_singlets_cd235p_pp, _$p24f605046457set_singlets_cd235nlndnlive_ct, _$p25f605046856set_singlets_cd235nlndnlive_pp, _$p26f1496190764s_cd235nlndnlive_cd3pcd14n_ct, _$p27f1496191163s_cd235nlndnlive_cd3pcd14n_pp, _$p28_cd4p_ct, _$p29_cd4p_pp, _$p30_cd4p_cd28pcd27pexcd27hi_ct, _$p31_cd4p_cd28pcd27pexcd27hi_pp, _$p32_cd4p_cd28pcd27pexcd27hi_cd45rapccr7p_ct, _$p33_cd4p_cd28pcd27pexcd27hi_cd45rapccr7p_pp, _$p34_cd4p_cd28pcd27pexcd27hi_cd45rapccr7n_ct, _$p35_cd4p_cd28pcd27pexcd27hi_cd45rapccr7n_pp, _$p36_cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_ct, _$p37_cd4p_cd28pcd27pexcd27hi_cd45ranccr7p_pp, _$p38_66222561excd27hi_cd45ranccr7p_cxcr5p_ct, _$p39_66222960excd27hi_cd45ranccr7p_cxcr5p_pp, _$p40_cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_ct, _$p41_cd4p_cd28pcd27pexcd27hi_cd45ranccr7n_pp, _$p42_1512641631cd27hi_cd45ranccr7n_cxcr5p_ct, _$p43_1512642030cd27hi_cd45ranccr7n_cxcr5p_pp, _$p44_cd4p_cd28pcd27pexcd27hi_ki67p_ct, _$p45_cd4p_cd28pcd27pexcd27hi_ki67p_pp, _$p46_cd4p_cd28pcd27pexcd27hi_ki67n_ct, _$p47_cd4p_cd28pcd27pexcd27hi_ki67n_pp, _$p48_cd4p_cd28ncd27n_ct, _$p49_cd4p_cd28ncd27n_pp, _$p50_cd4p_cd28ncd27n_cd45rapccr7p_ct, _$p51_cd4p_cd28ncd27n_cd45rapccr7p_pp, _$p52_cd4p_cd28ncd27n_cd45rapccr7n_ct, _$p53_cd4p_cd28ncd27n_cd45rapccr7n_pp, _$p54_cd4p_cd28ncd27n_cd45ranccr7p_ct, _$p55_cd4p_cd28ncd27n_cd45ranccr7p_pp, _$p56_cd4p_cd28ncd27n_cd45ranccr7p_cxcr5p_ct, _$p57_cd4p_cd28ncd27n_cd45ranccr7p_cxcr5p_pp, _$p58_cd4p_cd28ncd27n_cd45ranccr7n_ct, _$p59_cd4p_cd28ncd27n_cd45ranccr7n_pp, _$p60_cd4p_cd28ncd27n_cd45ranccr7n_cxcr5p_ct, _$p61_cd4p_cd28ncd27n_cd45ranccr7n_cxcr5p_pp, _$p62_cd4p_cd28ncd27n_ki67p_ct, _$p63_cd4p_cd28ncd27n_ki67p_pp, _$p64_cd4p_cd28ncd27n_ki67n_ct, _$p65_cd4p_cd28ncd27n_ki67n_pp, _$p66_cd4p_ki67p_ct, _$p67_cd4p_ki67p_pp, _$p68_cd4p_ki67n_ct, _$p69_cd4p_ki67n_pp, _$p70_cd8p_ct, _$p71_cd8p_pp, _$p72_cd8p_cd28pcd27pexcd27hi_ct, _$p73_cd8p_cd28pcd27pexcd27hi_pp, _$p74_cd8p_cd28pcd27pexcd27hi_cxcr3pccr7p_ct, _$p75_cd8p_cd28pcd27pexcd27hi_cxcr3pccr7p_pp, _$p76_cd8p_cd28pcd27pexcd27hi_cxcr3pccr7n_ct, _$p77_cd8p_cd28pcd27pexcd27hi_cxcr3pccr7n_pp, _$p78_cd8p_cd28pcd27pexcd27hi_cxcr3nccr7p_ct, _$p79_cd8p_cd28pcd27pexcd27hi_cxcr3nccr7p_pp, _$p80_cd8p_cd28pcd27pexcd27hi_cxcr3nccr7n_ct, _$p81_cd8p_cd28pcd27pexcd27hi_cxcr3nccr7n_pp, _$p82_cd8p_cd28pcd27pexcd27hi_ki67p_ct, _$p83_cd8p_cd28pcd27pexcd27hi_ki67p_pp, _$p84_cd8p_cd28pcd27pexcd27hi_ki67n_ct, _$p85_cd8p_cd28pcd27pexcd27hi_ki67n_pp, _$p86_cd8p_cd28ncd27n_ct, _$p87_cd8p_cd28ncd27n_pp, _$p88_cd8p_cd28ncd27n_cxcr3pccr7p_ct, _$p89_cd8p_cd28ncd27n_cxcr3pccr7p_pp, _$p90_cd8p_cd28ncd27n_cxcr3pccr7n_ct, _$p91_cd8p_cd28ncd27n_cxcr3pccr7n_pp, _$p92_cd8p_cd28ncd27n_cxcr3nccr7p_ct, _$p93_cd8p_cd28ncd27n_cxcr3nccr7p_pp, _$p94_cd8p_cd28ncd27n_cxcr3nccr7n_ct, _$p95_cd8p_cd28ncd27n_cxcr3nccr7n_pp, _$p96_cd8p_cd28ncd27n_ki67p_ct, _$p97_cd8p_cd28ncd27n_ki67p_pp, _$p98_cd8p_cd28ncd27n_ki67n_ct, _$p99_cd8p_cd28ncd27n_ki67n_pp, _$p100_cd8p_perforinpcd27n_ct, _$p101_cd8p_perforinpcd27n_pp, _$p102_cd8p_perforinpcd27n_gm, _$p103f250575660nglets_cd235nlndnlive_cd14p_ct, _$p104f250576059nglets_cd235nlndnlive_cd14p_pp); END IF ; RETURN; END; $$ LANGUAGE plpgsql; request attributes LABKEY.StartTime = 1400078079008 LABKEY.action = createSnapshot org.labkey.flow.query.FlowSchema.3.231.flow.object$c6c76d22-5620-1031-9852-c606067c5e84 = org.labkey.flow.query.FlowSchema$TempTableToken@1adae0a0 org.springframework.web.servlet.DispatcherServlet.CONTEXT = org.labkey.api.module.SpringModule$1@171d5450: display name [Study WebApplicationContext]; startup date [Tue May 13 09:21:13 EDT 2014]; parent: org.springframework.web.context.support.XmlWebApplicationContext@57e6de6 javax.servlet.request.key_size = 128 LABKEY.controller = study javax.servlet.request.ssl_session = 2E3D84A7B1951AA25B8CB2EF05AF96CE8B45B5493D1077963D082051DFE63CB0 javax.servlet.request.ssl_session_id = 2E3D84A7B1951AA25B8CB2EF05AF96CE8B45B5493D1077963D082051DFE63CB0 LABKEY.container = /RPRC/Studies & Labs/KS PROP CB LABKEY.RequestURL = /labkey/study/RPRC/Studies%20%26%20Labs/KS%20PROP%20CB/createSnapshot.view?schemaName=study&query.queryName=Flow_TPHE_GateSubset01_Query&query.viewName=&datasetId=&redirectUrl=%252Flabkey%252Fquery%252FRPRC%252FStudies%252520%252526%252520Labs%252FKS%252520PROP%252520CB%252FexecuteQuery.view%253FschemaName%253Dstudy%2526query.queryName%253DFlow_TPHE_GateSubset01_Query&ff_snapshotName=Flow_TPHE_GateSubset01_Snapshot&ff_updateDelay=0&ff_snapshotDatasetId=5083 LABKEY.OriginalURLHelper = /labkey/study/RPRC/Studies%20%26%20Labs/KS%20PROP%20CB/createSnapshot.view?schemaName=study&query.queryName=Flow_TPHE_GateSubset01_Query&query.viewName=&datasetId=&redirectUrl=%252Flabkey%252Fquery%252FRPRC%252FStudies%252520%252526%252520Labs%252FKS%252520PROP%252520CB%252FexecuteQuery.view%253FschemaName%253Dstudy%2526query.queryName%253DFlow_TPHE_GateSubset01_Query&ff_snapshotName=Flow_TPHE_GateSubset01_Snapshot&ff_updateDelay=0&ff_snapshotDatasetId=5083 X-LABKEY-CSRF = 8861cc602f482532e867bc92c0124344 javax.servlet.request.cipher_suite = DHE-RSA-AES128-SHA org.labkey.flow.query.FlowSchema.1.231.flow.object$c6c76d22-5620-1031-9852-c606067c5e84 = org.labkey.flow.query.FlowSchema$TempTableToken@17d13626 LABKEY.Counter = 0 LABKEY.OriginalURL = https://blis-dev.urmc.rochester.edu/labkey/study/RPRC/Studies%20%26%20Labs/KS%20PROP%20CB/createSnapshot.view?schemaName=study&query.queryName=Flow_TPHE_GateSubset01_Query&query.viewName=&datasetId=&redirectUrl=%252Flabkey%252Fquery%252FRPRC%252FStudies%252520%252526%252520Labs%252FKS%252520PROP%252520CB%252FexecuteQuery.view%253FschemaName%253Dstudy%2526query.queryName%253DFlow_TPHE_GateSubset01_Query&ff_snapshotName=Flow_TPHE_GateSubset01_Snapshot&ff_updateDelay=0&ff_snapshotDatasetId=5083 core schema database configuration Server URL jdbc:postgresql://localhost/labkey Product Name PostgreSQL Product Version 9.3.2 Driver Name PostgreSQL Native Driver Driver Version PostgreSQL 9.3 JDBC4.1 (build 1100)