Community forum

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
Offline ErikC  
#1 Posted : Friday, January 5, 2018 8:17:01 AM(UTC)
ErikC

Rank: Paid support

Joined: 2/26/2008(UTC)
Posts: 1,510
Netherlands
Location: Amsterdam

Thanks: 113 times
Was thanked: 216 time(s) in 185 post(s)
Hi,

I have a connection setup to download files from a SFTP (SSH - Secure Shell) server using a public key as authorisation.
I can access this server using the ftp explorer and download files from it.

I use this connection for a remote file trigger. All trigger settings are default except I cheked the Created file checkbox to watch for new files.
Overnight the job downloaded several files, but than the trigger was inactivated. Looking at the log_server file I saw a lot of trigger errors:
Code:
1/5/2018 1:55:57 AM	Err	Connect->Error connecting: Object reference not set to an instance of an object. (SFTP (SSH - Secure Shell) - connectionname [username@ipnumber])
1/5/2018 1:55:57 AM	Err	UpdateFileListing->Error in Trigger: 'nieuwe file gevonden op de FTP', ex: System.NullReferenceException: Object reference not set to an instance of an object.
   at VisualCronService.RemoteFileAPI.GetRemoteFileList(String strConnectionId, RemoteFileFilterClass rff, VariableReplacerClass VR, ConnectionHandlerClass chIn)
   at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.PJMGPNGGFJGPLJFPIKKEHCDNMAGACLNIEOEN.HPFDFOEFEHIIPICGDDKMELIDHKACPECLEJHG(Boolean  )

I see also normal download behaviour:
Code:
1/5/2018 3:36:58 AM	Info	RemoteFileTrigger->DownloadFile: /20180105_033401_M_D_00007.csv to 
1/5/2018 3:36:58 AM	Info	Job started: jobname
1/5/2018 3:36:58 AM	Info	Task started(FTP/FTPS/SFTP/SCP): Download de gevonden file (26941335)
1/5/2018 3:36:59 AM	Info	Task completed (Success)->'Download de gevonden file' (26941335)
1/5/2018 3:36:59 AM	Info	Task started(Email): Email (26941336)
1/5/2018 3:36:59 AM	Info	Task completed (Success)->'Email' (26941336)
1/5/2018 3:37:00 AM	Info	Job completed (Success)->'jobname'

one other error:
Code:
1/5/2018 6:29:00 AM	Err	Connect->Error connecting: Connection error 10061 (SFTP (SSH - Secure Shell) - connectionname [username@ipnumber])
1/5/2018 6:29:00 AM	Err	UpdateFileListing->Error in Trigger: 'nieuwe file gevonden op de FTP', ex: SBSftpCommon.EElSFTPError: SFTP component not connected
   at SBSftp.TElSftpClient.RequestAbsolutePathSync(String Path)
   at SBSimpleSftp.TElSimpleSFTPClient.RequestAbsolutePath(String Path)
   at VisualCronService.RemoteFileAPI.GetRemoteFileList(String strConnectionId, RemoteFileFilterClass rff, VariableReplacerClass VR, ConnectionHandlerClass chIn)
   at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.PJMGPNGGFJGPLJFPIKKEHCDNMAGACLNIEOEN.HPFDFOEFEHIIPICGDDKMELIDHKACPECLEJHG(Boolean  )

This last error repeats itself every 5-6 seconds and after a while I see:
Code:
1/5/2018 6:33:09 AM	Err	Unhandled exception occured in Remote file Trigger: SFTP component not connected
1/5/2018 6:33:09 AM	Err	Trigger error: SFTP component not connected
1/5/2018 6:33:09 AM	Debug	Trigger was expired and inactivated

To my knowledge the server was up all night.
What is happening here?

Regards,
Erik
Uses Visualcron since 2006.
Offline ErikC  
#2 Posted : Friday, January 5, 2018 9:24:41 AM(UTC)
ErikC

Rank: Paid support

Joined: 2/26/2008(UTC)
Posts: 1,510
Netherlands
Location: Amsterdam

Thanks: 113 times
Was thanked: 216 time(s) in 185 post(s)
I received a notice that the SFTP server was indeed not reachable at the time period of my error around 06:30u so the trigger inactivation was ok.
Only the 1st error with the nullreference in the post is unknown for me.

Regards
Erik
Uses Visualcron since 2006.
Offline Support  
#3 Posted : Friday, January 5, 2018 9:31:39 AM(UTC)
Support

Rank: Official support

Joined: 2/23/2008(UTC)
Posts: 11,157

Thanks: 864 times
Was thanked: 440 time(s) in 418 post(s)
Hi Erik,

are you able to test this with a newer version? We released 8.3.2 today.
Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!
Offline Rachel P  
#4 Posted : Tuesday, June 11, 2019 9:24:11 PM(UTC)
Rachel P

Rank: Paid support

Joined: 8/7/2015(UTC)
Posts: 1
United States
Location: California, Geyserville

Hello,
I'm on VisualCron 8.3.4 and I'm receiving a similar error with an FTPS task. It occassionally fails with the message:

"SSL Error: 75777, Fatal: True, Remote: False
Exception in Task: Error (6) downloading file(s): shipconfirm_201906101711405.xml, err: Object reference not set to an instance of an object."

It has failed three times in the last 4 days. The vendor has said there are no errors on their side and no other clients are complaining -- they have lots of connections at the same time.

How can I troubleshoot this error?

Thanks,
Rachel
Offline Support  
#5 Posted : Wednesday, June 12, 2019 10:38:02 AM(UTC)
Support

Rank: Official support

Joined: 2/23/2008(UTC)
Posts: 11,157

Thanks: 864 times
Was thanked: 440 time(s) in 418 post(s)
Originally Posted by: Rachel P Go to Quoted Post
Hello,
I'm on VisualCron 8.3.4 and I'm receiving a similar error with an FTPS task. It occassionally fails with the message:

"SSL Error: 75777, Fatal: True, Remote: False
Exception in Task: Error (6) downloading file(s): shipconfirm_201906101711405.xml, err: Object reference not set to an instance of an object."

It has failed three times in the last 4 days. The vendor has said there are no errors on their side and no other clients are complaining -- they have lots of connections at the same time.

How can I troubleshoot this error?

Thanks,
Rachel


Please update your email to official one so we can connect the support to a company.
Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!
Users browsing this topic
Guest
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 cannot create polls in this forum.
You cannot vote in polls in this forum.

Scroll to Top