INFO ModuleLoader 2015-09-16 10:46:56,502 localhost-startStop-1 : __ || | _ |_ |/ _ (¯ _ _ _ _ (__) |_(_||_)|\(/_\/ _)(/_| \/(/_| / INFO DbScope 2015-09-16 10:46:58,752 localhost-startStop-1 : Attempting to create database "TEST_LabKey2" INFO DbScope 2015-09-16 10:47:00,427 localhost-startStop-1 : Database "TEST_LabKey2" created INFO DbScope 2015-09-16 10:47:00,682 localhost-startStop-1 : Initializing DbScope with the following configuration: DataSource Name: labkeyDataSource Server URL: jdbc:jtds:sqlserver://RGHRHSQL011:1433/TEST_LabKey2;instance=RGHRHSQL011B Database Product Name: Microsoft SQL Server Database Product Version: 11.00.3381 JDBC Driver Name: jTDS Type 4 JDBC Driver for MS SQL Server and Sybase JDBC Driver Version: 1.3.1 SQL Dialect: MicrosoftSqlServer2012Dialect INFO DbScope 2015-09-16 10:47:01,027 localhost-startStop-1 : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:03,463 localhost-startStop-1 : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:04,264 localhost-startStop-1 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:47:04,302 localhost-startStop-1 : Loading DbSchema "labkey.test" (Module) INFO SqlScriptRunner 2015-09-16 10:47:04,401 localhost-startStop-1 : Running [core-0.00-13.10.sql, core-13.10-13.20.sql, core-13.20-13.30.sql, core-13.30-14.10.sql, core-14.20-14.30.sql, core-14.30-15.10.sql] INFO SqlScriptManager 2015-09-16 10:47:04,412 localhost-startStop-1 : start running script : core-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:47:05,246 localhost-startStop-1 : finished running script : core-0.00-13.10.sql INFO ScriptService$Console 2015-09-16 10:47:05,258 localhost-startStop-1 : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:05,275 localhost-startStop-1 : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:05,411 localhost-startStop-1 : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptManager 2015-09-16 10:47:05,511 localhost-startStop-1 : start running script : core-13.10-13.20.sql INFO ScriptService$Console 2015-09-16 10:47:05,780 localhost-startStop-1 : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:05,782 localhost-startStop-1 : Executing CoreUpgradeCode.setPortalPageUniqueIndexes(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:47:05,784 localhost-startStop-1 : Purging RhinoService caches INFO ScriptService$Console 2015-09-16 10:47:05,807 localhost-startStop-1 : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:05,810 localhost-startStop-1 : Adding deferred upgrade task to execute CoreUpgradeCode.populateWorkbookSortOrderAndName(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:47:05,813 localhost-startStop-1 : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:47:05,813 localhost-startStop-1 : finished running script : core-13.10-13.20.sql INFO DbScope 2015-09-16 10:47:05,813 localhost-startStop-1 : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:05,959 localhost-startStop-1 : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptManager 2015-09-16 10:47:06,257 localhost-startStop-1 : start running script : core-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:47:06,270 localhost-startStop-1 : finished running script : core-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:47:06,300 localhost-startStop-1 : start running script : core-13.30-14.10.sql INFO ScriptService$Console 2015-09-16 10:47:06,310 localhost-startStop-1 : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:06,310 localhost-startStop-1 : Adding deferred upgrade task to execute CoreUpgradeCode.ensureCoreUserPropertyDescriptorScales(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:47:06,310 localhost-startStop-1 : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:47:06,415 localhost-startStop-1 : finished running script : core-13.30-14.10.sql INFO DbScope 2015-09-16 10:47:06,415 localhost-startStop-1 : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:06,531 localhost-startStop-1 : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptManager 2015-09-16 10:47:06,720 localhost-startStop-1 : start running script : core-14.20-14.30.sql INFO SqlScriptManager 2015-09-16 10:47:06,881 localhost-startStop-1 : finished running script : core-14.20-14.30.sql INFO SqlScriptManager 2015-09-16 10:47:06,916 localhost-startStop-1 : start running script : core-14.30-15.10.sql INFO SqlScriptManager 2015-09-16 10:47:07,094 localhost-startStop-1 : finished running script : core-14.30-15.10.sql INFO ScriptService$Console 2015-09-16 10:47:07,114 localhost-startStop-1 : Purging RhinoService caches INFO SqlScriptRunner 2015-09-16 10:47:07,140 localhost-startStop-1 : Running [core-create.sql] INFO SqlScriptManager 2015-09-16 10:47:07,141 localhost-startStop-1 : start running script : core-create.sql INFO SqlScriptManager 2015-09-16 10:47:07,289 localhost-startStop-1 : finished running script : core-create.sql INFO ScriptService$Console 2015-09-16 10:47:07,290 localhost-startStop-1 : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:07,311 localhost-startStop-1 : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:07,529 localhost-startStop-1 : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptRunner 2015-09-16 10:47:07,577 localhost-startStop-1 : Running [prop-0.00-12.20.sql, prop-13.20-13.30.sql, prop-13.30-14.10.sql] INFO SqlScriptManager 2015-09-16 10:47:07,580 localhost-startStop-1 : start running script : prop-0.00-12.20.sql INFO SqlScriptManager 2015-09-16 10:47:08,087 localhost-startStop-1 : finished running script : prop-0.00-12.20.sql INFO SqlScriptManager 2015-09-16 10:47:08,124 localhost-startStop-1 : start running script : prop-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:47:08,136 localhost-startStop-1 : finished running script : prop-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:47:08,160 localhost-startStop-1 : start running script : prop-13.30-14.10.sql INFO SqlScriptManager 2015-09-16 10:47:08,288 localhost-startStop-1 : finished running script : prop-13.30-14.10.sql INFO ScriptService$Console 2015-09-16 10:47:08,313 localhost-startStop-1 : Purging RhinoService caches INFO SqlScriptRunner 2015-09-16 10:47:08,331 localhost-startStop-1 : Running [prop-create.sql] INFO SqlScriptManager 2015-09-16 10:47:08,333 localhost-startStop-1 : start running script : prop-create.sql INFO SqlScriptManager 2015-09-16 10:47:08,345 localhost-startStop-1 : finished running script : prop-create.sql INFO ScriptService$Console 2015-09-16 10:47:08,346 localhost-startStop-1 : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:08,356 localhost-startStop-1 : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:08,533 localhost-startStop-1 : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptRunner 2015-09-16 10:47:08,572 localhost-startStop-1 : Running [test-0.00-12.10.sql, test-13.10-13.20.sql, test-14.30-15.10.sql] INFO SqlScriptManager 2015-09-16 10:47:08,575 localhost-startStop-1 : start running script : test-0.00-12.10.sql INFO SqlScriptManager 2015-09-16 10:47:08,601 localhost-startStop-1 : finished running script : test-0.00-12.10.sql INFO SqlScriptManager 2015-09-16 10:47:08,721 localhost-startStop-1 : start running script : test-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:47:08,734 localhost-startStop-1 : finished running script : test-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:47:08,761 localhost-startStop-1 : start running script : test-14.30-15.10.sql INFO SqlScriptManager 2015-09-16 10:47:08,779 localhost-startStop-1 : finished running script : test-14.30-15.10.sql INFO ScriptService$Console 2015-09-16 10:47:08,798 localhost-startStop-1 : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:08,810 localhost-startStop-1 : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:09,662 localhost-startStop-1 : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:10,395 localhost-startStop-1 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:47:11,989 localhost-startStop-1 : start running script : group_concat_uninstall.sql INFO SqlScriptManager 2015-09-16 10:47:12,061 localhost-startStop-1 : finished running script : group_concat_uninstall.sql INFO SqlScriptManager 2015-09-16 10:47:12,157 localhost-startStop-1 : start running script : group_concat_install_1.00.23696.sql ERROR Table 2015-09-16 10:47:12,250 localhost-startStop-1 : SQL Exception java.sql.SQLException: User does not have permission to perform this action. 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.JtdsStatement.executeImpl(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1282) at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:131) at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:119) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:97) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:73) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:68) at org.labkey.api.data.SqlScriptExecutor$Block.execute(SqlScriptExecutor.java:201) at org.labkey.api.data.SqlScriptExecutor.execute(SqlScriptExecutor.java:96) at org.labkey.api.data.dialect.SqlDialect.runSql(SqlDialect.java:597) at org.labkey.api.data.SqlScriptManager.runScript(SqlScriptManager.java:203) at org.labkey.bigiron.mssql.GroupConcatInstallationManager.install(GroupConcatInstallationManager.java:117) at org.labkey.bigiron.mssql.GroupConcatInstallationManager.ensureGroupConcat(GroupConcatInstallationManager.java:173) at org.labkey.bigiron.mssql.MicrosoftSqlServer2008R2Dialect.afterCoreUpgrade(MicrosoftSqlServer2008R2Dialect.java:1150) at org.labkey.core.CoreModule.afterUpdate(CoreModule.java:506) at org.labkey.api.module.ModuleUpgrader.upgrade(ModuleUpgrader.java:60) at org.labkey.api.module.ModuleLoader.upgradeCoreModule(ModuleLoader.java:1009) at org.labkey.api.module.ModuleLoader.doInit(ModuleLoader.java:329) at org.labkey.api.module.ModuleLoader.init(ModuleLoader.java:230) at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279) at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260) at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:105) at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4841) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5535) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1912) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) ERROR Table 2015-09-16 10:47:12,261 localhost-startStop-1 : SQL EXEC sys.sp_configure @configname = 'show advanced options', @configvalue = 1 ; org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:101) org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:73) org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:68) org.labkey.api.data.SqlScriptExecutor$Block.execute(SqlScriptExecutor.java:201) org.labkey.api.data.SqlScriptExecutor.execute(SqlScriptExecutor.java:96) ERROR ExceptionUtil 2015-09-16 10:47:12,263 localhost-startStop-1 : Exception detected and logged to mothership java.lang.Exception: Failure installing GROUP_CONCAT aggregate function. This function is required for optimal operation of this server. Contact LabKey Software if you need assistance installing this function, or see https://www.labkey.org/wiki/home/Documentation/page.view?name=groupconcatinstall at org.labkey.bigiron.mssql.GroupConcatInstallationManager.install(GroupConcatInstallationManager.java:126) at org.labkey.bigiron.mssql.GroupConcatInstallationManager.ensureGroupConcat(GroupConcatInstallationManager.java:173) at org.labkey.bigiron.mssql.MicrosoftSqlServer2008R2Dialect.afterCoreUpgrade(MicrosoftSqlServer2008R2Dialect.java:1150) at org.labkey.core.CoreModule.afterUpdate(CoreModule.java:506) at org.labkey.api.module.ModuleUpgrader.upgrade(ModuleUpgrader.java:60) at org.labkey.api.module.ModuleLoader.upgradeCoreModule(ModuleLoader.java:1009) at org.labkey.api.module.ModuleLoader.doInit(ModuleLoader.java:329) at org.labkey.api.module.ModuleLoader.init(ModuleLoader.java:230) at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279) at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260) at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:105) at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4841) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5535) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1912) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.labkey.api.data.SqlScriptRunner$SqlScriptException: group_concat_install_1.00.23696.sql : SqlExecutor.execute(); bad SQL grammar []; nested exception is java.sql.SQLException: User does not have permission to perform this action. at org.labkey.api.data.SqlScriptManager.runScript(SqlScriptManager.java:208) at org.labkey.bigiron.mssql.GroupConcatInstallationManager.install(GroupConcatInstallationManager.java:117) ... 23 more Caused by: org.springframework.jdbc.BadSqlGrammarException: SqlExecutor.execute(); bad SQL grammar []; nested exception is java.sql.SQLException: User does not have permission to perform this action. 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.SqlExecutor.execute(SqlExecutor.java:104) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:73) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:68) at org.labkey.api.data.SqlScriptExecutor$Block.execute(SqlScriptExecutor.java:201) at org.labkey.api.data.SqlScriptExecutor.execute(SqlScriptExecutor.java:96) at org.labkey.api.data.dialect.SqlDialect.runSql(SqlDialect.java:597) at org.labkey.api.data.SqlScriptManager.runScript(SqlScriptManager.java:203) ... 24 more Caused by: java.sql.SQLException: User does not have permission to perform this action. 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.JtdsStatement.executeImpl(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1282) at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:131) at org.labkey.api.data.SqlExecutor$NormalStatementExecutor.execute(SqlExecutor.java:119) at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:97) ... 30 more INFO DbScope 2015-09-16 10:47:12,450 localhost-startStop-1 : Loading DbSchema "labkey.test" (Module) INFO ModuleLoader 2015-09-16 10:47:13,364 localhost-startStop-1 : Modules requiring upgrade: [Authentication, BigIron, FCSExpress, Pipeline, Experiment, Audit, DataIntegration, List, ELISpotAssay, Microarray, Query, Flow, MS2, MS1, Search, Survey, TargetedMS, Wiki, Announcements, FileContent, Issues, Study, Elisa, FreezerPro, Luminex, Nab, Visualization] INFO ModuleLoader 2015-09-16 10:47:13,364 localhost-startStop-1 : LabKey Server startup is complete, modules will be initialized after the first HTTP/HTTPS request INFO ViewServlet 2015-09-16 10:47:14,259 localhost-startStop-1 : ViewServlet initialized INFO ViewServlet 2015-09-16 10:47:14,259 localhost-startStop-1 : WEBAPP: C:\Program Files\Labkey server\labkeywebapp\ INFO ViewServlet 2015-09-16 10:47:14,259 localhost-startStop-1 : PATH: C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\ThinkPad\Bluetooth Software\;C:\Program Files\ThinkPad\Bluetooth Software\syswow64;C:\WINDOWS\SysWOW64\;C:\Program Files (x86)\Hyland\Web ActiveX\;C:\Program Files (x86)\PDFtk\bin\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\;C:\Program Files\SASHome\Secure\ccme4;C:\Program Files\SASHome\x86\Secure\ccme4; INFO DbScope 2015-09-16 10:47:29,846 Module Upgrade : Loading DbSchema "labkey.pipeline" (Module) INFO SqlScriptRunner 2015-09-16 10:47:30,149 Module Upgrade : Running [pipeline-0.00-10.30.sql, pipeline-14.10-14.20.sql] INFO SqlScriptManager 2015-09-16 10:47:30,155 Module Upgrade : start running script : pipeline-0.00-10.30.sql INFO SqlScriptManager 2015-09-16 10:47:30,265 Module Upgrade : finished running script : pipeline-0.00-10.30.sql INFO SqlScriptManager 2015-09-16 10:47:30,287 Module Upgrade : start running script : pipeline-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:30,297 Module Upgrade : finished running script : pipeline-14.10-14.20.sql INFO ScriptService$Console 2015-09-16 10:47:30,317 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:30,327 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:30,417 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:30,467 Module Upgrade : Loading DbSchema "labkey.pipeline" (Module) INFO DbScope 2015-09-16 10:47:30,502 Module Upgrade : Loading DbSchema "labkey.exp" (Module) INFO SqlScriptRunner 2015-09-16 10:47:30,608 Module Upgrade : Running [exp-0.00-13.10.sql, exp-13.10-13.20.sql, exp-13.30-14.10.sql, exp-14.10-14.20.sql, exp-14.20-14.30.sql, exp-14.30-15.10.sql, exp-15.10-15.20.sql] INFO SqlScriptManager 2015-09-16 10:47:30,615 Module Upgrade : start running script : exp-0.00-13.10.sql INFO DbScope 2015-09-16 10:47:30,950 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:47:32,985 Module Upgrade : finished running script : exp-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:47:33,012 Module Upgrade : start running script : exp-13.10-13.20.sql INFO ScriptService$Console 2015-09-16 10:47:33,093 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:33,093 Module Upgrade : Executing ExperimentUpgradeCode.createListSequences(ModuleContext moduleContext) INFO DbScope 2015-09-16 10:47:33,094 Module Upgrade : Loading DbSchema "labkey.exp" (Module) INFO ScriptService$Console 2015-09-16 10:47:33,196 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:33,198 http-bio-8080-exec-5 : Loading DbSchema "labkey.core" (Module) INFO SqlScriptManager 2015-09-16 10:47:33,272 Module Upgrade : finished running script : exp-13.10-13.20.sql INFO DbScope 2015-09-16 10:47:33,291 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:33,399 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:47:33,435 Module Upgrade : start running script : exp-13.30-14.10.sql INFO ScriptService$Console 2015-09-16 10:47:33,458 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:33,458 Module Upgrade : Executing ExperimentUpgradeCode.resyncDomainProjects(ModuleContext moduleContext) INFO DbScope 2015-09-16 10:47:33,482 Module Upgrade : Loading DbSchema "labkey.exp" (Module) INFO DbScope 2015-09-16 10:47:33,514 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:47:33,573 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:33,574 http-bio-8080-exec-5 : Loading DbSchema "labkey.temp" (Provisioned) INFO ScriptService$Console 2015-09-16 10:47:33,758 Module Upgrade : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:47:33,758 Module Upgrade : finished running script : exp-13.30-14.10.sql INFO DbScope 2015-09-16 10:47:33,758 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:33,839 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptManager 2015-09-16 10:47:33,902 Module Upgrade : start running script : exp-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:33,916 Module Upgrade : finished running script : exp-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:33,941 Module Upgrade : start running script : exp-14.20-14.30.sql INFO SqlScriptManager 2015-09-16 10:47:34,008 Module Upgrade : finished running script : exp-14.20-14.30.sql INFO SqlScriptManager 2015-09-16 10:47:34,032 Module Upgrade : start running script : exp-14.30-15.10.sql INFO SqlScriptManager 2015-09-16 10:47:34,049 Module Upgrade : finished running script : exp-14.30-15.10.sql INFO SqlScriptManager 2015-09-16 10:47:34,074 Module Upgrade : start running script : exp-15.10-15.20.sql INFO SqlScriptManager 2015-09-16 10:47:34,183 Module Upgrade : finished running script : exp-15.10-15.20.sql INFO ScriptService$Console 2015-09-16 10:47:34,204 Module Upgrade : Purging RhinoService caches INFO SqlScriptRunner 2015-09-16 10:47:34,222 Module Upgrade : Running [exp-create.sql] INFO SqlScriptManager 2015-09-16 10:47:34,225 Module Upgrade : start running script : exp-create.sql INFO DbScope 2015-09-16 10:47:34,285 http-bio-8080-exec-5 : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:34,448 http-bio-8080-exec-5 : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptManager 2015-09-16 10:47:34,524 Module Upgrade : finished running script : exp-create.sql INFO ScriptService$Console 2015-09-16 10:47:34,525 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:34,525 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:34,625 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:34,681 Module Upgrade : Loading DbSchema "labkey.exp" (Module) INFO DbScope 2015-09-16 10:47:34,729 Module Upgrade : Loading DbSchema "labkey.audit" (Provisioned) INFO SqlScriptRunner 2015-09-16 10:47:34,788 Module Upgrade : Running [audit-0.00-12.30.sql, audit-13.30-14.10.sql] INFO SqlScriptManager 2015-09-16 10:47:34,792 Module Upgrade : start running script : audit-0.00-12.30.sql INFO SqlScriptManager 2015-09-16 10:47:35,092 Module Upgrade : finished running script : audit-0.00-12.30.sql INFO SqlScriptManager 2015-09-16 10:47:35,119 Module Upgrade : start running script : audit-13.30-14.10.sql INFO ScriptService$Console 2015-09-16 10:47:35,128 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:35,129 Module Upgrade : Adding deferred upgrade task to execute AuditUpgradeCode.convertGroupAuditUserField(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:47:35,130 Module Upgrade : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:47:35,130 Module Upgrade : finished running script : audit-13.30-14.10.sql INFO DbScope 2015-09-16 10:47:35,130 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:35,219 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO ScriptService$Console 2015-09-16 10:47:35,278 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:35,282 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:35,368 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:35,420 Module Upgrade : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:47:35,420 Module Upgrade : Loading DbSchema "labkey.dataintegration" (Module) INFO DbScope 2015-09-16 10:47:35,483 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptRunner 2015-09-16 10:47:35,523 Module Upgrade : Running [dataintegration-0.00-13.10.sql, dataintegration-13.10-13.20.sql, dataintegration-13.20-13.30.sql, dataintegration-13.30-14.10.sql] INFO SqlScriptManager 2015-09-16 10:47:35,526 Module Upgrade : start running script : dataintegration-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:47:35,636 Module Upgrade : finished running script : dataintegration-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:47:35,668 Module Upgrade : start running script : dataintegration-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:47:36,480 Module Upgrade : finished running script : dataintegration-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:47:36,504 Module Upgrade : start running script : dataintegration-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:47:36,555 Module Upgrade : finished running script : dataintegration-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:47:36,580 Module Upgrade : start running script : dataintegration-13.30-14.10.sql INFO SqlScriptManager 2015-09-16 10:47:37,015 Module Upgrade : finished running script : dataintegration-13.30-14.10.sql INFO ScriptService$Console 2015-09-16 10:47:37,035 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:37,044 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:37,150 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:37,228 Module Upgrade : Loading DbSchema "labkey.dataintegration" (Module) INFO DbScope 2015-09-16 10:47:37,270 Module Upgrade : Loading DbSchema "labkey.list" (Provisioned) INFO SqlScriptRunner 2015-09-16 10:47:37,329 Module Upgrade : Running [list-13.10-13.20.sql, list-13.30-14.10.sql] INFO SqlScriptManager 2015-09-16 10:47:37,334 Module Upgrade : start running script : list-13.10-13.20.sql INFO ScriptService$Console 2015-09-16 10:47:37,354 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:37,355 Module Upgrade : Executing ListUpgradeCode.upgradeListDomains(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:47:37,355 Module Upgrade : Purging RhinoService caches INFO ScriptService$Console 2015-09-16 10:47:37,390 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:37,390 Module Upgrade : Executing ListUpgradeCode.ensureListDomains(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:47:37,391 Module Upgrade : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:47:37,391 Module Upgrade : finished running script : list-13.10-13.20.sql INFO DbScope 2015-09-16 10:47:37,391 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:37,492 http-bio-8080-exec-5 : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:37,535 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:47:37,680 Module Upgrade : start running script : list-13.30-14.10.sql INFO ScriptService$Console 2015-09-16 10:47:37,722 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:37,722 Module Upgrade : Executing ListUpgradeCode.addContainerColumns(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:47:37,722 Module Upgrade : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:47:37,722 Module Upgrade : finished running script : list-13.30-14.10.sql INFO DbScope 2015-09-16 10:47:37,722 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:37,811 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO ScriptService$Console 2015-09-16 10:47:37,866 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:37,872 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:37,973 http-bio-8080-exec-5 : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:38,027 Module Upgrade : Loading DbSchema "labkey.list" (Provisioned) INFO DbScope 2015-09-16 10:47:38,027 Module Upgrade : Loading DbSchema "labkey.elispotlk" (Module) INFO SqlScriptRunner 2015-09-16 10:47:38,126 Module Upgrade : Running [elispotlk-15.10-15.20.sql] INFO SqlScriptManager 2015-09-16 10:47:38,129 Module Upgrade : start running script : elispotlk-15.10-15.20.sql INFO ScriptService$Console 2015-09-16 10:47:38,240 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:38,240 Module Upgrade : Executing ElispotUpgradeCode.migrateToElispotTables(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:47:38,241 Module Upgrade : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:47:38,254 Module Upgrade : finished running script : elispotlk-15.10-15.20.sql INFO DbScope 2015-09-16 10:47:38,255 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:38,350 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO ScriptService$Console 2015-09-16 10:47:38,407 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:38,411 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:38,512 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:38,660 Module Upgrade : Loading DbSchema "labkey.elispotlk" (Module) INFO DbScope 2015-09-16 10:47:38,705 Module Upgrade : Loading DbSchema "labkey.microarray" (Module) INFO SqlScriptRunner 2015-09-16 10:47:38,819 Module Upgrade : Running [microarray-0.00-12.10.sql, microarray-13.20-13.30.sql, microarray-13.30-14.10.sql, microarray-14.10-14.20.sql, microarray-15.10-15.20.sql] INFO SqlScriptManager 2015-09-16 10:47:38,824 Module Upgrade : start running script : microarray-0.00-12.10.sql INFO SqlScriptManager 2015-09-16 10:47:38,850 Module Upgrade : finished running script : microarray-0.00-12.10.sql INFO SqlScriptManager 2015-09-16 10:47:38,878 Module Upgrade : start running script : microarray-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:47:38,903 Module Upgrade : finished running script : microarray-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:47:38,934 Module Upgrade : start running script : microarray-13.30-14.10.sql INFO DbScope 2015-09-16 10:47:38,935 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:47:39,001 Module Upgrade : finished running script : microarray-13.30-14.10.sql INFO SqlScriptManager 2015-09-16 10:47:39,029 Module Upgrade : start running script : microarray-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:39,046 Module Upgrade : finished running script : microarray-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:39,069 Module Upgrade : start running script : microarray-15.10-15.20.sql INFO SqlScriptManager 2015-09-16 10:47:39,083 Module Upgrade : finished running script : microarray-15.10-15.20.sql INFO ScriptService$Console 2015-09-16 10:47:39,102 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:39,115 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:39,188 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:39,228 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:47:39,236 Module Upgrade : Loading DbSchema "labkey.microarray" (Module) INFO DbScope 2015-09-16 10:47:39,278 Module Upgrade : Loading DbSchema "labkey.query" (Module) INFO DbScope 2015-09-16 10:47:39,333 Module Upgrade : Loading DbSchema "labkey.junit" (Module) INFO DbScope 2015-09-16 10:47:39,364 Module Upgrade : no schema metadata xml file found for schema "junit" INFO SqlScriptRunner 2015-09-16 10:47:39,420 Module Upgrade : Running [query-0.00-13.10.sql, query-13.10-13.20.sql, query-14.20-14.30.sql] INFO SqlScriptManager 2015-09-16 10:47:39,423 Module Upgrade : start running script : query-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:47:39,660 Module Upgrade : finished running script : query-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:47:39,679 Module Upgrade : start running script : query-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:47:39,689 Module Upgrade : finished running script : query-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:47:39,709 Module Upgrade : start running script : query-14.20-14.30.sql INFO SqlScriptManager 2015-09-16 10:47:39,722 Module Upgrade : finished running script : query-14.20-14.30.sql INFO ScriptService$Console 2015-09-16 10:47:39,741 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:39,751 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:39,843 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:40,207 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:47:40,278 Module Upgrade : Loading DbSchema "labkey.query" (Module) INFO DbScope 2015-09-16 10:47:40,318 Module Upgrade : Loading DbSchema "labkey.junit" (Module) INFO DbScope 2015-09-16 10:47:40,356 Module Upgrade : no schema metadata xml file found for schema "junit" INFO DbScope 2015-09-16 10:47:40,356 Module Upgrade : Loading DbSchema "labkey.flow" (Module) INFO SqlScriptRunner 2015-09-16 10:47:40,410 Module Upgrade : Running [flow-0.00-13.10.sql, flow-13.10-13.20.sql, flow-14.10-14.20.sql] INFO SqlScriptManager 2015-09-16 10:47:40,414 Module Upgrade : start running script : flow-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:47:41,199 Module Upgrade : finished running script : flow-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:47:41,221 Module Upgrade : start running script : flow-13.10-13.20.sql INFO ScriptService$Console 2015-09-16 10:47:41,265 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:41,266 Module Upgrade : Executing FlowUpgradeCode.removeMacRomanDashes(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:47:41,266 Module Upgrade : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:47:41,266 Module Upgrade : finished running script : flow-13.10-13.20.sql INFO DbScope 2015-09-16 10:47:41,266 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:41,354 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptManager 2015-09-16 10:47:41,595 Module Upgrade : start running script : flow-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:41,686 Module Upgrade : finished running script : flow-14.10-14.20.sql INFO DbScope 2015-09-16 10:47:41,695 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO ScriptService$Console 2015-09-16 10:47:41,705 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:41,708 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:41,747 http-bio-8080-exec-5 : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:41,776 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:47:41,835 Module Upgrade : Loading DbSchema "labkey.flow" (Module) INFO DbScope 2015-09-16 10:47:41,878 Module Upgrade : Loading DbSchema "labkey.ms2" (Module) INFO DbScope 2015-09-16 10:47:41,934 Module Upgrade : Loading DbSchema "labkey.prot" (Module) INFO SqlScriptRunner 2015-09-16 10:47:42,030 Module Upgrade : Running [ms2-0.00-12.20.sql, ms2-13.10-13.20.sql, ms2-13.20-13.30.sql, ms2-14.10-14.20.sql, ms2-15.10-15.20.sql] INFO SqlScriptManager 2015-09-16 10:47:42,037 Module Upgrade : start running script : ms2-0.00-12.20.sql INFO SqlScriptManager 2015-09-16 10:47:43,735 Module Upgrade : finished running script : ms2-0.00-12.20.sql INFO SqlScriptManager 2015-09-16 10:47:43,755 Module Upgrade : start running script : ms2-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:47:43,766 Module Upgrade : finished running script : ms2-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:47:43,786 Module Upgrade : start running script : ms2-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:47:43,811 Module Upgrade : finished running script : ms2-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:47:43,831 Module Upgrade : start running script : ms2-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:43,843 Module Upgrade : finished running script : ms2-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:43,865 Module Upgrade : start running script : ms2-15.10-15.20.sql INFO SqlScriptManager 2015-09-16 10:47:43,895 Module Upgrade : finished running script : ms2-15.10-15.20.sql INFO ScriptService$Console 2015-09-16 10:47:43,913 Module Upgrade : Purging RhinoService caches INFO SqlScriptRunner 2015-09-16 10:47:43,919 Module Upgrade : Running [ms2-create.sql] INFO SqlScriptManager 2015-09-16 10:47:43,920 Module Upgrade : start running script : ms2-create.sql INFO SqlScriptManager 2015-09-16 10:47:44,002 Module Upgrade : finished running script : ms2-create.sql INFO ScriptService$Console 2015-09-16 10:47:44,003 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:44,007 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:44,084 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:44,261 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:47:44,274 Module Upgrade : Loading DbSchema "labkey.ms2" (Module) INFO DbScope 2015-09-16 10:47:44,328 Module Upgrade : Loading DbSchema "labkey.prot" (Module) INFO DbScope 2015-09-16 10:47:44,376 Module Upgrade : Loading DbSchema "labkey.ms1" (Module) INFO SqlScriptRunner 2015-09-16 10:47:44,447 Module Upgrade : Running [ms1-0.00-9.10.sql] INFO SqlScriptManager 2015-09-16 10:47:44,450 Module Upgrade : start running script : ms1-0.00-9.10.sql INFO SqlScriptManager 2015-09-16 10:47:45,278 Module Upgrade : finished running script : ms1-0.00-9.10.sql INFO ScriptService$Console 2015-09-16 10:47:45,297 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:45,301 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:45,388 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:45,448 Module Upgrade : Loading DbSchema "labkey.ms1" (Module) INFO DbScope 2015-09-16 10:47:45,485 Module Upgrade : Loading DbSchema "labkey.search" (Module) INFO DbScope 2015-09-16 10:47:45,538 Module Upgrade : Loading DbSchema "labkey.umls" (Module) INFO DbScope 2015-09-16 10:47:45,575 Module Upgrade : no schema metadata xml file found for schema "umls" INFO SqlScriptRunner 2015-09-16 10:47:45,619 Module Upgrade : Running [search-0.00-13.10.sql] INFO SqlScriptManager 2015-09-16 10:47:45,623 Module Upgrade : start running script : search-0.00-13.10.sql INFO DbScope 2015-09-16 10:47:46,020 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:47:47,018 Module Upgrade : finished running script : search-0.00-13.10.sql INFO ScriptService$Console 2015-09-16 10:47:47,037 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:47,046 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:47,085 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:47:47,141 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptRunner 2015-09-16 10:47:47,179 Module Upgrade : Running [umls-0.00-10.20.sql] INFO SqlScriptManager 2015-09-16 10:47:47,185 Module Upgrade : start running script : umls-0.00-10.20.sql INFO SqlScriptManager 2015-09-16 10:47:48,133 Module Upgrade : finished running script : umls-0.00-10.20.sql INFO ScriptService$Console 2015-09-16 10:47:48,154 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:48,163 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:48,262 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:48,313 Module Upgrade : Loading DbSchema "labkey.search" (Module) INFO DbScope 2015-09-16 10:47:48,361 Module Upgrade : Loading DbSchema "labkey.umls" (Module) INFO DbScope 2015-09-16 10:47:48,409 Module Upgrade : no schema metadata xml file found for schema "umls" INFO DbScope 2015-09-16 10:47:48,409 Module Upgrade : Loading DbSchema "labkey.survey" (Module) INFO SqlScriptRunner 2015-09-16 10:47:48,503 Module Upgrade : Running [survey-0.00-13.10.sql] INFO SqlScriptManager 2015-09-16 10:47:48,506 Module Upgrade : start running script : survey-0.00-13.10.sql INFO DbScope 2015-09-16 10:47:48,544 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:47:48,562 Module Upgrade : finished running script : survey-0.00-13.10.sql INFO ScriptService$Console 2015-09-16 10:47:48,581 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:48,585 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:48,621 http-bio-8080-exec-5 : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:48,651 http-bio-8080-exec-5 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:47:48,721 Module Upgrade : Loading DbSchema "labkey.survey" (Module) INFO DbScope 2015-09-16 10:47:48,758 Module Upgrade : Loading DbSchema "labkey.targetedms" (Module) INFO SqlScriptRunner 2015-09-16 10:47:49,041 Module Upgrade : Running [targetedms-0.00-13.10.sql, targetedms-13.10-13.20.sql, targetedms-13.20-13.30.sql, targetedms-13.30-14.10.sql, targetedms-14.10-14.20.sql, targetedms-14.20-14.30.sql, targetedms-14.30-15.10.sql, targetedms-15.10-15.20.sql] INFO SqlScriptManager 2015-09-16 10:47:49,047 Module Upgrade : start running script : targetedms-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:47:50,363 Module Upgrade : finished running script : targetedms-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:47:50,483 Module Upgrade : start running script : targetedms-13.10-13.20.sql INFO ScriptService$Console 2015-09-16 10:47:50,621 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:50,621 Module Upgrade : Executing TargetedMSUpgradeCode.setContainersToExperimentType(ModuleContext moduleContext) INFO DbScope 2015-09-16 10:47:50,622 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:50,841 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:51,659 Module Upgrade : Loading DbSchema "labkey.prop" (Module) INFO ScriptService$Console 2015-09-16 10:47:51,870 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:51,922 http-bio-8080-exec-9 : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:51,980 http-bio-8080-exec-9 : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptManager 2015-09-16 10:47:52,215 Module Upgrade : finished running script : targetedms-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:47:52,290 Module Upgrade : start running script : targetedms-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:47:52,363 Module Upgrade : finished running script : targetedms-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:47:52,389 Module Upgrade : start running script : targetedms-13.30-14.10.sql INFO SqlScriptManager 2015-09-16 10:47:52,461 Module Upgrade : finished running script : targetedms-13.30-14.10.sql INFO SqlScriptManager 2015-09-16 10:47:52,491 Module Upgrade : start running script : targetedms-14.10-14.20.sql INFO DbScope 2015-09-16 10:47:52,667 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:47:52,736 Module Upgrade : finished running script : targetedms-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:52,765 Module Upgrade : start running script : targetedms-14.20-14.30.sql INFO ScriptService$Console 2015-09-16 10:47:52,845 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:52,845 Module Upgrade : Executing TargetedMSUpgradeCode.updateExperimentAnnotations(ModuleContext moduleContext) INFO DbScope 2015-09-16 10:47:52,845 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:52,853 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:47:52,945 http-bio-8080-exec-9 : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:52,950 Module Upgrade : Loading DbSchema "labkey.targetedms" (Module) INFO ScriptService$Console 2015-09-16 10:47:53,071 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:53,118 http-bio-8080-exec-9 : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:53,403 http-bio-8080-exec-9 : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:53,442 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:47:53,479 Module Upgrade : finished running script : targetedms-14.20-14.30.sql INFO SqlScriptManager 2015-09-16 10:47:53,552 Module Upgrade : start running script : targetedms-14.30-15.10.sql INFO ScriptService$Console 2015-09-16 10:47:53,582 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:53,582 Module Upgrade : Executing TargetedMSUpgradeCode.populateDefaultAnnotationTypes(ModuleContext moduleContext) INFO DbScope 2015-09-16 10:47:53,582 Module Upgrade : Loading DbSchema "labkey.targetedms" (Module) INFO DbScope 2015-09-16 10:47:53,588 http-bio-8080-exec-9 : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:53,749 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:53,906 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO ScriptService$Console 2015-09-16 10:47:54,243 Module Upgrade : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:47:54,463 Module Upgrade : finished running script : targetedms-14.30-15.10.sql INFO DbScope 2015-09-16 10:47:54,463 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:54,569 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptManager 2015-09-16 10:47:54,638 Module Upgrade : start running script : targetedms-15.10-15.20.sql INFO SqlScriptManager 2015-09-16 10:47:54,656 Module Upgrade : finished running script : targetedms-15.10-15.20.sql INFO ScriptService$Console 2015-09-16 10:47:54,674 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:54,683 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:54,787 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:54,830 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:47:54,841 Module Upgrade : Loading DbSchema "labkey.targetedms" (Module) INFO DbScope 2015-09-16 10:47:54,927 Module Upgrade : Loading DbSchema "labkey.comm" (Module) INFO SqlScriptRunner 2015-09-16 10:47:55,071 Module Upgrade : Running [comm-0.00-12.20.sql, comm-13.30-14.10.sql, comm-14.10-14.20.sql, comm-14.30-15.10.sql] INFO SqlScriptManager 2015-09-16 10:47:55,075 Module Upgrade : start running script : comm-0.00-12.20.sql INFO SqlScriptManager 2015-09-16 10:47:55,867 Module Upgrade : finished running script : comm-0.00-12.20.sql INFO SqlScriptManager 2015-09-16 10:47:55,894 Module Upgrade : start running script : comm-13.30-14.10.sql INFO ScriptService$Console 2015-09-16 10:47:55,904 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:47:55,904 Module Upgrade : Executing AnnouncementUpgradeCode.convertEmailListToUserList(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:47:55,905 Module Upgrade : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:47:55,905 Module Upgrade : finished running script : comm-13.30-14.10.sql INFO DbScope 2015-09-16 10:47:55,905 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:56,010 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptManager 2015-09-16 10:47:56,226 Module Upgrade : start running script : comm-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:56,245 Module Upgrade : finished running script : comm-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:56,268 Module Upgrade : start running script : comm-14.30-15.10.sql INFO SqlScriptManager 2015-09-16 10:47:56,280 Module Upgrade : finished running script : comm-14.30-15.10.sql INFO ScriptService$Console 2015-09-16 10:47:56,300 Module Upgrade : Purging RhinoService caches INFO SqlScriptRunner 2015-09-16 10:47:56,314 Module Upgrade : Running [comm-create.sql] INFO SqlScriptManager 2015-09-16 10:47:56,316 Module Upgrade : start running script : comm-create.sql INFO DbScope 2015-09-16 10:47:56,322 http-bio-8080-exec-9 : Loading DbSchema "labkey.core" (Module) INFO SqlScriptManager 2015-09-16 10:47:56,351 Module Upgrade : finished running script : comm-create.sql INFO ScriptService$Console 2015-09-16 10:47:56,352 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:56,352 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:56,435 http-bio-8080-exec-9 : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:56,470 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:47:57,708 Module Upgrade : Loading DbSchema "labkey.comm" (Module) INFO DbScope 2015-09-16 10:47:57,757 Module Upgrade : Loading DbSchema "labkey.filecontent" (Module) INFO SqlScriptRunner 2015-09-16 10:47:57,866 Module Upgrade : Running [filecontent-0.00-12.10.sql, filecontent-14.10-14.20.sql] INFO SqlScriptManager 2015-09-16 10:47:57,871 Module Upgrade : start running script : filecontent-0.00-12.10.sql INFO SqlScriptManager 2015-09-16 10:47:57,900 Module Upgrade : finished running script : filecontent-0.00-12.10.sql INFO SqlScriptManager 2015-09-16 10:47:57,929 Module Upgrade : start running script : filecontent-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:57,956 Module Upgrade : finished running script : filecontent-14.10-14.20.sql INFO ScriptService$Console 2015-09-16 10:47:57,975 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:57,980 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:58,072 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:58,458 Module Upgrade : Loading DbSchema "labkey.filecontent" (Module) INFO DbScope 2015-09-16 10:47:58,486 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:47:58,506 Module Upgrade : Loading DbSchema "labkey.issues" (Module) INFO SqlScriptRunner 2015-09-16 10:47:58,616 Module Upgrade : Running [issues-0.00-13.10.sql, issues-14.10-14.20.sql] INFO SqlScriptManager 2015-09-16 10:47:58,620 Module Upgrade : start running script : issues-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:47:58,757 Module Upgrade : finished running script : issues-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:47:58,782 Module Upgrade : start running script : issues-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:47:58,801 Module Upgrade : finished running script : issues-14.10-14.20.sql INFO ScriptService$Console 2015-09-16 10:47:58,823 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:47:58,831 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:47:58,926 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:47:58,977 Module Upgrade : Loading DbSchema "labkey.issues" (Module) INFO DbScope 2015-09-16 10:47:59,023 Module Upgrade : Loading DbSchema "labkey.study" (Module) INFO DbScope 2015-09-16 10:47:59,091 Module Upgrade : Loading DbSchema "labkey.studydataset" (Provisioned) INFO DbScope 2015-09-16 10:47:59,091 Module Upgrade : Loading DbSchema "labkey.assayresult" (Provisioned) INFO DbScope 2015-09-16 10:47:59,091 Module Upgrade : Loading DbSchema "labkey.studydesign" (Provisioned) INFO DbScope 2015-09-16 10:47:59,091 Module Upgrade : Loading DbSchema "labkey.specimentables" (Provisioned) INFO SqlScriptRunner 2015-09-16 10:47:59,146 Module Upgrade : Running [study-0.00-13.10.sql, study-13.10-13.20.sql, study-13.20-13.30.sql, study-13.30-14.10.sql, study-14.10-14.20.sql, study-14.20-14.30.sql, study-14.30-15.10.sql, study-15.10-15.20.sql] INFO SqlScriptManager 2015-09-16 10:47:59,159 Module Upgrade : start running script : study-0.00-13.10.sql INFO DbScope 2015-09-16 10:47:59,443 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:48:01,972 Module Upgrade : finished running script : study-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:48:01,996 Module Upgrade : start running script : study-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:48:02,046 Module Upgrade : finished running script : study-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:48:02,073 Module Upgrade : start running script : study-13.20-13.30.sql INFO ScriptService$Console 2015-09-16 10:48:02,168 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:48:02,168 Module Upgrade : Adding deferred upgrade task to execute StudyUpgradeCode.upgradeExternalReports(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:48:02,169 Module Upgrade : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:48:02,169 Module Upgrade : finished running script : study-13.20-13.30.sql INFO DbScope 2015-09-16 10:48:02,169 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:48:02,275 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:48:02,398 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:48:03,119 Module Upgrade : start running script : study-13.30-14.10.sql INFO ScriptService$Console 2015-09-16 10:48:03,150 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:48:03,151 Module Upgrade : Executing StudyUpgradeCode.migrateSpecimenTables(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:48:03,151 Module Upgrade : Purging RhinoService caches INFO ScriptService$Console 2015-09-16 10:48:03,271 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:48:03,272 Module Upgrade : Adding deferred upgrade task to execute StudyUpgradeCode.moveDefaultFormatProperties(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:48:03,272 Module Upgrade : Purging RhinoService caches INFO ScriptService$Console 2015-09-16 10:48:03,295 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:48:03,295 Module Upgrade : Executing StudyUpgradeCode.migrateProvisionedDatasetTables141(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:48:03,296 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:48:03,316 http-bio-8080-exec-9 : Loading DbSchema "labkey.core" (Module) INFO ScriptService$Console 2015-09-16 10:48:03,356 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:48:03,357 Module Upgrade : Adding deferred upgrade task to execute StudyUpgradeCode.migrateSpecimenDrawTimeStamp(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:48:03,357 Module Upgrade : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:48:03,394 Module Upgrade : finished running script : study-13.30-14.10.sql INFO DbScope 2015-09-16 10:48:03,394 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:48:03,466 http-bio-8080-exec-9 : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:48:03,499 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:48:03,522 Module Upgrade : start running script : study-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:48:03,674 Module Upgrade : finished running script : study-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:48:03,697 Module Upgrade : start running script : study-14.20-14.30.sql INFO SqlScriptManager 2015-09-16 10:48:03,766 Module Upgrade : finished running script : study-14.20-14.30.sql INFO SqlScriptManager 2015-09-16 10:48:03,788 Module Upgrade : start running script : study-14.30-15.10.sql INFO ScriptService$Console 2015-09-16 10:48:03,840 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:48:03,840 Module Upgrade : Adding deferred upgrade task to execute StudyUpgradeCode.migrateSpecimenTypeAndLocationTables(ModuleContext moduleContext) INFO ScriptService$Console 2015-09-16 10:48:03,841 Module Upgrade : Purging RhinoService caches INFO ScriptService$Console 2015-09-16 10:48:03,860 Module Upgrade : Purging RhinoService caches INFO SqlScriptExecutor 2015-09-16 10:48:03,860 Module Upgrade : Executing StudyUpgradeCode.upgradeStudySnapshotsType(ModuleContext moduleContext) INFO DbScope 2015-09-16 10:48:03,860 Module Upgrade : Loading DbSchema "labkey.study" (Module) INFO DbScope 2015-09-16 10:48:03,950 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO ScriptService$Console 2015-09-16 10:48:04,005 Module Upgrade : Purging RhinoService caches INFO SqlScriptManager 2015-09-16 10:48:04,006 Module Upgrade : finished running script : study-14.30-15.10.sql INFO DbScope 2015-09-16 10:48:04,006 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:48:04,108 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO SqlScriptManager 2015-09-16 10:48:04,177 Module Upgrade : start running script : study-15.10-15.20.sql INFO SqlScriptManager 2015-09-16 10:48:04,199 Module Upgrade : finished running script : study-15.10-15.20.sql INFO ScriptService$Console 2015-09-16 10:48:04,219 Module Upgrade : Purging RhinoService caches INFO SqlScriptRunner 2015-09-16 10:48:04,235 Module Upgrade : Running [study-create.sql] INFO SqlScriptManager 2015-09-16 10:48:04,236 Module Upgrade : start running script : study-create.sql INFO SqlScriptManager 2015-09-16 10:48:04,259 Module Upgrade : finished running script : study-create.sql INFO ScriptService$Console 2015-09-16 10:48:04,260 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:48:04,266 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:48:04,366 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:48:04,407 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:48:04,507 Module Upgrade : Loading DbSchema "labkey.study" (Module) INFO DbScope 2015-09-16 10:48:04,563 Module Upgrade : Loading DbSchema "labkey.studydataset" (Provisioned) INFO DbScope 2015-09-16 10:48:04,563 Module Upgrade : Loading DbSchema "labkey.assayresult" (Provisioned) INFO DbScope 2015-09-16 10:48:04,563 Module Upgrade : Loading DbSchema "labkey.studydesign" (Provisioned) INFO DbScope 2015-09-16 10:48:04,563 Module Upgrade : Loading DbSchema "labkey.specimentables" (Provisioned) INFO DbScope 2015-09-16 10:48:04,601 Module Upgrade : Loading DbSchema "labkey.luminex" (Module) INFO SqlScriptRunner 2015-09-16 10:48:04,694 Module Upgrade : Running [luminex-0.00-12.10.sql, luminex-13.20-13.30.sql, luminex-14.10-14.20.sql, luminex-14.20-14.30.sql, luminex-14.30-15.10.sql] INFO SqlScriptManager 2015-09-16 10:48:04,700 Module Upgrade : start running script : luminex-0.00-12.10.sql INFO SqlScriptManager 2015-09-16 10:48:05,536 Module Upgrade : finished running script : luminex-0.00-12.10.sql INFO SqlScriptManager 2015-09-16 10:48:05,563 Module Upgrade : start running script : luminex-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:48:05,630 Module Upgrade : finished running script : luminex-13.20-13.30.sql INFO SqlScriptManager 2015-09-16 10:48:05,654 Module Upgrade : start running script : luminex-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:48:05,755 Module Upgrade : finished running script : luminex-14.10-14.20.sql INFO SqlScriptManager 2015-09-16 10:48:05,787 Module Upgrade : start running script : luminex-14.20-14.30.sql INFO SqlScriptManager 2015-09-16 10:48:05,968 Module Upgrade : finished running script : luminex-14.20-14.30.sql INFO SqlScriptManager 2015-09-16 10:48:06,006 Module Upgrade : start running script : luminex-14.30-15.10.sql INFO SqlScriptManager 2015-09-16 10:48:06,092 Module Upgrade : finished running script : luminex-14.30-15.10.sql INFO ScriptService$Console 2015-09-16 10:48:06,112 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:48:06,123 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:48:06,235 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:48:06,287 Module Upgrade : Loading DbSchema "labkey.luminex" (Module) INFO DbScope 2015-09-16 10:48:06,339 Module Upgrade : Loading DbSchema "labkey.nab" (Module) INFO DbScope 2015-09-16 10:48:06,397 Module Upgrade : Loading DbSchema "labkey.nabvirus" (Provisioned) INFO SqlScriptRunner 2015-09-16 10:48:06,447 Module Upgrade : Running [nab-0.00-13.10.sql, nab-13.10-13.20.sql, nab-14.20-14.30.sql, nab-14.30-15.10.sql, nab-15.10-15.20.sql] INFO SqlScriptManager 2015-09-16 10:48:06,453 Module Upgrade : start running script : nab-0.00-13.10.sql INFO DbScope 2015-09-16 10:48:06,543 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO SqlScriptManager 2015-09-16 10:48:07,053 Module Upgrade : finished running script : nab-0.00-13.10.sql INFO SqlScriptManager 2015-09-16 10:48:07,079 Module Upgrade : start running script : nab-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:48:07,097 Module Upgrade : finished running script : nab-13.10-13.20.sql INFO SqlScriptManager 2015-09-16 10:48:07,118 Module Upgrade : start running script : nab-14.20-14.30.sql INFO SqlScriptManager 2015-09-16 10:48:07,141 Module Upgrade : finished running script : nab-14.20-14.30.sql INFO SqlScriptManager 2015-09-16 10:48:07,164 Module Upgrade : start running script : nab-14.30-15.10.sql INFO SqlScriptManager 2015-09-16 10:48:07,325 Module Upgrade : finished running script : nab-14.30-15.10.sql INFO SqlScriptManager 2015-09-16 10:48:07,350 Module Upgrade : start running script : nab-15.10-15.20.sql INFO SqlScriptManager 2015-09-16 10:48:07,361 Module Upgrade : finished running script : nab-15.10-15.20.sql INFO ScriptService$Console 2015-09-16 10:48:07,381 Module Upgrade : Purging RhinoService caches INFO DbScope 2015-09-16 10:48:07,391 Module Upgrade : Loading DbSchema "labkey.core" (Module) INFO DbScope 2015-09-16 10:48:07,497 Module Upgrade : Loading DbSchema "labkey.temp" (Provisioned) INFO DbScope 2015-09-16 10:48:07,625 http-bio-8080-exec-9 : Loading DbSchema "labkey.prop" (Module) INFO DbScope 2015-09-16 10:48:07,655 Module Upgrade : Loading DbSchema "labkey.nab" (Module) INFO DbScope 2015-09-16 10:48:07,712 Module Upgrade : Loading DbSchema "labkey.nabvirus" (Provisioned) INFO ModuleLoader 2015-09-16 10:48:07,828 http-bio-8080-exec-9 : Starting up modules INFO ModuleLoader 2015-09-16 10:48:07,829 Module Starter : Starting module 'Core' INFO DbScope 2015-09-16 10:48:08,622 Module Starter : Loading DbSchema "labkey.exp" (Module) INFO DbScope 2015-09-16 10:48:08,783 Module Starter : Loading DbSchema "labkey.study" (Module) INFO DbScope 2015-09-16 10:48:09,046 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:09,261 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:09,346 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:09,465 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:09,527 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:09,622 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:09,687 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:09,857 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:09,914 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:10,184 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:10,246 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:10,328 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO ModuleLoader 2015-09-16 10:48:10,618 Module Starter : Starting module 'Authentication' INFO ModuleLoader 2015-09-16 10:48:10,620 Module Starter : Starting module 'BigIron' INFO ModuleLoader 2015-09-16 10:48:10,622 Module Starter : Starting module 'FCSExpress' INFO ModuleLoader 2015-09-16 10:48:10,643 Module Starter : Starting module 'Pipeline' INFO SpringModule 2015-09-16 10:48:10,647 Module Starter : Loading Spring configuration for the Pipeline module from [/WEB-INF/pipelineContext.xml] INFO SpringModule$1 2015-09-16 10:48:10,649 Module Starter : Refreshing Pipeline WebApplicationContext: startup date [Wed Sep 16 10:48:10 CEST 2015]; parent: Root WebApplicationContext INFO DbScope 2015-09-16 10:48:10,777 Module Starter : Loading DbSchema "labkey.pipeline" (Module) INFO ModuleLoader 2015-09-16 10:48:11,128 Module Starter : Starting module 'Experiment' INFO SpringModule 2015-09-16 10:48:11,131 Module Starter : Loading Spring configuration for the Experiment module from [/WEB-INF/experimentContext.xml] INFO SpringModule$1 2015-09-16 10:48:11,132 Module Starter : Refreshing Experiment WebApplicationContext: startup date [Wed Sep 16 10:48:11 CEST 2015]; parent: Root WebApplicationContext INFO DbScope 2015-09-16 10:48:11,230 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:11,315 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:11,382 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:11,510 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:11,566 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO ModuleLoader 2015-09-16 10:48:12,027 Module Starter : Starting module 'Audit' INFO DbScope 2015-09-16 10:48:12,145 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO ModuleLoader 2015-09-16 10:48:12,154 Module Starter : Starting module 'DataIntegration' INFO ModuleLoader 2015-09-16 10:48:12,165 Module Starter : Starting module 'List' INFO DbScope 2015-09-16 10:48:12,225 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:12,375 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO ModuleLoader 2015-09-16 10:48:12,399 Module Starter : Starting module 'ELISpotAssay' INFO ModuleLoader 2015-09-16 10:48:12,412 Module Starter : Starting module 'Microarray' INFO SpringModule 2015-09-16 10:48:12,415 Module Starter : Loading Spring configuration for the Microarray module from [/WEB-INF/microarrayContext.xml] INFO SpringModule$1 2015-09-16 10:48:12,416 Module Starter : Refreshing Microarray WebApplicationContext: startup date [Wed Sep 16 10:48:12 CEST 2015]; parent: Root WebApplicationContext INFO ModuleLoader 2015-09-16 10:48:12,504 Module Starter : Starting module 'Query' INFO DbScope 2015-09-16 10:48:12,585 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:12,700 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:12,759 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:12,894 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO ModuleLoader 2015-09-16 10:48:12,912 Module Starter : Starting module 'Flow' INFO DbScope 2015-09-16 10:48:12,932 Module Starter : Loading DbSchema "labkey.flow" (Module) INFO ModuleLoader 2015-09-16 10:48:13,014 Module Starter : Starting module 'MS2' INFO SpringModule 2015-09-16 10:48:13,029 Module Starter : Loading Spring configuration for the MS2 module from [/WEB-INF/ms2Context.xml] INFO SpringModule$1 2015-09-16 10:48:13,031 Module Starter : Refreshing MS2 WebApplicationContext: startup date [Wed Sep 16 10:48:13 CEST 2015]; parent: Root WebApplicationContext INFO DbScope 2015-09-16 10:48:13,371 Module Starter : Loading DbSchema "labkey.ms2" (Module) INFO DbScope 2015-09-16 10:48:13,634 Module Starter : Loading DbSchema "labkey.prot" (Module) INFO ModuleLoader 2015-09-16 10:48:14,116 Module Starter : Starting module 'MS1' INFO SpringModule 2015-09-16 10:48:14,128 Module Starter : Loading Spring configuration for the MS1 module from [/WEB-INF/ms1Context.xml] INFO SpringModule$1 2015-09-16 10:48:14,130 Module Starter : Refreshing MS1 WebApplicationContext: startup date [Wed Sep 16 10:48:14 CEST 2015]; parent: Root WebApplicationContext INFO DbScope 2015-09-16 10:48:14,199 Module Starter : Loading DbSchema "labkey.ms1" (Module) INFO ModuleLoader 2015-09-16 10:48:14,520 Module Starter : Starting module 'Search' INFO DbScope 2015-09-16 10:48:14,685 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:14,842 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO ModuleLoader 2015-09-16 10:48:14,858 Module Starter : Starting module 'Survey' INFO ModuleLoader 2015-09-16 10:48:14,861 Module Starter : Starting module 'TargetedMS' INFO SpringModule 2015-09-16 10:48:14,869 Module Starter : Loading Spring configuration for the TargetedMS module from [/WEB-INF/targetedmsContext.xml] INFO SpringModule$1 2015-09-16 10:48:14,871 Module Starter : Refreshing TargetedMS WebApplicationContext: startup date [Wed Sep 16 10:48:14 CEST 2015]; parent: Root WebApplicationContext INFO DbScope 2015-09-16 10:48:15,107 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO ModuleLoader 2015-09-16 10:48:15,147 Module Starter : Starting module 'Wiki' INFO DbScope 2015-09-16 10:48:18,232 Module Starter : Loading DbSchema "labkey.comm" (Module) INFO ModuleLoader 2015-09-16 10:48:19,046 Module Starter : Starting module 'Announcements' INFO DbScope 2015-09-16 10:48:19,255 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO ModuleLoader 2015-09-16 10:48:19,321 Module Starter : Starting module 'FileContent' INFO ModuleLoader 2015-09-16 10:48:19,330 Module Starter : Starting module 'Issues' INFO DbScope 2015-09-16 10:48:19,338 Module Starter : Loading DbSchema "labkey.issues" (Module) INFO ModuleLoader 2015-09-16 10:48:19,401 Module Starter : Starting module 'Study' INFO SpringModule 2015-09-16 10:48:19,407 Module Starter : Loading Spring configuration for the Study module from [/WEB-INF/studyContext.xml] INFO SpringModule$1 2015-09-16 10:48:19,408 Module Starter : Refreshing Study WebApplicationContext: startup date [Wed Sep 16 10:48:19 CEST 2015]; parent: Root WebApplicationContext INFO DbScope 2015-09-16 10:48:19,664 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:19,909 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:20,214 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:21,020 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:21,146 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO DbScope 2015-09-16 10:48:21,243 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO ModuleLoader 2015-09-16 10:48:21,470 Module Starter : Starting module 'Elisa' INFO ModuleLoader 2015-09-16 10:48:21,479 Module Starter : Starting module 'FreezerPro' INFO ModuleLoader 2015-09-16 10:48:21,482 Module Starter : Starting module 'Luminex' INFO ModuleLoader 2015-09-16 10:48:21,508 Module Starter : Starting module 'Nab' INFO ModuleLoader 2015-09-16 10:48:21,548 Module Starter : Starting module 'Visualization' INFO ModuleLoader 2015-09-16 10:48:21,550 Module Starter : Running deferred upgrade for module 'Core': populateWorkbookSortOrderAndName INFO ModuleLoader 2015-09-16 10:48:21,600 Module Starter : Running deferred upgrade for module 'Core': ensureCoreUserPropertyDescriptorScales INFO ModuleLoader 2015-09-16 10:48:21,646 Module Starter : Running deferred upgrade for module 'Audit': convertGroupAuditUserField INFO ModuleLoader 2015-09-16 10:48:21,646 Module Starter : Running deferred upgrade for module 'Study': upgradeExternalReports INFO ModuleLoader 2015-09-16 10:48:21,646 Module Starter : Running deferred upgrade for module 'Study': moveDefaultFormatProperties INFO ModuleLoader 2015-09-16 10:48:21,646 Module Starter : Running deferred upgrade for module 'Study': migrateSpecimenDrawTimeStamp INFO ModuleLoader 2015-09-16 10:48:21,646 Module Starter : Running deferred upgrade for module 'Study': migrateSpecimenTypeAndLocationTables INFO DbScope 2015-09-16 10:48:21,647 Module Starter : Loading DbSchema "labkey.specimentables" (Provisioned) INFO ModuleLoader 2015-09-16 10:48:22,101 Module Starter : Running startup listener: Audit Log INFO AuditLogImpl 2015-09-16 10:48:22,101 Module Starter : Attempting to migrate all registered audit providers INFO AuditLogImpl 2015-09-16 10:48:22,102 Module Starter : Migrating audit type ExperimentAuditEvent INFO DbScope 2015-09-16 10:48:22,126 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO AuditLogImpl 2015-09-16 10:48:22,446 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d11_experimentauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:22,446 Module Starter : Migrating audit log for audit type ExperimentAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:22,454 Module Starter : Migrated 0 rows for audit type ExperimentAuditEvent INFO AuditLogImpl 2015-09-16 10:48:22,457 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d11_experimentauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:22,457 Module Starter : Marking provider ExperimentAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:22,499 Module Starter : Marked provider ExperimentAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:22,540 Module Starter : Migrating audit type AttachmentAuditEvent INFO AuditLogImpl 2015-09-16 10:48:22,660 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d3_attachmentauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:22,660 Module Starter : Migrating audit log for audit type AttachmentAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:22,673 Module Starter : Migrated 0 rows for audit type AttachmentAuditEvent INFO AuditLogImpl 2015-09-16 10:48:22,677 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d3_attachmentauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:22,677 Module Starter : Marking provider AttachmentAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:22,732 Module Starter : Marked provider AttachmentAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:22,749 Module Starter : Audit provider 'AuthenticationProviderConfiguration' postdates the audit migration, so it has no old events to convert. Skipping. INFO AuditLogImpl 2015-09-16 10:48:22,749 Module Starter : Migrating audit type Client API Actions WARN AuditLogImpl 2015-09-16 10:48:22,859 Module Starter : Could not copy column 'String3' INFO AuditLogImpl 2015-09-16 10:48:22,887 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d7_clientapiauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:22,887 Module Starter : Migrating audit log for audit type Client API Actions... please be patient INFO AuditLogImpl 2015-09-16 10:48:22,906 Module Starter : Migrated 0 rows for audit type Client API Actions INFO AuditLogImpl 2015-09-16 10:48:22,910 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d7_clientapiauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:22,910 Module Starter : Marking provider Client API Actions as migrated. INFO AuditLogImpl 2015-09-16 10:48:22,964 Module Starter : Marked provider Client API Actions as migrated. INFO AuditLogImpl 2015-09-16 10:48:22,981 Module Starter : Migrating audit type AssayPublishAuditEvent WARN AuditLogImpl 2015-09-16 10:48:23,096 Module Starter : Could not copy column 'SourceLsid' WARN AuditLogImpl 2015-09-16 10:48:23,096 Module Starter : Could not copy column 'RecordCount' WARN AuditLogImpl 2015-09-16 10:48:23,096 Module Starter : Could not copy column 'DatasetId' INFO AuditLogImpl 2015-09-16 10:48:23,110 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d20_assayauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:23,110 Module Starter : Migrating audit log for audit type AssayPublishAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:23,123 Module Starter : Migrated 0 rows for audit type AssayPublishAuditEvent INFO AuditLogImpl 2015-09-16 10:48:23,128 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d20_assayauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:23,128 Module Starter : Marking provider AssayPublishAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:23,223 Module Starter : Marked provider AssayPublishAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:23,293 Module Starter : Migrating audit type DatasetAuditEvent WARN AuditLogImpl 2015-09-16 10:48:23,459 Module Starter : Could not copy column 'newRecordMap' WARN AuditLogImpl 2015-09-16 10:48:23,459 Module Starter : Could not copy column 'oldRecordMap' INFO AuditLogImpl 2015-09-16 10:48:23,467 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d21_datasetauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:23,467 Module Starter : Migrating audit log for audit type DatasetAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:23,474 Module Starter : Migrated 0 rows for audit type DatasetAuditEvent INFO AuditLogImpl 2015-09-16 10:48:23,480 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d21_datasetauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:23,480 Module Starter : Marking provider DatasetAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:23,538 Module Starter : Marked provider DatasetAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:23,555 Module Starter : Migrating audit type DomainAuditEvent INFO AuditLogImpl 2015-09-16 10:48:23,685 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d10_domainauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:23,685 Module Starter : Migrating audit log for audit type DomainAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:23,691 Module Starter : Migrated 0 rows for audit type DomainAuditEvent INFO AuditLogImpl 2015-09-16 10:48:23,695 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d10_domainauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:23,695 Module Starter : Marking provider DomainAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:23,767 Module Starter : Marked provider DomainAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:23,785 Module Starter : Migrating audit type FileSystemBatch INFO DbScope 2015-09-16 10:48:23,873 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO AuditLogImpl 2015-09-16 10:48:23,987 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d6_filesystembatchauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:23,987 Module Starter : Migrating audit log for audit type FileSystemBatch... please be patient INFO AuditLogImpl 2015-09-16 10:48:23,993 Module Starter : Migrated 0 rows for audit type FileSystemBatch INFO AuditLogImpl 2015-09-16 10:48:23,997 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d6_filesystembatchauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:23,997 Module Starter : Marking provider FileSystemBatch as migrated. INFO AuditLogImpl 2015-09-16 10:48:24,073 Module Starter : Marked provider FileSystemBatch as migrated. INFO AuditLogImpl 2015-09-16 10:48:24,090 Module Starter : Migrating audit type FileSystem INFO AuditLogImpl 2015-09-16 10:48:24,249 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d5_filesystemauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:24,249 Module Starter : Migrating audit log for audit type FileSystem... please be patient INFO AuditLogImpl 2015-09-16 10:48:24,256 Module Starter : Migrated 0 rows for audit type FileSystem INFO AuditLogImpl 2015-09-16 10:48:24,273 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d5_filesystemauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:24,273 Module Starter : Marking provider FileSystem as migrated. INFO AuditLogImpl 2015-09-16 10:48:24,359 Module Starter : Marked provider FileSystem as migrated. INFO AuditLogImpl 2015-09-16 10:48:24,379 Module Starter : Migrating audit type GroupAuditEvent INFO AuditLogImpl 2015-09-16 10:48:24,487 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d2_groupauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:24,487 Module Starter : Migrating audit log for audit type GroupAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:24,493 Module Starter : Migrated 0 rows for audit type GroupAuditEvent INFO AuditLogImpl 2015-09-16 10:48:24,497 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d2_groupauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:24,497 Module Starter : Marking provider GroupAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:24,636 Module Starter : Marked provider GroupAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:24,654 Module Starter : Migrating audit type ListAuditEvent WARN AuditLogImpl 2015-09-16 10:48:24,757 Module Starter : Could not copy column 'newRecordMap' WARN AuditLogImpl 2015-09-16 10:48:24,758 Module Starter : Could not copy column 'oldRecordMap' INFO AuditLogImpl 2015-09-16 10:48:24,770 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d14_listauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:24,770 Module Starter : Migrating audit log for audit type ListAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:24,787 Module Starter : Migrated 0 rows for audit type ListAuditEvent INFO AuditLogImpl 2015-09-16 10:48:24,791 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d14_listauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:24,791 Module Starter : Marking provider ListAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:24,889 Module Starter : Marked provider ListAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:24,906 Module Starter : Migrating audit type MessageAuditEvent INFO AuditLogImpl 2015-09-16 10:48:25,125 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d19_messageauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:25,126 Module Starter : Migrating audit log for audit type MessageAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:25,132 Module Starter : Migrated 0 rows for audit type MessageAuditEvent INFO AuditLogImpl 2015-09-16 10:48:25,137 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d19_messageauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:25,137 Module Starter : Marking provider MessageAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:25,253 Module Starter : Marked provider MessageAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:25,271 Module Starter : Migrating audit type ContainerAuditEvent INFO DbScope 2015-09-16 10:48:25,373 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO AuditLogImpl 2015-09-16 10:48:25,465 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d4_containerauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:25,465 Module Starter : Migrating audit log for audit type ContainerAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:25,471 Module Starter : Migrated 0 rows for audit type ContainerAuditEvent INFO AuditLogImpl 2015-09-16 10:48:25,476 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d4_containerauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:25,476 Module Starter : Marking provider ContainerAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:25,597 Module Starter : Marked provider ContainerAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:25,619 Module Starter : Migrating audit type QueryExportAuditEvent INFO AuditLogImpl 2015-09-16 10:48:25,767 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d15_queryauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:25,767 Module Starter : Migrating audit log for audit type QueryExportAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:25,773 Module Starter : Migrated 0 rows for audit type QueryExportAuditEvent INFO AuditLogImpl 2015-09-16 10:48:25,777 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d15_queryauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:25,777 Module Starter : Marking provider QueryExportAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:26,128 Module Starter : Marked provider QueryExportAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:26,324 Module Starter : Migrating audit type QueryUpdateAuditEvent WARN AuditLogImpl 2015-09-16 10:48:26,505 Module Starter : Could not copy column 'newRecordMap' WARN AuditLogImpl 2015-09-16 10:48:26,506 Module Starter : Could not copy column 'oldRecordMap' INFO AuditLogImpl 2015-09-16 10:48:26,517 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d16_queryupdateauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:26,517 Module Starter : Migrating audit log for audit type QueryUpdateAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:26,525 Module Starter : Migrated 0 rows for audit type QueryUpdateAuditEvent INFO AuditLogImpl 2015-09-16 10:48:26,529 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d16_queryupdateauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:26,529 Module Starter : Marking provider QueryUpdateAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:26,643 Module Starter : Marked provider QueryUpdateAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:26,662 Module Starter : Migrating audit type SampleSetAuditEvent INFO DbScope 2015-09-16 10:48:26,746 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO AuditLogImpl 2015-09-16 10:48:26,861 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d12_samplesetauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:26,861 Module Starter : Migrating audit log for audit type SampleSetAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:26,867 Module Starter : Migrated 0 rows for audit type SampleSetAuditEvent INFO AuditLogImpl 2015-09-16 10:48:26,871 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d12_samplesetauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:26,871 Module Starter : Marking provider SampleSetAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:26,978 Module Starter : Marked provider SampleSetAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:27,000 Module Starter : Migrating audit type SearchAuditEvent INFO AuditLogImpl 2015-09-16 10:48:27,198 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d17_searchauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:27,198 Module Starter : Migrating audit log for audit type SearchAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:27,204 Module Starter : Migrated 0 rows for audit type SearchAuditEvent INFO AuditLogImpl 2015-09-16 10:48:27,208 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d17_searchauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:27,209 Module Starter : Marking provider SearchAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:27,318 Module Starter : Marked provider SearchAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:27,337 Module Starter : Migrating audit type AppPropsEvent WARN AuditLogImpl 2015-09-16 10:48:27,451 Module Starter : Could not copy column 'Changes' INFO AuditLogImpl 2015-09-16 10:48:27,463 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d13_sitesettingsauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:27,463 Module Starter : Migrating audit log for audit type AppPropsEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:27,471 Module Starter : Migrated 0 rows for audit type AppPropsEvent INFO AuditLogImpl 2015-09-16 10:48:27,475 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d13_sitesettingsauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:27,475 Module Starter : Marking provider AppPropsEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:27,602 Module Starter : Marked provider AppPropsEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:27,622 Module Starter : Migrating audit type SpecimenCommentEvent INFO AuditLogImpl 2015-09-16 10:48:27,770 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d22_specimencommentauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:27,770 Module Starter : Migrating audit log for audit type SpecimenCommentEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:27,777 Module Starter : Migrated 0 rows for audit type SpecimenCommentEvent INFO AuditLogImpl 2015-09-16 10:48:27,781 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d22_specimencommentauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:27,781 Module Starter : Marking provider SpecimenCommentEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:27,941 Module Starter : Marked provider SpecimenCommentEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:28,004 Module Starter : Migrating audit type TargetedMSRepresentativeStateEvent INFO DbScope 2015-09-16 10:48:28,091 Module Starter : Loading DbSchema "labkey.audit" (Provisioned) INFO AuditLogImpl 2015-09-16 10:48:28,150 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c912916549representativestateauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:28,150 Module Starter : Migrating audit log for audit type TargetedMSRepresentativeStateEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:28,156 Module Starter : Migrated 0 rows for audit type TargetedMSRepresentativeStateEvent INFO AuditLogImpl 2015-09-16 10:48:28,160 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c912916549representativestateauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:28,160 Module Starter : Marking provider TargetedMSRepresentativeStateEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:28,304 Module Starter : Marked provider TargetedMSRepresentativeStateEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:28,322 Module Starter : Migrating audit type UserAuditEvent INFO AuditLogImpl 2015-09-16 10:48:28,477 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d1_userauditdomain ON INFO AuditLogImpl 2015-09-16 10:48:28,477 Module Starter : Migrating audit log for audit type UserAuditEvent... please be patient INFO AuditLogImpl 2015-09-16 10:48:28,483 Module Starter : Migrated 0 rows for audit type UserAuditEvent INFO AuditLogImpl 2015-09-16 10:48:28,487 Module Starter : SQLServer, SET IDENTITY_INSERT audit.c3d1_userauditdomain OFF INFO AuditLogImpl 2015-09-16 10:48:28,487 Module Starter : Marking provider UserAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:28,658 Module Starter : Marked provider UserAuditEvent as migrated. INFO AuditLogImpl 2015-09-16 10:48:28,698 Module Starter : All audit event types have now been migrated. INFO AuditLogImpl 2015-09-16 10:48:28,698 Module Starter : Deleting ontology objects referenced by the audit log... INFO AuditLogImpl 2015-09-16 10:48:29,588 Module Starter : Unregistering the old audit view factory ExperimentAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,596 Module Starter : Unregistering the old audit view factory AttachmentAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,604 Module Starter : Unregistering the old audit view factory AuthenticationProviderConfiguration INFO AuditLogImpl 2015-09-16 10:48:29,613 Module Starter : Unregistering the old audit view factory Client API Actions INFO AuditLogImpl 2015-09-16 10:48:29,621 Module Starter : Unregistering the old audit view factory AssayPublishAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,629 Module Starter : Unregistering the old audit view factory DatasetAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,638 Module Starter : Unregistering the old audit view factory DomainAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,669 Module Starter : Unregistering the old audit view factory FileSystemBatch INFO AuditLogImpl 2015-09-16 10:48:29,677 Module Starter : Unregistering the old audit view factory FileSystem INFO AuditLogImpl 2015-09-16 10:48:29,685 Module Starter : Unregistering the old audit view factory GroupAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,693 Module Starter : Unregistering the old audit view factory ListAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,702 Module Starter : Unregistering the old audit view factory MessageAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,710 Module Starter : Unregistering the old audit view factory ContainerAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,718 Module Starter : Unregistering the old audit view factory QueryExportAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,728 Module Starter : Unregistering the old audit view factory QueryUpdateAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,736 Module Starter : Unregistering the old audit view factory SampleSetAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,745 Module Starter : Unregistering the old audit view factory SearchAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,753 Module Starter : Unregistering the old audit view factory AppPropsEvent INFO AuditLogImpl 2015-09-16 10:48:29,761 Module Starter : Unregistering the old audit view factory SpecimenCommentEvent INFO AuditLogImpl 2015-09-16 10:48:29,770 Module Starter : Unregistering the old audit view factory TargetedMSRepresentativeStateEvent INFO AuditLogImpl 2015-09-16 10:48:29,778 Module Starter : Unregistering the old audit view factory UserAuditEvent INFO AuditLogImpl 2015-09-16 10:48:29,778 Module Starter : Dropping the audit log table... INFO AuditLogImpl 2015-09-16 10:48:29,836 Module Starter : Marking audit log migration as complete INFO DbScope 2015-09-16 10:48:30,226 Module Starter : Loading DbSchema "labkey.query" (Module) INFO ModuleLoader 2015-09-16 10:48:31,550 Module Starter : Running startup listener: Search Service: clear indexes INFO DbScope 2015-09-16 10:48:31,769 Module Starter : Loading DbSchema "labkey.search" (Module) INFO ModuleLoader 2015-09-16 10:48:32,218 Module Starter : Running startup listener: PipelineJobRestarter INFO ModuleLoader 2015-09-16 10:48:32,223 Module Starter : Running startup listener: DataIntegration INFO DbScope 2015-09-16 10:48:32,223 Module Starter : Loading DbSchema "labkey.dataintegration" (Module) INFO ModuleLoader 2015-09-16 10:48:32,399 Module Starter : Running startup listener: Search Service INFO ModuleLoader 2015-09-16 10:48:32,849 Module Starter : Running startup listener: Daily Message Digest INFO ModuleLoader 2015-09-16 10:48:32,850 Module Starter : Running startup listener: Short Message Digest INFO ModuleLoader 2015-09-16 10:48:32,850 Module Starter : Module startup complete INFO DbScope 2015-09-16 10:48:35,269 DavCrawler : Loading DbSchema "labkey.filecontent" (Module) INFO DbScope 2015-09-16 10:53:39,382 http-bio-8080-exec-1 : Loading DbSchema "labkey.specimentables" (Provisioned) INFO DbScope 2015-09-16 10:53:40,318 http-bio-8080-exec-1 : Loading DbSchema "labkey.specimentables" (Provisioned) INFO DbScope 2015-09-16 10:53:40,648 http-bio-8080-exec-1 : Loading DbSchema "labkey.specimentables" (Provisioned) INFO DbScope 2015-09-16 10:53:40,934 http-bio-8080-exec-1 : Loading DbSchema "labkey.specimentables" (Provisioned) INFO DbScope 2015-09-16 10:53:42,021 http-bio-8080-exec-1 : Loading DbSchema "labkey.specimentables" (Provisioned) INFO DbScope 2015-09-16 10:53:43,156 http-bio-8080-exec-1 : Loading DbSchema "labkey.specimentables" (Provisioned) INFO DbScope 2015-09-16 10:53:45,421 http-bio-8080-exec-1 : Loading DbSchema "labkey.specimentables" (Provisioned) INFO DbScope 2015-09-16 10:53:46,648 http-bio-8080-exec-1 : Loading DbSchema "labkey.studydesign" (Provisioned) INFO DbScope 2015-09-16 10:53:46,866 http-bio-8080-exec-1 : Loading DbSchema "labkey.studydesign" (Provisioned) INFO DbScope 2015-09-16 10:53:56,071 http-bio-8080-exec-9 : Loading DbSchema "labkey.list" (Provisioned) INFO DbScope 2015-09-16 10:54:50,996 http-bio-8080-exec-10 : Loading DbSchema "labkey.assayresult" (Provisioned) INFO DbScope 2015-09-16 10:54:51,080 http-bio-8080-exec-10 : Loading DbSchema "labkey.assayresult" (Provisioned) ERROR Table 2015-09-16 10:54:56,867 st: http-bio-8080-exec-9 : SQL Exception java.sql.SQLException: Parameter #20 has not been set. at net.sourceforge.jtds.jdbc.JtdsConnection.prepareSQL(JtdsConnection.java:664) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1028) 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:382) at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.getResultSet(SqlExecutingSelector.java:322) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:254) at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:109) at org.labkey.api.data.TableSelector.getResults(TableSelector.java:274) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:289) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:286) at org.labkey.api.data.AsyncQueryRequest$1.run(AsyncQueryRequest.java:109) at java.lang.Thread.run(Unknown Source) ERROR Table 2015-09-16 10:54:56,868 st: http-bio-8080-exec-9 : SQL [99] SELECT TOP 101 * FROM ( SELECT Runs.LSID AS Flag, CAST((SELECT StringValue FROM exp.ObjectProperty WHERE exp.ObjectProperty.PropertyId = 31 AND exp.ObjectProperty.ObjectId = Runs$Flag$_C.ObjectId) AS VARCHAR(4000)) AS "Flag$", Runs.RowId AS Links, Runs.Name AS Name, Runs.Created AS Created, Runs.CreatedBy AS CreatedBy, Runs$CreatedBy$.DisplayName AS "CreatedBy$DisplayName", Runs.RowId AS RunGroups, Runs$RunGroups$.RunGroup$Name AS "RunGroups$RunGroup$Name", Runs.BatchId AS Batch, Runs$Batch$.Name AS "Batch$Name", Runs.Container AS Folder, Runs.RowId AS RowId, Runs$RunGroups$.RunGroup$RowId AS RunGroup_fs_RowId, Runs$Batch$.RowId AS Batch_fs_RowId, Runs$Batch$.Container AS Batch_fs_Folder, CASE WHEN Runs.ReplacedByRunId IS NULL THEN ? ELSE ? END AS Replaced FROM (SELECT * FROM exp.ExperimentRun WHERE (Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) AND (((ProtocolLSID = ?)))) Runs LEFT OUTER JOIN exp.Object Runs$Flag$_C ON (Runs.LSID = Runs$Flag$_C.ObjectURI) LEFT OUTER JOIN core.UsersData Runs$CreatedBy$ ON (Runs.CreatedBy = Runs$CreatedBy$.UserId) LEFT OUTER JOIN ( SELECT child.ExperimentRunId, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.RowId AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$RowId, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.Name AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$Name, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.ContactId AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$Contact, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.ExperimentDescriptionURL AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$ExperimentDescriptionURL, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.Created AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$Created, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.CreatedBy AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$CreatedBy, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.Modified AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$Modified, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.ModifiedBy AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$ModifiedBy, SUBSTRING ((SELECT',' + CAST( (SELECT COUNT(*) FROM exp.RunList WHERE ExperimentId = c$RunGroup$.RowId) AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$RunCount, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.BatchProtocolId AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$BatchProtocolId, SUBSTRING ((SELECT',' + CAST( CAST((c$RunGroup$.Container) AS UNIQUEIDENTIFIER) AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$Folder, SUBSTRING ((SELECT',' + CAST( CAST((c$RunGroup$.LSID) AS NVARCHAR(300)) AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$LSID FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) child GROUP BY child.ExperimentRunId ) Runs$RunGroups$ ON (Runs.RowId = Runs$RunGroups$.ExperimentRunId) LEFT OUTER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId = ?) AND (Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */)) Runs$Batch$ ON (Runs.BatchId = Runs$Batch$.RowId)) x WHERE (Replaced = ?) ORDER BY RowId DESC ?[1] false ?[2] true ?[3] urn:lsid:regionh.dk:GeneralAssayProtocol.Folder-5:CEP ?[4] false ?[5] false ?[6] false ?[7] false ?[8] false ?[9] false ?[10] false ?[11] false ?[12] false ?[13] false ?[14] false ?[15] false ?[16] false ?[17] false ?[18] 1 ?[19] false org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.handleSqlException(SqlExecutingSelector.java:436) org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:268) org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:109) org.labkey.api.data.TableSelector.getResults(TableSelector.java:274) org.labkey.api.data.TableSelector$1.call(TableSelector.java:289) ERROR WebPartView 2015-09-16 10:54:56,873 http-bio-8080-exec-9 : renderView() exception in org.labkey.api.view.GridView while responding to /labkey/assay/Persimune/main/assayBegin.view?rowId=1 org.springframework.jdbc.BadSqlGrammarException: ExecutingSelector; bad SQL grammar []; nested exception is java.sql.SQLException: Parameter #20 has not been set. 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:441) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:268) at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:109) at org.labkey.api.data.TableSelector.getResults(TableSelector.java:274) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:289) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:286) at org.labkey.api.data.AsyncQueryRequest$1.run(AsyncQueryRequest.java:109) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Parameter #20 has not been set. at net.sourceforge.jtds.jdbc.JtdsConnection.prepareSQL(JtdsConnection.java:664) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1028) 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:382) at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.getResultSet(SqlExecutingSelector.java:322) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:254) ... 6 more ERROR WebPartView 2015-09-16 10:54:56,873 http-bio-8080-exec-9 : View creation stacktrace: at org.labkey.api.view.HttpView.(HttpView.java:239) at org.labkey.api.view.WebPartView.(WebPartView.java:159) at org.labkey.api.view.DataView.(DataView.java:69) at org.labkey.api.view.GridView.(GridView.java:35) at org.labkey.api.query.QueryView.createDataView(QueryView.java:1914) at org.labkey.api.study.query.RunListQueryView.createDataView(RunListQueryView.java:81) at org.labkey.api.query.QueryView.renderDataRegion(QueryView.java:2010) at org.labkey.api.query.QueryView.renderView(QueryView.java:1779) at org.labkey.api.exp.ExperimentRunListView.renderView(ExperimentRunListView.java:96) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:371) at org.labkey.api.view.HttpView.render(HttpView.java:137) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.view.HttpView.include(HttpView.java:515) at org.labkey.api.view.HttpView.include(HttpView.java:492) at org.labkey.api.view.HttpView.include(HttpView.java:480) at org.labkey.api.view.VBox.renderView(VBox.java:79) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:371) at org.labkey.api.view.HttpView.render(HttpView.java:137) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.view.HttpView.include(HttpView.java:515) at org.labkey.api.view.HttpView.include(HttpView.java:492) at org.labkey.jsp.compiled.org.labkey.api.view.template.HomeTemplate_jsp._jspService(HomeTemplate_jsp.java:207) at org.labkey.api.view.JspView.renderView(JspView.java:154) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:371) at org.labkey.api.view.HttpView.render(HttpView.java:137) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.action.SpringActionController.renderInTemplate(SpringActionController.java:527) at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:422) at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:1207) at org.labkey.api.view.ViewServlet._service(ViewServlet.java:189) at org.labkey.api.view.ViewServlet.service(ViewServlet.java:123) ERROR ExceptionUtil 2015-09-16 10:54:56,874 http-bio-8080-exec-9 : Exception detected and logged to mothership org.springframework.jdbc.BadSqlGrammarException: ExecutingSelector; bad SQL grammar []; nested exception is java.sql.SQLException: Parameter #20 has not been set. 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:441) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:268) at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:109) at org.labkey.api.data.TableSelector.getResults(TableSelector.java:274) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:289) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:286) at org.labkey.api.data.AsyncQueryRequest$1.run(AsyncQueryRequest.java:109) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Parameter #20 has not been set. at net.sourceforge.jtds.jdbc.JtdsConnection.prepareSQL(JtdsConnection.java:664) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1028) 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:382) at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.getResultSet(SqlExecutingSelector.java:322) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:254) ... 6 more ERROR Table 2015-09-16 10:57:44,364 st: http-bio-8080-exec-3 : SQL Exception java.sql.SQLException: Parameter #20 has not been set. at net.sourceforge.jtds.jdbc.JtdsConnection.prepareSQL(JtdsConnection.java:664) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1028) 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:382) at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.getResultSet(SqlExecutingSelector.java:322) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:254) at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:109) at org.labkey.api.data.TableSelector.getResults(TableSelector.java:274) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:289) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:286) at org.labkey.api.data.AsyncQueryRequest$1.run(AsyncQueryRequest.java:109) at java.lang.Thread.run(Unknown Source) ERROR Table 2015-09-16 10:57:44,365 st: http-bio-8080-exec-3 : SQL [99] SELECT TOP 101 * FROM ( SELECT Runs.LSID AS Flag, CAST((SELECT StringValue FROM exp.ObjectProperty WHERE exp.ObjectProperty.PropertyId = 31 AND exp.ObjectProperty.ObjectId = Runs$Flag$_C.ObjectId) AS VARCHAR(4000)) AS "Flag$", Runs.RowId AS Links, Runs.Name AS Name, Runs.Created AS Created, Runs.CreatedBy AS CreatedBy, Runs$CreatedBy$.DisplayName AS "CreatedBy$DisplayName", Runs.RowId AS RunGroups, Runs$RunGroups$.RunGroup$Name AS "RunGroups$RunGroup$Name", Runs.BatchId AS Batch, Runs$Batch$.Name AS "Batch$Name", Runs.Container AS Folder, Runs.RowId AS RowId, Runs$RunGroups$.RunGroup$RowId AS RunGroup_fs_RowId, Runs$Batch$.RowId AS Batch_fs_RowId, Runs$Batch$.Container AS Batch_fs_Folder, CASE WHEN Runs.ReplacedByRunId IS NULL THEN ? ELSE ? END AS Replaced FROM (SELECT * FROM exp.ExperimentRun WHERE (Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) AND (((ProtocolLSID = ?)))) Runs LEFT OUTER JOIN exp.Object Runs$Flag$_C ON (Runs.LSID = Runs$Flag$_C.ObjectURI) LEFT OUTER JOIN core.UsersData Runs$CreatedBy$ ON (Runs.CreatedBy = Runs$CreatedBy$.UserId) LEFT OUTER JOIN ( SELECT child.ExperimentRunId, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.RowId AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$RowId, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.Name AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$Name, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.ContactId AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$Contact, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.ExperimentDescriptionURL AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$ExperimentDescriptionURL, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.Created AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$Created, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.CreatedBy AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$CreatedBy, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.Modified AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$Modified, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.ModifiedBy AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$ModifiedBy, SUBSTRING ((SELECT',' + CAST( (SELECT COUNT(*) FROM exp.RunList WHERE ExperimentId = c$RunGroup$.RowId) AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$RunCount, SUBSTRING ((SELECT',' + CAST( c$RunGroup$.BatchProtocolId AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$BatchProtocolId, SUBSTRING ((SELECT',' + CAST( CAST((c$RunGroup$.Container) AS UNIQUEIDENTIFIER) AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$Folder, SUBSTRING ((SELECT',' + CAST( CAST((c$RunGroup$.LSID) AS NVARCHAR(300)) AS NVARCHAR) AS [text()] FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) c INNER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId IS NULL) AND (Container IN (SELECT c.EntityId FROM core.Containers c INNER JOIN (SELECT CAST(x.Id AS UNIQUEIDENTIFIER) AS Id FROM (SELECT ? AS Id UNION SELECT ? AS Id UNION SELECT ? AS Id) x) x ON c.EntityId = x.Id OR (c.Parent = x.Id AND c.Type = 'workbook')))) c$RunGroup$ ON (c.ExperimentId = c$RunGroup$.RowId) WHERE child.ExperimentRunId = c.ExperimentRunId FOR XML PATH ('')), 2, 2147483647) AS RunGroup$LSID FROM (SELECT * FROM (SELECT rl.* FROM exp.RunList rl, exp.ExperimentRun er, exp.Experiment e WHERE e.Hidden = ? AND rl.ExperimentId = e.RowId AND rl.ExperimentRunId = er.RowId AND er.Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */) X ) child GROUP BY child.ExperimentRunId ) Runs$RunGroups$ ON (Runs.RowId = Runs$RunGroups$.ExperimentRunId) LEFT OUTER JOIN (SELECT * FROM exp.Experiment WHERE ((Hidden = ?)) AND (BatchProtocolId = ?) AND (Container='6A113761-3E7D-1033-B2C1-E4C2A92D4F10'/* main */)) Runs$Batch$ ON (Runs.BatchId = Runs$Batch$.RowId)) x WHERE (Replaced = ?) ORDER BY RowId DESC ?[1] false ?[2] true ?[3] urn:lsid:regionh.dk:GeneralAssayProtocol.Folder-5:CEP ?[4] false ?[5] false ?[6] false ?[7] false ?[8] false ?[9] false ?[10] false ?[11] false ?[12] false ?[13] false ?[14] false ?[15] false ?[16] false ?[17] false ?[18] 1 ?[19] false org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.handleSqlException(SqlExecutingSelector.java:436) org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:268) org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:109) org.labkey.api.data.TableSelector.getResults(TableSelector.java:274) org.labkey.api.data.TableSelector$1.call(TableSelector.java:289) ERROR WebPartView 2015-09-16 10:57:44,368 http-bio-8080-exec-3 : renderView() exception in org.labkey.api.view.GridView while responding to /labkey/assay/Persimune/main/assayBegin.view?rowId=1 org.springframework.jdbc.BadSqlGrammarException: ExecutingSelector; bad SQL grammar []; nested exception is java.sql.SQLException: Parameter #20 has not been set. 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:441) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:268) at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:109) at org.labkey.api.data.TableSelector.getResults(TableSelector.java:274) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:289) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:286) at org.labkey.api.data.AsyncQueryRequest$1.run(AsyncQueryRequest.java:109) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Parameter #20 has not been set. at net.sourceforge.jtds.jdbc.JtdsConnection.prepareSQL(JtdsConnection.java:664) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1028) 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:382) at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.getResultSet(SqlExecutingSelector.java:322) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:254) ... 6 more ERROR WebPartView 2015-09-16 10:57:44,370 http-bio-8080-exec-3 : View creation stacktrace: at org.labkey.api.view.HttpView.(HttpView.java:239) at org.labkey.api.view.WebPartView.(WebPartView.java:159) at org.labkey.api.view.DataView.(DataView.java:69) at org.labkey.api.view.GridView.(GridView.java:35) at org.labkey.api.query.QueryView.createDataView(QueryView.java:1914) at org.labkey.api.study.query.RunListQueryView.createDataView(RunListQueryView.java:81) at org.labkey.api.query.QueryView.renderDataRegion(QueryView.java:2010) at org.labkey.api.query.QueryView.renderView(QueryView.java:1779) at org.labkey.api.exp.ExperimentRunListView.renderView(ExperimentRunListView.java:96) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:371) at org.labkey.api.view.HttpView.render(HttpView.java:137) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.view.HttpView.include(HttpView.java:515) at org.labkey.api.view.HttpView.include(HttpView.java:492) at org.labkey.api.view.HttpView.include(HttpView.java:480) at org.labkey.api.view.VBox.renderView(VBox.java:79) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:371) at org.labkey.api.view.HttpView.render(HttpView.java:137) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.view.HttpView.include(HttpView.java:515) at org.labkey.api.view.HttpView.include(HttpView.java:492) at org.labkey.jsp.compiled.org.labkey.api.view.template.HomeTemplate_jsp._jspService(HomeTemplate_jsp.java:207) at org.labkey.api.view.JspView.renderView(JspView.java:154) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:371) at org.labkey.api.view.HttpView.render(HttpView.java:137) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.action.SpringActionController.renderInTemplate(SpringActionController.java:527) at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:422) at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:1207) at org.labkey.api.view.ViewServlet._service(ViewServlet.java:189) at org.labkey.api.view.ViewServlet.service(ViewServlet.java:123) ERROR ExceptionUtil 2015-09-16 10:57:44,370 http-bio-8080-exec-3 : Exception detected and logged to mothership org.springframework.jdbc.BadSqlGrammarException: ExecutingSelector; bad SQL grammar []; nested exception is java.sql.SQLException: Parameter #20 has not been set. 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:441) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:268) at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:109) at org.labkey.api.data.TableSelector.getResults(TableSelector.java:274) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:289) at org.labkey.api.data.TableSelector$1.call(TableSelector.java:286) at org.labkey.api.data.AsyncQueryRequest$1.run(AsyncQueryRequest.java:109) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Parameter #20 has not been set. at net.sourceforge.jtds.jdbc.JtdsConnection.prepareSQL(JtdsConnection.java:664) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1028) 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:382) at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.getResultSet(SqlExecutingSelector.java:322) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:254) ... 6 more INFO ContextListener 2015-09-16 11:59:11,881 localhost-startStop-2 : Calling HeartBeatThread shutdownPre() INFO ContextListener 2015-09-16 11:59:11,881 localhost-startStop-2 : Calling Thread-6 shutdownPre() INFO ContextListener 2015-09-16 11:59:11,895 localhost-startStop-2 : Calling Thread-6 shutdownPre() INFO ContextListener 2015-09-16 11:59:11,895 localhost-startStop-2 : Calling Job Runner shutdownPre() INFO ContextListener 2015-09-16 11:59:11,895 localhost-startStop-2 : Calling Job Runner shutdownPre() INFO ContextListener 2015-09-16 11:59:11,895 localhost-startStop-2 : Calling QueryProfilerThread shutdownPre() INFO ContextListener 2015-09-16 11:59:11,896 localhost-startStop-2 : Calling BreakpointThread shutdownPre() INFO ContextListener 2015-09-16 11:59:11,896 localhost-startStop-2 : Calling ThumbnailGeneratingThread shutdownPre() INFO ContextListener 2015-09-16 11:59:11,896 localhost-startStop-2 : Calling QuerySnapshotDependencyThread shutdownPre() INFO ContextListener 2015-09-16 11:59:11,896 localhost-startStop-2 : Calling System Maintenance shutdownPre() INFO ContextListener 2015-09-16 11:59:11,896 localhost-startStop-2 : Calling Temp table cleanup shutdownPre() INFO ContextListener 2015-09-16 11:59:11,896 localhost-startStop-2 : Calling Temp file deletion shutdownPre() INFO ContextListener 2015-09-16 11:59:11,896 localhost-startStop-2 : Calling Action stats export shutdownPre() INFO CoreModule 2015-09-16 11:59:11,896 localhost-startStop-2 : Starting to log statistics for actions prior to web application shut down INFO DatasetSnapshotProvider 2015-09-16 11:59:11,897 SnapshotDependencyThread : QuerySnapshotDependencyThread is terminating due to interruption INFO FileSystemWatcherImpl 2015-09-16 11:59:11,898 Thread-6 : FileSystemWatcherThread is terminating INFO CoreModule 2015-09-16 11:59:11,927 localhost-startStop-2 : Completed logging statistics for actions prior to web application shut down INFO ContextListener 2015-09-16 11:59:11,927 localhost-startStop-2 : Calling Job Runner shutdownPre() INFO ContextListener 2015-09-16 11:59:11,927 localhost-startStop-2 : Calling DataIntegration shutdownPre() INFO ContextListener 2015-09-16 11:59:11,936 localhost-startStop-2 : Calling Study Reload Handler shutdownPre() INFO ContextListener 2015-09-16 11:59:11,939 localhost-startStop-2 : Calling DAV crawler shutdownPre() INFO ContextListener 2015-09-16 11:59:11,939 localhost-startStop-2 : Calling Search service shutdownPre() INFO ContextListener 2015-09-16 11:59:11,939 localhost-startStop-2 : Calling Message digest timer task shutdownPre() INFO ContextListener 2015-09-16 11:59:11,939 localhost-startStop-2 : Calling Message digest timer task shutdownPre() INFO ContextListener 2015-09-16 11:59:11,939 localhost-startStop-2 : Calling HeartBeatThread shutdownStarted() INFO ContextListener 2015-09-16 11:59:11,939 localhost-startStop-2 : Calling Thread-6 shutdownStarted() INFO ContextListener 2015-09-16 11:59:11,939 localhost-startStop-2 : Calling Thread-6 shutdownStarted() INFO ContextListener 2015-09-16 11:59:11,939 localhost-startStop-2 : Calling Job Runner shutdownStarted() INFO ContextListener 2015-09-16 11:59:11,939 localhost-startStop-2 : Calling Job Runner shutdownStarted() INFO ContextListener 2015-09-16 11:59:11,939 localhost-startStop-2 : Calling QueryProfilerThread shutdownStarted() INFO QueryProfiler 2015-09-16 11:59:11,939 localhost-startStop-2 : Starting to log statistics for queries prior to web application shut down INFO QueryProfiler 2015-09-16 11:59:12,060 localhost-startStop-2 : Completed logging statistics for queries prior to web application shut down INFO ContextListener 2015-09-16 11:59:12,060 localhost-startStop-2 : Calling BreakpointThread shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,060 localhost-startStop-2 : Calling ThumbnailGeneratingThread shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,060 localhost-startStop-2 : Calling QuerySnapshotDependencyThread shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,060 localhost-startStop-2 : Calling System Maintenance shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,060 localhost-startStop-2 : Calling Temp table cleanup shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,062 localhost-startStop-2 : Calling Temp file deletion shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,062 localhost-startStop-2 : Calling Action stats export shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,062 localhost-startStop-2 : Calling Job Runner shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,062 localhost-startStop-2 : Calling DataIntegration shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,441 localhost-startStop-2 : Calling Study Reload Handler shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,441 localhost-startStop-2 : Calling DAV crawler shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,441 localhost-startStop-2 : Calling Search service shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,451 localhost-startStop-2 : Calling Message digest timer task shutdownStarted() INFO ContextListener 2015-09-16 11:59:12,451 localhost-startStop-2 : Calling Message digest timer task shutdownStarted() INFO EhCacheProvider 2015-09-16 11:59:12,455 localhost-startStop-2 : Shutting down Ehcache