Command Line Backup Error: Process exception > Object reference not set to an instance of an object

Jeff_Salisbury · March 20, 2018, 7:18pm

I’m using an un-released beta version of SQLBackupAndFTP linked in this thread:

I’m new to SQLBackupAndFTP and still in the evaluation phase. I’m trying to get the command line backup to work, but it’s failing with this error:

Process exception > Object reference not set to an instance of an object.

I believe the command line was working until I installed the beta version. Here is my command line:

SqlBak.Job.Cli.exe -runJob -jobName Captools -backupType Full

Is this a bug, or am I not executing the command line properly?

Alexander · March 21, 2018, 11:35am

Hi Jeff,

Thank you for the issue reporting.

To investigate this case we need more details, could you please enable advanced log, reproduce the issue and send logs to developers.

Please find more details on how to do it at https://sqlbackupandftp.com/blog/how-to-send-log-to-developers

Sorry for the inconvenience.

Jeff_Salisbury · March 21, 2018, 1:42pm

Will these procedures capture jobs and processes invoked from the command line?

Jeff_Salisbury · March 21, 2018, 1:49pm

I followed the procedures to sent logs to the developers. Will they be able to match the logs I sent to my description of the problem in this thread?

Jeff_Salisbury · March 22, 2018, 2:20pm

Did you receive the logs I sent?

Alexander · March 22, 2018, 3:00pm

Hi Jeff,

Yes, we received your logs, but they are empty. Could you please make sure that advanced log is enabled, then reproduce the issue, and after the issue is reproduced, please send logs to developers.

Jeff_Salisbury · March 22, 2018, 7:07pm

I double-checked that advanced logging is enabled, then I deleted the logs, then I ran the command line twice:

I then sent the logs to the developers.

Then, I looked at the logs myself. There’s not much there! Here is the log contents:

The two time-stamps corresponding to the two command line executions are:

2018-03-22 12:38:48.6415, and 2018-03-22 12:39:43.9611

Is there anything in these logs that give the developers an idea of the problem?

Alexander · March 23, 2018, 11:15am

Hi Jeff,

Thank you for the logs, we have checked them but it still isn’t enough information.

Could you please save the NLog.config file into the application folder C:\Program Files (x86)\SQLBackupAndFTP, restart “SQLBackupAndFTP (SQL Server backup)” Windows service, run the application and reproduce the issue. After the issue is reproduced please send us all log files from C:\Log\SBF folder.

To download Nlog.config file please follow this link https://www.dropbox.com/s/qsxhu9gz1k0rqf5/NLog.config?dl=0

To make your logs private please send them to support@sqlbackupandftp.com

Sorry for the inconvenience.

Jeff_Salisbury · March 23, 2018, 6:03pm

Hi Alexander,

I followed your instructions and just emailed you the Nlog / SBF folder. I peeked inside the log and it appears to have the relevant job and error information. Please let me know what the developers learn!

Jeff

Alexander · March 26, 2018, 7:18am

Thank you. We’ll check it as soon as we can.

SCS_Support_Team · March 27, 2018, 12:03pm

Hi @Alexander, I’m also seeing the same issue in the last 2 days or so. Would you like logs from me also?

Simon

Alexander · March 27, 2018, 2:13pm

Hi Simon,

Thanks, it’s ok, we are working to fix this issue. It will be fixed in the next release.

Sorry for the inconvenience.

Jeff_Salisbury · March 27, 2018, 9:43pm

Hi Alexander, Do you have an ETA for the next release?

Jeff

Alexander · March 28, 2018, 3:41pm

Hi Jeff,

We plan to release SQLBackupAndFTP version 11.6 till the end of this week.

SCS_Support_Team · March 29, 2018, 3:29pm

Confirmed resolved in 11.6.1

Alexander · March 30, 2018, 7:45am

Good news! Thanks for the feedback.

Please feel free to contact us on any issues or concerns.

Jeff_Salisbury · April 2, 2018, 7:26pm

11.6.1 also worked for us.

Alexander · April 3, 2018, 5:41pm

Good news! Thanks for the feedback.