[8.2.9] Remote SFTP trigger - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

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

ErikC
Free support Topic Starter

7 years ago

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:

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:

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:

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:

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.

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

ErikC
Free support Topic Starter

7 years ago

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.

Support
Official support

7 years ago

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!

Rachel P
No customer

6 years ago

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

Support
Official support

6 years ago

Originally Posted by: Rachel P

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!