Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

cannot get the data provider outline

I was trying to create a analytical view in SAP HANA with the help of following guide.

https://images.experiencesaphana.com/modeling-data/working-hana-modeller/creating-analytic-views/

I could not open data preview and received following error

SAP DBTech JDBC: [391] (at 119): invalidated view

After searching on SDN, I found following solution at http://scn.sap.com/thread/2043153


grant select on schema <SCHEMA> to SYSREPO with grant option;

grant select on schema <SCHEMA> to <USER>;

I successfully executed first statement but kept failing to execute second one. I was getting error. After reading the error message and SAP note I realized that I was logged in as SYSTEM so I do not have to execute second statement. I only needed this if I am allowing other users.

Silly, but I learnt something new.


Former Member
Not what you were looking for? View more on this topic or Ask a question