Extra Pages

▼

Monday, October 24, 2011

OBIEE11g SampleApp OID doesn’t start

Yep, I did again :-(.

After playing around with the new sampleapp107 I managed to crash the VM. After a reboot the OID refused to start up. It seemed that because there was still an active status record in the ODS schema, the OPMN couldn’t find anything to start.

Solution: truncate the "ODS"."ODS_PROCESS_STATUS" and  "ODS"."ODS_GUARDIAN" tables in your database repository.

(Not sure if the "ODS"."ODS_GUARDIAN"  is really necessary…. Please correct me if I’m wrong)

Till Next Time

at

1 comment:

  1. AnonymousNovember 14, 2011 at 10:39 PM

    Hi John, your blog is awesome, and its really helpful for all who just started exploring OBIEE. I recently encountered with following error in OBIEE 10.1.3.4:

    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46115] No Unicode translation is available for some of the input characters for MultiByteWideChar(). (HY000)


    The above error occured after selecting few columns in OBI Answers. Thanks for your help.

    -Kiran

    ReplyDelete

Note: Only a member of this blog may post a comment.