https://tracker.adobe.com/#/view/CF-4225676 ... View more

Wow, jumping in on a Satruday. Thanks @BKBK ! Good catch, you are correct that the application of a cache appears to be the pivoting factor in this example's error. However, I'm not sure the time span of the cache is the issue. I've created a simplified standalone example which employs a full one day cache - and the error is still present, even when employing the "does it exist?" test first. Here is the "broken" version: <cfstoredproc procedure="Get_Centers" datasource="[redacted]" cachedwithin="#createTimespan(1,0,0,0)#"> <cfprocparam variable="IdClient" cfsqltype="CF_SQL_INTEGER" value="2" /> <cfprocresult name="qResults" /> </cfstoredProc> <cfdump var="#qResults#" /> <hr/> <cfdump var="#qResults.columnList#" /> <hr/> <cfdump var="#queryKeyExists(qResults, "ADDED_IDUSERS")#" /> <hr/> <cfif queryKeyExists(qResults, "ADDED_IDUSERS")> <cfset queryDeleteColumn(qResults,'ADDED_IDUSERS') /> </cfif> <hr/> <cfdump var="#qResults.columnList#" />  Which produces this: Next, here is the "fixed" version: <cfstoredproc procedure="Get_Centers" datasource="[redacted]" cachedwithin="#createTimespan(1,0,0,0)#"> <cfprocparam variable="IdClient" cfsqltype="CF_SQL_INTEGER" value="2" /> <cfprocresult name="qResults" /> </cfstoredProc> <!--- ADDED ---> <cfquery name="qResults" dbtype="query"> SELECT * FROM qResults </cfquery> <cfdump var="#qResults#" /> <hr/> <cfdump var="#qResults.columnList#" /> <hr/> <cfdump var="#queryKeyExists(qResults, "ADDED_IDUSERS")#" /> <hr/> <cfif queryKeyExists(qResults, "ADDED_IDUSERS")> <cfset queryDeleteColumn(qResults,'ADDED_IDUSERS') /> </cfif> <hr/> <cfdump var="#qResults.columnList#" /> Here's the error-free result, after the ADDED interim step "turn this query into a query" step So to me, it seems a bit buggy.  The application of the cache seems to affect some internal column array, no matter how long the life span of the cache. The queryKeyExists function considers the column extant, while the queryDeleteColumn disagrees, perhaps using a different test. Can you audit my logic? Thanks again.   ... View more

It's been a year plus since the last reply, and I get the same error from an attempt to delete a column from a SP (sproc) generated cfprocresult set (Azure MS-SQL) in CF2021: <cfstoredproc procedure="Get_Centers" datasource="#application.datasource#" cachedwithin="#createTimespan(0,0,0,2)#"> <cfprocparam variable="IdClient" cfsqltype="CF_SQL_INTEGER" value="#val(struReturn.sessionStruct.client_id)#" /> <cfprocresult name="struReturn.data" /> </cfstoredProc> <cfset queryDeleteColumn(struReturn.data,'SECRETCOL') /> <!--- NegativeArraySizeException ERROR --->   My fix was a QoQ to "re-cast" the results as a query type - that CF apparently likes better:   <cfstoredproc procedure="Get_Centers" datasource="#application.datasource#" cachedwithin="#createTimespan(0,0,0,2)#"> <cfprocparam variable="IdClient" cfsqltype="CF_SQL_INTEGER" value="#val(struReturn.sessionStruct.client_id)#" /> <cfprocresult name="qResults" /> </cfstoredProc> <cfquery name="struReturn.data" dbtype="query"> <!--- DUMB BUT NEEDED ---> SELECT * FROM qResults </cfquery> <cfset queryDeleteColumn(struReturn.data,'SECRETCOL') /> <!--- WORKS --->     Hope this helps someone. ... View more

Hi @richt82047916  We do not have that module installed for this very reason. Sorry that I saved that trivia tidbit for the last line of my OP.   Yes @BKBK that's definately what they did, after @Priyank Shrivastava. replied that a patch was available for their problem. I tried that patch - as archived by Charlie - without any luck. I'll reach out to cfsupport as soon as I can revert this and all the stuff I've tried. Maybe they have something new for 2021 ... View more

Thanks @Dave Watts, but I'm not sure what else I would get beyond what's in the update.log file. I've always thought that the message "Connection Failure: Status code unavailable" simply means that the endpoint is not there or refuses the connection. My amateur conclusion is that the version cited in the updater UI selection option is not there, and that a message like this means we're not gonna see much else. Is that flawed logic?   Let me see what else I can find out, however: Do you know or suspect that this family of core and plugin updates will actually fix the cfreport xml parsing error? Al   P.S. I think you led a Macromedia MAX course that I attended (maybe in New Orleans?). How's that for a throwback? ... View more

