Toad World® Forums

Quest.FastData.FastDataException

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 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

  1. Launch Toad Data Point.
  2. Select Help -> Support Bundle
  3. 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.
  4. Return to the Toad World thread and Post a Reply using Rich Formatting
  5. Compose a message
  6. Select the Options tab next to Compose, then click Click to Add to add the .zip support bundle
  7. Post when you’re ready!

We look forward to your response.

Software Associate Developer 1,
-Joshua Liong

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.

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.

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)

Let me check with the SQL Server team.

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

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.

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

3.6 beta out yet? this error drives me nuts.

It should be posted tomorrow.

do you have a link to this?

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.