Don't see _SYS_BIC schema in Hana Trial Landscape

[Former Member]

Hello experts,

I'm using a Hana Trial instance (accessed via Eclipse on Mac OSX) and created a HANA XS Application as detailed in SAP Hana tutorial ( SAP HANA Cloud Platform ).

I connected successfully to the database in my p...trial account. I can see the _SYS_BI and _SYS schemas, but do not see the _SYS_BIC schema. That's causing a lot of access issues for me in previewing my data and refactoring views. I've tried to provide Select grant to the _SYS_BIC schema but it gives me an error stating I don't have privileges to do that.

Did I miss something during my setup? How can see the _SYS_BIC schema?

Thanks

[Former Member · Accepted solution]

I found a solution to my problem and I am posting it here.

In order to see _SYS_BIC, you need to run the SQL (Call "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS")  AFTER deleting all tables in your Dev schema. I was running it with tables still in my DEV schema, and hence it was throwing this error. The second part is that I need to recreate these tables in my NEO schema, and not the DEV schema. 

After deleting my tables, I ran the SQL, and then recreated my tables in the NEO schema. Then I recreated my attribute view, and activated it. The _SYS_BIC schema started to show.

Hope this helps anyone who faces the same issue.

[gowrisankar_m2]

create some view and activate it first, then you call below query and refresh the catalog folder , then you can see sys_bic schema.

CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"

[Former Member]

Hi Gowrisankar,

Thanks for your reply. I've tried that before and it does work. Here're all the things I've tried so far, and none of them help in viewing the _SYS_BIC schema.

1, Created Attribute and Analytic Views and Activated. Then

Call "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"

Error:

Could not execute 'call "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"' in 6.697 seconds .

SAP DBTech JDBC: [10001]: user-defined error:  [10001] "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS": line 35 col 14 (at pos 2108): [10001] (range 3) user-defined error exception: user-defined error:  [10001] "HCP"."GRANT_PRIVILEGES_ON_MANAGED_REPO_OBJECT": line 12 col 3 (at pos 995): [10001] (range 3) user-defined error exception: user-defined error:  [10001] "HCP"."DEPENDENCY_VALIDATOR": line 81 col 9 (at pos 4881): [10001] (range 3) user-defined error exception: Checking object: schema: _SYS_BIC, object: p1941689034trial.myhanaxs.hello/BERTHING_ATT_VIEW. User DEV_ER9C01K6SBZ9KTZ26JRQNN5HM is not authorized for:  Object: Dim_Pumping_Type Schema: DEV_ER9C01K6SBZ9KTZ26JRQNN5HM Type: TABLE

2. GRANT EXECUTE ON SCHEMA "<SCHEMA_NAME>" to _SYS_REPO WITH GRANT OPTION. This works successfully, but does not resolve the problem of _SYS_BIC. I'm also not able to Preview data of my Views.

3. I tried adding the _SYS_BI_SP_ALL privilege, but it says I'm not authorized to grant that privilege.

4. Created Views from tables in NEO schema instead of DEV), but still can't see _SYS_BIC. Also, still no luck with Data Preview of Views (Note: I can preview data in tables, but not in Views)

[Former Member]

Hi Gowrisankar - were you able to review my message with the errors?