Return
-
Title
'Object Table Result Set finished with error: Specified cast is not valid.' -
Description
User used Toad for DB2 v 4.7.1 running a query in query builder and right click on highlight output rows and selected Quick export then clicked on Excel Instance the error message came up below:
(Note: Only data with timestamp having this issue.)Thread (11) Export Started [2/15/2011 12:09:06 PM]
Thread (11) Export Wizard: Building object list
Thread (11) Exporting Data
Thread (11) Object Table Result Set started.
Thread (11) Workbooks Add target System.__ComObject
Thread (11) _ Arg: System.Reflection.Missing
Thread (11) Range AutoFit target System.__ComObject
Thread (11) Range AutoFit target System.__ComObject
Thread (11) Writing rows 1 - 1792
Thread (11) Exception in WriteRows
Thread (11) Specified cast is not valid.
Thread (11) Writing rows Finalize
Thread (11) Object Table Result Set finished with error: Specified cast is not valid.
Thread (11) at Quest.Toad.ImportExport.Writers.WriterBase.WriteRows(FastTable fastTable)
at Quest.Toad.ImportExport.ExportObjectData.StartTableWrite(Object context)
at Quest.Toad.ImportExport.ExportObjectData.Begin(LogEventHandler logEventHandler, Dictionary`2 connections, Object context)
Thread (11) Export Finished [2/15/2011 12:09:18 PM] -
Resolution
STATUS
Waiting for a fix with ST 82629 on a future release of Toad for DB2 V 5.0. (Quarter 3, 2011)
WORKAROUND:
None
-
Defect ID
ST82629