Skip to Content

HANA XSA: Java OData service error: user lacks privilege or object not found: CDS_ANNOTATION_VALUES


Tried to implement V4 Java OData service on our HANA XSA according to the tutorial. The service seem to run when starting from Web IDE, at least url with /java/odata/v4/ suffix shows single odata endpoint. However, after deployment service shows No Odata EndPoints Exposed text and any further addition after /java/odata/v4/ returns only this:

Odata server error. Please check logs for more details.

HANA db module contains a single file try2.hdbcds, containing this:

namespace hana_odata_ns.db_odata1;
@OData.publish : true
context try2 {
    entity Main {
        key id   : Integer;
            name : String(20);
    technical configuration {
        row store;

Log shows the following message:

java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: CDS_ANNOTATION_VALUES

The view CDS_ANNOTATION_VALUES actually exist and contains one record.

This is what xs version returns:

Controller server version information:
name  XS Controller  
build  v1.0.63  api version   1  software version  content version  state  READY  database type  HANA_MULTI 
database info  HDB

No configuration files were changed after generating of Java Odata V4 module

Any suggestions?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 07, 2019 at 12:54 AM

    WHat user have you used here, and does this user have the correct auth's to this CDS view?

    Add a comment
    10|10000 characters needed characters exceeded

    • If I understand correctly the db project is being deployed not under my own user name but under some technical user, and also the runtime data manipulations are done under the technical user. At least I see current user as SBSS_<something>.

      Is there any tool/way to provide the deployment user with sufficient authorisations? Probably something wrong with our installation? In most tutorials SAP claims this should work "out-of-the-box" and apparently it does not; and frankly I can't see how your comment can help.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.