Archives of the TeradataForum
Message Posted: Tue, 01 Jul 2003 @ 17:12:58 GMT
<-- Anonymously Posted: Tuesday, July 01, 2003 13:01 -->
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|