cancel
Showing results for 
Search instead for 
Did you mean: 

ECC to HANA 2nd DB Connection Failure

carlos_cheung2
Participant
0 Kudos

Hi Experts,

I have an issue when I coding ABAP in ECC fetching data from 2nd DB HANA.

*--------------------------------------------------*

start-of-selection.
data lv_count type i.


select count(*)

from ADRC

connection ('HANA_CONN')
into lv_count.


write: / 'Records Found:', lv_count.

*--------------------------------------------------*

Showing Dump when execute,

Short text

    A table is unknown or does not exist.

*--------------------------------------------------*

Test Connection is good.

ADBC_TEST_CONNECTION

Testing a Database Connection Defined in DBCON

Connection HANA_CONN                      successfully opened.
Connection HANA_CONN                      closed

*--------------------------------------------------*

Could anyone advise what is wrong here?

Thanks!

Carlos.

Accepted Solutions (1)

Accepted Solutions (1)

former_member182114
Active Contributor
0 Kudos

Hi Carlos,

This table ADRC exists on the target schema maintaned on DBCON?

Regards, Fernando Da Rós

carlos_cheung2
Participant
0 Kudos

Hi Fernando,

Yes, ADRC is existing in both ECC and HANA schema ECC_EHP6.

Carlos.

carlos_cheung2
Participant
0 Kudos

Hi,

Table is existing, but still get above error, could anyone advice what need to be check?

carlos_cheung2
Participant
0 Kudos

We solved this issue by install HANA client in ECC Application Server.

Thanks Fernando.

Close this one.

Answers (0)