S4Hana 2021 with SQL connector

[Barranco89]

Hi all,

After an upgrade, we are using S4Hana 2021 (SAP basis 7.56, SP2) with Sql connector 7.0.3/7.0.4, it is right? or we have to update to 8.0.1 connectors? we are getting this connection error:

14:48:19,779 [1] - Error in SQLConnectorSourceConnection.TestConnect()

System.Exception: RfcCommunicationException:The only destination DefaultDestination available failed when retrieving metadata from DS2 -- see log for details ---> SAP.Middleware.Connector.RfcCommunicationException: The only destination DefaultDestination available failed when retrieving metadata from DS2 -- see log for details

   at SAP.Middleware.Connector.RfcRepository.findAlternateDestination(Int32& destIndex, Int32& alternativeDestinationsCount, Exception ex)

   at SAP.Middleware.Connector.RfcRepository.Execute(RfcFunction function)

   at SAP.Middleware.Connector.RfcRepository.LookupFunctionMetadataNew(String name)

   at SAP.Middleware.Connector.RfcRepository.LookupFunctionMetadata(String name)

   at SAP.Middleware.Connector.RfcRepository.GetFunctionMetadata(String name)

   at SAP.Middleware.Connector.RfcRepository.CreateFunction(String name)

   at Qlik.Connectors.SAP.SapErpConnection.TransportsHaveCorrectVersion(String connectorClient, Int32& transportReleaseVersion, String& systemId, Int32& sapBasis, Nullable`1& sapBasisServicePackLevel, Boolean throwIfMismatch)

   at Qlik.Connectors.SAP.SapBaseConnection.TestConnection(String connectorClient)

   --- End of inner exception stack trace ---

   at Qlik.Connectors.SAP.SapBaseConnection.TestConnection(String connectorClient)

   at Qlik.Connectors.SQL.SQLConnectorSourceConnection.TestConnect(String& message, String& detailMessage)

14:48:19,779 [1] - Teardown Connection

Thanks in advance.

Regards,

Antonio

[Lukas-FW]

Hi together,

we have the same problem with S4 2021 FPS02 an SQL Connector 7.0.3. 
What was the solution in your case?

Thanks in advance

Regards,

Lukas

[SankarReddyK · Accepted solution]

Hi @Barranco89 @Lukas-FW , Please refer to the article https://community.qlik.com/t5/Official-Support-Articles/Qlik-SAP-SQL-connection-failed-with-an-error... 

Thanks,

Sankar