Error uploading a file

[LouieWarren]

I inherited an application a few years ago and up until today, a particular part of the code has worked flawlessly.   It was supposed to upload a pdf file and attach it to a record in the database.  Now, I receive a generic message and I have no clue what is wrong.  I mostly am an Oracle DBA and can do enough CF to get by, until now.   What can I add to this to help give me an idea of what is wrong?  Thanx.  In the below code piece, the cflocation line just goes on, but I can't do that here.

<cftry>

   <cffile action = "upload"  

             fileField = "requiredFILENAME"  

             destination = #newDest#     

             accept = "application/pdf">

<cfcatch>

   <CFLOCATION url="upload378.cfm?F378_ID=#FORM.F378_ID#&ERROR=We were unable to upload your file. Please try again..&FMBIC_DT=#FORM.FMBIC_DT#&IE_PMO_DT=#FORM.IE_PMO_DT#

                                 &IE_PMOMILCON_DT=#form.IE_PMOMILCON_DT#">

</cfcatch>

</cftry>

[EddieLotter]

No problem, I was agreeing with you, not calling you out. Perhaps I should have said "That's what I said too."

It's always better to have input from multiple people. Sometimes one person can explain exactly the same concept, but in a sufficiently different way that the solution becomes clear to the OP.

Cheers

Eddie

[LouieWarren]

Finally got the e-mail detail page after commenting out the generic error message.  Empty string?

Error - struct
Cause:  
    [struct]
    Detail: [empty string]
    Message: debugging
    StackTrace: coldfusion.runtime.AbortMessageException: debugging
        at coldfusion.tagext.lang.AbortTag.doStartTag(AbortTag.java:69)
        at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
        at cfupload378Act2ecfm386299277.runPage(\\TestServer\secure\Authorization\upload378Act.cfm:51)
        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 cfApplication2ecfc1353965066$funcONREQUEST.runFunction(\\TestServer\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.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:505)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
        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:450)
        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]
    TagContext:  
        [array]
        1) [struct]
            COLUMN: 0
            ID: CFABORT
            LINE: 51
            RAW_TRACE: at cfupload378Act2ecfm386299277.runPage(\\TestServer\secure\Authorization\upload378Act.cfm:51)
            TEMPLATE: \\TestServer\secure\Authorization\upload378Act.cfm
            TYPE: CFML 
        2) [struct]
            COLUMN: 0
            ID: CFINCLUDE
            LINE: 32
            RAW_TRACE: at cfApplication2ecfc1353965066$funcONREQUEST.runFunction(\\TestServer\secure\Application.cfc:32)
            TEMPLATE: \\TestServer\secure\Application.cfc
            TYPE: CFML 
    Type: Expression
Detail: An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.
Message: Event handler exception.
RootCause:  
    [struct]
    Detail: [empty string]
    Message: debugging
    StackTrace: coldfusion.runtime.AbortMessageException: debugging
        at coldfusion.tagext.lang.AbortTag.doStartTag(AbortTag.java:69)
        at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
        at cfupload378Act2ecfm386299277.runPage(\\TestServer\secure\Authorization\upload378Act.cfm:51)
        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 cfApplication2ecfc1353965066$funcONREQUEST.runFunction(\\TestServer\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.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:505)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
        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:450)
        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]
    TagContext:  
        [array]
        1) [struct]
            COLUMN: 0
            ID: CFABORT
            LINE: 51
            RAW_TRACE: at cfupload378Act2ecfm386299277.runPage(\\TestServer\secure\Authorization\upload378Act.cfm:51)
            TEMPLATE: \\TestServer\secure\Authorization\upload378Act.cfm
            TYPE: CFML 
        2) [struct]
            COLUMN: 0
            ID: CFINCLUDE
            LINE: 32
            RAW_TRACE: at cfApplication2ecfc1353965066$funcONREQUEST.runFunction(\\TestServer\secure\Application.cfc:32)
            TEMPLATE: \\TestServer\secure\Application.cfc
            TYPE: CFML 
    Type: Expression
StackTrace: coldfusion.runtime.EventHandlerException: Event handler exception.
    at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
    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.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:505)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
    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:450)
    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: coldfusion.runtime.AbortMessageException: debugging
    at coldfusion.tagext.lang.AbortTag.doStartTag(AbortTag.java:69)
    at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
    at cfupload378Act2ecfm386299277.runPage(\\TestServer\secure\Authorization\upload378Act.cfm:51)
    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 cfApplication2ecfc1353965066$funcONREQUEST.runFunction(\\TestServer\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)
    ... 36 more
