Unable to activate Open ODS - User is not authourized

[bhat_vaidya2]

Hi,

During the creation of Open ODS view, I am unable to activate my object. I think it might be due to missing HANA Authourization. Does any one

know how I can resolve it and which authourization that is required.

- Bhat

[muthuram_shanmugavel2]

Hi All,

I too face same Issue.

Regards,

Muthuram

[bhat_vaidya2]

Hi, Sorry guys. I am still unable to resolve it. I followed the instruction as per the note and the result is same. If you do find a solution, please do not hesitate to share it. Thanks, Bhat

[muthuram_shanmugavel2]

Hi Bhat,

I am able to resolve this Issue now .

Assume "DATA_BODS" is External schema and

We have to create Open ODS Views on top of Tables from "DATA_BODS" schema.

Standard HANA DB User for BW application will be SAP<SID>. Assume User is "SAPH01"

The point is that "SAPH01" user need select and Execute access for "DATA_BODS" schema.

So Open ODS View on top of the tables from schema can be activated successfully.

Execute the following SQL Queries using User, who is Owner of the schema "DATA_BODS".

GRANT SELECT ON SCHEMA DATA_BODS TO SAPH01 WITH GRANT OPTION

GRANT EXECUTE ON SCHEMA DATA_BODS TO SAPH01 WITH GRANT OPTION

Open ODS will be activated successfully.

Regards,

Muthuram

[former_member195433]

i have exactly the same error  when activating ODS view .

Can you let me know how did you resolve it ?

[Former Member]

Hi Guys,

I'm facing the same issue. Have you found any solution?

Regards

Amanda

[bhat_vaidya2]

Hi Amanda, It is still not resolved. If you happen to find a solution, do not hesitate to share it. thanks, Bhat

[Former Member]

Hi Bhat, I'm able to fix it.

Can you see this note: 2157188 - Activation of an Open ODS View terminates with Exception CX_RODPS_OBJECT_NOT_FOUND or "use...

After that I also gave access to the DB Owner user "to create any" on HANA schema that my ODS is doing the select.

Let me know if this will work for you.

Regards

Amanda

[bhat_vaidya2]

Hi, I have added the object and still get same error. - Bhat

[former_member182302]

Does the user you are using have the SELECT access on the source object on which you are creating ODS view?

Regards,

Krishna Tangudu

[bhat_vaidya2]

Hi, thanks for your response. The table is a custom table in ECC that was replicated to SAP HANA. I wanted to create an open ODS view based on the table from ECC. I have no issue visualizing data in the table in SAP HANA and was able to run select statement.

*****************************************************************************

Statement 'select * from ZPUBLIC'

successfully executed in 1 ms 369 µs  (server processing time: 0 ms 536 µs)

Fetched 8 row(s) in 0 ms 209 µs (server processing time: 0 ms 0 µs)

****************************************************************************

- Bhat

[former_member182302]

Does _SYS_REPO user have access to this Table? Or in other words are you able to create any HANA model on this table from HANA Studio?

Regards,

Krishna Tangudu

[bhat_vaidya2]

Hi,

I was able to create analytic View based on the table. I checked SYS_REPO and under "Object Priviledges" my userID has the following actions.

I changed all to "YES" and it doesn't resolve the issue.

Bhat

[former_member182302]

Just to confirm you are checking the authorizations for SAP<SID> database user right?

Regards,

Krishna Tangudu

[bhat_vaidya2]

Hi, Yes, I am checking it with my database user. - Bhat

[bhat_vaidya2]

Hi, I would like to resolve the issue and was wondering if anyone knows how it can be resolve. Thanks