ColdFusion

Hi, I am trying to manually execute Update 5 for Cold Fusion 5. I have stopped the ColdFusion2021 Application Server service. I am trying to execute the following:D:\ColdFusion2021\jre\bin>java.exe -jar D:\Hotfix\hotfix-005-330109.jar I am receiving the following message after trying to the above commandThe process cannot access the file because it is being used by another process. Does someone have an answer? Thanks, Mike  

Hi all,We are seeing a really weird, totally random crash on 2018. This is with code that is currently running fine in production on 2016, and ran fine on 11. Here are definitions for three simple objects that produce the crash:BaseEntity.cfccomponent mappedSuperClass="true" accessors="true" {    property name="id" fieldtype="id" generator="identity";} BaseType.cfccomponent mappedSuperClass="true" accessors="true" extends="BaseEntity" {    property name="title" fieldtype="column" ormtype="string";} PersonType.cfc component accessors="true" extends="BaseType" persistent="true" {    property name="People" fieldtype="one-to-many" cfc="Person" inverse="true" inverseJoinColumn="PersonTypeID" singularname="Person";} PersonType.cfc here is just an example. The third component in the chain could be totally empty (so only containing the inherited ID and Title).What we are seeing is that Coldfusion 2018 will crash at a random time, with an exception t

Hello:I need to replicate the following cURL call, which uses a multipart/form-data header and form fields: curl -L -R POST "https://api.XXXXXXXX.com/api/v1/academic_success/sync/enrollment" \-H "Authorization: Bearer <access_token>" \ # Generated OAuth2 token request-H "Content-Type: multipart/form-data" \-F "input_type=CSV" \-F "input_data=@enrollment_upload.csv" \ # Path to CSV file. Include '@' before path.-F "dry_run=false" \ # Set to true when testing-F 'drop_not_passed_enrollments=true' \ # only enabled when dry_run = false CFHTTP does not allow specifying form fields for multi-part data. I assume I'd have to code a header that included the form fields as part of the body along with the data, but am unclear on how to do this. We are currently production with CF 2018.Thanks.Gerry, Pace University 

Good morning, I recently upgraded from Coldfusion 2016, to 2021, with no real problems but did notice one thing that I cant seem to get a handle on. I do exporting of data though CF to build formatted spreadsheets, and since the upgrade, one thing no longer works and it is related to the setRepeatingRows. I use the "cellRangeAddress = CreateObject("java", "org.apache.poi.ss.util.CellRangeAddress");" followed by "poiSheet.setRepeatingRows(cellRangeAddress.valueOf("$1:$1"));" and get an error that says The setRepeatingRows method was not found.Either there are no methods with the specified method name and argument types or the setRepeatingRows method is overloaded with argument types that ColdFusion cannot decipher reliably.Has anyone run into this and would happen to have an idea around it?  

We've got an intranet hosting web apps written in ColdFusion with some RESTful services set up to query from our databases and return JSON for the web pages. Recently, we upgraded our development server from ColdFusion 2018 to ColdFusion 2021; afterwards, our calls to the REST service began returning objects that break our Javascript. On closer examination in the network tab, the JSON is all present and properly formatted; the only difference we can see is that the 'content-type' header of the returned object is 'application/json' on our production server (still running 2018), but 'text/plain' on our development server. We've confirmed that the RESTful services are all properly registered on the development server and that the REST API scripts, site scripts, and Javascript are all identical between the development and production servers. See below an example function from one of our REST API scripts:  <cffunction name="getProject" access="remote" returntype="Stri

