Persisting Error in HANA Studio with Data Preview

[gloria_mendoza2]

I am doing HANA Modeling in SAP HANA Studio. I have created a calculation view and am able to activate it just fine. Unfortunately, when I want to do a Data Preview, I get the following error message, "Cannot get the Data Provider Outline: Data Preview is not possible; object is either inactive or broken. If it is an inactive object, activate it, else redeploy." So I redeploy the calculation view I made, but unfortunately I get the same error message. Would anyone kindly advise as to why I am not able to perform a data preview on my Calculation View? Thanks so much.

[former_member227538]

Hi Gloria,

Were you able to solve this problem? I am facing the same issue. Looking forward to your response. Thank you

[gloria_mendoza2]

Hello Gargeya. Sorry for the long wait. I have been busy with another project so I haven't had the time to revisit this. No I still don't have the problem solved. I have tried the troubleshooting steps Rohit suggested in his response, but it did not solve my problem. If you happen to figure out what's wrong before I do, please let me know.

[surya_appala · Accepted solution]

Ensure that _SYS_REPO has access to the schema/tables for which the views are created. Access should be SELECT with GRANT option. If not you may face error while clicking on data preview.

Reason:

The activation of modeling views are done in the name of user _SYS_REPO.
Think of _SYS_REPO as "the activation guy". It takes your models and creates the necessary runtime objects from them. Therefore user _SYS_REPO needs the allowance to select YOUR tables/views. (If _SYS_REPO user cannot select on the tables specified in the from-clause of the view-definition, it cannot define that view)

I have just solved this issue by giving _SYS_REPO user access to schema with SELECT and GRANT option. 🙂

[Former Member · Accepted solution]

I had the same issue, but it worked for me when I added the SELECT permission WITH the GRANT option to the Schema that is used in the View (for user _SYS_REPO).

[Former Member · Accepted solution]

It helps me to solve the problem. I changed the GRANT option to "yes" on _SYS_REPO user.

[rohit_chowdhury17]

Hi Gloria ,

Can you please check if following privileges are assigned to your user , if not apply these

SELECT , CREATE ANY , EXECUTE , DROP on _SYS_BIC

SELECT on _SYS_BIC.

GRANT SELECT ON SCHEMA <SCHEMA NAME of the tables used in models > TO _SYS_REPO WITH GRANT OPTION

Analytical privilege SYS_BI_CP_ALL

Regards

Rohit

[gloria_mendoza2]

First of all, sorry for the long wait. I have been assigned to another project so I haven't had the time to revisit this. Anyway, I have all of these privileges assigned to my user, but the error still appears. I can activate the Calculation View. I just can't preview the data.