Skip to main content
Participating Frequently
September 17, 2021
Answered

COLDFUSION (2018 RELEASE) UPDATE 12 breaks spreadsheetAddRows

  • September 17, 2021
  • 1 reply
  • 989 views

 

Started receiving errors on issuing a spreadsheetAddRows in production code using a CF2018 standard server after applying update 12.

Production code was working as intended until update was applied.  After Update 12 was uninstalled, the code is once again working as before.

    This topic has been closed for replies.
    Correct answer Charlie Arehart
    quote

     I applied the hot fix below and reinstalled update 12.


    By @pcesana

    Just in case it matters, I would do it as follows:

    • install update 12 first, then apply the hot fix.

    Oh, great catch, BKBK. I had not noticed that pcesana had said they "applied the hot fix below and reinstalled update 12". (I had just woken when I saw and responded.)

     

    So yes, absolutely: that special hotfix was an UPDATE TO THE UPDATE 12. If you "applied" that  "hot fix below"  (by putting that special hotfix jar into the lib/updates of CF), and then  you "reinstalled update 12", that was NOT NECESSARY. Worse, installing update 12 would have removed ANY special hotfix jar you would have put in that lib/updates.

     

    This is how all CF updates work: they remove ANY jars in that lib/updates...which will help you when in the future you may apply update 13, which would not included that fix, and Adobe would not want to leave that "special fix" in there.

     

    So can you confirm for us, pcesana, if you NOW just drop in that special hotfix jar (alongside the chf jar for update 12), and then RESTART CF (that's key also, and perhaps you missed that last time), does your problem remain? It should not...again unless there still remains some OTHER bug. (Either way, you may want to update the big you filed to clarify which situation it was.)

    1 reply

    BKBK
    Community Expert
    Community Expert
    September 17, 2021

    Are you sure? When I run the first code example from the SpreadsheetAddRows documentation, I get addrows.xlsx as expected 

     

    Could you please share your code?

    In any case, have you installed the query-of-query hotfix mentioned in a previous thread? I have.

    To get the hotfix, contact cfsup@adobe.com

     

    Priyank Shrivastava.
    Community Manager
    Community Manager
    September 17, 2021

    Hi @pcesana ,

     

    As @BKBK mentioned, if you have the repro code, please log a bug in tracker so we can take a look.

    https://tracker.adobe.com/ 

     

     

    Thanks, Priyank Shrivastava