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


Aaron LaRose
2023-02-07T23:12:01Z
Attempting to create an SFTP connection using a PRIVATE key. I set it up as follows:

1. selected SFTP (SSH - Secure Shell) as type
2. put the address as it was given to me. Port is 22
3. under credentials, used Public Key (does it matter that this is a private key, b/c this may be just bad naming convention)
4. Set username given
5. selected the .ppk that I uploaded under SSH keys.

Test gives the error "A non-recoverable error occurred during a database lookup" and does not connect. Windows SAYS connected, but I don't get a folder view on the right half, and I cannot transfer any files.

I am able to connect to this site using WinSCP.

The log of the connection attempt is below. I replaced the actual user name and server name with the words USERNAME and SERVER.

5:06:59 PM: Connecting (5)
5:06:59 PM: ConnectThread->Setting basic connection settings (5)
5:06:59 PM: ConnectThread->Setting authentication (5)
5:06:59 PM: ConnectThread->Setting proxy (5)
5:06:59 PM: Connect->ObjectDumper: LastSyncComment=null
5:06:59 PM: Connect->ObjectDumper: LastSyncError=0
5:06:59 PM: Connect->ObjectDumper: NewLineConvention=System.Byte[]
5:06:59 PM: Connect->ObjectDumper: LocalNewLineConvention=System.Byte[]
5:06:59 PM: Connect->ObjectDumper: SFTPExt=SBSftpCommon.TSBSftpExtendedAttribute[]
5:06:59 PM: Connect->ObjectDumper: Version=0
5:06:59 PM: Connect->ObjectDumper: ExtendedProperties=SBSftpCommon.TElSftpExtendedProperties
5:06:59 PM: Connect->ObjectDumper: TotalBytesSent=0
5:06:59 PM: Connect->ObjectDumper: TotalBytesReceived=0
5:06:59 PM: Connect->ObjectDumper: SecondaryChannelExitStatus=0
5:06:59 PM: Connect->ObjectDumper: SecondaryChannelExitSignal=null
5:06:59 PM: Connect->ObjectDumper: SecondaryChannelExitMessage=null
5:06:59 PM: Connect->ObjectDumper: ASCIIMode=False
5:07:00 PM: Connect->ObjectDumper: FileSystemAdapter=null
5:07:00 PM: Connect->ObjectDumper: CopyEmptyDirs=False
5:07:00 PM: Connect->ObjectDumper: DeleteFailedDownloads=False
5:07:00 PM: Connect->ObjectDumper: EarlyIdString=False
5:07:00 PM: Connect->ObjectDumper: SftpBufferSize=131072
5:07:00 PM: Connect->ObjectDumper: Versions=124
5:07:00 PM: Connect->ObjectDumper: AutoAdjustTransferBlock=True
5:07:00 PM: Connect->ObjectDumper: PipelineLength=32
5:07:00 PM: Connect->ObjectDumper: DownloadBlockSize=8192
5:07:00 PM: Connect->ObjectDumper: UploadBlockSize=32768
5:07:00 PM: Connect->ObjectDumper: DefaultTransferBlock=0
5:07:00 PM: Connect->ObjectDumper: UseUTF8=True
5:07:00 PM: Connect->ObjectDumper: UseUTF8OnV3=False
5:07:00 PM: Connect->ObjectDumper: RemoteCharset=
5:07:00 PM: Connect->ObjectDumper: OperationErrorHandling=oehTryAllItems
5:07:00 PM: Connect->ObjectDumper: KeepAlivePeriod=90000
5:07:00 PM: Connect->ObjectDumper: ThreadSafe=True
5:07:00 PM: Connect->ObjectDumper: AdjustFileTimes=False
5:07:00 PM: Connect->ObjectDumper: PreserveExistingFileTimes=False
5:07:00 PM: Connect->ObjectDumper: UseTruncateFlagOnUpload=True
5:07:00 PM: Connect->ObjectDumper: TreatZeroSizeAsUndefined=True
5:07:00 PM: Connect->ObjectDumper: SFTPServerExecutableLocations=SBStringList.TElStringList
5:07:00 PM: Connect->ObjectDumper: Address=USERNAME@secureftp.SERVER.net
5:07:00 PM: Connect->ObjectDumper: Port=22
5:07:00 PM: Connect->ObjectDumper: ServerSoftwareName=
5:07:00 PM: Connect->ObjectDumper: ServerCloseReason=null
5:07:00 PM: Connect->ObjectDumper: EncryptionAlgorithmServerToClient=0
5:07:00 PM: Connect->ObjectDumper: EncryptionAlgorithmClientToServer=0
5:07:00 PM: Connect->ObjectDumper: CompressionAlgorithmServerToClient=0
5:07:00 PM: Connect->ObjectDumper: CompressionAlgorithmClientToServer=0
5:07:00 PM: Connect->ObjectDumper: MacAlgorithmServerToClient=0
5:07:00 PM: Connect->ObjectDumper: MacAlgorithmClientToServer=0
5:07:00 PM: Connect->ObjectDumper: KexAlgorithm=0
5:07:00 PM: Connect->ObjectDumper: PublicKeyAlgorithm=0
5:07:00 PM: Connect->ObjectDumper: KeyStorage=SBSSHKeyStorage.TElSSHMemoryKeyStorage
5:07:00 PM: Connect->ObjectDumper: KbdIntName=null
5:07:00 PM: Connect->ObjectDumper: KbdIntInstruction=null
5:07:00 PM: Connect->ObjectDumper: ServerKey=SBSSHKeyStorage.TElSSHKey
5:07:00 PM: Connect->ObjectDumper: ErrorString=null
5:07:00 PM: Connect->ObjectDumper: InternalSocket=SBSocket.TElSocket
5:07:00 PM: Connect->ObjectDumper: GSSMechanism=null
5:07:00 PM: Connect->ObjectDumper: GSSHostName=
5:07:00 PM: Connect->ObjectDumper: GSSDelegateCredentials=False
5:07:00 PM: Connect->ObjectDumper: AuthenticationTypes=6
5:07:00 PM: Connect->ObjectDumper: ClientHostname=
5:07:00 PM: Connect->ObjectDumper: ClientUsername=
5:07:00 PM: Connect->ObjectDumper: CompressionLevel=6
5:07:00 PM: Connect->ObjectDumper: ForceCompression=False
5:07:00 PM: Connect->ObjectDumper: SoftwareName=SecureBlackbox 20.0.8210.0
5:07:00 PM: Connect->ObjectDumper: Username=USERNAME
5:07:00 PM: Connect->ObjectDumper: RequestPasswordChange=False
5:07:00 PM: Connect->ObjectDumper: TrustedKeys=null
5:07:00 PM: Connect->ObjectDumper: CryptoProviderManager=null
5:07:00 PM: Connect->ObjectDumper: DefaultWindowSize=2048000
5:07:00 PM: Connect->ObjectDumper: MinWindowSize=2048
5:07:00 PM: Connect->ObjectDumper: MaxSSHPacketSize=262144
5:07:00 PM: Connect->ObjectDumper: CommandTimeout=60000
5:07:00 PM: Connect->ObjectDumper: SSHAuthOrder=aoDefault
5:07:00 PM: Connect->ObjectDumper: CertAuthMode=camAuto
5:07:00 PM: Connect->ObjectDumper: AutoAdjustCiphers=True
5:07:00 PM: Connect->ObjectDumper: ObfuscateHandshake=False
5:07:00 PM: Connect->ObjectDumper: ObfuscationPassword=
5:07:00 PM: Connect->ObjectDumper: CustomEncoding=null
5:07:00 PM: Connect->ObjectDumper: AuthAttempts=1
5:07:00 PM: Connect->ObjectDumper: UseInternalSocket=True
5:07:00 PM: Connect->ObjectDumper: RemoteHost=xn--USERNAME@secureftp-.SERVER.net
5:07:00 PM: Connect->ObjectDumper: Active=False
5:07:00 PM: Connect->ObjectDumper: WebTunnelResult=0
5:07:00 PM: Connect->ObjectDumper: ProxyResult=0
5:07:00 PM: Connect->ObjectDumper: UsingIPv6=False
5:07:00 PM: Connect->ObjectDumper: SocketSettings=SBSocket.TElSocketSettings
5:07:00 PM: Connect->ObjectDumper: SocketBinding=SBSocket.TElClientSocketBinding
5:07:00 PM: Connect->ObjectDumper: SocketTimeout=60000
5:07:00 PM: Connect->ObjectDumper: LocalAddress=
5:07:00 PM: Connect->ObjectDumper: LocalPort=0
5:07:00 PM: Connect->ObjectDumper: IncomingSpeedLimit=0
5:07:00 PM: Connect->ObjectDumper: OutgoingSpeedLimit=0
5:07:00 PM: Connect->ObjectDumper: UseIPv6=False
5:07:00 PM: Connect->ObjectDumper: SocksAuthentication=0
5:07:00 PM: Connect->ObjectDumper: SocksPassword=
5:07:00 PM: Connect->ObjectDumper: SocksPort=1080
5:07:00 PM: Connect->ObjectDumper: SocksResolveAddress=False
5:07:00 PM: Connect->ObjectDumper: SocksServer=null
5:07:00 PM: Connect->ObjectDumper: SocksUserCode=
5:07:00 PM: Connect->ObjectDumper: SocksVersion=1
5:07:00 PM: Connect->ObjectDumper: SocksUseIPv6=False
5:07:01 PM: Connect->ObjectDumper: UseSocks=False
5:07:01 PM: Connect->ObjectDumper: UseWebTunneling=False
5:07:01 PM: Connect->ObjectDumper: WebTunnelAddress=null
5:07:01 PM: Connect->ObjectDumper: WebTunnelAuthentication=0
5:07:01 PM: Connect->ObjectDumper: WebTunnelPassword=null
5:07:01 PM: Connect->ObjectDumper: WebTunnelPort=3128
5:07:01 PM: Connect->ObjectDumper: WebTunnelUserId=null
5:07:01 PM: Connect->ObjectDumper: WebTunnelRequestHeaders=SBStringList.TElStringList
5:07:01 PM: Connect->ObjectDumper: WebTunnelResponseHeaders=SBStringList.TElStringList
5:07:01 PM: Connect->ObjectDumper: WebTunnelResponseBody=
5:07:01 PM: Connect->ObjectDumper: PortKnock=null
5:07:01 PM: Connect->ObjectDumper: DNS=SBSocket.TElDNSSettings
5:07:01 PM: Connect->ObjectDumper: RuntimeLicense=53424E4641444E585246323032343037323131575041313735310000000000000000000000000000433759554D53303700005545473438325252335045440000
5:07:01 PM: Connect->ObjectDumper: Tag=null
5:07:01 PM: Connect->ObjectDumper: InternalObjectID=5Xd68gWQ
5:07:01 PM: Connect->ObjectDumper: IsDisposed=False
5:07:01 PM: Connect->ObjectDumper: Site=null
5:07:01 PM: Connect->ObjectDumper: Container=null
5:07:01 PM: ConnectThread->Before Open (5)
5:07:01 PM: Server software name: ''
5:07:01 PM: EncryptionAlgorithmClientToServer: '3des-cbc'
5:07:01 PM: EncryptionAlgoritmServerToClient: '3des-cbc'
5:07:01 PM: MacAlgorithmClientToServer: 'hmac-sha1'
5:07:01 PM: MacAlgorithmServerToClient: 'hmac-sha1'
5:07:01 PM: KexAlgorithm: 'diffie-hellman-group-exchange-sha1'
5:07:01 PM: A non-recoverable error occurred during a database lookup
Sponsor
Forum information
Rachel Gomez
2023-03-13T05:00:47Z
Message :Failed to rename the temp file. Your SFTP server doesn't support renaming temp file, set "useTempFileRename" as false in copy sink to disable uploading to temp file.

Cause : Your SFTP server doesn't support renaming the temp file.

Recommendation : Set "useTempFileRename" as false in the copy sink to disable uploading to the temp file.

Regards,
Rachel Gomez
Scroll to Top