That's exactly what the Gov't SysAdmin and DBA say.  On more than one occasion, I have had to do more digging to prove it was indeed their problem and even had to tell them how to fix it.  Sad but true.   However, I think this may be my problem. ... View more

So my predecessors were good in their error functions?  Good to know.   No, MyDB is not the datasource.  My customer gets crazy when I publish exact directories and datasource names, so I change all that before I post.  I've slipped a few times, but tried to make sure it is changed.   In this instance, it was the actual datasource name and not application.datasource which is assigned earlier in Application.cfc I believe the DB resides on a SAN, but the gov't DBA and SysAdmin aren't very forthcoming with that information.  It seems to me, in some meeting, that was mentioned, but my SysAdmin (for my company) was there, so I didn't pay attention.  He said he created my new development database server to mirror theirs and it resides on a SAN.   Hope this helps. ... View more

The message changes the module and line number, but the overall message remains the same: [Macromedia][Oracle JDBC Driver][Oracle]ORA-02396: exceeded maximum idle time, please connect again Not sure why I'm getting the timeout. Here's the OnError currently in my Application.cfc <cffunction name="OnError" access="public" returntype="void" output="true" hint="Fires when an exception occures that is not caught by a try/catch block">     <cfargument name="exception" type="any" required="true">     <cfargument name="eventName" type="string" required="true">     <cfset var errortext = "">     <cfset var redirectUrl= "../index.cfm">     <cfset application.datasource="MyDB">     <cfif arguments.exception.rootCause eq "coldfusion.runtime.AbortException">         <cfreturn/>     </cfif>     <!---<cflog file="#this.name#_ErrorLog" text="#arguments.exception.message#">---->         <cfsavecontent variable="errortext">         <cfoutput>             An error occurred: http://#cgi.server_name##cgi.script_name#?#cgi.query_string#<br />             Time: #dateFormat(now(), "short")# #timeFormat(now(), "short")#<br />         </cfoutput>         <cfdump var="#arguments.exception#" label="Error">         <cfdump var="#form#" label="Form">         <cfdump var="#url#" label="URL">        </cfsavecontent>         <cfquery name="getID" datasource="#application.datasource#">             SELECT ERR_SEQ.NEXTVAL AS newID FROM dual          </cfquery>         <cfset NewErrorNumber=getID.newID>         <cfquery datasource="#application.datasource#" >             INSERT INTO ERR_LOG (ERR_ID ,ERR_DETAIL ,SECUREUSERID ,UPTIME,ERR_INFO  )             VALUES (#NewErrorNumber#,'#left(arguments.exception.message,4000)#',#session.secureUserID# ,sysdate,<cfqueryparam value="#errortext#" cfsqltype="cf_sql_clob"/> )         </cfquery>          <cfmail to = "#application.DeveloperEmailList#" from = "HelpDesk@here.there" subject = "(Error ID: #NewErrorNumber#) App Error: #left(arguments.exception.message,100)#..." type="html">             <table><tr><td width="536">             This message is auto-generated by the AppApplication.  Please do not reply to this message. Given below are the details of the error that has been reported:             </td>             </tr></table>             <table width="100%">             <tr><td width="20%" style="word-break:break-all"><b>Error Number:</b></td>             <td width="80%" style="word-break:break-all"> #NewErrorNumber#</td>             </tr>              <tr><td><b>Submitted By:</b></td>             <td style="word-break:break-all">   #session.userName#</td>             </tr>              <tr><td><b>Submittor Email:</b></td>             <td style="word-break:break-all">   #session.email#</td>             </tr>                <tr><td><b>Brief Description:</b></td>             <td style="word-break:break-all">An error occurred: http://#cgi.server_name##cgi.script_name#?#cgi.query_string#<br />             Time: #dateFormat(now(), "short")# #timeFormat(now(), "short")#</td>             </tr>              <tr><td valign="top"><b>Detailed Description:</b></td>             <td style="word-break:break-all"><cfdump var="#arguments.exception#" expand="yes" showudfs="yes" label="Error" output="browser" format="text" metainfo="yes"></td>             </tr>             <tr><td valign="top"><b>Url Variables:</b></td>             <td style="word-break:break-all"><cfdump var="#form#" expand="yes" showudfs="yes" label="Error" output="browser" format="text" metainfo="yes"></td>             </tr>             <tr><td valign="top"><b>Form Variables:</b></td>             <td style="word-break:break-all"><cfdump var="#url#" expand="yes" showudfs="yes" label="Error" output="browser" format="text" metainfo="yes"></td>             </tr>                  </table>         </cfmail>         <cfoutput>                 <p>App has experienced an error. App Administrators have been notified and will coordinate with you in resolving the error.</p><p>Error #NewErrorNumber# - #arguments.exception.message#</p>         </cfoutput> </cffunction> I don't have a onMissingTemplate() section. ... View more

