This is a bug. We had the same issue and raised it with Adobe.   Seems SNS doesnt work at all out of the box.   https://tracker.adobe.com/#/view/CF-4211954   ... View more

This all depends on the code base. We migrated pretty seamlessly, but then we did not use a lot of things that were deprecated in later versions.   You will need to move to 2018. The easiest way is just get the trial / dev edition and run things on it and see where it falls down.    The CF Admin has a code analyzer  to check your code for potential issues. Its a good start but you would still want to test it all. ... View more

What version of CF are you using? There was a similar bug to this that I submitted and Adobe fixed. ... View more

If you are able to reproduce then I would recommend adding a bug report:   https://tracker.adobe.com/   ... View more

This version of Java will be too old.   I believe TLS 1.2 is supported in 1.8 and above. You will also CF 11 HF 3 or higher.   You could try setting -Dhttps.protocols=TLSv1.2 in the JVM config first before updatign to see if it works. ... View more

As you have to base64 the credentials as well, you may need to remove the username and password attributes and use the following cfhttpparam:   <cfhttpparam type="header" name="Authorization" value="Basic #ToBase64("username@domain.com:myPassword")#" /> ... View more

It would still be good to see what you have as a starting point.   I assume you are asking how to do it otherwise?   There are various examples here:   https://stackoverflow.com/questions/8932973/how-to-post-json-data-to-remote-api-using-coldfusion-cfhttp   <cfset stFields = { "report": "report_name", "columns": [ "column_one", "column_two" ], "filters": [ { "column": "column_two", "operator": "=", "threshold": 5 } ] }> <cfhttp url="http://api.url.com" username="myuser" password="mypass" method="post" result="httpResp" timeout="60"> <cfhttpparam type="header" name="Content-Type" value="application/json" /> <cfhttpparam type="body" value="#serializeJSON(stFields)#"> </cfhttp>   ... View more

Another one for the carehart.org bookmarks folder!   Forever anonymous I am, but if CF Summit ever comes to the UK,  I will buy you a beer 😉 ... View more

Hi Charlie,   Thanks for the response. Appreciate the long post as well, i'm sure it will go a long way for others too.   Had already been through most of what you suggested but the CFConfig tool is not one I was aware of and it looks like a good starting point! ... View more

Thanks for the vote and the idea.   This mainly affects us on S3 transfers though. We do very few local transfers, I just included these as part of the testing for the issue.   Could be that a third party option for S3 will be required. Which is a pain as we need to change a load of stuff!     ... View more

For reference, submitted a bug - https://tracker.adobe.com/#/view/CF-4206264     ... View more

Thanks for the reply Charlie.   I should have mentioned that I did check the secure profile side of things. I have done a comparison of all the setttings too (those that exist in both)   There seems to be no difference, although that is why I wanted to ask here first in case there could be a specific setting that may cause an issue with CFFile.    I even backed up the settings from CF11 and restored on CF2018 (car file) to see if any difference was made there.     ... View more

Are the two datasources on the same SQL instance? If so its possible just doing a normal query.   SELECT table.field1, table.field2, table.field3, databasename.dbo.tablename.field1 AS otherField1 FROM table LEFT OUTER JOIN databasename.dbo.tablename ON databasename.dbo.tablename.field1 = table.field WHERE table.field1 = 1     ... View more

See https://community.adobe.com/t5/ColdFusion/Reading-Current-SSL-Client-Certificate-Data/td-p/2498615 ... View more

I think it checks the type you have put in and then passes the type through. If no type is supplied or the type is not a correct one, it just defaults to a string check (i.e. varchar) - in this case it would work as that is what the field is. The documentation tells you the order of the validation - For these types, a data value can be converted to a numeric value: CF_SQL_SMALLINT, CF_SQL_INTEGER, CF_SQL_REAL, CF_SQL_FLOAT, CF_SQL_DOUBLE, CF_SQL_TINYINT, CF_SQL_MONEY, CF_SQL_MONEY4, CF_SQL_DECIMAL, CF_SQL_NUMERIC, and CF_SQL_BIGINT For these types, a data value can be converted to a date supported by the target data source: CF_SQL_DATE, CF_SQL_TIME, CF_SQL_TIMESTAMP For all other types, if the maxLength attribute is used, a data value cannot exceed the maximum length specified. ColdFusion debug output shows the bind variables as question marks and lists the values beneath the query, in order of usage. The code you used is probably the equivalent of excluding the cfsqltype attribute. Although it works, its technically incorrect as its an invalid type ... View more

What are you trying to do with the rules? What rules are you using? Without more information, its hard to say what the issue is. I have had no issues with outbound rewrite rules so its likely an issue with your rule or IIS setup. What version of IIS and CF? Have you looked at any logs or tried Failed Request Tracing? ... View more

Have you re run the Web Configuration Tool? This catches people out when they set the server up, run the tool and then add a new site in IIS later on. This new site does not automatically get covered. You need to run the tool after you add each new site. You can either run the tool and remove the existing connector and re add it a for all sites are just add a the new site specifically. ... View more

What port are you running it over? This just sounds like a classic case of firewall blocking the port. Allow the port on the firewall on the server and it will probably work. ... View more

There will be potentially a lot to consider but it depends on the complexity of the code. You can get the trial of 2016 and run the code analysis in the CF Admin. Although not perfect, it will give you a start on what might have been depreciated. The only real way will be to migrate in development and test it fully in the newer version. There isn't an upgrade path either for 9 to 2016 I don't think - You just have to buy the license for 2016 and install it separately. It uses Tomcat now instead of JRun so a lot in the underlying engine is different ... View more

Change the CF admin to a really low value i.e. 5 minutes and set your sessionTimeout to 10 minutes and then see it does as you expect. I assume you have a development server you can do this on! ... View more

This means that someone has removed the datasource from the SQL server. Whatever #Attributes.DATASOURCE# is equal to is either incorrect or the database on the server has been removed or rename. You will first need to check the value of #Attributes.DATASOURCE# and if that is correct ask whoever runs the SQL server to check the database still exists ... View more

It most likely due to the length of time it takes the data in the cfdiv to be generated. The second one must be quicker. There is no real way of getting around this. Javascript can help, but you will need to move away from cfdiv. Coldfusion generated UI elements are generally discouraged because of their issues. I would recommend migrating it to standard html divs and then use javascript / jquery to control the div if the same issue still occurs. Its less likely to happen if you dont use cfdiv though due to the way the DOM loads. ... View more

You might not get much help here as this is not a Coldfusion issue.   However, if you are using load balancers then you will need to make sure something like Sticky Sessions is enabled so that the user tends to resume the same session each time. Realistically though for uploading files you need a central storage that each web server can access (DFS Share etc) so that no matter which server you upload to, the file is accessible.   If you wanted to go further you could even use the Coldfusion Clustering (Enterprise) but this relates to sessions etc only, not to the file uploading. ... View more

Typically not but you never know. I did see a similar issue on a CF 11 server recently after updating to the latest hotfix, the JVM required an upgrade as well, so I downloaded and installed (1.8 144) it then changed the path in CF admin to the new location and restart but it took ages and the eventually gave up then causing the service to stop. Once I changed it back to the previous JVM it was fine. I reinstalled the JVM and tried again and its been fine since. There didnt appear to be anything untoward in the logs either so as the JVM was the only thing that changed I re-installed ... View more