Update the MDAC to the latest version, you should be using a SQL driver 2000.85 or greater. Please post what you are using now (ODBC Administrator > Drivers)
Also I know that MS SQL has its own Query Timeout, which you might be able to lower. I'm not familiar with how this works with Witango, but I've seen the option. Lastly, I would take a serious look at what you are doing in the SQL. Check indexes, remove joins, etc. There is little reason why any SQL request should take longer than a few seconds to process. Even the worst reporting type requests or table updates on my server take considerably less time than my querytimeout. If you didn't already, direct this post to [EMAIL PROTECTED] so that they are sure to have this and can take a look at it. If this truly is a failure in Witango to handle an execution timeout while having a pending DBMS open then I'm sure it will be fixed in the next update. Robert -----Original Message----- From: Dave Machin [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 12:55 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: URGENT - WiTango Always Crashes on Datasource Timeout I've mentioned this problem several times with no response and it's becoming a serious problem. I can reproduce it with 100% accuracy on several machines and with two different versions of WiTango server. Here's what happens: We built a clean install of W2K server, SP4, and all the MS patches - the machine is only running IIS and WiTango. This has also happened on an otherwise stable W2K machine with SP3. Install WiTango server (we've done either .54 or .65 same problem happens). We make no other changes Execute any .taf that runs a DBMS query (in my case against through ODBC to MS-SQL 2000 SP3) that takes longer than QueryTimeOut WiTango crashes This happens every single time with no exceptions. To simplify testing I reduced QueryTimeOut to 10 seconds and it crashes on every query that doesn't return in 10 seconds. My only workaround has been to increase QueryTimeOut to 1200 seconds to avoid the error and to set the Service to restart on failure. I need some help! What can I do or change? Below is an example of the error from the log: [ 1144] 2004-05-21 09:43:10 RUNTIME ERROR The application file "/paypal/impact/impact.taf" has timed out in the "find_performance_denom" action and has been terminated (15 seconds) [ 1144] 2004-05-21 09:43:10 RUNTIME FATAL System Exception at 77eab2f0; Thread ID=2264; Code=Unknown Code (0x); [ 1144] 2004-05-21 09:43:10 RUNTIME FATAL System Exception at 77eab2f0; Thread ID=2264; Stack: 0122f698 78033e68 e06d7363 00000001 00000000 77eab2f0 00000003 19930520 0122f6b8 0058d600 0122f684 7800ffb8 78033250 ffffffff 005c6b60 005550e5 00890138 00407fb2 00890138 008ade04 008ade04 0122f6c8 0122f698 7800b78d e06d7363 00000001 00000003 0122f68c 00860fa8 00007942 e06d7363 00000001 00000000 00000000 00000003 19930520 0122f6b8 0058d600 0122f6c8 0041b0c4 0122f6b8 0058d600 008ade00 00860fa8 008ade00 008ade00 008ade00 0122f744 0055c667 ffffffff 0122f704 0052ddea 00000000 008a3010 008a3008 00413473 00000000 0000ffe0 00406dbd 008c237c 008a3008 00454aba 008c237c 00860fa8 666c7674 0122f750 00413f4c 008c2378 00860fa8 00000000 00000000 0122f700 005749f4 00000000 00000000 00574830 00000000 00000000 00000000 00000000 0122fc64 0122fc64 0055be07 00000000 0122fc70 004122c6 ffffffff 7802bacc 051c001b 0122f6e0 ffff0023 00aefb1c 00000003 07182598 0003002f 1b300000 00004400 00aefcb0 0122f7bc 00000037 77fb2598 002f0000 0122f7cc 00000041 77fb2598 002f0000 002f12b8 00000041 008b5560 0122f7a4 00000200 0122f8b0 0122f8b0 0122f8c4 0122f8c4 0122f970 77fc8d32 002f12b8 00000208 00000039 008b1c10 0122fa08 0122fa58 00850e78 00860fa8 00000206 0122fa00 00000023 [ 1144] 2004-05-21 09:43:10 RUNTIME INFO Attempting restart Dave Machin E-Mail. [EMAIL PROTECTED] Tel. 805.614.0123 x 30 Address: 3201 Airpark Drive, Suite 104 Santa Maria, CA 93455________________________________________________TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
