WARN MapDataIterator 2018-07-23 10:55:18,110 http-bio-8443-exec-20 : Map already has column named 'ParticipantId' WARN MapDataIterator 2018-07-23 10:55:56,174 http-bio-8443-exec-6 : Map already has column named 'ParticipantId' WARN MapDataIterator 2018-07-23 10:56:39,133 http-bio-8443-exec-19 : Map already has column named 'ParticipantId' WARN MapDataIterator 2018-07-23 10:57:14,600 http-bio-8443-exec-17 : Map already has column named 'ParticipantId' WARN MapDataIterator 2018-07-23 10:57:51,335 http-bio-8443-exec-12 : Map already has column named 'ParticipantId' ERROR Table 2018-07-23 10:58:02,189 http-bio-8443-exec-12 : SQL Exception java.sql.SQLException: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.labkey.api.data.dialect.StatementWrapper.execute(StatementWrapper.java:1506) at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:168) at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:144) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:122) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:75) at org.labkey.study.visitmanager.SequenceVisitManager._updateVisitRowId(SequenceVisitManager.java:480) at org.labkey.study.visitmanager.SequenceVisitManager.updateVisitTable(SequenceVisitManager.java:512) at org.labkey.study.visitmanager.VisitManager.updateParticipantVisits(VisitManager.java:153) at org.labkey.study.query.DatasetUpdateService.resyncStudy(DatasetUpdateService.java:344) at org.labkey.study.query.DatasetUpdateService.resyncStudy(DatasetUpdateService.java:325) at org.labkey.study.query.DatasetUpdateService.insertRows(DatasetUpdateService.java:148) at org.labkey.query.controllers.QueryController$CommandType$1.saveRows(QueryController.java:3201) at org.labkey.query.controllers.QueryController$BaseSaveRowsAction.executeJson(QueryController.java:3415) at org.labkey.query.controllers.QueryController$InsertRowsAction.execute(QueryController.java:3494) at org.labkey.query.controllers.QueryController$InsertRowsAction.execute(QueryController.java:3487) at org.labkey.api.action.ApiAction.handlePost(ApiAction.java:180) at org.labkey.api.action.ApiAction.handleRequest(ApiAction.java:125) 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:1208) 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:206) 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:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) 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) ERROR Table 2018-07-23 10:58:02,192 http-bio-8443-exec-12 : SQL [63] WITH seqnum2visit AS ( SELECT SequenceNum, CASE WHEN SequenceNum < 2501.0 THEN CASE WHEN SequenceNum < 626.0 THEN CASE WHEN SequenceNum < 157.0 THEN CASE WHEN SequenceNum < 40.0 THEN CASE WHEN SequenceNum < 10.0 THEN CASE SequenceNum WHEN 1.0 THEN 1935 WHEN 2.0 THEN 1936 WHEN 3.0 THEN 1937 WHEN 4.0 THEN 1938 WHEN 5.0 THEN 1939 WHEN 6.0 THEN 1940 WHEN 7.0 THEN 1892 WHEN 8.0 THEN 1941 WHEN 9.0 THEN 1942 ELSE -1 END WHEN SequenceNum < 20.0 THEN CASE SequenceNum WHEN 10.0 THEN 1943 WHEN 11.0 THEN 1944 WHEN 12.0 THEN 1945 WHEN 13.0 THEN 1946 WHEN 14.0 THEN 1893 WHEN 15.0 THEN 1947 WHEN 16.0 THEN 1948 WHEN 17.0 THEN 1949 WHEN 18.0 THEN 1950 WHEN 19.0 THEN 1951 ELSE -1 END (…) END ELSE CASE SequenceNum WHEN 9991.0 THEN 17843 WHEN 9992.0 THEN 17844 WHEN 9993.0 THEN 17845 WHEN 9994.0 THEN 17846 WHEN 9995.0 THEN 17847 WHEN 9996.0 THEN 17848 WHEN 9997.0 THEN 17849 WHEN 9998.0 THEN 17850 WHEN 9999.0 THEN 17851 WHEN 10000.0 THEN 17852 ELSE -1 END END END END END END AS RowId FROM (SELECT DISTINCT SequenceNum FROM study.ParticipantVisit WHERE Container = ?) seqnumPV) UPDATE PV SET VisitRowId = RowId FROM study.ParticipantVisit PV WITH (INDEX(IX_PV_SequenceNum)), seqnum2visit WHERE seqnum2visit.SequenceNum = PV.SequenceNum AND PV.Container = ? AND seqnum2visit.RowId <> VisitRowId ?[1] org.labkey.api.data.Container@1098342026 /Cognitive Neurology/ApoE Assay/ 885CB551-5DC4-1035-A4DD-DC23B09EBC20 ?[2] org.labkey.api.data.Container@1098342026 /Cognitive Neurology/ApoE Assay/ 885CB551-5DC4-1035-A4DD-DC23B09EBC20 org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:126) org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:75) org.labkey.study.visitmanager.SequenceVisitManager._updateVisitRowId(SequenceVisitManager.java:480) org.labkey.study.visitmanager.SequenceVisitManager.updateVisitTable(SequenceVisitManager.java:512) org.labkey.study.visitmanager.VisitManager.updateParticipantVisits(VisitManager.java:153) ERROR ExceptionUtil 2018-07-23 10:58:02,208 http-bio-8443-exec-12 : Exception detected and logged to mothership org.springframework.dao.TransientDataAccessResourceException: SqlExecutor.execute(); SQL []; Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.; nested exception is java.sql.SQLException: I nternal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106) 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.SqlExecutor.execute(SqlExecutor.java:129) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:75) at org.labkey.study.visitmanager.SequenceVisitManager._updateVisitRowId(SequenceVisitManager.java:480) at org.labkey.study.visitmanager.SequenceVisitManager.updateVisitTable(SequenceVisitManager.java:512) at org.labkey.study.visitmanager.VisitManager.updateParticipantVisits(VisitManager.java:153) at org.labkey.study.query.DatasetUpdateService.resyncStudy(DatasetUpdateService.java:344) at org.labkey.study.query.DatasetUpdateService.resyncStudy(DatasetUpdateService.java:325) at org.labkey.study.query.DatasetUpdateService.insertRows(DatasetUpdateService.java:148) at org.labkey.query.controllers.QueryController$CommandType$1.saveRows(QueryController.java:3201) at org.labkey.query.controllers.QueryController$BaseSaveRowsAction.executeJson(QueryController.java:3415) at org.labkey.query.controllers.QueryController$InsertRowsAction.execute(QueryController.java:3494) at org.labkey.query.controllers.QueryController$InsertRowsAction.execute(QueryController.java:3487) at org.labkey.api.action.ApiAction.handlePost(ApiAction.java:180) at org.labkey.api.action.ApiAction.handleRequest(ApiAction.java:125) 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:1208) 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:206) 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:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) 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: java.sql.SQLException: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.labkey.api.data.dialect.StatementWrapper.execute(StatementWrapper.java:1506) at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:168) at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:144) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:122) ... 51 more ERROR ApiAction 2018-07-23 10:58:02,208 http-bio-8443-exec-12 : ApiAction exception: org.springframework.dao.TransientDataAccessResourceException: SqlExecutor.execute(); SQL []; Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.; nested exception is java.sql.SQLException: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106) 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.SqlExecutor.execute(SqlExecutor.java:129) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:75) at org.labkey.study.visitmanager.SequenceVisitManager._updateVisitRowId(SequenceVisitManager.java:480) at org.labkey.study.visitmanager.SequenceVisitManager.updateVisitTable(SequenceVisitManager.java:512) at org.labkey.study.visitmanager.VisitManager.updateParticipantVisits(VisitManager.java:153) at org.labkey.study.query.DatasetUpdateService.resyncStudy(DatasetUpdateService.java:344) at org.labkey.study.query.DatasetUpdateService.resyncStudy(DatasetUpdateService.java:325) at org.labkey.study.query.DatasetUpdateService.insertRows(DatasetUpdateService.java:148) at org.labkey.query.controllers.QueryController$CommandType$1.saveRows(QueryController.java:3201) at org.labkey.query.controllers.QueryController$BaseSaveRowsAction.executeJson(QueryController.java:3415) at org.labkey.query.controllers.QueryController$InsertRowsAction.execute(QueryController.java:3494) at org.labkey.query.controllers.QueryController$InsertRowsAction.execute(QueryController.java:3487) at org.labkey.api.action.ApiAction.handlePost(ApiAction.java:180) at org.labkey.api.action.ApiAction.handleRequest(ApiAction.java:125) 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:1208) 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:206) 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:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) 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: java.sql.SQLException: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.labkey.api.data.dialect.StatementWrapper.execute(StatementWrapper.java:1506) at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:168) at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:144) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:122) ... 51 more -- Emory Integrated Computational Core (http://www.cores.emory.edu/eicc) A member core of the Emory Integrated Core Facilities (http://www.cores.emory.edu) Phone: 404-778-5123 Email: eicc@emory.edu Address: 7110 WMRB, 101 Woodruff Circle, Atlanta, GA 30322