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

1 comment:

Unknown said...

really good piece of information, I had come to know about your site from my friend shubodh, kolkatta,i have read atleast nine posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a lot once again, Regards, obiee online training