Suppressed:  
    [array]
TagContext:  
    [array]
    1) [struct]
        COLUMN: 0
        ID: CFABORT
        LINE: 51
        RAW_TRACE: at cfupload378Act2ecfm386299277.runPage(\\TestServer\secure\Authorization\upload378Act.cfm:51)
        TEMPLATE: \\TestServer\secure\Authorization\upload378Act.cfm
        TYPE: CFML 
    2) [struct]
        COLUMN: 0
        ID: CFINCLUDE
        LINE: 32
        RAW_TRACE: at cfApplication2ecfc1353965066$funcONREQUEST.runFunction(\\TestServer\secure\Application.cfc:32)
        TEMPLATE: \\TestServer\secure\Application.cfc
        TYPE: CFML 
Type: Expression
name: onRequest

[EddieLotter]

There appears to be a cfabort tag with the message "debugging" in the Application.cfc script.

Search all of your ColdFusion scripts for the string "debugging" to find all occurrences. Just to be sure.

Cheers

Eddie

[LouieWarren]

Not in Application.cfc, but in the file where the generic error message was being displayed. (as mentioned on your first reply to this thread).

[EddieLotter]

Okay, that was added to stop page processing after dumping the error details for you to look at.

What appears above the text that you posted?

Cheers

Eddie

[LouieWarren]

This message is auto-generated by the Application. Please do not reply to this message. Given below are the details of the error that has been reported: 
Error Number:    1647
Submitted By:    Administrator
Submittor Email:    louie.warren@itility.com
Brief Description:    An error occurred: http://Testserver/secure/Authorization/upload378Act.cfm?Action=Upload
Time: 6/27/16 3:05 PM

[EddieLotter]

Is that what the user sees on the upload Web page after the error? It looks suspiciously like an e-mail.

The cfdump tag that we added is adding details to the Web page and it is those details that will be helpful in troubleshooting this problem.

Cheers

Eddie

[LouieWarren]

Yes, that is the e-mail notification, which mirrors the display (I think).   I will need to try again when the application is cooperating.  For some reason the display where I select the item to attach the uploaded file to, does not display data.  Not sure what has happened.  Worst case, I will get the Gov't DBA to refresh the Test DB from the Production DB so I can use the exact item in testing.  More as I know it.

[LouieWarren]

The Gov't DBA refreshed Test from Production.  I went to the option that displays records to attach a file to, and there is no data.  I go into production and it displays data.  So, it seems I have a problem somewhere.  Not sure what.  But I can't test this further until I can have records display.

While trying to figure out the above, I went into the option where records are entered to ensure there is data.  When I do, I immediately get an error that makes no sense.

An error occurred: http://TestServer/secure/Requirement/requirementsum.cfm?
frompage=orig&CFID=59365&CFTOKEN=a9a9c1564abec472-8C0B8613-0C2B-AB85-779367BB7D8FD763
Time: 7/1/16 1:58 PM
Error - struct
Cause:  
    [struct]
    Column: 40
    Detail: 
The CFML compiler was processing:
    The tag attribute prod2, on line 6, column 31.
    A CFQUERY tag beginning on line 6, column 10.
    A CFQUERY tag beginning on line 6, column 10.
    EOFSeen: NO
    ErrorText: "
    KnownColumn: -1
    KnownLine: -1
    KnownText: <unknown>
    Lexstate: 3
    Line: 6
    Message: Invalid token " found on line 6 at column 40.
    Snippet: The CFML compiler was processing:
    The tag attribute prod2, on line 6, column 31.
    A CFQUERY tag beginning on line 6, column 10.
    A CFQUERY tag beginning on line 6, column 10.
    EOFSeen: NO
    ErrorText: "
    KnownColumn: -1
    KnownLine: -1
    KnownText: <unknown>
    Lexstate: 3
    Line: 6
    Message: Invalid token " found on line 6 at column 40.
    Snippet:  

Line 6 of the listed .cfm file is the comment/header for the file.  There are no " or references to prod2 anywhere in the file.  BTW, prod2 is another user/schema in the same database.  The one that should be referenced in this case would be test.  My question is, is there a mismatch somewhere else in code before this file is included?   I have inserted <cfdump var ="#application.datasource#"> to ensure the code is pointing to the correct database.  In every case the proper one is displayed, even when the "Event Handler Exception" error page is displayed.   Once again, I am at a loss.

