Qlik Talend Cloud fails to find endpoint type SAPExtractor

[Bill_Steinagle]

Qlik Talend Cloud establishing a connection to SAP using the Extractor Endpoint fails with:

Status(StatusCode="Internal", Detail="SYS-E-HTTPFAIL, Failed to load dynamic endpoint properties. SYS,GENERAL_EXCEPTION,Failed to load dynamic endpoint properties,Failed to find endpoint type 'SAPExtractor' from endpoint server 'Local' Failed to find endpoint type 'SAPExtractor' from endpoint server 'Local' XXXX, HTTP request failed, Failed to connect using Data Movement gateway local_repsrv. Verify the status in Management Console > Data gateways is "Connected" and then retry the operation."). 

Resolution

1. Stop the Gateway server:
   

   systemctl stop repagent

2. Download the SAP Java Connector 3.x (64-bit) for Linux from https://support.sap.com/en/product/connectors/jco.html
3. Unzip the file. It includes the required sapjco3.jar and libsapjco3.so files.
4. Install the Java connector into the Gateway Server by manually copying the Sapjco3.jar and libsapjco3.so files to the /opt/qlik/gateway/movement/endpoint_srv/endpoints/SAP directory
5. Once the files have been copied, start the Gateway server:
   1. Verify you are root using:

      sudo su 

   2. Run the command:
      

      systemctl start repagent

6. Confirm the Gateway Server is up using the below command and example output:
   

   systemctl status repagent
   

   repagent.service - Qlik Data Gateway - Data Movement
   Loaded: loaded (/etc/systemd/system/repagent.service; enabled; vendor preset: disabled)  Active: active (running) since Tue 2025-03-25 14:18:57 GMT; 11min ago
   Process: 176787 ExecStop=/opt/qlik/gateway/movement/bin/repagent stop (code=exited, status=0/SUCCESS)
   Process: 176944 ExecStart=/opt/qlik/gateway/movement/bin/repagent start (code=exited, status=0/SUCCESS)
   Main PID: 177014 (agentctl)
   Tasks: 0 (limit: 49025)
   Memory: 28.0K
   CGroup: /system.slice/repagent.service
         ‣ 177014 /opt/qlik/gateway/movement/bin/agentctl -d /opt/qlik/gateway/movement/data service host -b
   Mar 25 14:18:53 RHEL8.domain.local systemd[1]: Starting Qlik Data Gateway - Data Movement...
   Mar 25 14:18:53 RHEL8.domain.local su[176967]: (to qlik) root on none
   Mar 25 14:18:53 RHEL8.domain.local su[176967]: pam_unix(su-l:session): session opened for user qlik by (uid=0)
   Mar 25 14:18:57 RHEL8.domain.local su[176967]: pam_unix(su-l:session): session closed for user qlik
   Mar 25 14:18:57 RHEL8.domain.local systemd[1]: Started Qlik Data Gateway - Data Movement.

Cause

Missing Sapjco3.jar and libsapjco3.so files in the /opt/qlik/gateway/movement/endpoint_srv/endpoints/SAP directory. 

Internal Investigation ID(s)

CC-16456

Environment

• Qlik Replicate