Qlik Data Gateway and SAP BW & SAP SQL: Error: No node supports data source sap-bw (registered datasources: 20)) (DirectAccess-2507)")

[Caterina_Fruci]

After upgrading Direct Access Qlik Data Gateway to version 1.2.0 to access SAP (SAP BW & SAP SQL), the connection fails with the following error: 

"Status(StatusCode="Internal", Detail="Error executing command:. connectiontest: ConnectorServiceLookupError(1101 - error retrieving node to service the command: sap-bw: Error: No node supports data source sap-bw (registered datasources: 20)) (DirectAccess-2507)")"

Resolution

1. On the Windows host running the Data Gateway, go to C:\Program Files\Qlik\ConnectorAgent\dcaas_gs\StartDcaaS.bat
   
   
2. Open and modify StartDcaaS.bat file
   
   
3. Locate the line:
   
   set CONNECTOR_SERVICE=localhost:50060
   
   
4. Modify it to:
   
   set CONNECTOR_SERVICE=localhost:50060 localhost:50070 localhost:50080
   
   
5. Verify that SAP NetWeaver RFC SDK is installed on the gateway server: Installing SAP NetWeaver RFC SDK for Qlik Data Gateway - Direct Access
   
   
6. Reboot the Gateway Server.

 

Related Content 

Qlik Data Gateway SAP connection failure: Unable to load DLL 'sapnwrfc' or one of its dependencies 
Supported data sources: SAP BW and SAP SQL sources. Requires Direct Access gateway 1.2.0 or later.

Environment

Qlik Data Gateway  
SAP BW and SAP SQL sources