# System.NullReferenceException error

**URL:** <https://forums.toadworld.com/t/system-nullreferenceexception-error/6730>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [July 8, 2011, 12:58pm UTC](https://forums.toadworld.com/t/system-nullreferenceexception-error/6730 "2011-07-08T12:58:40Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![john.park\_750](https://avatars.discourse-cdn.com/v4/letter/j/7feea3/32.png) [@john.park\_750](https://forums.toadworld.com/u/john.park_750)\
**Post date:** [July 8, 2011, 12:58pm UTC](https://forums.toadworld.com/t/system-nullreferenceexception-error/6730/1 "2011-07-08T12:58:40Z")

</div>

I have several critical schedule jobs and this unknown error frequently causes scheduled jobs from completing.

Can someone help with following error:

THanks.  
John

---

<div class="post-metadata">

**Author:** ![john.park\_750](https://avatars.discourse-cdn.com/v4/letter/j/7feea3/32.png) [@john.park\_750](https://forums.toadworld.com/u/john.park_750)\
**Post date:** [July 8, 2011, 1:06pm UTC](https://forums.toadworld.com/t/system-nullreferenceexception-error/6730/2 "2011-07-08T13:06:33Z")

</div>

Here is the screenshot.  
 ![TDA_Error.png](https://global.discourse-cdn.com/quest/original/2X/5/5bf1391f58aad61f4ac17e4b2edf6533daae2ee0.png)

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [July 8, 2011, 1:35pm UTC](https://forums.toadworld.com/t/system-nullreferenceexception-error/6730/3 "2011-07-08T13:35:53Z")

</div>

I have several questions:

1. What TDA automation activity is having an issue when this error occurs?
2. What is the connection in the Query Builder file? What is the connection in the parent connection? Are they the same?
3. Try taking the SQL out of the Query Builder file and putting into \*.sql file and using in automation script. Does this change things?

If the above does not lead to a solution please run script with verbose logging and send me the log file, automation script and query builder file.

Debbie

---

<div class="post-metadata">

**Author:** ![john.park\_750](https://avatars.discourse-cdn.com/v4/letter/j/7feea3/32.png) [@john.park\_750](https://forums.toadworld.com/u/john.park_750)\
**Post date:** [July 8, 2011, 3:27pm UTC](https://forums.toadworld.com/t/system-nullreferenceexception-error/6730/4 "2011-07-08T15:27:51Z")

</div>

Debbie,

Here are my responses.

1. What TDA automation activity is having an issue when this error occurs?  
--I don't know what specific activity causes this error, it suddenly appears periodically throughout the day. Where can I look to find what is triggering this?

2. What is the connection in the Query Builder file? What is the connection in the parent connection? Are they the same?  
--This is a connection to Oracle database. I'm attaching a screenshot.

3. Try taking the SQL out of the Query Builder file and putting into \*.sql file and using in automation script. Does this change things?  
--All scheduled .tas programs are already executing .sql files. Second attachment.

Since I don't know what is causing this error message, what can I provide to diagnose this?

Thanks for your attention.  
John

 ![TDA_Connection.png](https://global.discourse-cdn.com/quest/original/2X/b/b593838812e523eafe3fe2beec9a96514966a1a2.png)

---

<div class="post-metadata">

**Author:** ![john.park\_750](https://avatars.discourse-cdn.com/v4/letter/j/7feea3/32.png) [@john.park\_750](https://forums.toadworld.com/u/john.park_750)\
**Post date:** [July 8, 2011, 3:27pm UTC](https://forums.toadworld.com/t/system-nullreferenceexception-error/6730/5 "2011-07-08T15:27:51Z")

</div>

Debbie,

Here are my responses.

1. What TDA automation activity is having an issue when this error occurs?  
--I don't know what specific activity causes this error, it suddenly appears periodically throughout the day. Where can I look to find what is triggering this?

2. What is the connection in the Query Builder file? What is the connection in the parent connection? Are they the same?  
--This is a connection to Oracle database. I'm attaching a screenshot.

3. Try taking the SQL out of the Query Builder file and putting into \*.sql file and using in automation script. Does this change things?  
--All scheduled .tas programs are already executing .sql files. Second attachment.

Since I don't know what is causing this error message, what can I provide to diagnose this?

Thanks for your attention.  
John

 ![TDA_sql.png](https://global.discourse-cdn.com/quest/original/2X/2/2bee2c7e2012117bf423358eed069b95d70b5d17.png)

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [July 8, 2011, 5:06pm UTC](https://forums.toadworld.com/t/system-nullreferenceexception-error/6730/6 "2011-07-08T17:06:02Z")

</div>

I have one user who gets a similiar error. We solved this by adding a database connection at the top of the script. Try this out and if that does not solve please send me a verbose log file of output.

Debbie