[EddieLotter]

LouieWarren wrote:

Once again, I am at a loss.

My friend, it's time for you to bite the bullet and get a ColdFusion consultant. An experienced CF developer can figure out these types of problems very easily and quickly in person.

When we try to help you informally on this forum, you post more problems with no end in sight. At this point I am going to bow out of this thread.

Good luck.

Cheers

Eddie

[LouieWarren]

My friend, it's time for you to bite the bullet and get a ColdFusion consultant. An experienced CF developer can figure out these types of problems very easily and quickly in person.

When we try to help you informally on this forum, you post more problems with no end in sight. At this point I am going to bow out of this thread.

Good luck.

Cheers

Eddie

That's what I've been saying since the beginning of this crap in 2013.  The Gov't asked for a database administrator, with some CF knowledge, and that's what my company got.  What they really needed was a CF developer with some Oracle experience.  However, at present, I am stuck figuring it out for myself.  The customer won't fund a consultant or developer.  Last year, we had a CS major as a summer intern.  He helped greatly, so I understand what you're saying.  However, unless something changes significantly, I'm stuck figuring it out for myself.   Thank you all for your help.  You have told me things I would never have figured out as quickly by myself.  Until I can convince them I need further CF help, I will keep searching and trying to figure things out.  Thanx again.

[es336td]

My friend, it's time for you to bite the bullet and get a ColdFusion consultant. An experienced CF developer can figure out these types of problems very easily and quickly in person.

The Gov't won't pay for a consultant.  However, my company has decided if the expense is not to great, they may bite the bullet and hire a temporary CF consultant to get me through this patch of code.   I have no idea of where to go and what the cost is these days.  I'm in the Washington Metro Area.  Thanx in advance.

[BKBK]

LouieWarren wrote:

2. TheCFMLcompilerwasprocessing:
4. Thetagattributeprod2,online6,column31.
5. ACFQUERYtagbeginningonline6,column10.
6. ACFQUERYtagbeginningonline6,column10.
9. Line:6
10. Message:Invalidtoken"foundonline6atcolumn40.

Some useful information there. This snippet suggests:

1) There was a compiler error. It suggests an error in the language, which needs fixing first. So it is probably futile to go looking into external resources such as the database.

2) Coldfusion is apparently unhappy with your use of the tag cfquery and with an attribute named prod2 in the same line of code. I am therefore guessing that you have code that looks like this:

<cfquery prod2="some_value">

If so, why would you use prod2 as an attribute for cfquery?

3) Notwithstanding the use of prod2 as a cfquery attribute, at some point it is possibly allocated an invalid value (some_value).

[LouieWarren]

Some useful information there. This snippet suggests:

1) There was a compiler error. It suggests an error in the language, which needs fixing first. So it is probably futile to go looking into external resources such as the database.

2) Coldfusion is apparently unhappy with your use of the tag cfquery and with an attribute named prod2 in the same line of code. I am therefore guessing that you have code that looks like this:

<cfquery prod2="some_value">

If so, why would you use prod2 as an attribute for cfquery?

3) Notwithstanding the use of prod2 as a cfquery attribute, at some point it is possibly allocated an invalid value (some_value).

That;s what is so strange.  There is no cfquery on line 6 in the noted .cfm file, just a blank line in the commented change history header.  prod2 is another database/user/schema on the server; the appropriate one is test.

I did a comparison of what I currently have in development and what is on Production.  The only difference was I did the bulk change from #datasource# to #application.datasource# in the code I am working on now; as I did in an earlier thread.  Production still references #datasource#.   When I use AstroGrep to search my code base, there is no reference to prod2 anywhere.

[WolfShade]

Forgive the stupid question.  Does your USG employer require the .cfm files to be encrypted?

V/r,

^_^

[LouieWarren]

Forgive the stupid question.  Does your USG employer require the .cfm files to be encrypted?

V/r,

^_^

Not that I know of.  There is no classified information in the application.  It's more of a need to know thing.  That's why when I post things I try to ensure I change references to actual directories and database names.

There are no stupid questions.  If you all can listen to me whine about my predicament, anything you ask is getting me closer to figuring out what the problem is.  There are many.  Thank you all again.

[BKBK]

LouieWarren wrote:

Some useful information there. This snippet suggests:

