Error: 'Specified cast is not valid' occurs when using the Profiling option with a select query (4378101)

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