Qlik Replicate: One or more Endpoint Servers cannot be reached after licensing new endpoint

[Steve_Nguyen]

After licensing a new Qlik Replicate Endpoint that requires an Endpoint Server (such as Salesforce, MongoDB, BigQuery) one or more Endpoint Servers cannot be reached. 

The message One or more Endpoint Servers cannot be reached is displayed and the individual servers are listed as disconnected in the status column.

Resolution

1. Stop:
   • All running tasks
   • The Qlik Replicate Server or Attunity Replicate Server service
   • The Qlik Replicate UI Server services
     
     
2. Verify that the endpoint server java.exe is not running:
   1. Open your Windows Task Manager
   2. Switch to Details
   3. Search for java.exe
      
      
      
      
   4. If you can locate the java.exe running, right-click and terminate it
      
      
3. Open a cmd.exe window as Administrator 
   
   
4. Change to the Qlik Replicate bin directory. Default: C:\Program Files\Attunity\Replicate\bin
   
   
5. In the cmd.exe window, run:
   

   ~\bin>repctl -d "D:\attuntity\replicate\data" exportrepository​

   Note: "D:\attunity\replicate\data"  is an example of the data folder location.
   
   
6. This will create the following file:
   
   $QLIK_REPLICATE_INSTALL_ROOT\data\imports\Replication_Definition.json​
   
   
7. Open the Replication_Definition.json in a text editor and look for the section for the Local Endpoint Server.
   
   Example of the section: 
   

      "endpoint_servers": [{
              "name": "Local",
              "host": "localhost",
              "port": 3560,
              "password": "{ZASomeRandomLettersAndNumbersHereXXXXXXXXXXXXXXXXXXX}",
              ...
          }]
   ​

8. Edit the password for that section, by changing it to say:

      "endpoint_servers": [{
              "name": "Local",
              "host": "localhost",
              "port": 3560,
              "password": "password",
              ...
          }]

9. In the cmd.exe window, run: 
   

   repctl -d "D:\attunity\replicate\data" importrepository json_file=Replication_Definition.json​

10. In Windows file explorer, rename the folder:
    $QLIK_REPLICATE_INSTALL_ROOT\data\endpoint_srv\data to data_old
    
11. Start the Qlik Replicate Server or Attunity Replicate Server and Qlik Replicate UI Server services.
    
    

12. Log back into the Qlik Replicate console and verify that your local endpoint server reports as running in the status column. 

Environment

Qlik Replicate 7.0 and later