When using the profiling option with a select query, the following error appears:
'System.InvalidCastException
Specified cast is not valid.
Stack Trace:
at Quest.FastData.FastBooleanSerialize.Serialize(BinaryWriter outStream, Object obj)
at Quest.FastData.FastTable.SerializeRow(Object[] data, BinaryWriter writer, FastSerialize[] serializer)
at Quest.FastData.FastTable.RowCollection.SaveToStream(BinaryWriter writer, FastTable owningTable, Boolean readOnly, IFastProgress progress)
at Quest.FastData.FastTable.SaveToStream(Stream stream, Boolean readOnly, IFastProgress progress)
at Quest.FastETL.Profiling.Client.ClientProfiler.SaveTableResults(ClientProfilerStep step, FastTable table, FileStream stream, IFastProgress progress)
at Quest.FastETL.Profiling.Client.ClientProfilerStep.SaveTableResults(FileStream stream, IFastProgress tableProgress)
at Quest.FastETL.Profiling.Client.ClientProfilerStep.ProcessProfiling(ETLEngine engine)'
The issue is happening specially when there are BOOLEAN columns.
The issue can be replicated by the following steps -
1.Create a Table with Boolean objects
CREATE TABLE DB2ADMIN.BOOLEANTEST2 (
"Company code" INTEGER,
COUNTRY CHARACTER(10),
NAME CHARACTER(10),
PROFILE CHARACTER(10),
"Creation date" DATE,
TEST1 BOOLEAN,
TEST2 BOOLEAN
)
IN USERSPACE1
ORGANIZE BY ROW;
ALTER TABLE DB2ADMIN.BOOLEANTEST2
DATA CAPTURE NONE
PCTFREE 0
LOCKSIZE ROW
APPEND OFF
NOT VOLATILE;
COMMIT;
RUNSTATS ON TABLE DB2ADMIN.BOOLEANTEST2
ALLOW WRITE ACCESS;
2. Run the query in the editor: Select * from BOOLEANTEST2;
3. Click Profiling. The Error is shown and after a while Toad for DB2 crashes
Product Defect - TDB-4488
WORKAROUND:
None
STATUS:
Issue fixed in Toad for DB2 8.0
The latest version of Toad for DB2 can be downloaded here
