ColdFusion

Our SOLR database has records to delete that are best accessed by the CUSTOM2 field.  That field's been renamed to CUSTOM2_I and contains integer values. <cfsearch ...criteria = "custom2_i=32863"> doesn't filter any rows out.I'm hoping there's a syntax that will work. Thank youBrent 

Hello all:I am assigned to clean up or remove some unused tables in our Oracle database.  I have never done it before therefore I am not sure what is best approaching. I asked my DB administrator if we could generate the report from backend that shows the statistics of each table.  The statistics should include the date and time when it hit last time.  He said they "scan" the DB daily, so all tables get hit daily.I wonder if we can approach the task using frontend via ColdFusion.  I wonder if there is anyone out there who has done it before.Thank you very much for your timeHung Phampham_mn@yahoo.com

Hi folks,I need help to get the right group to place my problem.We had several installations of CF2016 ENTERPRISE. Now we migrate to CF2021 ENTERPRISE on new server installation. In CF2016 CFSPREADSHEETWRITE needs 10 sec. to create XLSX file with 3.000 rows and 16 columns.In CF2021 the same code needs 120 sec. to create same XLSX file. I write these problem with detailed documentation to cfinstal@adobe.com at 25th of Nov. 2021 but get no reply.This is a show stopper for go live. I need a hint where is the right place to put this problem? Would be great if anybody can help. Thx in advanced. Stay safe!

It seems after latest updates were applied to my Coldfusion 11 server my XMPP gateway stopped connecting. In my exception log I get:"coldfusion.eventgateway.im.IMGateway$IMGatewayMissingLicenseException: The JBuddy library does not appear to have a license for XMPP".It was working great before the updates.

Why am I getting this error when I've used the wsconfig within my "site-name" folder to bind my site to ColdFusion? It keeps looking for the isapi_redirect.dll inside of wsconfig\2\ instead wsconfig\1\ folder. Where do I look to make this correction?

We've applied the Log4js mitigations outlied in https://helpx.adobe.com/coldfusion/kb/log4j-vulnerability-coldfusion.html and when Update 13 for Coldfusion 13 was available we applied it. I'm now getting warning of a vulnerability for log4j core 2.9.0 installed vi a the mitigation and advised to upgrade to 2.15 or later. Any guidance on either backing out or or upgrading the mitigaation installed via https://helpx.adobe.com/coldfusion/kb/log4j-vulnerability-coldfusion.html to prevent the new vulnerabilities?

How can I check if the Windows Server running ColdFusion is using IIS or Apache? I think we are running IIS since : IIS installedChecked Task Manager and cannot see apache or httpd entries.Looked under cfroot\config\wsconfig\1 and the README file contains : This file was created by the ColdFusion Connector Installer.Do not delete this directory or the files in it because your web serverconfiguration files contain references to the files in this directory.web server: IISweb server version: 10.0IIS web site: All (0) Is this enough proof or are there more checks I can do?

Hello Community - need help badly as I am more of a infrastructure person then coder  We were in the process of setting up SSO with Azure as the identity provider - we had  it working with the simplest of code:  (basically from the Adobe help page)<cfset config = {idp = {name = "ptestidp"},sp = {name = "testsp"},relayState = "cart"}><cfset InitSAMLAuthRequest(config)> since the update I get the following -  line 11 being the call to initialize the azure call  Error Occurred: 12/20/2021 07:48:07 PM     Error Type: java.lang.NullPointerException     Error Message:     Error Detail:     Template: E:\internal\betahost.mycompany.com\pindex.cfm     Line: 11     Column: 0 

An older version of log4j file in ..\cfusion\hf-updates\hf-2018-00003-314033\backup\ was flagged as a security risk in a recent Tenable report. Is it safe to delete the backup files? Will it break the Coldfusion update history, or cause any issues with the future updates?

Adobe engineering and security have been hard at work determining which versions of ColdFusion might be affected and what, if any, workaround/mitigation steps are available.   For the mitigation steps, see Log4J vulnerability on ColdFusion. It will be updated if/as things change. This article contains information related to ColdFusion 2021, ColdFusion 2018 as well as ColdFusion 2016. There are also sections concerning the Performance Monitoring Toolset for 2021/2018 and API Manager.   We shall be releasing a patch on 12/17 for the same. In the meantime, follow the steps mentioned in the document. If you need more information, please contact us or reply in this thread.

