Category Archives: Berry van den Heuvel
There are physical tables mapped in Logical Table Source that are not used in any column mappings or expressions
Problem: Consistency Check Error No. 39057
Screenshot:
[39057] There are physical tables mapped in Logical Table Source [TABLE_SOURCE] that are not used in any column mappings or expressions.
Solution:
- open the logical table source [TABLE_SOURCE]
- select the Column Mapping tab
- verify which table has no column mappings
- select the General tab
- select the table that has no column mappings
- click the red cross to delete this table
- click OK
- check in the rpd
The error message is not displayed anymore.
Het bericht There are physical tables mapped in Logical Table Source that are not used in any column mappings or expressions verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
The Logical Table is not joined to any other logical table
Problem: Consistency Check Error No. 38133
Screenshot:
[38133] The Logical Table [SCHEMA].[TABLE] is not joined to any other logical table.
Solution:
- open the Business Model Diagram
- create at least 1 join between the TABLE and another table
Now, the error message is not displayed anymore.
Het bericht The Logical Table is not joined to any other logical table verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Restart processes with Enterprise Manager
To restart the processes (BI Presentation Services, BI Servers, BI Schedulers, BI Cluster Controllers and/or BI JavaHosts), follow these steps;
- log in to Enterprise Manager
- click Business Intelligence - coreapplication
- click Availability
- click Processes
- if you want to restart all, click Restart All
- if you want to restart only one part, then select that part and click Restart Selected
- click Yes
- wait untill the Done message appears
Het bericht Restart processes with Enterprise Manager verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Object is already checked out or temporarily locked
Problem: Consistency Check Error No. 36004
Screenshot:
[36004] Object [NAME] is already checked out or temporarily locked.
Cause:
This object is already checked out in another session of the Administration Tool.
Solution:
- go to the other session
- close the session
- go back to the first session
- check in/out the object
Now, the error message is not displayed anymore.
Het bericht Object is already checked out or temporarily locked verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Remove operator label from a prompt
There is a workaround to remove the prompt operator label (like between). In this prompt, we can see the operator label “Between”.
To remove this operator label, follow these steps.
- edit the dashboard that contains the prompt
- insert a Text object
- edit the Text object
- insert this text
<style>.promptOperatorLabelNarrowView {display: none;}</style>
- save text object
- save dashboard
- open dashboard
The prompt is now displayed without the prompt operator label.
Het bericht Remove operator label from a prompt verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
