ColdFusion

I'm trying to migrate from cf11 to cf21 and I'm getting a series of errors which I assume are related to hibernate.I already tried to use the .car generated in cf11 for cf21....this is the entire stack trace:java.lang.NullPointerException at com.sun.xml.bind.v2.runtime.unmarshaller.StAXConnector$1.getPublicId(StAXConnector.java:101) at org.apache.xerces.util.SAXLocatorWrapper.getPublicId(Unknown Source) at org.apache.xerces.xni.parser.XMLParseException.<init>(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.xs.XMLSchemaValidator$XSIErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.xs.XMLSchemaValidator.reportSchemaError(Unknown Source) at org.apache.xerces.impl.xs.XMLSchemaValidator.handleStartElement(Unknown Source) at org.apache.xerces.impl.xs.XMLSchemaValid

So this is a new installation running some old apps (which do work).One thing, though, is that try as I might, I can't get the debug information to get tacked onto the page.I've enabled it in cfadministratorEnable Robust Exception Information And I believe my IP address is listed in View / Remove Selected IP Addresses for Debug OutputAnd I've created a test page with<cfsetting showdebugoutput="Yes">What am I missing?!  

Hello,I just installed ubuntu 13.10, and it comes with apache 2.4, which means the next LTS of ubuntu will include apache 2.4.  I also read that Fedora 18 and up come with apache 2.4, and so RHEL 7 could also use apache 2.4 instead of 2.2.I understand that 2.4 is not supported now.  When will ColdFusion support apache 2.4?Thanks,Jonathan Morgan

I'm working with an application running on ColdFusion 2018 and Java 11. It uses threads to make multiple http requests at once to reduce the wait time of loading data. About once a month, sometimes more, we start to get error reports of java.lang.NoSuchMethodException: coldfusion.runtime.CFDummyComponent.<init>() on the line of code that creates a thread. I haven't found any pattern to it and the error seems to just keep happening for every request that goes through the affected code path after it's first triggered until the server is restarted. This is occurring in production but I haven't been able to reproduce it locally so I have a feeling it's related to the number of users of the system. Can anyone offer a suggestion on what could be the cause? Please see the related code and error dump snippets below. threadService.cfc/* * Runs all supplied threads and returns the results in a structure where each key * is the name of a thread and contains the results of running

Good day, We are working with an Education facility in the Middle East whom are a ColdFusion users. We're seeking a Cf expert to work with us remotely on the project. Please send me a private message if you're interested. Zaid

Hello,  I recently upgraded from CF2016 to CF2021.  Now i'm not heavily into ColdFusion, our previous developer has retired so I got put into this.  Mostly I have been upgrading/changing links and troubleshooting some syntax in coding or troubleshooting minor issues.  I basically have been tasked to keep this legacy system working.  (Our company is in the end stages and will most likely not be around in a few more years). So after the upgrade, i'm able to open up my dev site for our HR portal.  The login page comes up, but i'm unable to login.  I"m getting "User Doesn't Exist or Password Expired" error.  We have a EZ-SSO client that handles our login and I can't tell if that is what is causing the issue.  If the upgrade made changes that affects the code accessing the Active Directory.  I am using a <CFLDAP> command to query the active directory.

I have the CF Admin setting for cookies set to Secure and HTTPOnly, however when I browse the app, the session cookies are NOT secure. Is there something else that needs to happen to make the cookies secure? Thanks,Tom Muck

How can i link pivot table data to another sheet? As i want to link and save my all sites data at one place. Can anybody here help me out ?Thanks ! 

I recently did an upgrade from CF 2016 to  CF 2021 and all went well, Thanks to the inputs from the community.  One strange thing I noticed is that one of the menu options which usually renders a login/pwd page is garbled and not working, All other menu options in our site are clearly rendering the login page fine. Anything that I'm missing here? This is what I see in the our page, other similar menu comes up with login/pwd perfectly Any help is appreciated. ThanksSajan 

Hi, As part of moving towards Coldfusion 2021 (from CF2016) and I downloaded the installer file ColdFusion_2021_GUI_WWEJ_linux64.bin and completed the install successfully the 30day trial option. I was looking for the Standard Edition and not the Enterprise Edition as we are downgrading. Question:Upon launching the admin console, it says ColdFusion 2021 Release Enterprise Trial 30 day(s) left - How do I  downgrade to Standard Edition, is it through a specific license or do i need to blow this install totally and get the installer for standard edition? Since I could not locate the specific installer file for standard edition, I got whatever is there from Adobe site for our Linux OS. Please let me  know. ThanksSajan

Hello I am using coldfusion 2021 community and sqlserver 2014 on a windows 10 machine. I have not been able to create a DSN, receiving different errors the latest error being  Connection verification failed for data source: food_09292021java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Kerberos Authentication is not supported by this SQLServer. The driver attempted Kerberos authentication because the AuthenticationMethod connect option was "auto" and no username/password was specified.Thank you in advance for your help

Anyone have any experience with ACF docker and CFBuilder debugger?I can add the server that the docker container is running and the debugger is able to connect to the rds of the server when the debugger starts. The issue is that the debugger is unable to resolve the location of the source files. This leaves me with the error message "source file not found" when hitting breaksThe docker containers files live at "/app/file" but my local files that cfbuilder accesses are local with a different directory location. Is there a way to provide a debug mapping that will resolve this?Any insight is appericated!

We have been providing a simple javascript link for for other websites to embed to display content from our site without using iframes. Basically the HTML generated in the cfm file is saved in a <cfsavecontent> variable, and rendered into javascript using document.write('jsStringFormat(content)); Other sites then embed it using:<script type="text/javascript" src="somesite/temp.cfm"></script> This has worked well for many years, but due to increased security we added X-Content-Type-Options="nosniff" to our headers. This results in a MIME type (“text/html”) mismatch error, so the javascript is blocked. As far as I can tell this is because a .cfm page is delivering js content (?) Any suggestions how we can work around this?

Hello All,I am using the CF Builder 2016 and could not find anything to set up FTP.  I need to FTP connection to move file from Development to Production machine.Please adviseThank you so much

VERY IMPORTANT:  This code ran flawlessly on CF v10 (same master excel file "xlsx")MUST Find solution. My Master excel is "xlsx".   Going back to "xls" is NOT option as we're using advanced features not backward compatible. To simulate workflow I used Excel to create a blank "xls" and "xlsx" both with "sheet1" renamed to "interview".The following code sets the cells correctly... BUT "xls" will autocalc when opened, "xlsx" WILL NOT.  User must hit [cntrl-alt-F9] which then updates.Please try yourself, you will see same results.  (simply switch lines 1/2 to use different "master" in your simulation.<cfset excelFileToUse = "d:\oldExcel.xls"><cfset excelFileToUse = "d:\testMaster.xlsx"> <cfset dummyNumber = randrange(12345,99999)><cfset fileExt = listLast(excelFileToUse,".")><cfset CompanyLink = "HYPERLINK(""http://localhost/customers/customer.cfm?customerID=156"",""My Company"")"><cfset contactLink = "HYPERLINK(

I am using the below code to generate a PDF.  The top part of the page is an image but there is whitespace while placing the image in the generated PDF.  How do i remove the whitespace  from the PDF. Any suggestions? Please find the code snippet below.  Attached the CURRENT.JPG and EXPECTED.JPG images. In the current you can find a portion marked in red which i need to remove.  The PDF should look exactly like the expected.JPG <cfdocument pagetype="legal" format="PDF" marginbottom="0" margintop="0" marginleft="0" marginright="0" ><table border=0 cellspacing=0 cellpadding=0 height=200><tr><td valign=top align=left><img src="https://www.getinge-training.com/images/TopHeader.jpg" width="1429" height="496" border=0><br><br><br><br><p align=center><font size=10>NAME OF THE PERSON</td></tr></table></cfdocument>

Hello everybodyI don't know if you can help me but:I create an excel document using the instructions "spreadsheet" for ColdFusion 10.There is, among the data to be added, a "hyperlink" formula that will contain the URL of a websiteI therefore use the instruction "SpreadsheetSetCellFormula"See the code:<cfset SpreadsheetSetCellFormula(s, 'HYPERLINK("#Query.Field1#", "#qQuery.Field1#")', curRow, curCol)> Explanation of different variables:s                   : object representing the excel sheetQuery.Field1 : it is the data containing the URL (in a Query)curRow          : row number where the data will be writecurCol           : Column numberThe problem:When I execute the code on my computer and I open the file: the display is correctWhen my colleague tries to create the file with the same code, he r

Hi All, TL;DR: Basically not sure how to stream text to the browser from a CFC. I'm sure this is either simple or not possible but how do you return a Server Side Event text stream, using cfcontent type="text/event-stream" from a CFC function as opposed to a .cfm page? I currently have a this code sample set up in a getmessages.cfm page and it works as expected: <cfscript> cfheader( name="cache-control", value="no-cache, no-store, must-revalidate" ); cfheader( name="pragma", value="no-cache" ); cfheader( name="expires", value=getHttpTimeString(now()) ); cfcontent( type="text/event-stream" ); cfsetting( requesttimeout=60 ); for ( i=1 ; i<=10 ; i++ ) { // end each data line with two #Chr(10)# if ( i == 1 ) { writeOutput("id: #createUUID()##Chr(10)#"); writeOutput("data: {""msg"": ""Starting Process..."", ""id"": #i#} #Chr(10)##Chr(10)#"); } writeOutput("retry: 10000#

Hello,I am trying to fix SQL injection inside an <CFSCRIPT> block.  Please see the below screen snap shot /* Determine if user has account */qryAuthEmp = queryExecute("SELECT a.*, facility_key, org_cdFROM staffing.auth_user_name a,(SELECT ndc_emp_id,(CASEWHEN (INSTR (email_id, '@') - 1) > 20THENUPPER (SUBSTR (email_id, 1, 20)) || '@FAA.GOV'ELSEUPPER (email_id)END)user_emailFROM staffing.auth_user_name) b,(SELECT DISTINCT facility_key, y.org_cd, email_idFROM #session.userProfile.emailAddress contains "CTR." ? "staffing.contractor x" : "staffing.employee x"#JOIN staffing.master_org_cc_lookup YON x.org_cd = y.org_cdWHERE active = 'Y'AND end_date > SYSDATE#session.userProfile.emailAddress contains "CTR." ? "" : "AND emp_stat_cd IN ('A','C','F','L','M','P')"#) dWHERE a.ndc_emp_id = b.ndc_emp_idAND a.email_id = d.email_idAND a.is_active = :ActiveStatusAND a.end_date > SYSDATEAND UPPER(b.user_email) = :email_id",{ActiveStatus={value='Y', cfsqltype='cf_sql_varchar'},//

When I try to install CF 2021 on OSX Moneterey, either with the unzip installer or GUI installer, the proces gets aborted because:“java” cannot be opened because the developer cannot be verified. Although you can often make an exception for certain files to run in the Security and Privacy settings panel, this one won't run. Has the CF team abandoned developers who use OSX or is there something I'm missing?  

Hi all, I've inherrited an old web server running CF 11 on Ubuntu 14.04.  The server hasn't had a problem in the last 2 years that I've been here. However, at about 2:00pm last Tuesday, it started to crash.  When a user tried to access the site with their browser, it would just spin.  On the server, we noted that the java task was using 100% cpu.  When we restart coldfusion and apache, we are back to normal... for a while. I've discovered that one particular url will consistently crash the server: /shop/ItemAdd.cfm I was working on that file, but I've backed out all of my changes, and to my knowledge, nothing else was changed on the server. We've done a lot to try to diagnose this. But here's where it gets odd. If I rename ItemAdd.cfm to ItemAdd.cfm.orig, I would expect to get a 404 error when I point a browser to /shop/ItemAdd.cfm, but I don't.  It still crashes!  So, I don't THINK it's a code issue. I've

Hi Community,Hopefully someone has seen this before. I have a line of code this is actually in several applications and has never causes problems before. The line of code causing the error is below. This is pretty basic stuff. Creating a object from a SOAP enabled website (it's actually a ColdFusion website from a cfc). var webservice = createObject("webservice", arguments.url); The plan for this morning is to recycle (restart) the server and see if that fixes it. If this continues to come up, has anyone seen or fixed this? The server is CF 2018, with the latest patches applied.

Our ColdFusion server only allows connections via ftps. Has anyone figured out how to do a ftps connection to a remote server in ColdFusion Builder?I see ftp ot SSH, but nothing for ftps.An ftp client connection requires TLS/SSL Explicit encryption

The following is running on a ColdFusion 2018 server (in the event this is a version-specific issue). I'm setting the Application datasource property in the onApplicationStart() LifeCycle Handler, but the datasource property isn't accessible in a CFM Template. I'm thinking it may have something to do with how the this Scope is handled inside the onApplicationStart() method, but I'm not certain. I tried setting the datasource property using this.datasource as well as Application.datasource, but it's not accessible in the CFM Template either way. Application.cfc// The usual App config stuff here... (omitted for brevity) // Instantiate Instance of Java System Object used to set System Env Vars this.System = createObject("java", "java.lang.System"); // Include Config files include "resources/config/AppSettings.cfm"; include "resources/config/onApplicationStart.cfm"; AppSettings.cfmif (! isDefined(this.System.getProperty("DB_DSN_CREATED"))) {

I have found that on two of my coldfusion 2021 servers, at random intervals, the CGI scope starts returning an empty struct.   When this happens, the only solution seems to be a restart of the ColdFusion service. there dont seem to be any relevant entries in any of the ColdFusion logs or the Windows Event Viewer. Has anybody ever experienced this?