Issue after Upgrade from 11.1.1.6.0 to 11.1.1.6.2 BP1

Issue after Upgrade from 11.1.1.6.0 to 11.1.1.6.2 BP1

After upgrade to bundle patch set 11.1.1.6.2 The new SQL generated by the .RPD file aggregates data incorrectly.

Solution

1)      Take a copy of the 11.1.1.6.0 .RPD file (repository version 318)

2)      Open the 11.1.1.6.2 version of the Admin tool  (repository version 320)

3)      Open the 11.1.1.6.0 version of the .RPD file with the 11.1.1.6.2 version of the Admin tool.

4)      Save the .RPD file and upload it.

Note that opening a copy of the .RPD file from the upgraded (11.1.1.6.2) OBIEE server will not work.  The version of that RPD is already 11.1.1.6.2, so the 11.1.1.6.2 Admin tool will not “upgrade” it to the current version.  You need to use the 11.1.1.6.0 RPD.

Reference:

http://www.biztech.com/blog/2012/10/obiee-11-1-1-6-2-issues/

Till next time...

Error while generate DAC parameters

Issue:

Error while generate DAC parameters

BIDEV Financial Analytics

MESSAGE:::No physical folder information found for SILOS_DEV

EXCEPTION CLASS::: com.siebel.analytics.etl.execution.ExecutionPlanInitializationException

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.design(ExecutionPlanDesigner.java:1322)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:169)

com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.calculate(DefnBuildHelper.java:119)

com.siebel.analytics.etl.client.view.table.EtlDefnTable.doOperation(EtlDefnTable.java:169)

com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:53)

com.siebel.etl.gui.view.dialogs.WaitDialog$WorkerThread.run(WaitDialog.java:85)

Solution:

Go to Tools->Seed Data->Task Physical Folders -> add new physical folder, name it with SILOS_DEV

Till next time...

OBIEE 11.1.1.6.2 BP1 Patchset is released

OBIEE 11.1.1.6.2 BP1 is now available on My Oracle Support.

The Oracle Business Intelligence 11.1.1.6.2 BP1 patchset comprises of the below patches: 

1.     14223977 Patch 11.1.1.6.2 BP1 (1 of 7) Oracle Business Intelligence Installer

2.     14226980 Patch 11.1.1.6.2 BP1 (2 of 7) Oracle Real Time Decisions

3.     13960955 Patch 11.1.1.6.2 BP1 (3 of 7) Oracle Business Intelligence Publisher

4.     14226993 Patch 11.1.1.6.2 BP1 (4 of 7) Oracle Business Intelligence ADF Components

5.     14228505 Patch 11.1.1.6.2 BP1 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x

6.     13867143 Patch 11.1.1.6.2 BP1 (6 of 7) Oracle Business Intelligence

7.     14142868 Patch 11.1.1.6.2 BP1 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer

Note
•    The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch. 
•    The instructions to apply the above patches are identical, and are contained in the Readme file for Patch 14223977.

Reference: 

https://blogs.oracle.com/proactivesupportEPM/entry/obiee_11_1_1_64

Till next time...