cancel
Showing results for 
Search instead for 
Did you mean: 

'Error occurred while reading data from HANA Table in schema SAP_PAPM' while activating a join

soundaryacadiga
Explorer
0 Kudos
409

Hi Experts,

I have built a 'Model Table' on top of which I have built a join function type to aggregate the data. Upon activating this join function, we are facing a strange issue - 'Error occurred while reading data from HANA Table in schema SAP_PAPM' . Below is the screenshot.

soundaryacadiga_0-1708681787808.png

Please let us know as to how we could fix this issue.

Thank you,

Soundarya C Adiga

Accepted Solutions (0)

Answers (2)

Answers (2)

PavanKumar10
Advisor
Advisor
0 Kudos

Hi Soundarya, 

The error occurred while reading data from the HANA Table in the schema SAP_PAPM (PaPM Cloud), typically happens when consuming HANA tables or views from SAP HANA Cloud in new tenants or different projects. The solution for this issue is to execute the following command:

 

GRANT ALL PRIVILEGES ON SCHEMA "SAP_PAPM_ADMIN" TO "SCHEMA"; 

 

In this scenario, SAP_PAPM_ADMIN represents the schema from where all the HANA source data is being pulled, and SAP_PAPM represents your PaPM Cloud (tenant) schema. 

Best!

Pavan 

soundaryacadiga
Explorer
0 Kudos

Hello,

Now this issue is resolved. It was an issue with one of the hierarchy we were bringing in from external system. One we removed this hierarchy name from the fields, it started working fine.

Thanks,

Soundarya C Adiga