I'll have to check that out.  BTW, I found that all my error messages were going into the server's spam folder and were never sent out.  The tech just sent them to me.  The one from last week still referenced the line 76 in wetfirst.cfm.  The follow on messages referenced requirementsum.cfm line 46.  So, as long as I get e-mails, I can work through until I find the next one.   I can do a search to find examples of the functions you've mentioned to see format?   Thank you. ... View more

I still have yet to receive the e-mail notification.  Not sure what is up with that.  I still get the generic "The local variable application cannot be declared outside of a function."  error page..  Anything else I can do to find out what is up?  Is there a way to change what is displayed on the error page?  I would just wait for the notification, but the customer is breathing down my neck.   I have requested the SysAdmin check the queue to see if something was in there for me, but have yet to receive a response.  On top of that, the server is down for "emergency" updates and such, until tomorrow at 0600.  Just didn't want to sit around waiting if I could be doing something else.  Thanx ... View more

Amen.  This whole mess started when it couldn't find the datasource.  The only one declared was this.datasource.  I changed it to application.datasource and most of the application worked correctly.  Now we're going through and finding all the other dirty little secrets.   Cellophane toilet paper...  definitely. ... View more

Yep, I have had those suggestions before, but haven't had time to go through and redo all the mess I inherited.  However, I will attempt to fix this issue and hopefully it won't come up with another. 1. Fully qualifying is good practice, but it is not used at all in any of the code and the other code works fine.  The schema/user/datasource are all the same name.  The Gov't DBA suggested, when I started this process, that we just create the new database as a user in the existing database.  It has caused me no end of grief, but it's too late to modify it all now, so patching is in my future. 2. I forgot about the * thing!   That makes a ton more sense.  When you look at a big pile of code you inherit, you tend to not pay attention to the forest, but just the trees that are giving you trouble.   I will make your suggested changes and report back. Thanx! ... View more

I saw that, but it didn't make sense.  Here's lines 74-77 of wedtfirst.cfm:     <!---Login Popup Screen message--->      <cfquery name="mCount" datasource="#application.datasource#">           SELECT count(*) as count FROM admin_loginmessage WHERE messagegroup = '#session.UserLevel#' AND trunc(sysdate) >= startdate AND trunc(sysdate) <= expirationdate      </cfquery> application.datasource is assigned in Application.cfc.   The database and code function fine for every other option on the application but this one, at least they did when I originally posted about this one.  The SysAdmin and DBA say they have made no changes. ... View more

