Archives of the TeradataForum

Message Posted: Tue, 01 Jul 2003 @ 17:12:58 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Tuesday, July 01, 2003 13:01 -->

Hello all.

I'm hoping that someone can help me, or else give me some direction on how to debug this problem. We have a performance monitor application that was written using Excel and VBA. It's been working okay for months, but it seems like ever since we upgraded the database software from 4.1.1 to 4.1.3, we keep getting sporadic "Type mismatch" errors (which mostly seem to occur during off hours), while getting the session data. The monitor runs continually and does a GetSessionData call once every 30 seconds or so (we also have the session rate on the system set at 30 seconds).

Here are the relevant pieces of code:

Public MonObj As TeradataPerformance3.Monitor
Dim totSess As TeradataPerformance3.Sessions
Set MonObj = New TeradataPerformance3.Monitor
Set totSess = MonObj.GetSessionData
The error is:
   Err.Number: 13
   Err.Description: Type mismatch
   Err.Source: TeradataPerformance3
   Err.HelpContext: 1000013
   Err.HelpFile: C:\Program Files\Common Files\Microsoft
Shared\VBA\VEenLR3.HLP

The help info says that at run time, this error typically indicates that a variant used in an expression has an incorrect subtype. I'm wondering if I'm possibly getting something odd in the session data during our production batch?

TIA for ANY help or suggestions,

Anomy

	<Prev	Next>		<<First	<Prev	Next>	Last>>