Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
WARNING: Object reference not set to an instance of an object. Options · View
domain.contact
#1 Posted : Monday, January 9, 2017 9:01:15 AM
Rank: Newbie

Groups: Registered

Joined: 12/6/2016
Posts: 6
Location: Cleveland Ohio
**SOME NAMES AND IP'S REMOVED FROM BELOW LOG**

My backups to SFTP are successful but I get this error in the log.


SqlBackupAndFtp 10.2.5.30859 Professional (run as service) at BOSS-SQL (Microsoft Windows NT 6.1.7601 Service Pack 1) (.NET: 2.0.50727.5420, 3.0.30729.5420, 3.5.30729.5420, 4.5.50709, 4.0.0.0) Job name: C:\Users\administrator\Documents\default.jobx

SUMMARY:
Database BOSS: Folder - Success, FTP - Success

DETAILED LOG:
01/09/2017 08:00:12 Executing custom SQL script
01/09/2017 08:30:14 Custom SQL script has been successfully executed
01/09/2017 08:30:14 Creating backup of BOSS to C:\arrow\sqlbackuptemp\Pranas.NET\SQLBackupAndFTP\yyw4lsm2 (differential)
01/09/2017 08:37:08 Compressing (7-zip zip, Level: Normal) BOSS201701090830diff.bak (Size: 14,026,036 KB) to C:\**\sqlbackuptemp\Pranas.NET\SQLBackupAndFTP\yyw4lsm2
01/09/2017 09:10:11 Compression completed (archive: "BOSS201701090830diff.zip", size: 1,389,179 KB)
01/09/2017 09:10:11 Connecting to
01/09/2017 09:10:12 Uploading BOSS201701090830diff.zip to (BOSS\BOSS201701090830diff.zip)
01/09/2017 09:10:31 Remote file size has been successfully verified
01/09/2017 09:10:31 Disconnecting from
01/09/2017 09:10:32 Connecting to SFTP:
01/09/2017 09:10:34 Uploading BOSS201701090830diff.zip to SFTP: (BOSS/BOSS201701090830diff.zip)
01/09/2017 09:12:43 Remote file size has been successfully verified
01/09/2017 09:12:43 Disconnecting from
01/09/2017 09:12:43 Removing BOSS201701090830diff.zip from C:\arrow\sqlbackuptemp\Pranas.NET\SQLBackupAndFTP\yyw4lsm2
01/09/2017 09:12:43 Delete temporary folder: "C:\**\sqlbackuptemp\Pranas.NET\SQLBackupAndFTP\yyw4lsm2"
01/09/2017 09:12:43 Cleaning
01/09/2017 09:12:43 Connecting to
01/09/2017 09:12:43 Cleaning subfolder: BOSS
01/09/2017 09:12:44 Disconnecting from
01/09/2017 09:12:44 Cleaning SFTP:
01/09/2017 09:12:44 Connecting to SFTP:
01/09/2017 09:12:44 Cleaning subfolder: BOSS
01/09/2017 09:12:44 Disconnecting from
01/09/2017 09:12:44 WARNING: Object reference not set to an instance of an object.
01/09/2017 09:12:45 Trying again...
01/09/2017 09:12:45 Job finished
Alexander Omelchenko
#2 Posted : Monday, January 9, 2017 10:02:13 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 348
Thank you for the detailed log.

To solve this issue, please provide us more information. Could you please save the attached NLog.config file into the application's folder: C:\Program Files (x86)\Pranas.NET\SQLBackupAndFTP, restart SQLBackupAndFTP application, run the backup job again, and send us all files from C:\Log\SBF folder after this warning.

File Attachment(s):
NLog.rar (1kb) downloaded 4 time(s).
domain.contact
#3 Posted : Monday, January 9, 2017 10:14:16 AM
Rank: Newbie

Groups: Registered

Joined: 12/6/2016
Posts: 6
Location: Cleveland Ohio
Will do.
domain.contact
#4 Posted : Monday, January 9, 2017 12:55:35 PM
Rank: Newbie

Groups: Registered

Joined: 12/6/2016
Posts: 6
Location: Cleveland Ohio
How do I send you the log? There is just a check box below that says Attach files to this post. But no way to pick or drag/drop the file.
File Attachment(s):
SBF.zip (5kb) downloaded 3 time(s).
domain.contact
#5 Posted : Monday, January 9, 2017 12:56:53 PM
Rank: Newbie

Groups: Registered

Joined: 12/6/2016
Posts: 6
Location: Cleveland Ohio
Figured it out.
Alexander Omelchenko
#6 Posted : Tuesday, January 10, 2017 9:56:36 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 348
Thanks for the log file, we have checked it. It seems it was a temporary network issue. Could you please clarify do you get a success backup job as a result?

Also, please note we are going to release a new version where we have applied a new method of work with SFTP.
domain.contact
#7 Posted : Tuesday, January 10, 2017 10:35:43 AM
Rank: Newbie

Groups: Registered

Joined: 12/6/2016
Posts: 6
Location: Cleveland Ohio
Yes I do get a successful backup.

When is new version?
Alexander Omelchenko
#8 Posted : Wednesday, January 11, 2017 1:36:41 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 348
Great!

Sorry but we cannot promise the date of release.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com