I am running Standard in a production environment.  Client can't justify the expense of moving to Enterprise for this solution, so we have discussed going a different route, and creating a processing queue for files that are uploaded by the customers.  It was nice to be able to do it realtime, as I had programmed a "console" that showed them the progress (and any potential errors) of their file as I was parsing it.  But it is what it is, I suppose. ... View more

Thank you for the continued effort with helping try to figure this out. I increased my sleep to 60 seconds. You can see that the behavior between our environments is different.  Also, where is your "Start Dump in Execution1" ? "Information","ajp-bio-8014-exec-156","12/17/18","16:50:22",,"Test1: Start: Reading File ABC SUPPLY ROOFING.xlsx" "Information","ajp-bio-8014-exec-155","12/17/18","16:50:24",,"Test2: Start: Reading File ALSIDE SUPPLY ROOFING.xlsx" "Information","ajp-bio-8014-exec-156","12/17/18","16:50:38",,"Test1: End: Reading File ABC SUPPLY ROOFING.xlsx" "Information","ajp-bio-8014-exec-156","12/17/18","16:50:38",,"Test1: Sleep: 60 seconds" "Information","ajp-bio-8014-exec-156","12/17/18","16:51:38",,"Test1: Start: Dump getData1" "Information","ajp-bio-8014-exec-156","12/17/18","16:52:02",,"Test1: End: Dump getData1" "Information","ajp-bio-8014-exec-155","12/17/18","16:52:03",,"Test2: End: Reading File ALSIDE SUPPLY ROOFING.xlsx" "Information","ajp-bio-8014-exec-155","12/17/18","16:52:03",,"Test2: Sleep: 60 seconds" "Information","ajp-bio-8014-exec-155","12/17/18","16:53:03",,"Test2: Start: Dump getData2" "Information","ajp-bio-8014-exec-155","12/17/18","16:53:24",,"Test2: End: Dump getData2" ... View more

BKBK​ thanks.  I had a hunch that might be an issue, and as such did indeed make sure it was reading two different files and using two different query attributes.  I have even gone so far as to try copying the queries from the spreadsheet read into new variables and deleting the original queries.  This really has me stumped.  In 20+ years of CF development, this is the first time I haven't been able to find a solution or work around for something that puzzles me. ... View more

You are correct.  I didn't mean to put the word "NOT" there.  That was from previous edits. I will test this out on a developer edition, as you are correct, we are running CF Standard. Do you know where in Adobe documentation it explicitly says that these functions are limited to single-threads? I found this document: Buying guide | Adobe ColdFusion Family  but don't see an explanation of what "Restricted Functionality" means. ... View more

Thanks for the suggestions.  I have already done a bunch of different tests to debug this, noteably, using a query with a similar amount of data from the database.  It doesn't behave the same way.  What I have provided here is the simplest way I have been able to reproduce and visualize the issue. ... View more

Thanks for the response. CF Version: 11,0,08,298512 Java Version: 1.8.0_25 I have also tried this on a different server running CF2016, and have witnessed the same behavior. I have created two test files in the same directory.  I have two XLSX files that each have 2 worksheets (so I can read from the second worksheet specifically).  These files are ~300k in size and reside in the same directory as the CFM files.  The second worksheets each have ~2000 rows x 10 columns of data. The code of both CFM files is very similar to this (only changing the values of the "thisExecution" and "thisFile" variables. I tail the application.log as load both of these from the same computer.  (separate computers also present the same behavior). The code:  (for some reason isn't showing up - I have tried editing a few times) <CFSETTING requesttimeout="6000" > <CFSET private.thisExecution = "Test1" > <CFSET private.thisFile = "testfile1.xlsx" > <CFOUTPUT>#private.thisExecution#: #private.thisFile#: #private.dataType#</CFOUTPUT> <CFLOG text="#private.thisExecution#: Start: Reading File #private.thisFile#" > <CFSPREADSHEET action="read" src="#expandpath('#private.thisFile#')#" sheet="2" query="getData" headerrow="1" excludeheaderrow="true" > <CFLOG text="#private.thisExecution#: End: Reading File #private.thisFile#" > <CFLOG text="#private.thisExecution#: Sleep: 5 seconds" > <CFSCRIPT>sleep(5000);</CFSCRIPT> <CFLOG text="#private.thisExecution#: Start: Dump getData" > <CFDUMP var="#getData#" > <CFLOG text="#private.thisExecution#: End Dump getData" > Picture of the code: (since I can't get it to output in this forum) The log output: "Information","ajp-bio-8014-exec-104","12/14/18","13:04:47",,"Test1: Start: Reading File ABC SUPPLY ROOFING.xlsx" "Information","ajp-bio-8014-exec-87","12/14/18","13:04:48",,"Test2: Start: Reading File ALSIDE SUPPLY ROOFING.xlsx" "Information","ajp-bio-8014-exec-104","12/14/18","13:04:58",,"Test1: End: Reading File ABC SUPPLY ROOFING.xlsx" "Information","ajp-bio-8014-exec-104","12/14/18","13:04:58",,"Test1: Sleep: 5 seconds" "Information","ajp-bio-8014-exec-104","12/14/18","13:05:03",,"Test1: Start: Dump getData" "Information","ajp-bio-8014-exec-104","12/14/18","13:05:45",,"Test1: End: Dump getData" "Information","ajp-bio-8014-exec-87","12/14/18","13:05:52",,"Test2: End: Reading File ALSIDE SUPPLY ROOFING.xlsx" "Information","ajp-bio-8014-exec-87","12/14/18","13:05:52",,"Test2: Sleep: 5 seconds" "Information","ajp-bio-8014-exec-87","12/14/18","13:05:57",,"Test2: Start: Dump getData" "Information","ajp-bio-8014-exec-87","12/14/18","13:06:13",,"Test2: End: Dump getData" They both start reading the files at around the same time.  But script 2 waits until script 1 has finished working with the spreadsheet before it continues. I am thinking CFSpreadsheet is not thread safe.  Is there a way to explicitly kill the process after it is done reading the worksheet in the file?  Since it creates a query object with the results of the read, I could duplicate the object, kill CFSpreadsheet and free it up for the next instance to use. ... View more