Since upgrading from CF11 to CF2021, the <cfpdfform> tag no longer works - that said, not sure if the upgrade is the issue or not. In the past (on CF11), we’ve successfully generated a pdf file with the code:<cfpdfform source="Avery45008CopierMailingLabels_HBD.pdf"destination="E:\HBD_DEV\files\DestiAvery.pdf"action="populate"overwrite="true"overwriteData="yes"/> No file is generated, nor is there an error message displayed in the browser (see exception log below). I've also used the following code, as suggested by CFSupport via StackOverflow, which results in the same error:<cfpdfform source="Avery45008CopierMailingLabels_HBD.pdf"destination="E:\HBD_DEV\files\DestiAvery.pdf"action="populate"fdf="true" />Coldfusion 2021: Update 5Our JAVA version is: jdk-11.0.17 We've also deleted all files in the cfusion/bin/felix-cache and cfusion/wwwroot/WEB-INF/cfclasses folders. No love.Looking in the exception log, we find:(the culkprit appears to be "java.lang

I'm getting the error "Invalid CFML structure found on line 10019 at column 34."I know the code at line 10019 (in cfscript) has no problem.When adding a new line (by enter key at anywhere before the error line) it still gives an error at line 10020,but when adding one more new line it's OK.What is the cause?I have tried several different things like:add or delete any comment or cftag it's OK.(or remove a space then OK, but adding a space then gives an error ※after a little modification)※any modifications after the error line(10019) is not efficientI use ColdFusion2018 update15, pageEncoding="SJIS".

Recently we moved from cfusion11 to 2021. While generating pdf file sometimes image breaks. Please suggest us solution if anybody face same issue and came out from that.

Using cfinclude tag throwing error and recommended to put this.mappings in application.cfc. but how to use that mapping in cfm file with cfinclude tag. Please guide if anyone face smiler issue.

I've create a excel file with CFSpreadSheet and now I want to change the color of a cell to a hexcolor that is not available with CFSpreadSheet.  Can it be done with javascript? <cfset xl = spreadsheetNew("Hazard Details",true)><cfset SpreadsheetAddRow(xl,"Test")><cfset SpreadsheetFormatCell(xl,{color="red",bold="true"},#xl.rowcount#,1)> Will set it to red.  But I want to use a color that is not available with cfspreadsheet like hexcolor #355f91something like:<cfset SpreadsheetFormatCell(xl,{color="#355f91",bold="true"},#xl.rowcount#,1)> 

We have an instance of CF2021 running on RHEL.  Our database is SQL Server 2019 running on Windows Server 2019.  We are trying to establish a database connection through the CF Admin to said database but keep getting a timeout error.  The server is not running on port 1433 (it is using another port) and has DOD and Entrust certs.  Do I need to export those certs and import them into the CF JVM to establish that "handshake"?  Or, would I be better off just running CF on Windows?  Any help is greatly appreciated.

Hi ! Dear expertsI wrote a simple program to send LINE notifications to customer groups via IFTTT.Just pass three simple URL parameters, which are as follows: <CFHTTP Url=https://maker.ifttt.com/trigger/mic0121_line/with/key/boYiM....   Method="get" Charset="utf-8" ResolveUrl="Yes">  <CFHTTPPARAM Type=“url” Name=“value1” Value='test_url_01'>  <CFHTTPPARAM Type="url" Name="value2" Value='測試參數 2' >  <CFHTTPPARAM Type="url" Name="value3" Value='測試參數3' ></CFHTTP> mic0121_line is the LINE customer group code defined in IFTTT, value1, value2, value3 are 3 URL parameters, some of which are Chinese Traditional characters (big5 code). These codes are OK on the CF2021 Update5 test on ColdFusion Fiddle.But why can't I send it properly when executed on my installed CF2021 Update5 computer. Are there any settings that need to be changed in CF2021 Adminstrator?

Recently we have seen an issues with number having 16 digits.For eg val(9999999999999399) internally getting coverted to some other number. In this case its 9999999999999400.Because of which we are facing a lot of validation issues and challenges. Is there a  way to handle such huge number in coldfusion.The other workaround is to convert it to string but wated to check with all the possibility before doing so. Thanks!

Hi I am facing an issue where in SOLR search result in some results context column is empty string. I am receiving in some but not all. I am using CF 2021.Why is this so?Kindly help

HelloSorry I think I may have asked this question in the past but now this has become a comedy of errors.Simply put, there are two tables in the same DB containing rows of individuals last names, first, DOB etc,Table 1 has 3000 recordsTable 2 has 4000 in which the above 3000 are intermingled with no other matching identity except last name.I need the query to pull out the 1000 names that were added. No success yet on several approaches. Last names are nvarchar max, SQL Server. <cfquery name="find_added_lastnames" datasource="#Request.BaseDSN#">Select lastname1from TABLE1join TABLE2on ' '+ lastname1+' ' not like '% '+ lastname2+' %'ORDER BY lastname2 ASC <cfquery name="find_added_lastnames" datasource="#Request.BaseDSN#">SELECT lastname1, lastname2FROM table1, table2WHERE lastname1 NOT LIKE '%lastname2%'ORDER BY lastname2 ASC</cfquery>  <cfquery name="find_added_lastnames" datasource="#Request.BaseDSN#">SELECT lastname1, lastname2FROM tab

We are using Coldfusion 2021 and iText 7.4When loading the license, I get the error _objectFieldValueSeparatorWithSpaces I have finally nailed it down to the fact that iText uses Jackson .jar files version 2.12 while ColdFusion uses the same .jar files version 2.8.Question... will Coldfusion work properly with jackson 2.12?

Day 2 of testing CF 2021 and I'm puzzled by what seems to be another bug.  Consider the following: <CFSet A='147.xxx.yyy.zzz'> <CFOutput> #A#---<br> Left 4: #Left(A,4)#---<br> Left 4 eq: #iif(Left(A,4) eq '147.',DE('Yes'),DE('No'))#<br> Left 4 is: #iif(Left(A,4) is '147.',DE('Yes'),DE('No'))#<br> Left 4 equal: #iif(Left(A,4) equal '147.',DE('Yes'),DE('No'))#<br> Left 4 CFIf eq: <CFIf Left(A,4) eq '147.'>Yes<CFElse>No</CFIf><br> Mid dot: #iif(Mid(A,4,1) eq '.',DE('Yes'),DE('No'))#<br> Left 3 Compare: #iif(Left(A,3) eq '147',DE('Yes'),DE('No'))#<br> First Item in List: #iif(GetToken(A,1,'.') eq '147',DE('Yes'),DE('No'))#<br> </CFOutput> This outputs the following in CF 2021 (update 4): 147.xxx.yyy.zzz--- Left 4: 147.--- Left 4 eq: No Left 4 is: No Left 4 equal: No Left 4 CFIf Compare: No Mid dot: Yes Left 3 Compare: Yes First Item in List: Yes But in CF 201

I have an app recently migrated to CF2021 from CF9. We are finally able to get FusionReactor on it to track why it has periodic slow downs and excessive memory usage.  While I am still deducing, I can see chunks of memory allocated to coldfusion.monitor.memory.MemoryTracker. Some research online attributes this class to the PMT, though we do not have PMT enabled. Is this normal? How can I turn off PMT if it is somehow running while not enabled? We have not yet installed our license so are running under Dev mode until we pass testing.    

Can Coldfusion 2016 spider a site out of the box? If not can solr that ships with CF spider a site

I am running a docker container locally and it's running very slowly.I use Windows 10 and WSL 2.I use the app folder as volume.Without volume, it's running better.I use this command: docker-compose up -d --build 

I am getting the following error when trying to connect CF2021 and Oracle 19. Please let me know if anyone has faced similar issues before.. Only complexity is that the StoredProcs are created referencing Column type. Error Executing Database Query.[Macromedia][Oracle JDBC Driver][Oracle]ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1 This code works when run form CF10 environment (Driver used SeeFusion (Oracle)However from CF2018 or CF2021 it does not work (Driver used Oracle) Below is a sample code (cfml page).I have tried with CF_SQL_NUMERIC as well instead of CF_SQL_DECIMAL <cfset arguments = StructNew() /> <cfset arguments.username = "userName" /> <cfset arguments.P_GROUP_PR_SEQ_NO = "10" /> <cfset arguments.groupName = "g" /> <cfset arguments.cboID = "17065" /> <cfset arguments.P_GROUP_MANAGER_PR_SEQ_NO = "10" /> <cfset arguments.groupIdentifier = "g" />

Hello,For a new installation, I get an error 500 with the detailed information as follow:Module: IsapiModuleNotification: ExecuteRequestHandlerhandler: cfmHandlerError Code: 0x800700c1 I checked that IISUser has permissions in c:ColdFusion2021/config and at the physical path of the directory I try to access.ColdFusion administrator works with the 8500 port. Does it means taht the error is with IIS or could it be something I have not set properly?I also checked everything suggested on the following post:https://helpx.adobe.com/ca/coldfusion/kb/troubleshoot-error-500-coldfusion.html Any suggestion on how to fix this 500 error that was not covered by the previous link?

Hi, Is there way to prevent host header attack on CF2016 (Win Server 2008 IIS7.5)? We had server scan and identified this vulnerability where X-Forwarded-Host was modified to trigger redirect to potentially malicious site.I have seen some references to adding dummy virtual hosts to apache server but, I am not skilled in server administration and not sure how to do that in CF2016. Thank you,Gena

Hello all, We recently upgraded from Coldfusion 9 to 2021.  Coldfusion 9 was using jrun as the java server, while 2021 uses Tomcat. On 9, we had a separate server running some servlets we had written, and works just fine.  I can't figure out how to duplicate this feature in 2021.   I created a separate instance, and placed the class files (after recompiling) into the classes directory, but it cannot find them.  I get a 404 error, with the message "The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.".  I did create a simple .cfm page that works fine, but cannot call the class.  Is there a document or something that could point me in the right direction?   In jrun, the main thing I had to do was add to the config was "<attribute name="url">file:<path_to_servlets></attribute>".  I don't see an equivalent in tomcat. Any hint

We have released fixes for both ColdFusion (2021 release) and ColdFusion (2018 release) that help authenticate IMAP, POP, SMTP, and Exchange connections using OAuth. For more information, see this KB document.   We've also released an update for cfexchange for both ColdFusion (2021 release) and ColdFusion (2018 release). The document also lists the steps to apply the update.   Apply these updates and let us know your feedback.