Troubleshooting Data Modeling Issues

This topic describes common problems that you might encounter when modeling data and explains how to solve them.

I can’t see any tables or views in Data Modeler

If you start Data Modeler and see no tables or views, then one of the following has occurred:

  • There aren’t any tables in the database connected to your service. Use one of the supported data-loading tools to load some data.

  • Data Modeler does not show the latest database objects. To see the latest objects, refresh the Database pane in Data Modeler.

I can’t see the left pane in Data Modeler

The left pane in Data Modeler is collapsed. To display the left pane, click the Restore Pane icon displayed on the left of the page.

I can’t edit any objects in Data Modeler

You must always lock the data model before making any changes. Click Lock to Edit to lock the data model.

I can’t lock the data model

Check whether someone else locked the data model. If you’re an administrator, then you can override the lock. Otherwise, wait until the lock is released. For more information, see Overriding Locks in Locking the Data Model.

I can’t publish the data model

Check whether you have Data Modeler open in multiple browser tabs or multiple browser windows. If you do, close any additional browser tabs and windows running Data Modeler, and try publishing the model again. If you still get a publishing error, then restart the browser.

Why must I use the SQL Query tab to edit a join or filter for a view?

The message ”Please use SQL Query tab to edit Joins/Filters” is displayed when you click the Joins tab or the Filters tab in the view editor for one of the following reasons:
  • Oracle BI Cloud Service can’t parse the SQL query for the database view

    If you use only the Overview, Joins, and Filters tabs to edit a database view, then Oracle BI Cloud Service constructs a simple SQL query for you. If you decide to edit the SQL manually through the SQL Query tab, then simple updates are reflected back in the Overview, Join, and Filters tabs so you can use these tabs to further edit the view later on. If, however, you have used the SQL Query tab to make more advanced code changes, then you can’t use the Overview, Joins or Filters tabs to further edit the view becauseOracle BI Cloud Service can’t verify your updates. For example, if you include:
    • SQL aggregation functions, GROUP BY clause, HAVING clause

    • ORDER BY clause

    • OR keyword in WHERE clause

    • UNION clause

  • Oracle BI Cloud Service can’t access the database view

    If the problem persists, report the issue to your administrator. Your administrator can investigate connection issues relating to your database service.

I see the message: Cluster error-No active server node found

The instance might be down or the database might be locked. If the problem persists, then report the issue to an administrator.