[Pansophy] Error: Event handler exception. QUERY_VARGIRD C100R-CAV-CHEM-HPR

Valerie Bookwalter bookwalt at jlab.org
Tue Jun 21 10:08:13 EDT 2022


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/49543653/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/49543653/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: C100-RI-062data.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 19514 bytes
Desc: C100-RI-062data.xlsx
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20220621/49543653/attachment-0001.xlsx>


More information about the Pansophy mailing list