cancel
Showing results for 
Search instead for 
Did you mean: 

_SYS_BIC missing

former_member197620
Participant
0 Kudos

Hi experts,

I had tried to follow . When I created a caculation view SO_CV, I noticed that _SYS_BIC is missing, even I had executed the following SQL


CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"

Why?

Regards,

Candy Zhang

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hey hi, I could not see the "_SYS_BIC" schema first but when i activated some views and some objects still i could not see the "_SYS_BIC" schema

but when i call

CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"

i could see the _SYS_BIC schema and objects in that.

i think only when you have atleast select permission on atleast one object in that schema you can view the _SYS_BIC

former_member197620
Participant
0 Kudos

Hi,

I could see the "_SIS_BIC" after I created and actived some views, objects.

Thanks.

Answers (2)

Answers (2)

thomas_madsen
Participant
0 Kudos

Hi Candy

I am also not able to see _SYS_BIC even after calling the grant procedure.

Did you solve your problem?

Best regards

Thomas

former_member197620
Participant
0 Kudos

Hi Thomas,

The issue isn't  solved

thomas_madsen
Participant
0 Kudos

Hi,

After creating a calc view using eclipse and running the CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS" I can now see _SYS_BIC.

But I am only able to see the column view of the calc view I just created. I am still not able to see the table that I create using a cds script in Web IDE.

So somehow creating a table and activating this table in the _SYS_BIC schema is not visible in the _SYS_BIC schema.

former_member197620
Participant
0 Kudos

Hi,

I could see the "_SIS_BIC" after I created and actived some views, objects. Thanks.

Now I am no able to see the table in the "_SIS_BIC" schema like you.

Vlado
Advisor
Advisor
0 Kudos

Have you refreshed the Catalog folder?

former_member197620
Participant
0 Kudos

I have refreshed the Catalog folder, even I also restart Eclipse.