Error while creating Open ODS View

[Former Member]

Hi,

Scenario is BW 7.5 system with HANA sp08.

I am trying to create a Open ODS view on HANA Studio using BW modeling tools. Source of this OODS is HANA table.

While checking I am not getting any errors, but while activating I am getting the below errors.

column store error: fail to create scenario: column store error: fail to create scenario: EC:2048"column store error: fail to create scenario:  [2950] user is not authorized" Error 2.048 has occurred in the BWA/SAP HANA server Error in BW ODS View Error when activating Open ODS View Unable to create CalculationScenario

It says user is not authorized. I have full access levels in my BW system. not sure which authorizations are missing. Any specific authorizations needs to be added in HANA Studio?  I am using the admin authorizations in HANA Studio too..

Regards,

Vishnu

[muthuram_shanmugavel2]

Hi,

Please check this thread -->

Solution:

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 Member]

Hi Vishnu,

You may be using admin user in HANA studio but in your case there may be a missing object privilege on the Schema that owns the HANA table. Make sure ‘Select’ privilege on the schema is granted to the HANA user.

For example, your user name is USR01 (this is the same user used to create and activate Open ODS view)

table name is TAB01,

the schema name is SCH01

and the owner of this schema is USR02

USR02 has to grant Select access on Schema SCH01 to USR01

FYI…

Command to find the owner

SELECT * FROM sys.ownership where object_name = ‘TAB01’

Command to grant select access

GRANT SELECT ON SCHEMA SCH01 TO USER01

Hope this information helps resolve your issue.

Regards,

Praveen Poosa

[former_member184624]

Hi Praveen,

Thanks for providing the inputs.

Even i am unable to create Open ODS view in BW and also in HANA Studio. I am getting the same error as

As per you suggestion, I ran the command

SELECT * FROM sys.ownership where object_name = ‘Customer’ . In my case Customer is the table name.

After executing, I am getting the error as

Could not execute 'SELECT * FROM sys.ownership where object_name = ‘customer’'

SAP DBTech JDBC: [257]: sql syntax error: line 1 col 49 (at pos 49)

And also, I ran the command GRANT SELECT ON SCHEMA SCH01 TO USER01

In my case the schema name and User ID is same.

GRANT SELECT ON SCHEMA TR_M1019418 TO TR_M1019418

But i am getting the error message as

Could not execute 'GRANT SELECT ON SCHEMA TR_M1019418 TO TR_M1019418'

SAP DBTech JDBC: [7]: feature not supported: grantor and grantee are identical

As per my knowledge my schema name and User name is same. Please find the below snap.

Can you please help on this issue.

Thanks.

[Former Member]

Hi ,

                      This error

Could not execute 'GRANT SELECT ON SCHEMA TR_M1019418 TO TR_M1019418'

SAP DBTech JDBC: [7]: feature not supported: grantor and grantee are identical

is occuring  because, you are trying to give rights to the same user with which you have logged into the database system. Inorder to give rights to a particular user you should login with either admin user or any other user apart from the one which need the rights.

Here you can try this statement

GRANT SELECT ON SCHEMA TR_M1019418 TO _SYS_REPO with Grant option

It should work.

regards

tharun.