[Pansophy] FW: Error: Invalid data href=/pansophydev/Travelers/TRAVELER_FORM.cfm?project=L2PRD&area=L2PRD&system=NCR&page=1&maxpage=4&trav_id=L2PRD-NCR&trav_revision=R8&trav_seq_num=1&travstat=y&SNType=SN&serialnum=0027&SN=0027 for CFSQLTYPE CF_SQL_DECIMAL.

Tue Sep 1 11:11:38 EDT 2020

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

From: adapps at jlab.org <adapps at jlab.org>
Sent: Tuesday, September 1, 2020 10:44 AM
To: Valerie Bookwalter <bookwalt at jlab.org>; Megan McDonald <megan at jlab.org>; Mike Dickey <mdickey at jlab.org>
Subject: Error: Invalid data href=/pansophydev/Travelers/TRAVELER_FORM.cfm?project=L2PRD&area=L2PRD&system=NCR&page=1&maxpage=4&trav_id=L2PRD-NCR&trav_revision=R8&trav_seq_num=1&travstat=y&SNType=SN&serialnum=0027&SN=0027 for CFSQLTYPE CF_SQL_DECIMAL.

An error occurred: MDICKEY
http://pansophydev.jlab.org/development/P2020/Components/Global/TDNFilter2.cfc?method=SearchGrid&&&gpk=3&&&TravId=L2PRD-NCR,L2PRD-NCR&&&SerialName=SN&&&BooleanSelect=-1&&&iFilter1=Select%20All&&&iFilter2=Select%20All&&&DateOption=all&&&AfterDate=&&&BeforeDate=&&&pSize=2500&pageSize=2500&_cf_ajaxproxytoken=53FCB086BC9771064D2884&_cf_clientid=3EBEEF97E239998F9F4F07A88230724A&_cf_rc=4&_cf_nodebug=true&_cf_nocache=true&returnFormat=json&_dc=1598971414390&start=0&limit=2500&page=1&sortcolumn=&sortdirection=ASC
Time: 9/1/20 10:43 AM
Error - struct
Detail
[empty string]
ErrorCode
n/a
Message
Invalid data href=/pansophydev/Travelers/TRAVELER_FORM.cfm?project=L2PRD&area=L2PRD&system=NCR&page=1&maxpage=4&trav_id=L2PRD-NCR&trav_revision=R8&trav_seq_num=1&travstat=y&SNType=SN&serialnum=0027&SN=0027 for CFSQLTYPE CF_SQL_DECIMAL.
NativeErrorCode
0
SQLState
n/a
StackTrace
coldfusion.sql.Parameter$DataTypeMismatchException: Invalid data href=/pansophydev/Travelers/TRAVELER_FORM.cfm?project=L2PRD&area=L2PRD&system=NCR&page=1&maxpage=4&trav_id=L2PRD-NCR&trav_revision=R8&trav_seq_num=1&travstat=y&SNType=SN&serialnum=0027&SN=0027 for CFSQLTYPE CF_SQL_DECIMAL. at coldfusion.sql.Parameter.getMappingValue(Parameter.java:174) at coldfusion.runtime.QueryFunction.validateDataType(QueryFunction.java:1323) at coldfusion.sql.Table.setField(Table.java:222) at coldfusion.runtime.QueryFunction.QuerySetCell(QueryFunction.java:1116) at coldfusion.runtime.QueryFunction.QuerySetCell(QueryFunction.java:945) at coldfusion.runtime.CFPage.QuerySetCell(CFPage.java:2119) at cfTDNFilter22ecfc1080439488$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophydev/html/development/P2020/Components/Global/TDNFilter2.cfc:361) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:597) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:251) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:590) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) 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.xml.rpc.CFCServlet.invoke(CFCServlet.java:156) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:298) at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 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:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) 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_CFPAGE
LINE
361
RAW_TRACE
at cfTDNFilter22ecfc1080439488$funcSEARCHGRID.runFunction(/sgroup/asd/www/pansophydev/html/development/P2020/Components/Global/TDNFilter2.cfc:361)
TEMPLATE
/sgroup/asd/www/pansophydev/html/development/P2020/Components/Global/TDNFilter2.cfc
TYPE
CFML
Type
Database
sql_type
CF_SQL_DECIMAL
value
href=/pansophydev/Travelers/TRAVELER_FORM.cfm?project=L2PRD&area=L2PRD&system=NCR&page=1&maxpage=4&trav_id=L2PRD-NCR&trav_revision=R8&trav_seq_num=1&travstat=y&SNType=SN&serialnum=0027&SN=0027

Form - struct [empty]

URL - struct
AfterDate
[empty string]
BeforeDate
[empty string]
BooleanSelect
-1
DateOption
all
SerialName
SN
TravId
L2PRD-NCR,L2PRD-NCR
_cf_ajaxproxytoken
53FCB086BC9771064D2884
_cf_clientid
3EBEEF97E239998F9F4F07A88230724A
_cf_nocache
true
_cf_nodebug
true
_cf_rc
4
_dc
1598971414390
gpk
3
iFilter1
Select All
iFilter2
Select All
limit
2500
method
SearchGrid
pSize
2500
page
1
pageSize
2500
returnFormat
json
sortcolumn
[empty string]
sortdirection
ASC
start
0

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20200901/7d614b9a/attachment-0001.html>