HANA Express edition error

[jagadish]

Hello All,

I am getting following error when doing openSAP exercise 2.4 in Software development on HANA course 2016.

Build is failing because of TRIGGER privilege in admin.hdbrole file.

Link to the exercise

Does anyone know the reason?

-------------------------

Deploying "src/roles/admin.hdbrole"...
Error: com.sap.hana.di.role: Could not create the role definition in the database [8254541]
at "src/roles/admin.hdbrole" (0:0)
Error: com.sap.hana.di.role: "TRIGGER": invalid schema privilege [8254524]
at "src/roles/admin.hdbrole" (0:0)
Error: com.sap.hana.di.role: Deploying "src/roles/admin.hdbrole"... failed [8212145]
at "src/roles/admin.hdbrole" (0:0)
Error: Worker 1 has encountered an error; all remaining jobs will be canceled [8214600]
Error: Processing work list... failed [8212102]
Make failed (4 errors, 0 warnings): tried to deploy 1 files, undeploy 0 files, redeploy 1 dependent files
Error: Making... failed [8211605]
Error: Starting make in the container "OPENSAP_HANA5_00_1" with 1 files to deploy, 0 files to undeploy... failed [8214168]
Command failed
Deployment to container OPENSAP_HANA5_00_1 failed - error: HDI make failed [Deployment ID: none].
Error: HDI make failed

Thank you,

Jagadish.B

[thomas_jung · Accepted solution]

This was change in one of the HANA revisions: TRIGGER is no longer an allowed authorization object. I assume you are using an exercise document from an older HANA release level but a newer system to do the exercises. If you look in github, we have a separate branch for each HANA release:

https://github.com/SAP/com.sap.openSAP.hana5.example/blob/hana2_sps03/core_db/src/roles/admin.hdbrol...

Also while you should go through the videos of the older courses I would recommend always using the exercise document from the latest course in the series. With each updated course we update all the exercises from previous courses as well to the latest HANA release level.

[jagadish · Accepted solution]

Thank you Thomas! That solved the issue.