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.