# Toad for SQL Server aborts

**URL:** <https://forums.toadworld.com/t/toad-for-sql-server-aborts/56471>\
**Category:** Toad for SQL Server\
**Created:** [November 15, 2022, 4:50am UTC](https://forums.toadworld.com/t/toad-for-sql-server-aborts/56471 "2022-11-15T04:50:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jesse.swensen](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@jesse.swensen](https://forums.toadworld.com/u/jesse.swensen)\
**Post date:** [November 15, 2022, 4:50am UTC](https://forums.toadworld.com/t/toad-for-sql-server-aborts/56471/1 "2022-11-15T04:50:24Z")

</div>

I'm using version 7.4. I can launch, log in and review tables, views and stored procedures. But when I run any sql query, or update Toad crashes with the following error:

* * *

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

Stack Trace:  
at Quest.Toad.SQLRecall.SQLRecallItemExtensions.\<\>c\_\_DisplayClass2\_0.b\_\_0(FileStorageItem`1 i) at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate) at Quest.Toad.SQLRecall.SQLRecallItemExtensions.AddItem(JsonFileStorage`1 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()

I would appreciate some direction as to how this might be corrected.

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [November 15, 2022, 8:18pm UTC](https://forums.toadworld.com/t/toad-for-sql-server-aborts/56471/2 "2022-11-15T20:18:27Z")

</div>

Assuming that you're doing nothing more than 1. launching Toad, 2. Connecting to a SQL Server, 3. typing/pasting a valid SQL (in the Editor?), then I'll take a guess here. But let us know if you're doing something in between these steps (like trying to run a previously executed query from SQL Recall). Otherwise...

Judging from the stack trace, I wonder if there's an issue with Windows folder permissions when Toad needs to access/write to the folder that keeps track of your execution history. SQL or scripts that are previously executed are stored as JSON files in the following location by default (unless you changed the install directory, etc.) ...

C:\Users\<_ **yourwinlogname** _\>\AppData\Roaming\Quest Software\Toad for SQL Server 7.4\SQLRecall

If this isn't pointing us to a resolution, I'd suggest opening a Support ticket so Quest can get to the bottom of this for you.

---

<div class="post-metadata">

**Author:** ![jesse.swensen](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@jesse.swensen](https://forums.toadworld.com/u/jesse.swensen)\
**Post date:** [November 16, 2022, 3:52pm UTC](https://forums.toadworld.com/t/toad-for-sql-server-aborts/56471/3 "2022-11-16T15:52:30Z")

</div>

Yes, I was simply entering a query and the query would run but at the end of the work, it would cause this error.  
Digging deeper, I begin to think there was some supporting file causing the problem. So, I completely uninstalled Toad, removed all the folder in the AppData/Roaming folder. After a re-install, things seem to be working again.

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [November 17, 2022, 10:22pm UTC](https://forums.toadworld.com/t/toad-for-sql-server-aborts/56471/4 "2022-11-17T22:22:47Z")

</div>

Glad the re-install got you up and running again!
