Loyalty Plus | Loyalty Plus Upload | An Error has occurred while trying to connect to the specified SFTP server using SSH: Private key not found
Version:
2024.10.0.0
Issue:
We have upgraded from IQ version 2024.6.0.0 to version 2024.10.0.0 and the IQ Automation Loyalty Plus uploads stopped working.
When we run the event manually via IQ Automation we are getting the error below.
Why?
IQ made a SSH security change on the event, but never applied the code to the event.
Note: [!]
The problem was logged at IQ and will be rectified in a future version.
This article relates to this Loyalty Plus | Setting up Loyalty.
Steps:
In this knowledge base article we will explain the workaround in how to address the problem.
Navigate to Utilities --> Setup --> Module Parameters (Default Tables).
Click on the Services tab.
Click on the LoyaltyPlus Loyalty Uploads option and click on the Setup button.
Click on the FTP Setup tab.
Followed by clicking on the FTP Server button.
Click on the Loyalty Plus FTP server.
Click on the Edit button.
Make sure that the SSH Authentication is set to Password (Default)
Click on the Test button, if successful you will get a message Test: Successful. (Refer to image 2.)
(Image 2)
Note [!]:
The next steps will require a IQ System Administrator and experienced IQ business partner to perform.
We will need to run a SQL script to delete the previous old Loyalty_Plus_Sales event.
Steps:
Navigate to Utilities --> Tools --> Database Utilities
Copy and paste the SQL in the SQL Query form below:
Note: [!]
We recommend that you make a backup of the IQEvent.* tables.
Also make sure the path is correct of where the Companys folder is located.
"C:\IQRetail64\IQEnterprise\Companys\IQEvents.dat"
SQL script below:
Delete from "C:\IQRetail64\IQEnterprise\Companys\IQEvents.dat"
Where Name = 'IQEVENT_LOYALTYPLUS_SALES'
If the SQL is successful only one record should be impacted.
Once completed close the SQL Query form.
Navigate to Utilities --> Setup --> Module Parameters (Default Tables).
Click on the Services tab.
Click on the LoyaltyPlus Loyalty Uploads option and click on the Setup button.
Click on the Setup Automation Events.
Event Successfully Refreshed message will display.
Navigate to IQ Automation
You will note the new event will appear again.
Test the event again and you will note that the Event has no errors.
This entails that all is working again.
Related Articles
Loyalty Plus | Setting up Loyalty
Customer loyalty is the critical objective of customer relationship management and describes the loyalty that is established between a customer and companies, products, or brands. Great attention is therefore given to marketing and customer service ...Loyalty Plus | Redeeming Loyalty
Your customers can redeem their earned loyalty on purchases made in-store. A customer can pay for an in-store sale, in full or partially, with their earned loyalty. To redeem points click on the Gift Card tender or the tender that has been configured ...Loyalty Plus | WAPPoint Guide
Contents Overview Support Numbers Switching the device On & Off Activating your device for loyalty Authenticate Attendant Landing page - Home Client / Member Enrolment Client / Member Search Earn Points – Capture transaction details Process a ...Loyalty Plus | Debtors | Maintenance | Link number to account
Version: 2024.4.0.0 Question: Can a loyalty plus number be linked to a debtor's account? Answer: Yes, it is now possible in version 2024.4.0.0. Steps: To link a loyalty number to a debtor's account, navigate to Debtors -> Maintenance. Click on the ...Loyalty Plus | Processing | Invoicing
You are able to perform loyalty sales via the Point of Sale Account sales and the Processing Invoicing modules. Navigate to Processing and select Invoicing. Select the customer or debtor. To enter the Loyalty customer click Actions followed by ...