ERROR: Object reference not set to an instance of an object.

Hello,

I am trying to create an automation which will export data into an .xlsm spreadsheet which then runs a macro. However, whenever I run my automation I receive an “Object reference not set to an instance of an object” error. This error occurs whether or not I am running a macro after the export. Additionally, none of my colleagues here have this issue; we will perform the exact same steps and I get an error whereas they do not.

I am currently running Toad Data Point 4.1.0.226 (64 bit), which is a newer version than any of my colleagues are running, as far as I know. We are all running Windows 7 Professional. The only difference between my system and theirs is that I am running Microsoft Office 2016, while everybody else uses 2013.

Is there a known export issue with Toad Data Point and the Office 2016?

I have attached the log, set to verbose, but I don’t think it’ll be too helpful.

If anybody could shed some light on how to resolve this, I would be greatly appreciative. We have the ability to revert my Office to 2013, if that might be a solution to this issue.

– 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Setting up environment
– 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Script run by Toad Data Point 4.1.0.226 as jemery on FFC-xxx
– 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Build started
– 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Compiling script
– 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Start CompileWorkflow
– 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Before Compile
– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Return from CompileWorkflow
– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Workflow Compiled without Errors
– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Workflow Compiled has warnings
– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Warning: No Exception Handler. To send an Email when there is an error, change the value of Email on Error to true and enter email values.
– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Build completed
– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Create Workflow instance
– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Started workflow instance
– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Begin execution script activities
– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Variable “ROOT_PATH” set to ‘’
– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Running embedded export template
– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Executing export using connection CompassDB2 (FNDODBCxxxxx) is not XQuery Connection
– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Export_1 - Object reference not set to an instance of an object.

– 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Failed

Thank you,

John

From your description, I’m guessing you found a bug. Better hope somone from Quest looks at this.

John,

Can you run the export template (.txp) flle directly by going to Tools | Export Import | Execute template? if so it should not be an issue with Office 2016.