@Charlie Arehartagreed. My other "no pdf service?" thread was sidelined until I could address the "latest version?" dependency in this one. Now I can pivot and continue there with my year-old homework. I only threw the other Java forks in my bullet list because Pete does as much in his video. Aside from possible lags in updates to Adobe's download page, I don't see any reason to employ them. Finally, I may take you up on the consultation after I exhaust the more popular [add-on-services] fixes. One of our clients is pretty pdf intensive, and it's becoming a pain to switch dev machines just to switch projects. But I'll move the conversation over there. TTFN! ... View more

Thanks @Charlie Arehart for your plethora of advice and links. Sorry I couldn't get back to this right away. Clients do not consider our personal development environments when setting their arbitrary due dates ;-] I suspect the problem is "solved" via your JVM update notion, I'll end this post with some quirks. But for now, a condensed summary of my steps for future Google posterity! Again, this is specific to my Zorin Linux 16 laptop: Only download Java release with documented compatability for your CF version (usually LTS version) Download (archive/zip version) from Adobe (my choice), Oracle, Amazon etc based on your Java licensing needs Expand archive in new location (for me, the Adobe version placed at /usr/java/jdk-11.0.16.1/ ) Set ample Linux access permissions on this new location (for me, it was chmod 777 [folder] because localhost) Insure you downloaded the right thing (there's /bin and /lib folders in there, right?) Note the path to the new location. Navigate to CF Admin | Java/JVM: Note the existing path in a backup txt file for possible * undo needs (for me it was /opt/ColdFusion2021/jre/) Paste the new JVM path. Change nothing else. (Note that you are actually changing the contents of ...cfusion/bin/jvm.config, in case you blow this - and need to undo manually * when CF fails to restart) Submit form & Restart CF Service Check CF Admin | Java/JVM to confirm new version shows now...   After these steps, the Update page in the CF Package Manager finally loaded up with all the plugin and core update data. Turns out I was able to either Uninstall Update 3 or Install Update 4. I did the later, and am at 2021,0,04,330004 now.   Quirks: 1) After an entire system restart, the Package Manager page went blank & started logging these again: Error [http-nio-8500-exec-5] - macromedia/externals/org/bouncycastle_1_60_0_0/asn1/pkcs/PKCSObjectIdentifiers The specific sequence of files included or processed is: /opt/ColdFusion2021/cfusion/wwwroot/CFIDE/administrator/updates/index.cfm, line: 219 Also, my application's calls to another dev server (our CFML API) started failing with the same Invalid SSL protocol error as before. HOWEVER, a stop and start of the CF Service seemed to get things working again. 2) Regarding the part in Pete's video about changing the file ...cfusion/jetty/jetty.lax for the CF Add-On Services, my installation has no such file - even tho I had added them with the specific installer. Perhaps it's somewhere else now? 3) The original issue here was not fixed by all this updating. I was hopeful that I could finally make a PDF, but no luck. The lack of the service started me down this whole update experience! I'll update that thread to note as much. But hopefully this one is closed now, thanks again. ... View more

@BKBKcan you do me a favor and check this bug first (before I file my own) in reference to the things you noted in my logs posted here? I suspect that mine would then be a duplicate. https://tracker.adobe.com/#/view/CF-4212668 Thanks, Al ... View more

Looping back to this issue, I see that I neglected to mention what happens in a GET request to http://127.0.0.1:8993 Nothing happens. The browser notes that nothing is there to connect to.   I will try to file a bug as you suggest. I'm reluctant to change the Java engine, as I do not want to shuffle a bunch of variables while the cause is still unknown. Let's see what quick response comes first. ... View more

Hey Charlie, always nice to hear from you 🙂   Aye, I spy both folders here: The first one is probably from the original installation: /opt/ColdFusion2021/cfusion/jetty   The second is probably from running ColdFusion_2021_Addon_WWEJ_linux64.bit (the cure recommended by doctor internet). /opt/coldfusionaddonservices   Both start.ini versions have the same passeges you cited, verbatim: ## Connector host/address to bind to # jetty.http.host=0.0.0.0 ## Connector port to listen on jetty.http.port=8993 I'm browsing this development environment by way of http://127.0.0.1:8500/  fwiw.   So, if both are trying to run, I suspect that would cause an issue. Netstat did not indicate that either was listening there. So I guess nobody won that battle.   Onto the logs. They are attached. 2021_12_28.stderrout.log is from coldfusionaddonservices 2021_12_30.stderrout.log is from /cfusion/jetty Both contain the Started ServerConnector message, but are soon followed by ConcurrentModificationException and ServletException messages.   I suspect this will not be fixed this year 😉 Al ... View more

