Toad Data Point 5.0.7 crashes - "Toad encountered a serious error and must close. Please save your data and close the application. Sorry for the inconvenience"

Toad Data Point
1

Toad data point crashes every time i run any query in the sql editor. Please find below the complete error that is being shown.

NullReferenceException
Object reference not set to an instance of an object.

Stack Trace:
at Quest.Toad.SQLRecall.SQLRecallItemExtensions.<>c__DisplayClass2_0.b__0(FileStorageItem1 i) at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable1 source, Func2 predicate) at Quest.Toad.SQLRecall.SQLRecallItemExtensions.AddItem(JsonFileStorage1 storage, SQLRecallItem item, String body)
at Quest.Toad.SQLRecall.ProducerConsumerQueue`1.Work()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

2

Hi,
this is really strange and it looks like you have some problem with saving SQL Recall functionality. This module try to help you store all SQLs which you run in Toad so you have full history of your SQLs. You can open this module in Toad menu -> View -> SQL Recall (F8)

We are saving all your ran statements in Application Data directory of toad. So you can try to remove/move this folder. Go to Help menu -> About -> and click on link label "Application Data Directory". There should be folder "SQLRecall". Try to move this folder out and run Editor again.

Filip

1 Like
3

Hi Filip,

I deleted the JSON files stored in the "SQLRecall" folder and ran the editor again. It works fine now.

Thank you very much.