OBIEE 12c installation configuration fails — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c installation configuration fails

Received Response
201
Views
10
Comments
Sunny86
Sunny86 Rank 6 - Analytics Lead

Hello All,

We couldnt complete BI12c installation configuration due to an error at Add default service instance started . what could be the issue.  Any pointers and help will be highly appreciated.

Operating System : Aix

Database : Oracle 12c

Error Message :

Failed single shot step: Add default service instance with: oracle.bi.bar.si.exception.ServiceInstanceLifeCycleException: Failed in running all the handlers during import service instance.

[2017-07-13T16:20:05.321+03:00] [bi] [ERROR] [] [oracle.bi.install.config.actions] [tid: 67] [ecid: 0000Low2S4vFGBMLIMo2yf1PPqsJ000004,0] Non-skipped failure during configuration action: oracle.bi.bar.si.exception.ServiceInstanceLifeCycleException: Failed in running all the handlers during import service instance.[[

java.lang.RuntimeException: oracle.bi.bar.si.exception.ServiceInstanceLifeCycleException: Failed in running all the handlers during import service instance

Capture.PNG

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Search in support.oracle.com for the error. I could find a few documents with a similar error. More importantly confirm that your environment is certified for OBIEE 12.x.x.x (always provide the complete version). Refer the certification matrix Edit: Refer this as well Oracle® Fusion Middleware System Requirements and Specifications

  • 3310714
    3310714 Rank 6 - Analytics Lead

    Hi,


    We had issues installing on AIX previously.  It needed UTF8 and Bash installed otherwise it won't work.  You might want to double check.

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    Hello All,

    We were able to complete installation without sampleapp. But now all the servers are down. i am naive user of obiee. any help will be highly appreciated.

    1)all the servers seems to be up in the em home. But when i move to deployment all are down.

    Bi login page is opening. But not able to login.

    Capture.PNG

    Capture1.PNG

    Capture2.PNG

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    Now only BIServer is failed.

    pastedImage_0.png

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    What do you mean when you say "We were able to complete installation without sampleapp", do you mean you performed clean slate installation?

    Correction in your update from screenshot it doesn't look like deployments are down but instead what you are referring to is you BIEE Services or Components, which are down.

    What is the error reported in your logs for failure to start BIEE component or services, logs with location to look for are listed below

    Log: nodemanager.log  Location: <obiee_home>/user_projects/domains/bi/nodemanager

    Log: obis1,obis1-diagnostics.log Location: <obiee_home>/user_projects/domains/bi/servers/obis1/logs

    Log: sawlog(X).log Location: <obiee_home>/user_projects/domains/bi/servers/obips1/logs

    Log: jh.log Location: <obiee_home>/user_projects/domains/bi/servers/obijh1/logs

    Log: nqcluster.log Location: <obiee_home>/user_projects/domains/bi/servers/obisch1/logs

    Log: nqscheduler.log Location: <obiee_home>/user_projects/domains/bi/servers/obiccs1/logs

    More on logs in below link of Product document

    https://docs.oracle.com/middleware/1221/biee/BIESG/logging.htm#BIESG176

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    My previous response took sometime

    Now since only obis1 is down then check NQSServer(BI Server Component) logs

    Log: obis1,obis1-diagnostics.log Location: <obiee_home>/user_projects/domains/bi/servers/obis1/logs

    Still need answer to What do you mean when you say "We were able to complete installation without sampleapp", do you mean you performed clean slate installation?

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    Yes cleanstate installation.

    1)UTF8 installed already. but that error is there in log.

    pastedImage_0.png

    2)in the diagnostic file i could see BI home is pointed to a different instance.

    I have two instance. one BI and second one is BINEW.

    pastedImage_1.png

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    I suppose this is what has happened till now.

    You tried and install OBIEE 12c first time with

    ORACLE_HOME=/app/Oracle/Middleware/Oracle_Home

    DOMAIN_HOME=/app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi

    But since this configuration failed due to missing locale you left the domain(bi) as is and then proceeded with installation of locale EN_US.UTF-8 followed by configuration as clean slate creating a new domain(binew) but ORACLE_HOME remained the same

    ORACLE_HOME=/app/Oracle/Middleware/Oracle_Home

    DOMAIN_HOME=/app/Oracle/Middleware/Oracle_Home/user_projects/domains/binew

    but since you did clean slate you skipped the steps to "Add default service instance" hence your configuration went through fine and it did not perform test for locale, whether or not if installed is it installed correctly or not.

    So all you did was recreated new domain and not ORACLE_HOME hence path showed in diagnostics log seems to be correct, let me know if you differ on same or I have misunderstood something.

    I would suggest you to do following

    1) Stop your OBIEE 12c environment by executing below command from below location.

    Command : ./stop.sh

    File Location: /app/Oracle/Middleware/Oracle_Home/user_projects/domains/binew/bitools/bin

    2) Once environment is stopped then re-verify if locale package has been installed or not by executing below command.

    lslpp -l | grep "bos.loc.utf.EN_US"

    3) If still not found then install the same

    IBM Fileset information for: bos.loc.utf.EN_US - United States

    4) Then reconfigure your environment either by either creating a new domain within same user_projects folder or completely clear off previous configured domain by manually backing up or removing /app/Oracle/Middleware/Oracle_Home/user_projects folder and then running config.sh from following location /app/Oracle/Middleware/Oracle_Home/bi/bin

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    THank you very much.. it worked... ...... Also is it possible to import samplessales bar file in it? is it downloadable anywhere or we can get from the set up files?

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Great News!!

    Yes you can import sample app bar file within the setup following below steps:

    a) Launch WLST Scripting Tool be executing below command from following location <ORACLE_HOME>\oracle_common\common\bin

    ./wlst.sh

    b) Once your within WLST Scripting Tool environment then execute below command

    importServiceInstance( '<DOMAIN_HOME>','<SERVICE INSTANCE NAME>', '<SAMPLEAPPLITE BAR FILE LOCATION>')

    In above command:

    a) DOMAIN_HOME will be the directory location as following /app/Oracle/Middleware/Oracle_Home/user_projects/domains/<DOMAIN NAME>
    b) SERVICE INSTANCE NAME by default is ssi but if in doubt check by executing below command


    listBIServiceInstances('<DOMAIN_HOME>')

    c) SAMPLEAPPLITE BAR FILE LOCATION can be found within below mentioned location

    <ORACLE_HOME>/bi/bifoundation/samples/sampleapplite/SampleAppLite.bar

    If not found in above location just give a search for same within following location <ORACLE_HOME>/bi

    Example would be as below:

    importServiceInstance( '/app/Oracle/Middleware/Oracle_Home/user_projects/domains/bi','ssi', '/app/Oracle/Middleware/Oracle_Home/bi/bifoundation/samples/sampleapplite/SampleAppLite.bar')

    d) Once importing SampleAppLite bar is successful then you might not changes within your environment immediately for that you need to restart your BIEE Component from EM.

    You have been great marking all the helpful comments,Please mark correct answer comment/remark which resolved your issue to close the thread