But it was in response to my results from the cfcatch/cftry suggestion from WolfShade on 6/6.  Is that still a new topic?  Here's the full error received. ErrorCode    2396 Message    [Macromedia][Oracle JDBC Driver][Oracle]ORA-02396: exceeded maximum idle time, please connect again SQLState    HY000 StackTrace    java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-02396: exceeded maximum idle time, please connect again at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddam.t(Unknown Source) at macromedia.jdbc.oraclebase.dde3.w(Unknown Source) at macromedia.jdbc.oraclebase.dde3.s(Unknown Source) at macromedia.jdbc.oraclebase.dde3.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1451) at coldfusion.sql.Executive.executeQuery(Executive.java:1201) at coldfusion.sql.Executive.executeQuery(Executive.java:1131) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688) at cfwedtFirst2ecfm1610912140.runPage(\\52tayz-ws-004v\Testdata\Sites\SAF\IE\WEDT\BMT_New\secure\wedtFirst.cfm:76) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795) at cfApplication2ecfc158086648$funcONREQUEST.runFunction(\\52tayz-ws-004v\Testdata\Sites\SAF\IE\WEDT\BMT_New\secure\Application.cfc:32) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:300) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:426) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) 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.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:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:437) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:722) Suppressed    array [empty] TagContext    array 1    struct COLUMN    0 ID    CFQUERY LINE    76 RAW_TRACE    at cfwedtFirst2ecfm1610912140.runPage(\\Testdata\Sites\New\secure\wedtFirst.cfm:76) TEMPLATE    \\Testdata\Sites\New\secure\wedtFirst.cfm TYPE    CFML 2    struct COLUMN    0 ID    CFINCLUDE LINE    32 RAW_TRACE    at cfApplication2ecfc158086648$funcONREQUEST.runFunction(\\Testdata\Sites\New\secure\Application.cfc:32) TEMPLATE    \\Testdata\Sites\New\secure\Application.cfc TYPE    CFML Type    java.sql.SQLException SQLState    HY000 Sql    SELECT count(*) as count FROM admin_loginmessage WHERE messagegroup = 'Tool Administrator' AND trunc(sysdate) >= startdate AND trunc(sysdate) <= expirationdate StackTrace    coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:739) at cfwedtFirst2ecfm1610912140.runPage(\\52tayz-ws-004v\Testdata\Sites\SAF\IE\WEDT\BMT_New\secure\wedtFirst.cfm:76) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795) at cfApplication2ecfc158086648$funcONREQUEST.runFunction(\\52tayz-ws-004v\Testdata\Sites\SAF\IE\WEDT\BMT_New\secure\Application.cfc:32) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:300) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:426) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) 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.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:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:437) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:722) Caused by: java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-02396: exceeded maximum idle time, please connect again at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source) at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddal.a(Unknown Source) at macromedia.jdbc.oracle.ddam.t(Unknown Source) at macromedia.jdbc.oraclebase.dde3.w(Unknown Source) at macromedia.jdbc.oraclebase.dde3.s(Unknown Source) at macromedia.jdbc.oraclebase.dde3.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1451) at coldfusion.sql.Executive.executeQuery(Executive.java:1201) at coldfusion.sql.Executive.executeQuery(Executive.java:1131) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688) ... 50 more Suppressed    array [empty] TagContext    array 1    struct COLUMN    0 ID    CFQUERY LINE    76 RAW_TRACE    at cfwedtFirst2ecfm1610912140.runPage(\\Testdata\Sites\New\secure\wedtFirst.cfm:76) TEMPLATE    \\Testdata\Sites\New\secure\wedtFirst.cfm TYPE    CFML 2    struct COLUMN    0 ID    CFINCLUDE LINE    32 RAW_TRACE    at cfApplication2ecfc158086648$funcONREQUEST.runFunction(\\Testdata\Sites\New\secure\Application.cfc:32) TEMPLATE    \\Testdata\Sites\New\secure\Application.cfc TYPE    CFML Type    Database queryError    [Macromedia][Oracle JDBC Driver][Oracle]ORA-02396: exceeded maximum idle time, please connect again where    [empty string] ... View more

Well, the e-mail notification from the server showed up on Sunday while I was on leave.  I just got back and it was waiting in my inbox.  The error was weird... java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-02396: exceeded maximum idle time, please connect again at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source) The correct datasource is spelled out in the stack trace.  What can't it find?  What have I done wrong? ... View more

Thank you.  Your example made sense and I was able to insert it into my Application.cfc.   I FTP'd it to the test environment and brought up the application.  Nothing appeared to change, however, my e-mail notices have been delayed from the server up to 12 hours or more later.  Thank you for the tip.  I will post results when I get them. ... View more

I'll have to brush up on that.   I tried it previously and it didn't work correctly.  Thanx. ... View more

