|
org.labkey.api.query.QueryParseException: Error on line 17: Query 'Physical Exam + AverageTemp' has errors SkipMothershipLogging=true ResolveText=edit Physical Exam + AverageTemp QuerySchema=study ResolveURL=/home/Demos/Study/demo/query-sourceQuery.view?schemaName=study&query.queryName=Physical%20Exam%20%2B%20AverageTemp QueryName=study.Physical Exam + TempDelta LabkeySQL=SELECT "Physical Exam + AverageTemp".ParticipantId, "Physical Exam + AverageTemp".SequenceNum, "Physical Exam + AverageTemp".Date, "Physical Exam + AverageTemp".Day, "Physical Exam + AverageTemp".Weight_kg, "Physical Exam + AverageTemp".Temp_C, "Physical Exam + AverageTemp".SystolicBloodPressure, "Physical Exam + AverageTemp".DiastolicBloodPressure, "Physical Exam + AverageTemp".Pulse, "Physical Exam + AverageTemp".Respirations, "Physical Exam + AverageTemp".Signature, "Physical Exam + AverageTemp".Pregnancy, "Physical Exam + AverageTemp".Language, "Physical Exam + AverageTemp".AverageTemp, ROUND("Physical Exam + AverageTemp".Temp_C -"Physical Exam + AverageTemp".AverageTemp,1) AS TempDelta FROM "Physical Exam + AverageTemp" org.labkey.api.query.QueryParseException: Error on line 17: Query 'Physical Exam + AverageTemp' has errors at org.labkey.query.sql.Query.resolveTable(Query.java:785) at org.labkey.query.sql.QuerySelect.initializeSelect(QuerySelect.java:330) at org.labkey.query.sql.QuerySelect.<init>(QuerySelect.java:149) at org.labkey.query.sql.QuerySelect.<init>(QuerySelect.java:156) at org.labkey.query.sql.Query.createQueryRelation(Query.java:325) at org.labkey.query.sql.Query._parse(Query.java:272) at org.labkey.query.sql.Query.parseQuerySource(Query.java:224) at org.labkey.query.sql.Query.parse(Query.java:249) at org.labkey.query.QueryDefinitionImpl.getQuery(QueryDefinitionImpl.java:485) at org.labkey.query.QueryDefinitionImpl.createTable(QueryDefinitionImpl.java:604) at org.labkey.query.QueryDefinitionImpl.getTable(QueryDefinitionImpl.java:565) at org.labkey.api.query.UserSchema.getTable(UserSchema.java:202) at org.labkey.api.query.UserSchema.getTable(UserSchema.java:169) at org.labkey.api.query.UserSchema.getTable(UserSchema.java:162) at org.labkey.api.query.QuerySchema.getTable(QuerySchema.java:50) at org.labkey.api.reports.report.view.ReportUtil.getQueryLabelByName(ReportUtil.java:511) at org.labkey.api.reports.report.view.ReportUtil.getQueryLabelByName(ReportUtil.java:501) at org.labkey.jsp.compiled.org.labkey.visualization.views.chartWizard_jsp._jspService(chartWizard_jsp.java:255) at org.labkey.api.view.JspView.renderView(JspView.java:142) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:392) at org.labkey.api.view.HttpView.render(HttpView.java:126) at org.labkey.api.view.HttpView.render(HttpView.java:111) at org.labkey.api.view.HttpView.include(HttpView.java:557) at org.labkey.api.view.HttpView.include(HttpView.java:533) at org.labkey.jsp.compiled.org.labkey.core.view.template.bootstrap.body_jsp._jspService(body_jsp.java:287) at org.labkey.api.view.JspView.renderView(JspView.java:142) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:392) at org.labkey.api.view.HttpView.render(HttpView.java:126) at org.labkey.api.view.HttpView.render(HttpView.java:111) at org.labkey.api.view.HttpView.include(HttpView.java:557) at org.labkey.api.view.HttpView.include(HttpView.java:533) at org.labkey.jsp.compiled.org.labkey.core.view.template.bootstrap.pageTemplate_jsp._jspService(pageTemplate_jsp.java:248) at org.labkey.api.view.JspView.renderView(JspView.java:142) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:392) at org.labkey.api.view.HttpView.render(HttpView.java:126) at org.labkey.api.view.HttpView.render(HttpView.java:111) at org.labkey.api.action.SpringActionController.renderInTemplate(SpringActionController.java:685) at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:535) at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:1124) at org.labkey.api.view.ViewServlet._service(ViewServlet.java:202) at org.labkey.api.view.ViewServlet.service(ViewServlet.java:126) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:195) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140) at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:166) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140) at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:244) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140) at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140) at org.labkey.filters.ContentSecurityPolicyFilter.doFilter(ContentSecurityPolicyFilter.java:229) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140) at org.labkey.filters.ContentSecurityPolicyFilter.doFilter(ContentSecurityPolicyFilter.java:229) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:666) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:398) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1740) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:840) Caused by: org.labkey.api.query.QueryParseException: Error on line 16: Query 'AverageTempPerParticipant' has errors at org.labkey.query.sql.Query.resolveTable(Query.java:785) at org.labkey.query.sql.QuerySelect.initializeSelect(QuerySelect.java:330) at org.labkey.query.sql.QuerySelect.<init>(QuerySelect.java:149) at org.labkey.query.sql.QuerySelect.<init>(QuerySelect.java:156) at org.labkey.query.sql.Query.createQueryRelation(Query.java:325) at org.labkey.query.sql.Query._parse(Query.java:272) at org.labkey.query.sql.Query.parseQuerySource(Query.java:224) at org.labkey.query.sql.Query.parse(Query.java:249) at org.labkey.query.QueryDefinitionImpl.getQuery(QueryDefinitionImpl.java:485) at org.labkey.query.QueryDefinitionImpl.getQuery(QueryDefinitionImpl.java:467) at org.labkey.query.sql.Query._resolveTable(Query.java:966) at org.labkey.query.sql.Query.resolveTable(Query.java:746) ... 80 more Caused by: org.labkey.api.query.QueryParseExceptionUnresolvedField: Error on line 2: Unknown field [Physical Exam.Temp_C] at org.labkey.query.sql.QuerySelect.parseErrorUnknownField(QuerySelect.java:1855) at org.labkey.query.sql.QuerySelect.declareField(QuerySelect.java:993) at org.labkey.query.sql.QuerySelect.declareFields(QuerySelect.java:1074) at org.labkey.query.sql.QuerySelect.declareFields(QuerySelect.java:1083) at org.labkey.query.sql.QuerySelect.declareFields(QuerySelect.java:1083) at org.labkey.query.sql.QuerySelect.declareFields(QuerySelect.java:1038) at org.labkey.query.sql.QuerySelect.declareFields(QuerySelect.java:1109) at org.labkey.query.sql.QueryLookupWrapper.declareFields(QueryLookupWrapper.java:157) at org.labkey.query.sql.Query._parse(Query.java:283) at org.labkey.query.sql.Query.parseQuerySource(Query.java:224) at org.labkey.query.sql.Query.parse(Query.java:249) at org.labkey.query.QueryDefinitionImpl.getQuery(QueryDefinitionImpl.java:485) at org.labkey.query.QueryDefinitionImpl.getQuery(QueryDefinitionImpl.java:467) at org.labkey.query.sql.Query._resolveTable(Query.java:966) at org.labkey.query.sql.Query.resolveTable(Query.java:746) ... 91 morerequest attributes LABKEY.StartTime = 1750259325687 datadog.context.path = / org.apache.tomcat.util.net.secure_protocol_version = TLSv1.3 ReadOnlyHttpRequest = true LABKEY.Counter = 4 datadog.servlet.path = /home/Demos/Study/demo/visualization-genericChartWizard.view jakarta.servlet.request.ssl_session_id = 12d5e1dfdfe2c307488d11e1c37c65925b5e29fb5a6fcb0f740a35581dcf3f66 LABKEY.container = /home/Demos/Study/demo dd.trace_id = 6852d67d0000000050b7cdcfcbeb4557 LABKEY.RequestURL = /home/Demos/Study/demo/visualization-genericChartWizard.view?dataRegionName=query&edit=true&filterUrl=%2Fhome%2FDemos%2FStudy%2Fdemo%2Fquery-executeQuery.view%3Fquery.TempDelta%257Egt%3D1.5%26query.queryName%3DPhysical%2520Exam%2520%252B%2520TempDelta%26schemaName%3Dstudy%26dataRegionName%3Dquery&queryName=Physical%20Exam%20%2B%20TempDelta&schemaName=study org.apache.tomcat.util.net.secure_requested_protocol_versions = TLSv1.3,TLSv1.2,TLSv1.1,TLSv1.0 org.apache.tomcat.util.net.secure_requested_ciphers = TLS_AES_128_GCM_SHA256,TLS_AES_256_GCM_SHA384,TLS_CHACHA20_POLY1305_SHA256,TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256,TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256,TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256,TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA,TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA,TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384,TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384,TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA,TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA,TLS_RSA_WITH_AES_128_GCM_SHA256,TLS_RSA_WITH_AES_128_CBC_SHA256,TLS_RSA_WITH_AES_128_CBC_SHA,TLS_RSA_WITH_AES_256_GCM_SHA384,TLS_RSA_WITH_AES_256_CBC_SHA256,TLS_RSA_WITH_AES_256_CBC_SHA,Unknown(0x00ff) jakarta.servlet.request.ssl_session_mgr = org.apache.tomcat.util.net.jsse.JSSESupport@2439678b LABKEY.OriginalURL = https://www.labkey.org/home/Demos/Study/demo/visualization-genericChartWizard.view?dataRegionName=query&edit=true&filterUrl=%2Fhome%2FDemos%2FStudy%2Fdemo%2Fquery-executeQuery.view%3Fquery.TempDelta%257Egt%3D1.5%26query.queryName%3DPhysical%2520Exam%2520%252B%2520TempDelta%26schemaName%3Dstudy%26dataRegionName%3Dquery&queryName=Physical%20Exam%20%2B%20TempDelta&schemaName=study LABKEY.action = genericChartWizard jakarta.servlet.request.cipher_suite = TLS_AES_128_GCM_SHA256 org.labkey.filters.ContentSecurityPolicyFilter#NONCE = 88790fb1bc396924 LABKEY.controller = visualization dd.span_id = 612350839469950055 X-LABKEY-CSRF = dadb8686cf7322535f521128c8c272a33c8b72a577fdcab4b130d7dd645d7d55 LABKEY.OriginalContainerPath = /home/Demos/Study/demo/ LABKEY.OriginalURLHelper = /home/Demos/Study/demo/visualization-genericChartWizard.view?dataRegionName=query&edit=true&filterUrl=%2Fhome%2FDemos%2FStudy%2Fdemo%2Fquery-executeQuery.view%3Fquery.TempDelta%257Egt%3D1.5%26query.queryName%3DPhysical%2520Exam%2520%252B%2520TempDelta%26schemaName%3Dstudy%26dataRegionName%3Dquery&queryName=Physical%20Exam%20%2B%20TempDelta&schemaName=study jakarta.servlet.request.key_size = 128
| ||||||||||||