ColdFusion 8 Migration ColdFusion 11

[Imran Chaudhary_857]

Currently getting the following error. 

The START_DATE argument passed to the insertApplication function is not of type date.

If the component name is specified as a type of this argument, it is possible that either a definition file for the component cannot be found or is not accessible.

The error occurred in D:/web-sites/Web/poolDischarge/components/poolDischarge.cfc: line 54

52 : <cfargument name="Mailing_State" type="string" default="#arguments.discharge_state#">

53 : <cfargument name="Mailing_Zip" type="string" default="#arguments.discharge_zip#">

54 : <cfargument name="Pro_Discharge" type="boolean" default="0" required="yes">

55 : <cfargument name="Maintenance_Company_ID" type="numeric" required="yes">

56 : <cfargument name="Start_Date" type="date" required="yes">

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.

Search the Knowledge Base to find a solution to your problem.

Browser   Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.94 Safari/537.36

Remote Address   192.168.21.59

Referrer   http://192.168.25.130/pooldischarge/index.cfm

Date/Time   10-Sep-15 03:07 PM

Stack Trace

at cfpoolDischarge2ecfc1389536174$funcINSERTAPPLICATION.runFunction(D:/web-sites/Web/poolDischarge/components/poolDischarge.cfc:54) at cfindex2ecfm1834540527.runPage(D:/web-sites/Web/poolDischarge/index.cfm:58)

coldfusion.runtime.UDFMethod$InvalidArgumentTypeException: The START_DATE argument passed to the insertApplication function is not of type date.

  at coldfusion.runtime.UDFMethod._validateArg(UDFMethod.java:1105)

  at coldfusion.runtime.UDFMethod._validateArg(UDFMethod.java:1118)

  at cfpoolDischarge2ecfc1389536174$funcINSERTAPPLICATION.runFunction(D:\web-sites\Web\poolDischarge\components\poolDischarge.cfc:54)

  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)

  at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420)

  at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)

  at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)

  at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)

  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:533)

  at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:648)

  at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:457)

  at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2424)

  at cfindex2ecfm1834540527.runPage(D:\web-sites\Web\poolDischarge\index.cfm:58)

  at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)

  at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)

  at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)

  at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)

  at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)

  at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:487)

  at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)

  at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)

  at coldfusion.filter.PathFilter.invoke(PathFilter.java:142)

  at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)

  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:58)

  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:219)

  at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

  at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)

  at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)

  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422)

  at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:199)

  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

  at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

  at java.lang.Thread.run(Thread.java:745)

[nic_tunney]

We might need to see more code.  Are you sure you are passing in enough arguments, and that the last argument for start_date is indeed a valid date?  If you are sure you are passing in a value you can change the type to "Any" and dump out arguments to see what is being sent.

[Imran Chaudhary_857]

Here is the code:

