Skip to Content
avatar image
Former Member

Connecting to SAP HANA cloud database

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/sampletable/$count 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/sampletable?$skip=3&$top=107&$inlinecount=allpages 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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 07, 2015 at 06:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 19, 2015 at 02:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded