ColdFusion

Hi all.I recently had a problem with reports created with CFR when I try to open them in Excel with Coldfusion 2018, it has an error"Invalid cell range, having lastRow  firstRow lastCol  firstCol, had rows 12  38 or cells 13 38 null "or "Cannot add merged region B2 E2 to sheet because it overlaps with an existing merged region A1E2 nullThe error occurred on line 1. " apparently there are problems with lines that have overlapping cells this did not happen in CF 2011- 2016 I would like to know if someone has had the same error or if this problem has been corrected in some way.  

Hi all. Help would be very appreciated... I have a requirement to accept a POST parameter that is encrypted using DESede/ECB/PKCS5Padding, and decrypt that param for use in my application.  In attempting to test out this encryption and decryption, the following code was found to work successfully:<cfset theKey = generateSecretKey('DESEDE')> <cfset varString = "Testing"> <cfset encrypted=encrypt(varString, theKey, 'DESEDE','Base64')> <cfset decrypted=decrypt(encrypted, theKey, 'DESEDE','Base64')> <cfdump var="#decrypted#"> Our issue is that in the test above the key value produced appears to be plain text, but the key that we are receiving from our data sender is in a .key file, and which seems to contain binary data. Can anyone tell me how a .key file might be used to decrypt a desede encrypted file?

Hi, So I went to https://www.adobe.com/products/coldfusion/download-trial/try.htmlI downloaded the Linux version of it. It downloaded a file called ColdFusion_2018_APIManager_WWEJ_linux64.binthen I ran ./[downloaded_installer_name].binThis installed stuff in my /opt/coldfusionaddonservices  There I have  Adobe_ColdFusion_2021_Add-on_Services_Install_04_29_2021_19_01_02.log*cf_app.ico*cfjetty*etc/exampleAnalysis/example-DIH/exampledocs/jre/lib/logs/modules/notice.txt*resources/solr/start.ini*start.jar*webapps/work/  1. Did I installed it correctly?2. How Do I start it now?

Attempting to setup our Oracle datasource in CFIDE and keep getting this error:Seed passed for encryption in null.The error occurred in oracle.cfm: line 99Called from oracle.cfm: line 70Called from oracle.cfm: line 1-1 : Unable to display error's location in a CFML template. java.lang.RuntimeException: Seed passed for encryption in null.at coldfusion.util.PasswordUtils.encryptPassword(PasswordUtils.java:506)at coldfusion.sql.Executive.encryptPassword(Executive.java:465)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)at java.base/java.lang.reflect.Method.invoke(Unknown Source)at coldfusion.runtime.StructBean.invoke(StructBean.java:509)at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4368)at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4220)at cforacle2ecfm1478693949._factor

I have installed ColdFusion 2021 on a test server and am working through my web apps to find any issues. I discovered that whenever I try to instantiate a .NET class using cfobject, I receive an error. I have tried uninstalling and reinstalling the dotnet package, but that has not resolved the issue. All CF packages are installed and the "ColdFusion 2021 .NET Service" is running. Here is test code that works fine on my CF2016 servers, but fails on CF2021:<cfobject type=".NET" class= "System.IO.Directory" name="fso"> <cfset cwd = fso.getCurrentDirectory()> <cfdump var = "#fso#"><cfdump var = "#cwd#">Here is the error message I receive:DotNetExtension not installed. If a dll is specified in the assembly list, DotNetExtension must also be installed. Also of note, nothing is being created in the wwwroot\WEB-INF\cfclasses\dotNetProxy folder on the new server like it is on the old server. Folder rights on that dotNetProxy folder appear to be the same between

I have been trying all day to get RDS working, so that I can run the Security Analyzer.I've gotten over several hurdles (CFIDE was blocked, IIS wouldn't handle requests for files that don't exist, a few other things, all resulting in 404 errors). So now that I'm not getting a 404, I feel like I must be close.  But I don't know what's wrong.All I get when testing the connection is 'The HTTP request to talk to your server returned with the following message: For input string: "" 'I am using an SSL connection, but when I enable regular HTTP traffic, and don't use SSL, I get the exact same thing, so I'm fairly sure it doesn't matter.

