SAP HANA SHINE HCP_GRANT_ROLE_TO_USER Issue

98 Views

Hi,

I have imported the SAP HANA SHINE 8 content in my SAP HANA Cloud trial instance using my Eclipse (Luna) environment.

I am now trying to execute the following but get errors below:

call "HCP"."HCP_GRANT_ROLE_TO_USER" ('s0007081080trial.kallidusdev.shinesp8.roles::Admin','s0007081080')

Could not execute 'call "HCP"."HCP_GRANT_ROLE_TO_USER" ...' in 1:21.996 minutes .

SAP DBTech JDBC: [10001]: user-defined error: [10001] "HCP"."HCP_GRANT_ROLE_TO_USER": line 17 col 12 (at pos 1164): [10001] (range 3) user-defined error exception: s0007081080trial.kallidusdev.shinesp8.roles::Admin role is not created, active or part of package described in view HCP.HCP_DEV_METADATA.

Can anyone explain what is wrong and how I can fix this so the statemt executes successfully?

Thanks,

Chris