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

[kartik_patel]

Hi @Steve_Nguyen , @Sonja_Bauernfeind ,

This solution is working on only one Node, when Qlik Replicate is hosted on the HA cluster then only one node is working and when we apply this solution then it will working on another node but stop working on previous node. For e.g. Node 1 where mongo db endpoint is working and node 2 is not working, and we have applied this solution on node 2 then it will start working but node 1 is stopped working. Also, when we have tried again same step on node 1 then it will start working on node 1 but stopped working on node 2. Are there any solutions where we can configure to run on both nodes.

We are running Qlik Replicate 2023.11.0.282 version.

[Dana_Baldwin]

Hi @kartik_patel 

In the high availability cluster configuration, only one node can be active and running Qlik Replicate at a time. The data folder is shared between the nodes.

Thanks,

Dana

[kartik_patel]

Hi @Dana_Baldwin ,

Thanks for your response. I agree in HA only one node will be active at a time but when we do switch over from active node to passive node (as active) that time we need to do all this steps mentioned above because It will not pickup the MongoDB Endpoint automatically when we are doing the switch over.

Are there any ways to automatically enable the MongoDB Endpoint when we do switch over without performed above steps.

Thanks,
Kartik Patel

[Dana_Baldwin]

Hi @kartik_patel 

You should not need to perform this on each node as the repository is stored in the data directory which should be shared by the two cluster nodes. It sounds like the cluster is not set up properly, like each node has its own data directory - this will not work.

Please verify per our documentation here, and if you are still having trouble please open a support case:

Setting up Qlik Replicate in a cluster environment #Setting up Qlik Replicate in a cluster environme...

Thanks,

Dana