I have ColdFusion 11 U4 running as a Amazon EC2 instance from Adobe's Windows AMI.I am trying to connect via ColdFusion Builder 3 (mine) and ColdFusion Studio (client's). At first I got the dreaded 404 error, so I added in /CFIDE/main/ide.cfm as an empty file so IIS would find it.Now the error has changed to: 'Unable to contact the RDS Server... For input string: ""' in CF Builder.In ColdFusion Studio the error was "server operation failure". After debugging was turned off it changed to "unhandled error, use logging enabled clients if possible."I had HTTP filter restrictions in place for CFIDE directory stuff, but removed all that, no change. I have also tried all three options for user authentication for RDS.I also tried it on my local machine but after I resolved the 404 error I get a 405 error for method not allowed. So that's no help either.Here's the settings:Description: {client name}Host name: {IP Address}Port Number: 80Timeout: 30sContext Root: emptyUser Name: {user name}Passwo

I am getting the following messages after applying cf 2016 update 17:Invalid attribute value cf_sql_int for attribute CFSQLType  any ideas?

Currently my cfhttp process works for the API I am calling on CF10 Enterprise version running on Windows Server 2008R2 but, on my CF2018 editon it will run once (sometimes) and then fail every call after that. I applied update 10 when I first noticed the issue to see if that may help but it did not and I recently applied Update 11 with same results. I am running ColdFusion 2018 Enterprise Version: 2018.0.11.326016 on Windows Server 2016 Standard. I then did as BKBK recommended in another post and installed latest Java from http://adobe.com/support/coldfusion/downloads.html which was 11.0.10 and pointed my jvm.config to the new Java home directory. When I dump out value for the version using <cfdump var="#server.system.properties.java.version#"> just to make sure, it does indeed show "11.0.10+8-LTS-162" is being used. I restarted both the server and ColdFusion service and still get this issue: Another thing I tried was importing the SSL cert

How can I set the "com.sun.jndi.ldap.read.timeout" value, or otherwise get a CFLDAP call to properly timeout. I have an Active Directory (AD) server that I'm making CFLDAP calls to.   Randomly the calls will hang for approximately 900 seconds.  The AD server admins say they don't see any issues on their end, but the 900 seconds does correspond to a default MaxConnIdleTime setting on the AD server.   In FusionReactor it will show that it's stuck on "java.net.SocketInputStream.socketRead0" This page matches with the issue I'm seeing:  java.net.socketinputstream.socketread0 Problem patterns  According to the various pages I've found on this issue I need to set the "com.sun.jndi.ldap.read.timeout" value.   I've tried setting this in the jvm.config, but I found web pages that say you can't set it there.  That it needs to be set in the jndi.properties file.  All of the web pages I find for ColdFusion and jndi.properties ar

Great news for CFML developers!   Adobe ColdFusion Developer Week 2021 is edging closer! This year, we’ve lined up a series of sessions and webinars that will give you a 360-degree view of ColdFusion 2021’s brand new features and updates. Right from developing cloud-native applications to reducing downtime, these webinars will let you in on the best tips to deploy applications rapidly and seamlessly.   This is your chance to meet coders from across the globe and exchange ideas with some of the best minds in the industry. And that’s not all! Your presence at the conference will earn you points that can help you win exciting prizes and vouchers. Our scoreboard will keep track of active participation!   When: 22-24 June, 2021 Register today!

