> Machine A that fails is using ODBC driver 2000.85.1022.00
> Machine B that fails is using ODBC driver 3.70.11.46
>
> I can upgrade B, but A looks like the right version and the problem happens there
> (with WiTango .65)
>
> Dave
>
> ----- Original Message -----
> From: "Robert Shubert" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, May 21, 2004 10:25 AM
> Subject: RE: Witango-Talk: URGENT - WiTango Always Crashes on Datasource Timeout
>
>
> > 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
> >
> >
