Skip to main content
michaelh53276323
michaelh53276323
Inspiring
December 15, 2021
Answered

CFSPREADSHEETWRITE needs up to 20th more time after install CF2021

  • December 15, 2021
  • 2 replies
  • 1431 views

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!

    This topic has been closed for replies.
    Correct answer michaelh53276323

    I tried the simple test case in this discussion, and in the Win 10 Ent 21H1 environment it takes 9 minutes between "Start CFSPREADSHEETWRITE" and "End CFSPREADSHEETWRITE".

     

    By @Legorol

    9 minutes! Wow! This is then a thing.

     

    Have you experimented by writing to a different file path?

    What happens when you run the tag version of the code?

    Could you too share the content of your jvm.config file  (Obfuscate any private or sensitive information with ***).

    Does either of you use FusionReactor? If so, could you share the "profiler" log for this request.

     

    While we look into it, could you or @michaelh53276323, in the meantime, create a bug ticket. Please let us know when you do.

     


    Hi, i hope you had nice christmas! 🙂
    I found my problem, for that a little bit of history.

    I installed CF2021 at the end of June of 2021 with the installer timestamp 20th march 2021.

    Than i changed java to 12.0.2, that i found of highest specification.

    Over the time i install Update 1,2,3.

    The system runs well until the CFSPREADSHEETWRITE problem.

    The rest of the story is written above.

    Now i compare every files and restore the java.home to {application.home}/jre.

    I compare the JRE folder with the JRE folder of my out of the box laptop with my fresh downloaded installer with timestamp 3th september 2021.

    Every files are different.

    I overwrite JRE-files from fresh to old JRE-files of old installation. Voila, it works.

    I go back to java12.0.2 inside jvm.config and the same time problem is in town.

     

    On my way to the deepness of CF i have to say many many many thanks for your support, patience and help me for repair this problem.

     

    Everyone, have a good New Year! To an exciting 2022... 🙂

    2 replies

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    December 17, 2021

    We're in the ColdFusion Forum, a discussion group for all things ColdFusion. Hence this is a good place to look for a solution to your problem.Typically, if you face ColdFusion coding problems, this will be the place to be. 🙂 

     

    Could you share the cfspreadsheet code that is causing the problem? Remember to replace any private or sensitive information with ***.

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity Expert
    Community Expert
    December 15, 2021

    You may think the problem is in cf 2021, but you say it's also a new server. THAT could be the cause of the problem. So also could be how you configured cf2021 differently from how cf2016 had been configured. 

     

    If you get no other ready answer here, here's practical advice: I'd recommend you consider installing cf2016 on the new server. They can co-exist, no problem. And if 2021 is running when you install 2016, the latter will get new ports for its settings so they won't conflict. 

     

    And even if you "don't want to convert all the configuration to run the site on 2016" on the new server, just create a single simple test cfm page that demonstrates the "slow spreadsheet" processing. You can use cf's builtin web server (used by the admin) to run the tests. 

     

    Then put that in the cfusion/wwwroot of CF2021, and test it there (using port 8500 or whatever is the port of the cf admin). Is it still slow, as it should be (since it's still 2021 running it)?

     

    Then move it to the cfusion/wwwroot of the ew cf2016 (on the new server), and run that with port 8501. Is it still slow? If so, the problem is not 2021 itself.

     

    Either way, there's much more we could consider. Let's hear what you may think or try (or others may say) before  I may share more. 

    /Charlie (troubleshooter, carehart. org)
    michaelh53276323
    michaelh53276323Author
    Inspiring
    December 19, 2021

    Hi Charlie,

    thanks for your reply.

    I test many cases. Installing CF2016 and CF2021 on server, on my local development equipment.

    On every environment is the same issue.

    I also tested the data collection before given to CFSPREADSHEETWRITE to write with CFFILE ACTION="WRITE".

    On all systems it needs less then 0.5 seconds to write to file system.

     

    I have prepared a detailed documentation with all the settings of both systems but would not like to post that here with the server settings...

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    December 19, 2021

     

    I have prepared a detailed documentation with all the settings of both systems but would not like to post that here with the server settings...


    By @michaelh53276323

    @michaelh53276323 ,

    As I wrote earlier, you can replace any private or sensitive information, such as server settings, with *** characters.

     

    The sooner you post the code here, the quicker you will get feedback from fellow developers. Some of us have written thousands of lines of cfspreadsheet-write code in the past.

     

     

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices