ColdFusion

Hi,We are currently migrating an old CF10 server to CF2018; theres been very few problems.  A lot of the pages have the ability to export their views to xls.  When the system gets to the SpreadSheetWrite() call, a java runtime reflection exception is thrown:java.lang.reflect.InvocationTargetException It seems like java is throwing the error in such a way that CF isnt able to resume so my catch never gets triggered, so I cant get any additional information.  Haven't been able to figure out a way to catch and unwind the java error and the CF logs don't seem to have anything in them.I've tried the traditional CF catch "any" and I've tried catching "java.lang.Exception", but processing seems to end the moment SpreadSheetWrite() is called. I've also dumped the spreadsheet object prior to the write call, it appears to be properly formed in memory. I tried the same function on multiple sites within the server, they are all exhibiting the same behavior. Does anyon

How long should it take to install the lockdown tool? I have 4 websites in IIS and it has been stuck at 100% for an hour. Installing… Change permissions of IIS website: The log stopped populating and the cpu under task manger is at zero.

Hi,We have migrated from Coldfusion 10 to 2018. In the windows services I see Coldfusion 10 services and Coldfuision 2018 services running. When I stop the CF 10 services and just run the CF 2018 services the coldfusion administrator url does not work. When I run the CF 10 services the CF administration works. Do I need to run the CF 10 services? How do I make the CF administration work? Thanks.        

Hello all, QQ, with each CF Hotfix, there is also the PM hotfix.jar file that is bundled.  I see the date modified on the bundled hotfix.jar falls in date/time range for the update.  For example in hotfix 8, the PMT-hotfix\hotfix.jar has a modified date of 3/13/2020.  However, when I run the jar, the wizard notes its for PMT Update 1.   Thus, what is up and should the PMT hotfix be run as well?  If not, perhaps it should not be bundled with the CF HF 8? please advise. Bill

I just saw that CF11 is being unsupported at the end of this month.  Two tags that I see I need to replace with going to CF2018 are cftree and cfmenu.  Can someone point me to where I can find replacements for these?  thanks,Ronnie

In the installation documentation there is reference to installing CF on Unix (Other) by using ColdFusion_2018_WWEJ_java.jar but I can't seem to find that installer file.

I am helping a client update their existing ColdFusion 8 server environment to ColdFusion 2018. They currently run many (hundreds) of websites through a single instance of ColdFusion 8 Standard Edition on Windows Server. Is this model still supported by ColdFusion 2018 Standard Edition, or does this require an Enterprise Edition license to do so? Aside from all of the obvious changes to code required to make the upgrade (there will be a development and staging environment setup to test everything before the new servers go live), the client is worried that the license for Standard Edition may not cover their specific use case any longer. Can someone shed some light? I cannot find the answer here nor through the official license documentation. Perhaps I'm misinterpreting it, but it doesn't appear to touch on this specific use case.

Having issues with 2016 Update 14. I am not sure if it has something to do with the ISAPI redirect. I know in the past updates we had issues with accessing the ColdFusion Administrator using their connector port using ISS.

Resources:• Check the ColdFusion documentation to verify that you are using the correct syntax.• Search the Knowledge Base to find a solution to your problem.Browser Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36 Edg/80.0.361.66Remote Address XXX.XXX.XXX.XXXReferrerDate/Time 20-Mar-20 12:56 PMStack Traceat cfscrImportEMail_Orders2ecfm1689115925._factor46(C:/inetpub/wwwroot/ScheduledTasks/Example_Company/scrImportEMail_Orders.cfm:162) at cfscrImportEMail_Orders2ecfm1689115925._factor48(C:/inetpub/wwwroot/ScheduledTasks/Example_Company/scrImportEMail_Orders.cfm:2) at cfscrImportEMail_Orders2ecfm1689115925.runPage(C:/inetpub/wwwroot/ScheduledTasks/Example_Company/scrImportEMail_Orders.cfm:1)coldfusion.exchange.webservice.EWSException: Could not connect to the exchange server with the credentials.at coldfusion.exchange.webservice.EWSConnection.login(EWSConnection.java:1799)at coldfusion.tagext.net.exchange.ExchangeTag.cre

We are trying to install coldfusion11 on a new server.We have updated the correct values for datasources in CF admin page , but the neodatasource.xml is not getting updated. Could you please suggest the path forward here?

Hi, I logged in to CF admin with my username and was able to create the DSN using admin account and password.  However, I need to login as admin to grant access for other user and can't use that same admin account.  What should I do? Thanks

Since Coldfusion version 3, I work with Access datasources for information systems built with CF.Access datasource does still work with Coldfusion version 11.Then , with Coldfusion version 16,after days ans days of trials, CF16 cannot create Access datasource anymore !So , will next version of Coldfusion will be back with this historical functionnality ?All my work is based on this.Stays with CF11 for the moment.Thanks for any comment.I have never seen a new software version abandonning an historical and great functionnality.Pierre.

Hello,   We are using Oracle 12c and ColdFusion 2018.     I am trying to make the index.cfm page the default page instead of default.cfm page as default and this is not working on our Dev server, it worked correctly on our test server, both Dev and test are on Windows 2019 servers. ThanksIQ

