Skip to Content
0
Feb 17, 2017 at 09:52 AM

500 Internal Server Error - Invalid HANA settings provided. OData services are disabled?

5499 Views Last edit Feb 17, 2017 at 10:23 AM 3 rev

I try to run the OData Service on my SAP HANA HXE and get this error if I run the node.js-module within the Odata Service and go the xsodata-path. How could I solve this to get a correct ODataV2-Service?

I tried to set NODE_TLS_REJECT_UNAUTHORIZED: 0 in the MTA.yaml file, but this didn't solve the error.

500 Internal Server Error - Invalid HANA settings provided. OData services are disabled.
Error: Internal Server Error - Invalid HANA settings provided. OData services are disabled.
    at /hana/shared/HXE/xs/controller_data/executionagent/executionroot/6d27693a-a555-497d-ac73-37558c6e4024/app/node_modules/sap-xsjs/lib/index.js:107:14
    at Layer.handle [as handle_request] (/hana/shared/HXE/xs/controller_data/executionagent/executionroot/6d27693a-a555-497d-ac73-37558c6e4024/app/node_modules/express/lib/router/layer.js:95:5)
    at trim_prefix (/hana/shared/HXE/xs/controller_data/executionagent/executionroot/6d27693a-a555-497d-ac73-37558c6e4024/app/node_modules/express/lib/router/index.js:312:13)
    at /hana/shared/HXE/xs/controller_data/executionagent/executionroot/6d27693a-a555-497d-ac73-37558c6e4024/app/node_modules/express/lib/router/index.js:280:7
    at Function.process_params (/hana/shared/HXE/xs/controller_data/executionagent/executionroot/6d27693a-a555-497d-ac73-37558c6e4024/app/node_modules/express/lib/router/index.js:330:12)
    at next (/hana/shared/HXE/xs/controller_data/executionagent/executionroot/6d27693a-a555-497d-ac73-37558c6e4024/app/node_modules/express/lib/router/index.js:271:10)
    at urlRewriteMiddleware (/hana/shared/HXE/xs/controller_data/executionagent/executionroot/6d27693a-a555-497d-ac73-37558c6e4024/app/node_modules/sap-xsjs/lib/middleware.js:38:5)
    at Layer.handle [as handle_request] (/hana/shared/HXE/xs/controller_data/executionagent/executionroot/6d27693a-a555-497d-ac73-37558c6e4024/app/node_modules/express/lib/router/layer.js:95:5)
    at trim_prefix (/hana/shared/HXE/xs/controller_data/executionagent/executionroot/6d27693a-a555-497d-ac73-37558c6e4024/app/node_modules/express/lib/router/index.js:312:13)
    at /hana/shared/HXE/xs/controller_data/executionagent/executionroot/6d27693a-a555-497d-ac73-37558c6e4024/app/node_modules/express/lib/router/index.js:280:7



My Mta looks like this and in the nodedb are the hbcds and hdbtabledata.file

_schema-version: '2.0'
ID: watson
version: 0.0.1


modules:
- name: nodedb
  type: hdb
  path: nodedb
  requires:
  - name: hdi-container


 
- name: tinyjs
  type: nodejs
  path: tinyjs
  requires:
    - name: nodedb
    - name: hdi-container
    
- name: odatajs
  type: nodejs
  path: odatajs
  requires:
    - name: nodedb
    - name: hdi-container
  provides:
    - name: odatajs_api
      properties:
        service_url: ${default-url}
        
- name: test
  type: html5
  path: agent


- name: table
  type: html5
  path: table


resources:
 - name: hdi-container
   properties:
      hdi-container-name: ${service-name}
      type: com.sap.xs.hdi-container
     
   


My xsodata-file: vendormodel is the context and Audit the table:

service {
         "watson.nodedb::vendormodel.Audit" as "MyTable";
}