hello all.i am at a loss...  i installed a vanilla windows 2019 server, coldfusion 2021 trial and apache 2.4.46 win64 (also vanilla).  i then run the coldfusion connector wizzard and that does what it does and says it's done afterwards.when i want to connect to a website then, i only get "Service Unavailable - The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later."i checked, also using https://helpx.adobe.com/coldfusion/kb/coldfusion-apache-manual-connector-configuration.html and basically, all seems ok:- mod_jk.conf, workers.properties and mod_jk.so is in apache/conf directory- the respective two lines are in http.conf:     Include "C:\Apache24\conf\mod_jk.conf"     Include "C:\ColdFusion2021\config\wsconfig\1\mod_jk_vhost.conf"- apache also starts and shows 'Apache/2.4.46 (Win64) OpenSSL/1.1.1h mod_jk/1.2.46' in services- but mod_jk.log in c:\ColdFusion2021\co

We updated to update 13 (from update 11). The scheduled tasks are run on a cluster with MySQL. After the update all clustered schedule tasks disappeared. When tried to disable cluster and enable by selecting datasource and try to submit changes, it shows up with the following wierd error messages. I have verified scheduled task DSN and its working.   

Bonjour,Que ce soit en français ou dans d'autres langues, les accents posent un problème.Je passe par :<!DOCTYPE html public "-//W3C//DTD HTML 4.0 Transitional//EN">mais existe-t-il une autre définition pour ne pas passer par un parser ... qui marche mal.Merci par avance Hello,Whether in French or other languages, accents are a problem.I go by :<! DOCTYPE html public "- // W3C // DTD HTML 4.0 Transitional // EN">but is there another definition not to go through a parser ... which works badly.thanks in advance