1) There was a compiler error. It suggests an error in the language, which needs fixing first. So it is probably futile to go looking into external resources such as the database.

2) Coldfusion is apparently unhappy with your use of the tag cfquery and with an attribute named prod2 in the same line of code. I am therefore guessing that you have code that looks like this:

<cfquery prod2="some_value">

If so, why would you use prod2 as an attribute for cfquery?

3) Notwithstanding the use of prod2 as a cfquery attribute, at some point it is possibly allocated an invalid value (some_value).

That;s what is so strange. There is no cfquery on line 6 in the noted .cfm file, just a blank line in the commented change history header. prod2 is another database/user/schema on the server; the appropriate one is test.

I did a comparison of what I currently have in development and what is on Production. The only difference was I did the bulk change from #datasource# to #application.datasource# in the code I am working on now; as I did in an earlier thread. Production still references #datasource#. When I use AstroGrep to search my code base, there is no reference to prod2 anywhere.

Cfquery need not be on Line 6 or even in the referenced CFM file!

It might be coming in through a cfinclude or - what amounts to the same - through the Application file.

Comparing the development and production code only complicates matters. Just search the code that produced the error message above. It does contain an artefact named prod2. If you don't find it, then you are probably searching the wrong code base.

[es336td]

Cfquery need not be on Line 6 or even in the referenced CFM file!

It might be coming in through a cfinclude or - what amounts to the same - through the Application file.

Comparing the development and production code only complicates matters. Just search the code that produced the error message above. It does contain an artefact named prod2. If you don't find it, then you are probably searching the wrong code base.

Lovely.  I checked the referenced .cfm file and there are no includes that I can see.  So I need to find where the referenced show is called and trace through that?

There are no references to prod2 in my development code base.  In doing the comparison, mentioned earlier, I did solve a problem I had that relates directly to the original post in this thread.  I found hard coded fiscal year references in production and development.  Once I made the reference in development match what was in production, I was able to see the data I need to attach the file to.  Small victories.

There are two databases/schemas/users on the server: prod2 and test.  Different code bases and different data in each.  CF admin points the code to the correct database.   I have added cfdump messages at various points to display the datasource and it shows up correctly each time.  Still at a loss.

[LouieWarren]

It appears I replied to two answers using my personal ID.  I had meant to use this one.  Yes, ess336td is me.  Sorry for the confusion.

[BKBK]

Search for all occurences of cfquery in the code base that produced the above error message. Locate the line that has prod2 in it, or else, something like #prodSvr#, where prodSvr may take the value prod2.

[Carl Von Stetten]

Louie, this thread is becoming very convoluted.  I'd like to close out the initial question.  If you can, please click the "Correct Answer" button on the reply that answered the initial question satisfactorily.

Then, if you can identify which of your subsequent replies branched to a new topic, let me know and I'll branch everything from there on to a separate question (maybe give me a suggested title for the question).

In the future, if a question is answered, please start a new question if you need assistance with a separate issue - continuing to ask new questions on the same thread makes it confusing for people coming later on to find answers to similar issues.

Thanks,

-Carl V. - Moderator

[LouieWarren]

I have reviewed this thread.  While it is extremely long, it has yet to be solved.   There is no correct answer, yet.  I have had some good pointers on ways to find out what is going on, but no real solution.    I can mark your reply as the correct answer, or this one.  Not really sure of where to go with it.  I apologize if I have not followed protocol.  I get really involved in trying to fix problems and don't focus on anything else.  I see where it went wrong, but there's now way to split out the two threads; the original one and the one about cfquery and prod2.  The latter is a tangent and should not be in here.  It should be it's own thread.  Once again, I apologize.

[BKBK]

LouieWarren,

Apparently, the thread got stranded. Let's give one last go. What is the problem to which you seek an answer? Please provide the offending code wherever possible.

[LouieWarren]

The original post is still an issue.  I get the generic error message saying that the file could not be uploaded.  Bypassing that message, I get the message that the directory where I want to store the file is invalid.   I've posted the code above.  I just had CF Admin turn on debugging and I will post any further insight when I return from a meeting.  Thank you.

[Carl Von Stetten]

From reading back through the thread, I agree with others that you still probably have a permissions issue somewhere.  And writing an uploaded file to disk requires a full absolute path (C:\folder\folder\webroot\somefolder, not a web-relative path (

\webroot\somefolder).  Other than that, I'm not sure what else to suggest.

-Carl V.