Notice:
The work below should be performed by a qualified IQ Business Partner/Advisor.
Alternatively you can contact Implement Pty Ltd to assist with the request, but please note that is a billable function.
Contact details below:
Phone: 021 300 5776
E-Mail: support@implement.co.za
Version:
2024.10.0.0
Issue:
We have upgraded to version 2024.10.0.0 and since the upgrade all our FTP events does not work on IQ Automation.
We are getting the following error when the event tries to execute:
An Error has occurred while trying to connect to the specified SFTP server using SSH: Private key not found 1/1.
Technical explanation:
A new column SSHAuthType was added to the IQFTPSetup table.
When creating a new FTP event the SSHAuthType is 1.
However existing FTP events will have a blank value in them as the IQUpgrade program did not accomodate for them.
This you would need to update to 1.
The problem was reported to IQ and it will be addressed in future.
Resolution:
Login as an Administrator in IQ.
Navigate to Utilities --> Tools --> Database Utilities
Copy and paste the SQL script below to the empty space, like the below screenshot.
Just note make sure of the path where the Companys folder database is located.
Marked in yellow is what the path should be.
update "E:\IQRetail\IQEnterprise\companys\IQFTPSetup" set SSHAuthType = 1
Where SSHAuthType is null
Click on the Run SQL button.
Once completed test your IQ FTP event again.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article