I use Expression Web 4.  I have a copy of Dreamweaver, but it's from my old job and my computer guys don't like me to put stuff on my laptop...  therefore, I used AstroGrep and found 2250 occurrences.  The only one I found with application is var application.datasource. .No other references.  I have yet to go through all the occurrences, but will report back if I find the issue.  Right now... it's still as mysterious as it was before.  I am going to have the gov't SysAdmin turn on debugging in CF Admin to see if I can find anything else.   Thank you. ... View more

I've gone through the CF code numerous times; both the requirementssum.cfm and another .cfm file it includes and don't see anything in CF like that.  However, there is a bunch of Java/Javascript embedded and it has numerous var assignments. Is there a way I can narrow the error down?   If I didn't mention it earlier, I'm an Oracle DBA and had the CF stuff thrust upon me.   I'm sure it's much simpler than it seems. ... View more

I believe it's a local drive.  It's the same drive that contains the CF code.  When you select the option to upload the file, you are in the same directory where the code for that option resides.  There is a subdirectory that is defined (as mentioned earlier) where the physical uploaded file resides and a link to that file is stored in the database. The biggest issue I have is, 1) it worked flawlessly up until a little while ago (beginning of this thread)  2) the gov't sysadmin says that nothing has been done to change directories or permissions  3) there are no references to drive letters in any part of the code.  The way I get it in my simple mind is, when you log in, you are virtually logging in as the schema/user for the database and all the files and database are yours to update as the application allows.  What would have caused this to suddenly change after working fine for a while?  Newer version of Windows?  CF?  Supposedly my development server, the Test server, and the Production server are all running the same version of Windows, CF, and Oracle.   The original code was written with CF 8 and I believe we're at 11 now.  I found a few things that caused me issues between the old and new versions of CF (i.e.- getbuiltin scopes), but nothing like this. ... View more

Ok, it's highly likely I misunderstood UNC... The directory is assigned in Application.cfc <cfset authfileroot="\xxxxxxxx\secure\Authorization\"> In the .cfm I am working with, the storage location of the uploaded file is assigned as such: <CFOUTPUT>    <CFSET newDest = #authfileroot#&"378Docs\"/> </CFOUTPUT> I hope that answers your question. ... View more

I've had the SysAdmin involved and he ensures me (with screen shots) that everything is correct and that it is my problem.  I had another error with this app, earlier, where it was trying to produce a report (an Excel spreadsheet) and it threw the error message, "access denied".  I was able to go to the directory in FTP and change the permissions to 777 and it worked.  I will attempt that with this, but I don't see how it would change the not found issue.  ... View more

I deleted everything but the test code and got the message The file is not visible to the server.  I put the original file back and the same message came up.  I missed it in  the original error page.  The variable newDest is assigned earlier in the page: <CFOUTPUT>    <CFSET newDest = #authfileroot#&"378Docs\"/>     </CFOUTPUT> Which gives the correct location displayed in the error message.  What am I not understanding? ... View more

I plugged it in before and after the debug code and no change.  I'm sure I didn't do it correctly. ... View more

UNC  - \xxxxxx\secure\Authorization\378Docs\ The \xxxxxx is the root where the code resides and the directory to store the uploaded file. ... View more

I think I put it in the right place: <CFIF IsDefined("URL.Action") AND URL.Action is "Upload">     <CFSET F378_ID = #FORM.F378_ID#/>     <CFSET IE_PMO_DT = #FORM.IE_PMO_DT#/>     <CFSET FMBIC_DT = #FORM.FMBIC_DT#/>     <CFSET FILENAME = #FORM.requiredFILENAME#/>     <CFSET IE_PMOMILCON_DT = #FORM.IE_PMOMILCON_DT#/>    <cftry>       <cffile action = "upload"                   fileField = "requiredFILENAME"                   destination = #newDest#                       accept = "application/pdf">     <cfcatch>     <!---    <CFIF variables.FILENAME is "">         <CFLOCATION url="upload378.cfm?F378_ID=#FORM.F378_ID#&ERROR=You must select a file.&FMBIC_DT=#FORM.FMBIC_DT#&IE_PMO_DT=#FORM.IE_PMO_DT#&IE_PMOMILCON_DT=#form.IE_PMOMILCON_DT#">     </CFIF> --->       <cfdump var="#cfcatch#">       <cfabort showError="debugging">     </cfcatch>     </cftry>  <cfdump var="#form#">    The error message now tells me the path, where the uploaded file is stored, isn't valid.  It exists. The value of the attribute destination, which is currently \xxxxxx\secure\Authorization\378Docs\, is invalid. Do you need to see the whole error page?  Sorry for the crappy formatting.  I still haven't figured out how to format the code with the line numbers.  I did once, but can't seem to do it again. Thank you. ... View more