Using the GET HTTP method, Nessus found that the following resources may be vulnerable to blind SQL injection :The 'method' parameter of the /CFIDE/componentutils/cfcexplorer.cfc CGI : Input: /CFIDE/componentutils/cfcexplorer.cfc?path=%2fCFIDE%2fappdeployment%2fID atasourcesEventsHandler.cfc&name=CFIDE.appdeployment.IDatasourcesEventsH andler&method=getcfcinhtml'||'%2fCFIDE%2fappdeployment%2fIDatasourcesEve ntsHandler.cfc&name=CFIDE.appdeployment.IDatasourcesEventsHandler&method =getcfcinhtml-------- output -------- HTTP/1.1 200 OK -------- vs -------- HTTP/1.1 400 Bad Request ------------------------" Is this vulnerabilty exists or it is a false positive?

Hi,While using CFINDEX to index the content of files with SOLR, I keep occasionally get this excpetion when indexing PDFs:coldfusion.pdf.PDFDocException: PDFDoc Exception <p/> Created on Sep 12, 2006. I am not getting any other indication of what is actually causing the exception and I can not yet find a pattern in the PDFs that this is happening with.  It is not all PDFs or even most - it only occurs occasionaly. Any ideas?  We are currently on:Server ProductColdFusionVersion2016,0,13,316217EditionEnterprise  Operating SystemUNIX Thanks for any help.

I've installed the CF 2021 developer edition on my machine which uses apache tomcat.  I then followed the guide below under the "Configure IIS for ColdFusion in Windows" section:https://helpx.adobe.com/coldfusion/user-guide.html/coldfusion/installing/configuring-your-system.ug.html  My site now appears to be using IIS.  I can browse to it under localhost and access cfm pages under my CF installation directory.  If I stop the IIS site, then my site is no longer available.  My question is where can I place a web.config file to make configuration changes to the site or is this even possible?  Putting a web.config file in the IIS wwwroot or the CF installation wwwroot seems to do nothing to the configuration.  For example I tried to restrict access to anonymous users in this web.config file and all users still had access.  If I restrict anonymous users in IIS management console, then it does work. 

Hello,I installed CF2018 on Win2016 server and moved my code into it from CF9. Now I am receiving errors that I did not receive in CF9.09:15:16.016 - Object Exception - in D:/Application.cfc : line 249 The getMetaData method was not found.09:15:16.016 - Application Exception - in D:/Application.cfc : line 249 An exception occurred while calling the function getMetaData.The line 249 refers to the <cfdump> tag in the following function in Application.cfm<cffunction name="onError" returnType="void" output="false"><cfargument name="exception" required="true"><cfargument name="eventname" type="string" required="true">        <cfset var errortext = "">            <cfif isDefined("arguments.exception.rootCause") AND arguments.exception.rootCause IS "coldfusion.runtime.AbortException">            <cfreturn/> &

I've created a rest API in ColdFusion 2016.  The first time a request is made to the API in the morning will generate an error:Application (myapp) could not be found. The specific sequence of files included or processed is: ''All subsequent requests to the API go through without errors after that.  Any idea why I am getting this error?

It would be great if smb from CFdev team can help find us how to add to debuggin EVENTs - some information. instead of phrase"COMLEX VALUE" -to show a dump of the argument( at least for structure and arrays) 

I received a nonfatal error when I tried to install either Adobe ColdFusion 2016 or ColdFusion 2021 on a Windows 10 computer.  The following is from the log file:Install File: C:\CF\runtime\manager\WEB-INF\jsp\401.jspStatus: ERRORAdditional Notes: ERROR - Flexeraak7: C:\CF\runtime\manager\WEB-INF\jsp\401.jsp (Access is denied)I have tried installing(as admin) several times, but I always get the same result. Any assistance would be appreciated.

I am installing 2018 on a new server and the installation choice is "Server configuration" and "JEE configuration". Server configuration is described as an embedded JEE server and JEE, I am assuming, is for an existing Tomcat installation.What I want is to duplicate the configuration of the old server and use IIS for web services. Did I miss a step somewhere or is there something I am not getting? TIA,Gary  

