Quest.FastData.FastDataException

alloyd_640 · May 12, 2014, 11:03am

i have been getting this error lately when running queries. Sometimes when i re-run the query, it will work, other times ill get the same error or even a System.OutOfMemoryException

I recently rebooted my machine.

Quest.FastData.FastDataException
Encountered problem with spooling data to disk.
Closing result spool file.
2048 rows lost from the current result.
Stack Trace:
at Quest.FastData.FastTable.RowCollection.Add(Object[] item)
at Quest.FastData.FastTable.AddRowAccepted(Object[] data)
at Quest.Toad.SqlServer.SqlServerConnection.AddRow(Object[] rowArray, FastTable datatable, PrePostProcessHandler prePostProcessHandler)
at Quest.Toad.SqlServer.SqlServerConnection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler)
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()

System.Reflection.TargetInvocationException
Exception has been thrown by the target of an invocation.
Stack Trace:
at Quest.FastData.FastTable.RowCollection.Add(Object[] item)

System.InvalidCastException
Specified cast is not valid.
Stack Trace:
at Quest.Toad.SqlServer.SqlByteSerialize.Serialize(BinaryWriter outStream, Object obj)
at Quest.FastData.FastTable.SerializeRow(Object[] data, BinaryWriter writer, FastSerialize[] serializer)
at Quest.FastData.FastTable.RowCollection.SerializeRowData(Object[] data, FastSerialize[] serializers)
at Quest.FastData.FastTable.RowCollection.<>c__DisplayClass46.b__45(Object state)

Joshua.Liong · May 12, 2014, 11:53am

To alloyd_640:

Thank you for posting in Toad World. We apologize for the inconvenience and greatly appreciate any additional information you can provide.

I see that you’re encountering issues with any kind of queries intermittently. If you happen to notice a specific query where an issue occurs the majority of the time, a copy of that query would be useful.

At a minimum, we humbly request a post with a support bundle.

How to Create a Support Bundle and post it

Launch Toad Data Point.
Select Help -> Support Bundle
A new tab will appear. After it’s done generating the bundle, Right-click the tab -> Save File to save the .zip file to any directory of your choosing.
Return to the Toad World thread and Post a Reply using Rich Formatting
Compose a message
Select the Options tab next to Compose, then click Click to Add to add the .zip support bundle
Post when you’re ready!

We look forward to your response.

Software Associate Developer 1,
-Joshua Liong

IgorM · May 19, 2014, 10:18am

Can’t it be that your hard drive is full?

Igor.

From: alloyd_640 [mailto:bounce-alloyd_640@toadworld.com]

Sent: Monday, May 12, 2014 11:04 AM

To: toaddatapoint@toadworld.com

Subject: [Toad Data Point - Discussion Forum] Quest.FastData.FastDataException

Quest.FastData.FastDataException

Thread created by alloyd_640

i have been getting this error lately when running queries. Sometimes when i re-run the query, it will work, other times ill get the same error or even a System.OutOfMemoryException

I recently rebooted my machine.

Quest.FastData.FastDataException

Encountered problem with spooling data to disk.

Closing result spool file.

2048 rows lost from the current result.

Stack Trace:

at Quest.FastData.FastTable.RowCollection.Add(Object[] item)

at Quest.FastData.FastTable.AddRowAccepted(Object[] data)

at Quest.Toad.SqlServer.SqlServerConnection.AddRow(Object[] rowArray, FastTable datatable, PrePostProcessHandler prePostProcessHandler)

at Quest.Toad.SqlServer.SqlServerConnection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler)

at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()

System.Reflection.TargetInvocationException

Exception has been thrown by the target of an invocation.

Stack Trace:

at Quest.FastData.FastTable.RowCollection.Add(Object[] item)

System.InvalidCastException

Specified cast is not valid.

Stack Trace:

at Quest.Toad.SqlServer.SqlByteSerialize.Serialize(BinaryWriter outStream, Object obj)