All, I've been tasked to create a simple SMS system that we can use in office to keep in real-time contact with those working from home.  Any ideas/suggestions? I don't think we need/want anything that would require maintaining a connection.  Heck, the boss even suggested using polling to update communications (although I kind of balk at that idea.)  Although if maintaining a connection (having a state vs stateless) is easier/better, I'd be all about it. V/r, ^  _ ^

Hello, Is it possible to migrate or import a CF site built in CF 8 directly into CF 2018. I have limited experience with CF and need some guidence. I have installed yeh trial version of CF 2018 and need to make sure I will have the same functionality with the site on the new platform. I have been attempting this but have not had sucess. My trial has 19 days left. Is there a possible extension for this trial so I can test further? Thank you, Robert

Hello,    I have installed ColdFusion 2018 Enterprise edition on Windows 2019 server.I have configured the ColdFusion Admin for server settings successfully and also installed an application which is running successfully on our Windows 2016 server, however on this new server I am not able to run the application , I get an error , Please let me know how to fix this error. ThanksIQ "HTTP Error 500.0 - Internal Server Error The page cannot be displayed because an internal server error has occurred.Most likely causes:IIS received the request; however, an internal error occurred during the processing of the request. The root cause of this error depends on which module handles the request and what was happening in the worker process when this error occurred.IIS was not able to access the web.config file for the Web site or application. This can occur if the NTFS permissions are set incorrectly.IIS was not able to process configuration for the Web site or application.The a

I am trying to connect to azure-mysql-db from non-azure vm but getting below error - - It's being allowed through firewall, I checked the logs but refusing by database. Error -Connection verification failed for data source: mydatasourcejava.sql.SQLException: Access denied for user 'mydatasource'@'12.11.156.5' (using password: YES)The root cause was that: java.sql.SQLException: Access denied for user 'mydatasource'@'12.11.156.5' (using password: YES). Can anyone please help me with this.

In my application, I am getting an error saying "The type for attribute format of tag document could not be determined". This is happening during PDF generation using cfdocument tag. Note that we are working with PDF files in Memory (ie , we are using the coldfusion option to write a PDF file to a variable by using the name attribute). Attaching the stack trace here. 

I just installed Coldfusion 2018 standard on a new Windows Server 2016 VM.  The installer I used has Update 2 pre-installed, and I'm trying to upgrade to Update 7.  From what the documentation states, I need to apply Update 4, and then 5,6,7 separately.  However, I'm having 2 issues: One: the interface in CFAdmin doesn't actually have the download links available for anything (it appears to be hidden in an accordian box).  Since I'm running this on a server, I don't really want to install other browsers to find one which renders this correctly. Two: after giving up on installing via the admin console, when I try to download apply Update 4 manually via the jar file, it fails with a message saying "some errors occurred during the install".  It points me to an installation log that doesn't seem to indicate any errors.  I also tried to manually install Update 3 with the same results. Any direction would be appreciated!

I am looking/investigating some error we've been having with a CF app. And looking at Application.log, it is not listing the full URL being process when the error occurs. I would like to change this behavior but I do not know how to do this? Can you please help? Example of an entry in Application.log------"Error","ajp-nio-8016-exec-2","03/13/20","15:02:40","","File not found: /testapp/index.cfm The specific sequence of files included or processed is: /opt/www/apps/testapp/index.cfm'' "----Thanks

Hello, I have got the source code for a webapplication written using CFML. In the current production environment, this is uing bluedragon engine and IIS as webserver.  The legacy server has windows 2008 server and IIS 6. Can you please help in setting this up in windows 7/10 with latest versions of IIS. 

when I am fetching the date from the database it's showing one date before.for example - if date in the database is - 2020-02-26then when i fetch to my coldfusion using select date from db it shows - 2020-02-25. I checked for the now() which is showing correct.- showing accurate now date and time. issue is only when i am fetching it from the database. 

Just upgrade from ColdFusion 9 to ColdFusion 2018. A sybase stored procedure ran successfully in ColdFusion 9, but get error in ColdFusion 2018. The code to call the stored procedure <cfstoredproc procedure="sp_cm_set_project_details" datasource="#APPL_DATA#"><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ref_proj_exist" value="#ref_proj_exist#"><cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" dbvarname="@ref_proj_id" value="#ref_proj_id#"><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ref_proj_name" value="#trim(ref_proj_name)#"><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ref_proj_location" value="#trim(ref_proj_location)#"><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ref_proj_city" value="#trim(ref_proj_city)#"><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ref_proj_prov" value="#trim(ref_proj_prov)#"><cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC"

I am looking for an existing tool, resource, program, etc. to display the results of nightly tasks.  I want to make this available for employees outside of the IT sphere, to make it easy to see that tasks have or haven't run. An ability to retain and display historical ST data would also be beneficial.Thanks.

Need to switch to LDAPS (LDAP over SSL) before Microsoft turn off LDAP in January 2020 - but cannot get it to work.Created certificate on Cold Fusion server (checked is using ldp.exe).Exported it to a Base64-encoded X.509 format xxx.cer certificate file.Added it to the cacerts file using keytool, this being under the JVM listed in the Cold Fusion Admin page (and checked contents using -v option).Amended the existing cfldap tag to include port="636"  and secure="CFSSL_BASIC"Ran test - and it failed with :An error has occurred while trying to executequery :simple bind failed: xxxx.xxxx:636.  One or more of the required attributes may be missing or incorrect or you do not havepermissions to execute this operation on the server. Has anyone any ideas to fix it?