Skip to main content

Oracle connection doesn's show tables in Reporting module

Comments

5 comments

  • Nico Burgerhart

    Can you post a screenshot? The user used to connect has a SELECT privilege on the tables?

    0
  • Jeroen Smal

    Here are some screenshots. The user does have select rights. It's currently also used in our old Geoweb (5.6) environment without trouble

    Connection test is succesfull:

     

    But no tables to select:

     

     

    0
  • Nico Burgerhart

    In the dialog where you specify the Data Source settings it should already show the tables, there you should see a list of tables, when selecting a data connection.

    In the network traffic you should see a POST request like this. Is there an error?

    https://mydomain.com/vertigisstudio/reporting/editor/QueryBuilder/Invoke

     

    0
  • Jeroen Smal

    Yes i do see the Invoke  Post requests and they do say succesfull (2 times actually, once with actionKey: getDBSchema and once with getDBStoredProcedures).

    Here are the responses (they seem to be identical:

     

    {
        "error": null,
        "result": {
            "dbSchemaJSON": "{\"StoredProcedures\":[],\"Tables\":null,\"Views\":null}"
        },
        "success": true
    }
    {
        "error": null,
        "result": {
            "dbSchemaJSON": "{\"StoredProcedures\":null,\"Tables\":[],\"Views\":[]}"
        },
        "success": true
    }

     

    0
  • Jeroen Smal

    Nico Burgerhart We got it working by using the credentials for the owner of the table. 

    This seems to be the only way to get the application to connect right now. The other user has the rights to read/select the tables (it is currently being used in our Geoweb 5.6 application to connect to the same tables). So this looks like a bug in the reporting module i think.

    0

Please sign in to leave a comment.