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
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?
Oracle BI Cloud Service can’t parse the SQL query for the database viewIf 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,
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.