OBIEE change default style

After upgrade of OBIEE from 11.1.1.6.X to 11.1.1.7.X , dashboard style has changed.According to Oracle note before 11.1.1.7 default style was blafp and new is FusionFX. Customer declared old style is preferred.

To change back to old style , instanceconfig.xml configuration files are edited with below attributes.Related files are located in ORACLE_INSTANCE/config/ OracleBIPresentationServicesComponent / coreapplication_obipsn.

Add or change following attributes between <ServerInstance> and </ServerInstance> tags

    <UI>
    <DefaultStyle>blafp</DefaultStyle>
    <DefaultSkin>blafp</DefaultSkin>
    </UI>

Restart presentation Services.

After this change , there will be icon trouble which is no longer displayed.Related "System busy" icon searching_light.gif is located in %ORACLE_HOME%\bifoundation\ web \appv2\res\s_FusionFX\views\searching_light.gif and must be copied into following locations

Middleware\Oracle_BI1\bifoundation\web\appv2\res\s_blafp\views
 
Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\views

Restart all services.

UPGAST-00224:The specified database does not contain any schemas for Oracle MDS ...

From Oracle Error Message documentation,

UPGAST-00224: The specified database does not contain any schemas for {0} or the database user lacks privilege to view the schemas.

Cause: The database you have specified does not contain any schemas registered as belonging to the component you are upgrading, or else the current database user lacks privilege to query the contents of the schema version registry.

Action: Verify that the database contains schema entries in schema version registry. If it does not, specify a different database. Verify that the user has DBA privilege. Connect to the database as DBA.

Level: 1

Type: ERROR

Impact: Upgrade

While upgrading OBIEE from 11.1.1.6 to 11.1.1.7 i have encountered UPGAST-00224 error at stage of PSA for the update of MDS schema .

I was doing upgrade process at TEST enviroment and related MDS + BIPLATFORM schemas have been imported from LIVE database to TEST database by changing schema names in order to sepearate TEST and LIVE . My original schema names were OBI_MDS and OBI_BIPLATFORM  and changed to OBIUPG_MDS ,OBIUPG_BIPLATFORM After done this process system.SCHEMA_VERSION_REGISTRY$ must be updated with new schema information.

To do this , system.SCHEMA_VERSION_REGISTRY$ can be exported and imported from live into TEST , or related MDS and BIPLATFORM data can be inserted or updated  at TEST enviroment.