Thanks for the fast response, but no - the problem is not solved. 😞 The Firewall on my Linux system is disabled, and I ran netstat to see that the port range surrounding 8993 was not already LISTENING or ESTABLISHED with another process. Per your suggestion, I also reconfigured the existing PDF Service to use ports 8992, 8991 and so on (also 8501, 8600 and 8900 for fun). Each configuration logged the same errors: application.log coldfusion.document.webkit.PDFgErrorHandler$ConnectionVerificationFailedException: Connection verification failed. Error enabling PDF Service Manager. coldfusion-out.log Information [main] - Package htmltopdf started...  Information [main] - Package pdf started... Error [http-nio-8500-exec-5] - Connect to 127.0.0.1:<port> [/127.0.0.1] failed: Connection refused (Connection refused) http://127.0.0.1:<port>/PDFgServlet/verify   Error [http-nio-8500-exec-2] - Connect to 127.0.0.1:<port> [/127.0.0.1] failed: Connection refused (Connection refused) http://127.0.0.1:<port>/PDFgServlet/   Error [http-nio-8500-exec-2] - Connection verification failed. Error [http-nio-8500-exec-5] - Error enabling PDF Service Manager.   I will continue to entertain the "blocked port" theory, but I also suspect that the error may be presumptive or misleading: ie that the connection is actually refused because one of these daemons or services is lacking suffecient permissions on some resource or user?   ... View more

Any resolution to this? I've also run the ColdFusion_2021_Addon_WWEJ_linux64.bin on my Zorin linux with successful messaging from the installer UI. There's even this message in my coldfusion-out.log "1029 Dec 27, 2021 18:23:17 PM Information [main] - Package pdf started... " But I experience the same problem from the CF Admin page: 1063 Dec 27, 2021 18:31:37 PM Error [http-nio-8500-exec-3] - Server Error 1064 Dec 27, 2021 18:31:37 PM Error [http-nio-8500-exec-3] - Connection verification failed.   1065 Dec 27, 2021 18:31:37 PM Error [http-nio-8500-exec-3] - Error enabling PDF Service Manager. ... View more

Thank heavens I found this post. "The next update will fix the ability to update". What a paradox, like "we don't want to loose the combination, so we keep it locked in the safe". It's six months later, and the version they're shipping on the Download page still hides the button.   Anyway, thanks again! Al ... View more

Hi Priyank; This is a paradox. There is no "UPDATE" button visible for me. The "Log" button is directly above the "Analytics Dashboard". Therefore I cannot obtain the current build number. The hosting firm has just told me that this is about user permissions, and they will resolve this for me. This is a classic UI problem without a common answer: When a user does not have access to a feature, do you HIDE the feature (which will increase your support volume as evidenced here), or do you show - but DISABLE - the feature, perhaps with a tool tip to explain why? ... View more

Thanks Charlie. I was afraid of that.  I hope it's just a temporary oversight. Al ... View more

I've been waiting for some resolution to this since last July. We do not compile our Flex source for the Flash player. Rather, ours is a desktop application which runs under the AIR platform in a closed network. We've been update-less since last summer, please don't tell the bad guys. I agree with Charlie's line of reasoning (something 3rd party was updated, not intentional CF engine change by the CF team). But in addition to Tomcat, I would also check the other Java libraries that are more specific to the "native" RO calls handled by flex_gateway (like BlazeDS), and see if some version trial and error could be done there. Al ... View more

Yes, sorry. Our log showed everything was successful in applying the update. So a partial or failed update was not the reason for our encoding faultString bug. ... View more

On Charlie Arehart's advice, we also checked our update logs to insure that there were no problems with the update process. How to solve common problems with applying ColdFusion updates (in 10 and above) - Charlie Arehart's ColdFusion Troublesh… ... View more

Laurence, did you ever get an answer or fix for this? Our test server was just updated to this patch and we are experiencing the same error. ... View more

Perhaps it could be stated "It's a bit like black magic trying to get CF to work properly with IIS" CF is basically a Java J2EE application. IIS is a Microsoft application. I think it's more a game of cat and mouse, than black magic. ... View more

Are you running the latest update? Does it help if you enable "Cache Web Server Paths" setting in the Caching page of the ColdFusion Administrator? The bug report for 3222748 claims that as a workaround. If not, I would go here and vote up the bug, assuming your issue is producing the same error messages as the ones stated there. https://bugbase.adobe.com/index.cfm?event=bug&id=3222748 HTH, Al ... View more