CO-PA Accelerator: Error on Distribution - "Access to HANA is Locked"

[Former Member]

We have setup the CO-PA Accelerator to connect ECC to HANA using SLT. Data is replicating from ECC to HANA and we are able to read data from HANA in ECC via KE24.

However, when we go to attempt a distribution, we get the error message the HANA is locked. The following possible causes are given:

- No replication has yet been performed successfully.

- Not all CO-PA realignment runs have yet been replicated to the SAP HANA database

- Relevant changes in the CO-PA settings (such as in transactions KEA0 or KEQ3) have yet been transferred to SAP HANA.

- Access to SAP HANA has been deactivated manually.

We are then pointed to KEHC for troubleshooting. Everything in KEHC is green lit, except the Data Transfer light which is not lit at all. We also do not have any time stamps for CO-PA Replication as we are using SLT to replicate the data.

My expectation was that we would not need to use "CO-PA Replication" if using SLT. Is that not correct?

Thanks for any insight you can provide.

AZ

[Former Member · Accepted solution]

This is resolved.

Turns out that Basis recently added a second app server to our development ECC system. We didn't know this when we installed the DMIS and the HANA DB client on ECC. While the DMIS covers all the servers, the HANA DB client needed to be installed on each server independently. Our jobs that hit the one with the client worked fine. When they ran on the server without the client installed, we got the generic HANA Lock message.

[Former Member]

As an update - we seem to be experiencing this problem intermittently. It looks like we are able to run the distributions/allocations in the foreground without issue. However, using background, it is working in some cases and cancelling with a "HANA Lock" in others. Even though the message points to CO-PA replication, I doubt that is causing the issue.