Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Nov 23, 2022 4:52:15 AM
Aug 9, 2022 2:02:13 AM
QlikView throws the below error while testing the SapSQL Connection:
Connection failed
RfcCommunicationException: The only destination DefaultDestination available failed when retrieving metadata from ESS -- see log for details
Below error found in SAP SQL Connector logs files (C:\ProgramData\QlikTech\Custom Data\QvSAPSqlConnector\Log\)
SqlSapService.OpenConnection() - Using SocketBufferSize:32768
Connection to SAP verified, using sapnco version:3.0.18.0 with SocketBufferSize:32768
Mismatch Error in SapErpConnection.TransportsHaveCorrectVersion(): RfcCommunicationException:The only destination DefaultDestination available failed when retrieving metadata from ESS -- see log for details
The problems above have been caused by the following issues in NCo 3.0.23:
Note:
Microsoft provided the following information:
Install the most recent version of SAP Connector (NCo 3.0) for Microsoft.NET 3.0.25.0 compiled with.NET Framework 4.0 - Windows 64-bit (x64). Previous versions of SAP NCo may encounter the following issues:
The following exception message will be displayed in an older version: 'The only destination <some-GUID> available failed when retrieving metadata from <SAP-system-ID> - see log for details'.
QB-17093