<cffunction name="insertApplication" returntype="numeric">

  <cfargument name="Approval_Status" type="numeric" default="#this.APPROVAL_STATUS_EVALUATION#">

  <cfargument name="Approval_Date" default="">

  <cfargument name="Delivery_Method" type="numeric" default="0">

  <cfargument name="Certified_Mail_Number" type="string" default="">

  <cfargument name="Inspector_Name" type="string" default="">

  <cfargument name="Inspector_Phone" type="string" default="">

  <cfargument name="Discharge_Address_Entered" type="string" required="Yes">

  <cfargument name="Discharge_Address_Number" type="numeric" default="-1">

  <cfargument name="Discharge_Address_Street_Name" type="string">

  <cfargument name="Discharge_Address2" type="string" default="">

  <cfargument name="Discharge_City" type="string" required="yes">

  <cfargument name="Discharge_State" type="string" required="yes">

  <cfargument name="Discharge_Zip" type="string" required="yes">

  <cfargument name="Owner_First_Name" type="string" required="yes">

  <cfargument name="Owner_Last_Name" type="string" required="yes">

  <cfargument name="Owner_Phone" type="string" required="yes">

  <cfargument name="Owner_Fax" type="string" default="">

  <cfargument name="Owner_Email" type="string" default="">

  <cfargument name="mailingSame" type="boolean" default="true">

  <cfargument name="Mailing_Address1" type="string" default="#arguments.discharge_address_entered#">

  <cfargument name="Mailing_Address2" type="string" default="#arguments.discharge_address2#">

  <cfargument name="Mailing_City" type="string" default="#arguments.discharge_city#">

  <cfargument name="Mailing_State" type="string" default="#arguments.discharge_state#">

  <cfargument name="Mailing_Zip" type="string" default="#arguments.discharge_zip#">

  <cfargument name="Pro_Discharge" type="boolean" default="0" required="yes">

  <cfargument name="Maintenance_Company_ID" type="numeric" required="yes">

  <cfargument name="Start_Date" type="date" required="yes">

  <cfargument name="End_Date" type="date" required="no">

  <cfargument name="altDischarge" type="numeric" default="0">

  <cfargument name="Discharge_Point" type="string" required="yes">

  <cfargument name="Volume" type="numeric" required="yes">

  <cfargument name="Requested_Flow_Rate" type="numeric" default="#this.DEFAULT_FLOW_RATE#">

  <cfargument name="Is_Saltwater" type="boolean" default="false" required="yes">

  <cfargument name="Has_Solids" type="boolean" default="false" required="yes">

  <cfargument name="Solids_Treatment" type="string" default="">

  <cfargument name="Has_Copper" type="boolean" default="false" required="yes">

  <cfargument name="Copper_Treatment" type="string" default="">

  <cfargument name="Water_pH" type="numeric" default="0" required="yes">

  <cfargument name="pH_Treatment" type="string" default="">

  <cfargument name="created_by" type="string" default="User">

  <cfargument name="Comments" type="string" default="">

  <cfargument name="Preferred_Delivery_Method" type="string" default="">

  <cfquery name="doInsert" datasource="#application.dsn#">

   insert into Applications (

    Approval_Status,

    Approval_Date,

    Permit_Number,

    Delivery_Method,

    Certified_Mail_Number,

    Inspector_Name,

    Inspector_Phone,

    Discharge_Address_Entered,

    Discharge_Address_Number,

    Discharge_Address_Street_Name,

    Discharge_Address2,

    Discharge_City,

    Discharge_State,

    Discharge_Zip,

    Owner_First_Name,

    Owner_Last_Name,

    Owner_Phone,

    Owner_Fax,

    Owner_Email,

    MailingSame,

    Mailing_Address1,

    Mailing_Address2,

    Mailing_City,

    Mailing_State,

    Mailing_Zip,

    Pro_Discharge,

    Maintenance_Company_ID,

    Start_Date,

    End_Date,

    altDischarge,

    Discharge_Point,

    Volume,

    Requested_Flow_Rate,

    Is_Saltwater,

    Has_Solids,

    Solids_Treatment,

    Has_Copper,

    Copper_Treatment,

    Water_pH,

    pH_Treatment,

    created_by,

    Comments,

    Preferred_Delivery_Method

   ) values (

    <cfqueryparam value="#arguments.Approval_Status#" cfsqltype="CF_SQL_NUMERIC">,

    <cfif isDate(arguments.Approval_Date)>

     <cfqueryparam value="#arguments.Approval_Date#" cfsqltype="CF_SQL_TIMESTAMP">,

    <cfelse>

     null,

    </cfif>

    <cfqueryparam value="#generatePermitNumber()#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Delivery_Method#" cfsqltype="CF_SQL_NUMERIC">,

    <cfqueryparam value="#arguments.Certified_Mail_Number#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Inspector_Name#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Inspector_Phone#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Discharge_Address_Entered#" cfsqltype="CF_SQL_VARCHAR">,

    <cfif arguments.Discharge_Address_Number neq "-1">

     <cfqueryparam value="#arguments.Discharge_Address_Number#" cfsqltype="CF_SQL_NUMERIC">,

    <cfelse>

     null,

    </cfif>

    <cfqueryparam value="#arguments.Discharge_Address_Street_Name#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Discharge_Address2#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Discharge_City#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Discharge_State#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Discharge_Zip#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Owner_First_Name#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Owner_Last_Name#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Owner_Phone#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Owner_Fax#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Owner_Email#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.MailingSame#" cfsqltype="CF_SQL_BIT">,

    <cfqueryparam value="#arguments.Mailing_Address1#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Mailing_Address2#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Mailing_City#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Mailing_State#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Mailing_Zip#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Pro_Discharge#" cfsqltype="CF_SQL_BIT">,

    <cfqueryparam value="#arguments.Maintenance_Company_ID#" cfsqltype="CF_SQL_NUMERIC">,

    <cfqueryparam value="#arguments.Start_Date#" cfsqltype="CF_SQL_TIMESTAMP">,

    <cfqueryparam value="#arguments.End_Date#" cfsqltype="CF_SQL_TIMESTAMP">,

    <cfqueryparam value="#arguments.altDischarge#" cfsqltype="CF_SQL_NUMERIC">,

    <cfqueryparam value="#arguments.Discharge_Point#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Volume#" cfsqltype="CF_SQL_NUMERIC">,

    <cfqueryparam value="#arguments.Requested_Flow_Rate#" cfsqltype="CF_SQL_NUMERIC">,

    <cfqueryparam value="#arguments.Is_Saltwater#" cfsqltype="CF_SQL_BIT">,

    <cfqueryparam value="#arguments.Has_Solids#" cfsqltype="CF_SQL_BIT">,

    <cfqueryparam value="#arguments.Solids_Treatment#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Has_Copper#" cfsqltype="CF_SQL_BIT">,

    <cfqueryparam value="#arguments.Copper_Treatment#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Water_pH#" cfsqltype="CF_SQL_NUMERIC">,

    <cfqueryparam value="#arguments.pH_Treatment#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.created_by#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Comments#" cfsqltype="CF_SQL_VARCHAR">,

    <cfqueryparam value="#arguments.Preferred_Delivery_Method#" cfsqltype="CF_SQL_VARCHAR">

   )

[nic_tunney]

Are you using named arguments when calling that beast of a function, or are you passing each individually?  It is difficult when you are mixing required arguments.  I'd still ensure you are passing everything and not missing something that is throwing off the arguments if you aren't using named arguments in the call.

[Imran Chaudhary_857 · Accepted solution]

I changed numberic data type to any to make it work. I don't know why i need to change the data type, just cause we moved to new coldfusion.

[WolfShade]

The error says that line 54 (Pro_Discharge) is the culprit, but Start_Date is line 56.  Are you sure you're passing the correct number of arguments to the function?  Seems like something is not adding up.

Are you passing the values alone in proper order?  Or are you naming each value passed?

V/r,

^_^