Wednesday, June 26, 2013

Cannot Start OBIEE Presentation service

[OBIPS] [ERROR:1] Cannot create new catalog while running in update GUID or recover mode

There are many reasons why the presentation service will not start, but this one was interesting because this happened when somebody tinkered with the server configuration settings while migrating RPD and catalog from another similar specs environment.

This error occurs while deploying a new RPD and creating the corresponding new catalog for it.

just make sure:

  1. in the NQSConfig.INI file

    FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO;

    don’t comment the above line, and don’t set the value to YES.

  2. in the instanceconfig.xml file

    <Catalog>
             <UpgradeAndExit>false</UpgradeAndExit>
             <!-- <UpdateAccountGUIDs>UpdateAndStartNormally</UpdateAccountGUIDs> -->
    </Catalog>

    I have commented the line with UpdateAccountGUIDs, this is required only if you want to refresh the GUIDs.

  3. bounce OPMN services and the presentation service will be up.

opmn status