Hey hey, I'm trying to import a large file into a database by sending the insert statements to an asynchronous gateway. The gateway itself is nothing but a database insert, and it is working to some extent. For instance, with my test data of about 701 inserts, only about 150-180 actually get inserted when I try it. This is confirmed by the in/out columns in cfadministrator which in this case read 152/701. 152 is also the number of rows in that database table, so it most certainly worked to some extent.
My eventgateway.log file is loaded with this same error over and over again: "Problem adding event for gateway Movie Gateway: A problem occurred when attempting to add more assignments into the threadpool task queue.". My "Event Gateway Processing Threads" value is at 10, which doesn't seem to be changeable in the developer version (correct me if i'm wrong). Even changing the "Asynchronous Events via CFML" timeout to something ridiculous and making it not kill on timeout still produces the same result. Looking at the results, it looks like the first 10 ALWAYS work, but after that there seems to be a problem sporadically. It's almost as if there's only 10 threads, and each one that's queued up while those 10 are executing is failing; but that wouldn't make sense. Any ideas how I can get this to work? I'm considering installing bluedragon to try out cfthread otherwise. Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269220 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
