[Pansophy] Error: Event handler exception. QUERY_VARGIRD C100R-CAV-CHEM-HPR
Mircea Stirbet
stirbet at jlab.org
Tue Jun 21 10:39:57 EDT 2022
Hi Val,
Yes, I tried SN option for data mining. It gives a list of travelers, related (as in your example) with work done on C100-RI-062. But now I want to go to the next level and select from each traveler a number of parameters collected in C100R-CAV-CHEM-USC ( lets say date, USC time and temperature), from C100R-CAV-ASSY ( date and particulate counts) , and from C100-R-CAV-VTRF (date, Emax, Radmax).
It will be great to be able to make such data mine and directly generate a report.
I suppose, sequence 4 to 7 collect data related with C100-RI-062 preps for VTA tests done in 14 March 2022.
But... it still waiting for the next step, to data mine each (set ) traveler then generate the report I am looking for.
Thanks Val!
Mircea
________________________________
From: Valerie Bookwalter <bookwalt at jlab.org>
Sent: Tuesday, June 21, 2022 10:08
To: Mircea Stirbet <stirbet at jlab.org>
Cc: pansophy <pansophy at jlab.org>; Tony Reilly <areilly at jlab.org>; E. Anne McEwen <mcewen at jlab.org>; Kirk Davis <kdavis at jlab.org>
Subject: RE: Error: Event handler exception. QUERY_VARGIRD C100R-CAV-CHEM-HPR
Mircea,
Thank you for your kind words. The whole team really appreciates it.
We do not have your request AT THIS TIME. I would really like to add those kinds of data mining functions soon.
For now we can offer the following:
Under DATAMINE MENE -> QUERIES -> SERIAL NUMBER SEARCH
This will allow you to search for any SN(s) from multiple PROJECTS.
* To select multiple projects, use CNTL + LEFT MOUSE CLICK. It will allow you to select, for example, C50R and C75.
* Then the component selection will update with any components found in all the projects selected.
* I mention this because if you select, for example, C100R, C50R and C75, they do not use all the same components because they are different styles of cryomodules.
* Once project(s) is/are selected then select a COMPONENT, like CAVSN.
* Then the serial number selection will update and again you can select one or many (select with CNTL + LEFT MOUSE CLICK).
* The display shows every where we can find that component with that serial number in a traveler in the selected projects. It will display sorted by serial number and then by date of travelers.
*
This gives a pretty good view of what, as in your example, was the process for a particular CAVSN.
I have attached an example below.
Unfortunately, the trav_seq_num links are not yet fixed (still trying to figure out this). But you can see which travelers are associated and their respective seq numbers.
This can also be exported to an excel file (attached to this email).
The links in the excel are part of that problem we are having with the new excel code (fix in progress).
However, if you edit the hyperlink (right click) and copy from excel, paste into URL of web page, it will take you to the traveler.
I’m sorry this is long and cumbersome. It is my hope we can put this into a single “vargrid” sort of report.
I hope this helps in the interim until we expand our datamining functions.
Thanks again for all your support and patience.
Valerie
Pansophy Team
[cid:image001.jpg at 01D88556.CFCB79D0]
From: Mircea Stirbet <stirbet at jlab.org>
Sent: Tuesday, June 21, 2022 9:33 AM
To: Valerie Bookwalter <bookwalt at jlab.org>
Cc: pansophy <pansophy at jlab.org>; Mircea Stirbet <stirbet at jlab.org>
Subject: Re: Error: Event handler exception. QUERY_VARGIRD C100R-CAV-CHEM-HPR
Hi Val,
You and all Pansophy group had plenty on your table these last weeks.. . Really appreciate your team efforts related with Pansophy upgrading. And I want to thank you all.
What I would like to know is related with VARGRID usage. Can this be used to query and generate an report ( Excel file ), data mining travelers related with the same (cavity) serial number which went in different working centers. I mean, each traveler have been generated in different work centers ( tuning area, chem area, clean room, VTA ) at different dates and data uploaded in dedicated travelers.
Take as a working cavity serial number C100-RI-062, VTA tested 4 times this year. Would like to associate to the VTA data, what have been done each time, in chem area, then in clean room when the cavity was prepared for VTA tests.
Then, how this kind of data mining/ reporting can be done if VARGRID is not the right choice?
Thank you,
Mircea
________________________________
From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Friday, June 17, 2022 14:34
To: Mircea Stirbet <stirbet at jlab.org<mailto:stirbet at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>
Subject: RE: Error: Event handler exception. QUERY_VARGIRD C100R-CAV-CHEM-HPR
Mircea,
I am sorry this took so long to solve.
The error on the VARGRID when you export to excel was not correctly determining which variables were data formatted.
Hopefully, I have resolved that issue. There are still other formatting issues with exporting to Excel but they will come in the future.
Please let us know if you have any more problems.
Thank you.
Valerie
From: adapps at jlab.org<mailto:adapps at jlab.org> <adapps at jlab.org<mailto:adapps at jlab.org>>
Sent: Thursday, June 16, 2022 9:20 AM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>; Megan McDonald <megan at jlab.org<mailto:megan at jlab.org>>; Mike Dickey <mdickey at jlab.org<mailto:mdickey at jlab.org>>; David Parham <dparham at jlab.org<mailto:dparham at jlab.org>>; Allen Samuels <samuels at jlab.org<mailto:samuels at jlab.org>>
Subject: Error: Event handler exception.
An error occurred: STIRBET
http://pansophy.jlab.org/pansophy/DataMine/Queries/QUERY_VARGRID.cfm?project=C100&area=C100
Time: 6/16/22 9:19 AM
Error - struct
Cause
Error - struct
Detail
[empty string]
ErrNumber
0
Message
0-6:13:00 is an invalid date or time string.
StackTrace
coldfusion.runtime.locale.CFLocaleBase$InvalidDateTimeException: 0-6:13:00 is an invalid date or time string. at coldfusion.runtime.Cast._Date(Cast.java:1477) at coldfusion.runtime.Cast._Date(Cast.java:1373) at coldfusion.runtime.Cast._Date(Cast.java:1503) at cfVGExport2ecfm1245338330.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Includes/VGExport.cfm:40) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfQUERY_VARGRID2ecfm1258628473.runPage(/sgroup/asd/www/pansophy/html/production/P2022/DataMine/Queries/QUERY_VARGRID.cfm:144) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:551) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CF_CAST
LINE
40
RAW_TRACE
at cfVGExport2ecfm1245338330.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Includes/VGExport.cfm:40)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Includes/VGExport.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
144
RAW_TRACE
at cfQUERY_VARGRID2ecfm1258628473.runPage(/sgroup/asd/www/pansophy/html/production/P2022/DataMine/Queries/QUERY_VARGRID.cfm:144)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/DataMine/Queries/QUERY_VARGRID.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc
TYPE
CFML
Type
Expression
datetime
0-6:13:00
Detail
An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.
Message
Event handler exception.
RootCause
Error - struct
Detail
[empty string]
ErrNumber
0
Message
0-6:13:00 is an invalid date or time string.
StackTrace
coldfusion.runtime.locale.CFLocaleBase$InvalidDateTimeException: 0-6:13:00 is an invalid date or time string. at coldfusion.runtime.Cast._Date(Cast.java:1477) at coldfusion.runtime.Cast._Date(Cast.java:1373) at coldfusion.runtime.Cast._Date(Cast.java:1503) at cfVGExport2ecfm1245338330.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Includes/VGExport.cfm:40) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfQUERY_VARGRID2ecfm1258628473.runPage(/sgroup/asd/www/pansophy/html/production/P2022/DataMine/Queries/QUERY_VARGRID.cfm:144) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:551) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CF_CAST
LINE
40
RAW_TRACE
at cfVGExport2ecfm1245338330.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Includes/VGExport.cfm:40)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Includes/VGExport.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
144
RAW_TRACE
at cfQUERY_VARGRID2ecfm1258628473.runPage(/sgroup/asd/www/pansophy/html/production/P2022/DataMine/Queries/QUERY_VARGRID.cfm:144)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/DataMine/Queries/QUERY_VARGRID.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc
TYPE
CFML
Type
Expression
datetime
0-6:13:00
StackTrace
coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:319) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:551) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844) Caused by: coldfusion.runtime.locale.CFLocaleBase$InvalidDateTimeException: 0-6:13:00 is an invalid date or time string. at coldfusion.runtime.Cast._Date(Cast.java:1477) at coldfusion.runtime.Cast._Date(Cast.java:1373) at coldfusion.runtime.Cast._Date(Cast.java:1503) at cfVGExport2ecfm1245338330.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Includes/VGExport.cfm:40) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfQUERY_VARGRID2ecfm1258628473.runPage(/sgroup/asd/www/pansophy/html/production/P2022/DataMine/Queries/QUERY_VARGRID.cfm:144) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) ... 41 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN
0
ID
CF_CAST
LINE
40
RAW_TRACE
at cfVGExport2ecfm1245338330.runPage(/sgroup/asd/www/pansophy/html/production/P2022/Includes/VGExport.cfm:40)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Includes/VGExport.cfm
TYPE
CFML
2
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
144
RAW_TRACE
at cfQUERY_VARGRID2ecfm1258628473.runPage(/sgroup/asd/www/pansophy/html/production/P2022/DataMine/Queries/QUERY_VARGRID.cfm:144)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/DataMine/Queries/QUERY_VARGRID.cfm
TYPE
CFML
3
Error - struct
COLUMN
0
ID
CFINCLUDE
LINE
196
RAW_TRACE
at cfApplication2ecfc2019976864$funcONREQUEST.runFunction(/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc:196)
TEMPLATE
/sgroup/asd/www/pansophy/html/production/P2022/Application.cfc
TYPE
CFML
Type
Expression
name
onRequest
Form - struct
FIELDNAMES
PROJSCOPEVAL,PROJECTS,TRAVID,MYACTION
MYACTION
Excel
PROJECTID
[empty string]
PROJECTS
C100R
PROJSCOPEVAL
[empty string]
TRAVID
C100R-CAV-CHEM-HPR
URL - struct
TRAV_REVISION
[empty string]
area
C100
project
C100
system
[empty string]
title
DATAMINE
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20220621/b6fbb5fd/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 92862 bytes
Desc: image001.jpg
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20220621/b6fbb5fd/attachment-0001.jpg>
More information about the Pansophy
mailing list