Skip to Content
avatar image
Former Member

Don't see _SYS_BIC schema in Hana Trial Landscape

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 25, 2015 at 09:48 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 22, 2015 at 05:28 AM

    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"

    Add comment
    10|10000 characters needed characters exceeded