I am trying to create my first event gateway.  For now, I just want to log when a file is put into a specified directory.  It seems it should be simple, but I keep getting an error in the eventgateway log:Error","Thread-339","04/20/21","17:11:33","","Error invoking CFC for gateway videowatcher: Could not find the ColdFusion component or interface image. {GATEWAYTYPE={FileWatcher},CFCMETHOD={onAdd},DATA={{LASTMODIFIED={Tue Apr 20 17:11:24 CDT 2021},FILENAME={C:\home\safetyforward.com\wwwroot\safety\present\connectionsCameraTesting\uploads\drop98.webm},TYPE={ADD}}},GATEWAYID={videowatcher},ORIGINATORID={},CFCPATH={C:/ColdFusion2021/cfusion/gateway/cfc/examples/videowatcher.cfc}}. Ensure that the name is correct and that the component or interface exists." My gateway name is videowatcher.  When i put a file in the directory I'm watching the gateway is firing, but it can't seem to find the videowatcher.cfc.  This despite when I create the event watcher in CF Admin

Just recently, I am getting the following error on a CFDUMP command.  I have a routine that runs every hour and 95% of the time, it works perfectly fine.  Every once in a while I'll get this error.  Would love to hear any thoughts as to how to possibly tackle this mysterious error! COLUMN0LINE-1RAW_TRACEjava.security.AccessControlException: access denied ("java.io.FilePermission" "C:\ColdFusion11\cfusion\wwwroot\CFIDE" "read")TEMPLATE"java.io.FilePermission" "CTYPECFML

I've migrated the app and only one endpoint is having an issue. Java server does a form post to it. Every time I get this error. It looks like its failing where it validates data being passed in so my try catch inside the endpoint isn't catching it. The @FormParam is utilized when the content type of the request entity is not application/x-www-form-urlencoded The specific sequence of files included or processed is: d:\xx\xx.cfcjava.lang.IllegalStateException: The @FormParam is utilized when the content type of the request entity is not application/x-www-form-urlencodedat org.glassfish.jersey.server.internal.inject.FormParamValueFactoryProvider$FormParamValueFactory.ensureValidRequest(FormParamValueFactoryProvider.java:176)at org.glassfish.jersey.server.internal.inject.FormParamValueFactoryProvider$FormParamValueFactory.getForm(FormParamValueFactoryProvider.java:160)at org.glassfish.jersey.server.internal.inject.FormParamValueFactoryProvider$FormParamValueFactory.provide(FormParamV

I have an application inside an Iframe, in the first CFM page, I set a session variable, when I go to the next page in the Iframe, the session variable have disappeared. It seems that session variables are not working inside an Iframe ? Thansk for any comment. Pierre.

Started seeing some weird message today in my CF18 environment. The message is "The @FormParam is utilized when the content type of the request entity is not application/x-www-form-urlencoded" when calling a CF REST service in a cfc file. This has worked as recent as a week ago so not sure why it would be an issue now. Has anyone expereicned this before? The call we make to the REST service is shown below. I am thinking it is related to tthe headers but not sure if that value should be something different. $http({method: 'POST',url: strServiceUrl + 'admin/create/' + $scope.selectedRecall.id + '/retailblock/remove',headers: {'Content-Type': 'application/x-www-form-urlencoded'} Thanks.

I ran into a problem when applying the 11th update for CF2018 as the drive ran out of space, which corrupted the files and ended up having to uninstall and re-install on a separate drive in order to resolve the issue; however, now I am dealing with an odd quirk in that when a form with multiple checkboxes or multiple selections from a select lists is submitted -- I receive the variable as an array rather than a list, which causes issues when I attempt to pass that variable into a query via cfqueryparam.Is there an option that can be adjusted to control this behavior?   My code has not changed and now gives an error about a complex type.   I would prefer to have the items submitted as a list or string, as otherwise, I have to go into my code in all these places to test if it's an array and then call ArrayTolist, which was never needed before the reinstall.