File Types Creation works in great cf9.1 however not in cf 2021

[Claude5FCA]

Hi,

The company has an application that stores the content of files uplaoded into an sql database table allowing for the content of those files to be rebuilt and downloaded as required using cf code.

The code works perfectly in the application running cf9.1 on a window 2008 server

When I run the identical code pointing to the same database running cf2021 on a windows 2016 server  the files are generated successfully however when they are opened they either generate an error within the default application used to open the file determined by the file extension  (eg ms word, xls, msg, etc ) and or advises there are permission errors preventing the file to be opened.

Can anyone shed some light on what may be causing this and a possible solution

Just recapping the cfm page generating the file, and the sql database, table, and the record being  used are idetical in both examples. The ony differnece is the working solution is running cf9.1 on windows server 2008 whilst the not working solution is running on cf 2021 on windows server 2016.

I thnak you in advance or any responses that can enlighten me as to the cause and the path to resovle the above 

Regards

Claude Raiola

[Charlie Arehart]

Claude, I'd assert that your description is too general for us to assess what may be amiss.

Can you take a few mins to create a working example that demonstrates the problem, even in just a few lines of code? In doing that, you'd clarify the problem for us and for you...and you may even see that the cause is other than just that "cf2021 doesn't work" for that process.

Perhaps you may find that some earlier partt of the process (that you're not currently considering) has changed in its behavior, affecting the results of the ultimate steps you actually see.

Note also that you're skipping over four releases (10, 11, 2016, and 2018) in addition.to 2021 itself (and about 100 updates). There have indeed been compatibility issues between each release (a few per release, on average, and in about 1 in 5 updates). You could be tripping over one or more in your entire process. We just can't know given what you've shared.

Also, did you install cf or someone else? When you were asked to implement the "secure profile" (new since 10), did you do it or skip it? That too can impact how your code runs.

I realize I'm offering more questions than answers, but you did ask for "any responses". 🙂 

[BKBK]

One suggestion comes to mind: make sure that locations, file paths and permissions are no longer for (CF9, Windows Server 2008), but for  (CF2021, Windows Server 2016).

[Charlie Arehart]

Claude, any update on things? Did you consider what I or BKBK offered? Any follow-up?