OBIEE consistency check errors in RPD

1.      Warning [39003] – Missing functional dependency association of a column.
Any Logical Table Source that has been unused in 10g is disabled during the upgrade. Cleaning up such tables before the upgrade might help avoid this warning.

Fix: Enable all the Logical Table Sources that are disabled during the upgrade.

2.      Warning [38028] – column does not have valid data type.
I encountered this error because of the disabled Logical Table Sources (from warning 39003). The datatype for all the columns belonging to the disabled LTS were set to null.

Fix:  Fixing the warning 39003 should fix this error, otherwise check to see if the column has a valid datatype.

3.      Warning [39057] – There are physical tables mapped in Logical Table Sources that are not used in any column mappings or expressions.

Fix: Delete the unused logical tables. Delete the aggregations set for that dimension in the content tab of the fact.
  

4.      Warning [39009] – Logical fact table FACTS have an aggregate source that does not join to a Dimension: source at the proper level of detail.

Fix: Make sure there is a physical join between the fact Logical Table Source and dimension’s Logical Table Source. Make sure the aggregation levels are set at the same grain for both dimension and fact on the content tab.

5.      Warning [39076] – Logical level does not have any key with Use for Display property on.
‘Use for Display’ option is turned off during the upgrade.

Fix: Turn on the ‘Use for Display’ option for all the keys specified.

6.      Warning [39008] – Logical dimension table has a source that does not join to any fact source.
The Logical levels on the content tab for LTS and Fact table are not set properly.
The join between the LTS and Fact table is missing in the physical layer.

Fix the Logical levels on the content tab for Logical Table Sources and Fact table. Both should be set to the same Aggregation level.
Check for any missing foreign key joins between LTS and Fact table in physical layer.

7.      Warning [39062] – Initialization block uses Connection Pool which is used for report queries.  This may impact query performance.

 Update the initialization blocks to use the right connection pool. If a connection pool for the init block does not exist, create a new connection pool so that it does not use the connection pool specified for the queries.

8.      Warning [39028] – The features in database does not match the defaults. This may cause query problems.

 Make sure all the required database features are turned on.

9.      Warning [39074] – Logical dimension table has a source with aggregation content set to level ‘Detail’. The same dimension has aggregation content set in fact source to a higher level.

The aggregation levels are set at different grain for fact dimension tables. Update the content tab for dimension and fact to be at the same level.

 

Default ports for OBIEE 11g

You can find the same file located at below location. bishiphome/Disk1/stage/Response/ 

Oracle WLS BIEE Managed Server SSL Port No = 9804

Oracle Process Manager Local Port No = 6700

Oracle Process Manager Remote Port No = 6701

Oracle Process Manager Request Port No = 6702

 Oracle BI Server Port No = 9703

 Oracle BI Server Monitor Port No = 9701

Oracle BI Presentation Services Port No = 9710

 Oracle BI Scheduler Port No = 9705

 Oracle BI Scheduler Monitor Port No = 9708

Oracle BI Scheduler Script RPC Port No = 9707

Oracle BI Cluster Controller Port No = 9706

Oracle BI Cluster Controller Monitor Port No = 9700

Oracle BI JavaHost Port No = 9810

Essbase Agent Port No = 1423