In this post about the 2021 release (https://helpx.adobe.com/coldfusion/deprecated-features.html) it is mentioned that "cfscript support for script-based CFCs, such as query and storedproc." I can't find anything that clarfies what that means. My organization has applications that use pure script based CFCs and ones that mix tags and script inside CFSCRIPT tags. What precisely is being deprecated? Thanks,

Hello All- I'm trying to configure a webservice to work over https w/o any luck. The web server has ssl installed and the server housing the webservice also has ssl installed. I configured the directory containing the webservice to require ssl, then tried to update the webservice registration in CF Admin and it failed. I am able to view the wsdl via https. I guess my question is, what is required to make a webservice run over ssl? It appears that simply requiring 128-bit encryption on the directory containing the webservice does not work. TIA, Aaron

The ColdFusion 2021 Support Matrix https://www.adobe.com/content/dam/cc/us/en/products/coldfusion/pdfs/customer-case-study/ColdFusion_Support_Matrix.pdf.pdfindicates that Oracle database support is only available in Enterprise edition, not Standard.Is that correct?Also, it says Oracle 18c and 19c.Can it be used with 12c?We're in the process of upgrading to 19c, but need CF 2021 to be used with Oracle 12c for a short while yet. Thank you.Regards,Chris. 

Hi I am brand new to Adobe CloudFusion. My supervisor has tasked me with implementing Account Lockup on our server. Can you guide me as to how to do this and if there is any scripts or coding, it would be a termendous help. I tried looking for materials in Google and Youtube, but there is no beginner guide to do so, to my knowledge. Thank you in advance.

I just installed the developer edition of Coldfusion 2018 and I navigate to the administrator http://servername:8500/CFIDE/administrator/index.cfm, I log in and it goes to the administrator page and the entire page is disabled, I can't do anything, search or and of the icons are all disabled.  Any ideas?

I have CF 2018 Enterprise, and was trying to update from v4 to v11. I have IIS running on a web server (different machine) and CF running on another machine (app server) (I think this is called "Distributed Mode"). v4 everything works as it should, but when I upgrade to v11, I see the following errors in isapi_redirect.txt file (I run wsconfig.ext on the webserver to establish the connection between the web server (IIS) and app server (CF). Here are the errors I am seeing in the isapi_redirect.txt[Sat Aug 21 10:55:10.690 2021] [5916:5976] [info] jk_open_socket::jk_connect.c (816): connect to [CF App server IP address]:8018 failed (errno=61)[Sat Aug 21 10:55:10.690 2021] [5916:5976] [info] ajp_connect_to_endpoint::jk_ajp_common.c (1140): (cfusion) Failed opening socket to ([CF App server IP address]:8018) (errno=61)[Sat Aug 21 10:55:10.690 2021] [5916:5976] [error] ajp_send_request::jk_ajp_common.c (1811): (cfusion) connecting to backend failed. Tomcat is probably not started or is list

Silly question that I can't quite figure out: I want to schedule a task via the CFAdmin panel to run a .cfm script every 30 seconds starting at 10pm and ending a 8:59am the following morning.Right now, I am unable to figure out how to do this as one task.  Instead, I've had to set up a "daily" task that runs every 30 seconds starting at 10pm (with no end  specified), and then a second task (that runs the same .cfm script) that starts at 12am and ends at 9am. Is there a way to do this as a single task instead of the two?  It's not a huge deal, just trying to see if there an obvious way to do that my brain is not seeing at the moment. Thanks!

The "no ColdFusion update without issues"-streak continues ... It's year 10 now, I guess. Ok, so I logged into CFIDE/adminstrator and hit the "Download" button below the Core Server Update 2 Logs say:Sep 22, 2021 12:05:49 PM Information [http-nio-8500-exec-5] - Starting HTTP request {URL='https://www.adobe.com/go/coldfusion-updates', method='get'} Sep 22, 2021 12:05:49 PM Information [http-nio-8500-exec-7] - Starting HTTP request {URL='https://www.adobe.com/go/coldfusion-updates', method='get'} Sep 22, 2021 12:05:49 PM Information [http-nio-8500-exec-7] - HTTP request completed {Status Code=200 ,Time taken=363 ms} Sep 22, 2021 12:05:49 PM Information [http-nio-8500-exec-5] - HTTP request completed {Status Code=200 ,Time taken=414 ms} ... but the progress bar just shows "Starting Download..." and is stuck. Manually installing the update worked, but lost some packages on the way (adminapi, administrator, ...) AND although the system information page (top right, "i")

My first post! 🙂 I am currently doing a search of a list of data elements (like 15) from a specific table.  The goal is to see if they are being UPDATEd or INSERTed in any of the existing ColdFusion sources we have.  The site is HUGE and I am using DREAMWEAVER's FIND & REPLACE search too to look into from the root folder down, then I check the "matched text" results and in doubt, I open the source to double check if the field is in an UPDATE or INSERT statement. So, I was wondering if there is a way to build a TABLE-WHERE-USED or FIELD-WHERE-USED approach that can be used as a reference, in order to speed up database analysis like this.  Any suggestions are welcomed.Thank you!

I have updated an installation of CF2018 from U4 to U8, and then to U12.  I did upgrade the web connectors after upgrading to U8, and then upgraded to U12.  All of these steps completed with no errors, and my site is now up, and I am able to use CFAdmin.  I also confirmed that the secret introduced in U8 matchs in server.xml and workers.properties. In CFAdmin, when I check the Information page, to verify the current version, I see that CF is at U8 (2018.0.08.328566), and not U12.  If I go Server Updates, no updates are available.  If I check the CF Updates folder, I see that there is information for the U12 update.  As part of this update, I also updated to Java 11.0.12 (I will update to 11.0.13 at a later date). At this point, I need some guidance.  Do I manually uninstall U12, even though CFAdmin thinks that I am at U8?  Or, do I manually re-install U12 without uninstalling it first?  Or, is there a different way to on how to add

HelloEach person in this DB has their unique ID (ged_ID), and a spouse ID (ged_spouse_ID).Also ged_lastname, ged_firstnameI'm having trouble with the SQL query structure to output:Person First, Last, - Spouse First, Last names on a single row.Would this be set up as a single query, qoqs, or SQL Joins "WHERE IN" etc.?Sorry if this is staring me in face- probably is...Norman B.

We have an application that uses CFLDAP, port 636 to authenticate user to Active Directory. We are getting the following error: An error has occurred while trying to execute query :xxx.yyy.zzzz:636.The server is running CF2021 Enterprise, on a Windows 2016 serverI can get it to work randomly rebooting the server or starting/stopping the CF Application service. It might start working on the second, third, fourth reboot, etc. Once it is working it is fine until monthly patch reboots and the failure process starts all over again. We do have a CF2018 server also on Windows 2016 server and do not have the issue.Here is what I have tried, all with no long-term luck in fixing the issue:Reinstalled Windows and a fresh copy of CF2021Tried different OpenJDK versions (all ver 11.x)Tried importing our domain and server certs into the cacert in the JRE folderTried a completely different CF2021 server – same issueThe error output is not very helpful.No entries in Windows, Apache or CF logs when the