Connecting to SAP HANA cloud database

[Former Member]

Hi Team,

Am trying to connect to SAP HANA cloud database using SAP HANA. Am getting this error while executing and i can see this error only when i press F12 in the google chrome browser

"

GET https://s8hanaxs.hanatrial.ondemand.com/p1941669224trial/hanainstan/helloworld/dummy.xsodata/samplet... 500 (Internal Server Error)o.defaultHttpClient.request @ datajs.js:17E2 @ datajs.js:17o.request @ datajs.js:17h._request @ ODataModel.js:6c._getLength @ ODataListBinding.js:6c.resetData @ ODataListBinding.js:6L.extend.constructor @ ODataListBinding.js:6h.bindList @ ODataModel.js:6g._bindAggregation @ sap-ui-core.js:152T._bindAggregation @ Table.js:6g.bindAggregation @ sap-ui-core.js:152b.bindRows @ TreeTable.js:6(anonymous function) @ index1.html?_=Mon Nov 02 2015 12:57:14 GMT+0530 (India Standard Time):60

datajs.js:17

GET https://s8hanaxs.hanatrial.ondemand.com/p1941669224trial/hanainstan/helloworld/dummy.xsodata/samplet... 500 (Internal Server Error)o.defaultHttpClient.request @ datajs.js:17E2 @ datajs.js:17o.request @ datajs.js:17h._request @ ODataModel.js:6l @ ODataModel.js:6h._loadData @ ODataModel.js:6c.loadData @ ODataListBinding.js:6c.getContexts @ ODataListBinding.js:6T._createRows @ Table.js:6T.render @ TableRenderer.js:6R.renderControl @ sap-ui-core.js:152(anonymous function) @ sap-ui-core.js:152M.render @ MatrixLayoutRenderer.js:6R.renderControl @ sap-ui-core.js:152(anonymous function) @ sap-ui-core.js:152P.render @ PanelRenderer.js:6R.renderControl @ sap-ui-core.js:152R.render @ sap-ui-core.js:152U.rerender @ sap-ui-core.js:152k.renderPendingUIUpdates @ sap-ui-core.js:152k.init @ sap-ui-core.js:152k.handleLoad @ sap-ui-core.js:152(anonymous function) @ sap-ui-core.js:152l @ sap-ui-core.js:88S.finishTask @ sap-ui-core.js:88(anonymous function) @ sap-ui-core.js:152t @ sap-ui-core.js:71v.fireWith @ sap-ui-core.js:71Q.extend.ready @ sap-ui-core.js:71W @ sap-ui-core.js:71

sap-ui-core.js:88 2015-11-02 12:57:35 The following problem occurred: HTTP request failed500,Internal Server Error,{ "error": { "code": "", "message": { "lang": "en-US", "value": "Service exception: insufficient privilege."},"innererror":{"exception":"exception  1: no.71000258  (ptime\/query\/checker\/query_check.cc:2422)\n    Not authorized\nNO exception throw location recorded. Stack generation suppressed.\n"}}} -

"

in the output it shows " No Data"

Attached file has the sample code of files which are named after, which i have used to work on this complete process of display.

When i try to connect to SYS.DUMMY it works fine and shows value  as expected but it will not work.

Suggest how to display values which connects to SAP HANA database and pulls values.

Regards,

Pallavi.

SAP HANA-Error code.txt.zip

[Former Member]

Hello Pallavi,

The live3 project made by Mr. Philips of SAP HANA Academy is very resourceful in terms of how to give authorization, knowing user application schema, grant role and many. Below is the url link for the SAP Git hub fro live3,

Live3 - SAP HANA Cloud Platform · saphanaacademy/Live3HCP@def1576 · GitHub

You shall find the information in scripts. Also, there is link to all video for this project in YouTube

Hope this shall help.

Thanks,
Sandeep

[Former Member]

Hello Pallavi,

I'm also trying to connect to the SAP HANA Cloud Database using my trail account in the SAP Web development Workbech platform. I too could access the Dummy table is SYS using oData as well as XSproject but could not access the table that i have inserted in the NEO."....." schema. Please let me know if you have find out any solution to this problem.

Thanks,
Sandeep

[former_member185414]

Hello Sandeep,

In all probability, its a privilege/authorization issue.

Have you followed all the steps for your table in NEO schema i.e. created a .xsprivilege, .xsaccess, .hdbrole and granted privilege of the table to your user?

BR.

[Former Member]

Hello Ankit,

Thanks for answering. I have done the things you have mentioned above. I don't get where i was going wrong. Can you suggest me any reference that could help me solve this exercise. I just would like to display the content in my table using oData.

Thanks,
Sandeep

[Qualiture]

The error message clearly states Service exception: insufficient privilege [...] Not authorized, so check if the user who is accessing the OData service is authenticated and authorized correctly