Errors in setting connection

[Former Member]

Hi Everyone

I'm trying to create a schema in SLT server in transaction LTR.

When I try and create it against SAP ERP I get the error "Errors in setting connections".

But if i create from Legacy System which is MS SQL it works and I can replicate.

I have tested the following.

-SLT can communicate with HANA system. In SLT system,transaction DBCO to for connection for your target HANA system and test the same with program 'ADBC_TEST_CONNECTION' (tx: SE38). Returns postive results.

-Due to replication working with MS SQL I have concluded that connection between SLT and HANA is fine.

With the above in mind I assume the problem is in SAP ERP. But we have done the following

-Loaded DMIS all the way to 5. Also loaded in SLT.

-Kernal is 720_EXT and patche level is way above 110

-RFC connection between SLT and SAP ERP is fine

-User for RFC connection created and assigned the correct role in ERP.

-In SM21 I see no errors in SLT or ERP. No errors in ST22

How can I get a more descriptive error on what is wrong?

Please point me in the correct direction. What is wrong?

[Former Member]

There is a SAP note 1801462 for this error if the source is SAP via RFC.

Did you apply the note?

Unfortunately this error also occurs with e.g. Source DB2 destination HANA. Does anybody know how to fix it then?

[Former Member]

Hi Louis,

Have you solved the issue now? I'm facing the same issue. And same as your situation, the RFC connection test and ADBC_TEST_CONNECTION test are both ok.

Do you by any chance have a solution on this? Thanks a lot!

Hao