I do all the testing.  The customer, being impatient, constantly tries to upload, I am assuming, thinking that time will solve the issue, or that I fixed it and didn't tell her.   She just recently sent the e-mail that said, previously, the filename was including the entire path of where the file resided, which caused problems.  That was in 2012, and the programmer at the time, fixed it.  The customer has no clue.  I liken their knowledge of the app and how it works to the old custom of bleeding the patient to get out the bad blood. All that aside, in my testing, it still fails to upload. ... View more

I've been sidetracked with that other issue we worked through.   Did I give the code snippet you needed? The customer sent an e-mail this morning stating that she remembered this issue happening before and that the solution or workaround was the filename could not contain special characters.   I don't think that is it, but at this point, since I don't really know what I'm doing, I'm willing to try anything. ... View more

I apologize.   I get so caught up in troubleshooting, I forget protocol.  I did mention my initial error was a CFMAIL error, so I assumed this was fine.  I am currently ruling out whether or not the data is bad in the database before I submit another thread.  The problem: 12 instances of <cfset someVar = "some value" > with no end tag. The solution Changed all 12 instances to <cfset someVar = "some value" /> Problem solved.  Thank you. ... View more

OK, I'm an idiot.  I posted the code fragment of the page that referring.cfm file.  When I checked the actual .cfm file causing the error, I found 12 <cfset  something=something> in that code but not a </cfset> in the bunch.  I added the /> to each of the 12 and now I am back to my original error:  I have not touched this file except the datasource issue I had earlier.  The Production version has the non-terminated <cfset> assignments and works just fine. CurrentPage = MyAppt/App_New/secure/helpdesk/newchangerequest.cfm Call from = https://App_New//secure/helpdesk/add_changerequest.cfm MESSAGE = Attribute validation error for CFMAIL. LOCATION = Code location is not available TAGNAME = CFMAIL ERROR = Error WARNING = Info DETAIL = The value of the TO attribute is invalid. The length of the string, 0 character(s), must be greater than or equal to 1 character(s). ATTRIBUTE = TO KNOWNCOLUMN = -1 KNOWNLINE = -1 COLUMN = -1 KNOWNTEXT = <unknown> FEATURENAME = CFMAIL LINE = -1 CATEGORY = Tag SEVERITY = Error REMEDY = Try The Following: After looking at this, I am assuming it can't extract the e-mail address from the user database.  I have it in the database on development that I dumped and sent to the gov't DBA for import.   I will have him run the query to see if the value is valid and then report back. In the event it isn't screwed data...  is there a possible way I can brute force it and hardwire the code to just make all the TO addresses my e-mail address?  I'm supposed to get all mail anyway.  Just curious.  This is taking time they don't want to let me have. Thank you all so much for your help on all of this.   You have definitely helped this old man out. ... View more

I'm using Expression Web 4 because my customer didn't want to spend the money for DreamWeaver.   I will do the matching of <cfset> tags and post whatever I find. ... View more

Here's line 70 - 81 of the module identified: 70 71  if(document.form1.Priority.value=="") 72  {alert("Please select the Priority") 73  document.form1.Priority.focus() 74  document.form1.problem.select() 75  return false} 76        77  if(document.form1.problemarea.value=="") 78  {alert("Please select a Problem Area") 79  document.form1.problemarea.focus() 80  document.form1.problem.select() 81  return false} ... View more