at Quest.FastData.FastTable.SerializeRow(Object[] data, BinaryWriter writer, FastSerialize[] serializer)

at Quest.FastData.FastTable.RowCollection.SerializeRowData(Object[] data, FastSerialize[] serializers)

at Quest.FastData.FastTable.RowCollection.<>c__DisplayClass46.b__45(Object state)

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.

Debbie_Peabody · May 20, 2014, 8:08pm

I recognize this issue. What version of TDP are you using? If you are not using TDP 3.5 please download and try. This is a data driven error that has been fixed.

alloyd_640 · May 27, 2014, 6:59am

This has only started happening to me since upgrading to Toad 3.5. I’m on 3.5.0.2940. Here is the latest occurrence, happened while just running a query that returns around 300k records:

Quest.FastData.FastDataException
Encountered problem with spooling data to disk.
Closing result spool file.
2048 rows lost from the current result.
Stack Trace:
at Quest.FastData.FastTable.RowCollection.Add(Object item)
at Quest.FastData.FastTable.AddRowAccepted(Object data)
at Quest.Toad.SqlServer.SqlServerConnection.AddRow(Object rowArray, FastTable datatable, PrePostProcessHandler prePostProcessHandler)
at Quest.Toad.SqlServer.SqlServerConnection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler)
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()

System.Reflection.TargetInvocationException
Exception has been thrown by the target of an invocation.
Stack Trace:
at Quest.FastData.FastTable.RowCollection.Add(Object item)

System.InvalidCastException
Specified cast is not valid.
Stack Trace:
at Quest.Toad.SqlServer.SqlByteSerialize.Serialize(BinaryWriter outStream, Object obj)
at Quest.FastData.FastTable.SerializeRow(Object data, BinaryWriter writer, FastSerialize serializer)
at Quest.FastData.FastTable.RowCollection.SerializeRowData(Object data, FastSerialize serializers)
at Quest.FastData.FastTable.RowCollection.<>c__DisplayClass46.b__45(Object state)
ToadSupportBundleToad Data Point.zip (4.36 MB)

Debbie_Peabody · May 30, 2014, 7:18pm

Let me check with the SQL Server team.

alloyd_640 · June 2, 2014, 7:46am

Thanks. This is still happening consistently to me. I’d go back to toad 3.4 but all my automation scripts wont work.

Debbie_Peabody · June 2, 2014, 7:29pm

If you go to help about and click the app data dir you can navigate to Automation\bak. We keep a back up copy of all automation scripts prior to the version change. Try using those scripts with TDP 3.4. If that doesn't work Igor can tell you how to manually change the version number.

Debbie_Peabody · June 3, 2014, 7:20pm

P.S. we made a fix for this and it will be in the next TDP 3.6 Beta.

alloyd_640 · June 16, 2014, 6:34am

3.6 beta out yet? this error drives me nuts.

Debbie_Peabody · June 16, 2014, 6:34pm

It should be posted tomorrow.

alloyd_640 · June 23, 2014, 7:38am

do you have a link to this?

Joshua.Liong · June 23, 2014, 10:27am

To alloyd_640:

This page will house the latest betas:

www.toadworld.com/…/default.aspx

The version as of this point is 3.6.0.2898.

We look forward to your feedback.

Topic		Replies	Views
System.InvalidCastException Toad Data Point & Toad Intelligence Central	2	1293	November 11, 2010
Querying Oracle Data Connection Against Excel Data Connection Toad Data Point & Toad Intelligence Central	1	880	August 2, 2013
Select * Toad 5.5 fails Toad for SQL Server	4	987	August 17, 2011
Issue with TOAD Data Point 3.2, InvalidCastException Toad Data Point & Toad Intelligence Central	17	2086	March 19, 2016
Not enough memory to load data-- ?? Toad Data Point & Toad Intelligence Central	4	1174	October 1, 2013

Quest.FastData.FastDataException

Related topics