Oracle Analytics Cloud and Server

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

Error after BI installation - Server not initialized. Please make sure the repository is ready

Received Response
537
Views
11
Comments
Farzad Soltani
Farzad Soltani Rank 2 - Community Beginner

Hi,

I intend to test BI functionalities on Oracle APEX. I have installed Oracle Business Intelligence 12.2.1 on my windows x64 server.

The installation went through with difficulties but it was eventually successfully installed.

I configured a domain for BI. All steps were completed successfully.

I run

"startWebLogic.cmd"

through this directory :

 product\12.2.1\mw\user_projects\domains\bi\bin

No issues, I can access >

http://localhost:9500/console

and EM via

http://localhost:9500/em

1.JPG

2.JPG

I run

"startManagedWebLogic.cmd bi_server1" 

through the same directory. Server seems to startup correctly. These are the final lines in the console window :

Build Info: Oracle BI Publisher 12.2.1.0.0Build Info: Oracle BI Publisher 12.2.1.0.0Build Info: Oracle BI Publisher 12.2.1.0.0

6.JPG

I check in EM whether the server has startup or not, everything's green to go.

3.JPG

4.JPG

I try to access this link :

http://localhost:9502/xmlpserver/

I'm faced with this error :

ErrorServer not initialized. Please make sure the repository is ready.

5.JPG

What am I doing wrong?

«1

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Check this link:

    https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-6543ADEA-8161-4C90-9AEA-A132C292D2EE.htm#GUID-D700619E-77B4-4E2… https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-6543ADEA-8161-4C90-9AEA-A132C292D2EE.htm#GUID-D700619E-77B4-4E2D-8B56-1613C7054AD0

    Could you see the status of the

    1. Enter an appropriate command to run the status script located in:
      style="margin-bottom:1.25rem;font-family:inherit"
    2. The command displays component name, type, status, and machine name.

    1.png

    And also check the bi_server1.log and AdminServer.log

  • Farzad Soltani
    Farzad Soltani Rank 2 - Community Beginner

    I had already seen those links, but in reply to your answer :

    In this link : OBIEE 11g: Error: “Server not initialized. Please make sure the repository is ready” When Accessing BI Publisher from OB…
    it says to Log in to OBIEE 11g with Administrator credentials,

    where is that?

    in this link : Oracle Data Integrator Online Training: BI Publisher error : Server not initialized. Please make sure the repository is …

    it says to go to this directory : MW_HOME\user_projects\domains\bifoundation_domain\config\bipublisher

    first of all such a directory does not exist in my mw home, this is my structure : D:\app\Farzad\product\12.2.1\mw\user_projects\domains\bi\config

    and this its contents :

    1.JPG

    again in this link:https://orclfmw.wordpress.com/2015/03/07/server-not-initialized-please-make-sure-the-repository-is-ready/

    the folders mentioned (meta) do not exist

    and in this link : https://www.technicalconfessions.com/posts.php?post_id=201

    i don't have opmnctl.exe in this directory : D:\app\Farzad\product\12.2.1\mw\bin

  • Farzad Soltani
    Farzad Soltani Rank 2 - Community Beginner

    Thank you for your reply, in my initial attempt to run status.cmd through D:\app\Farzad\product\12.2.1\mw\user_projects\domains\bi\bitools\bin

    i was faced with this error :

    2.JPG

    then i went  to : D:\app\Farzad\product\12.2.1\mw\user_projects\domains\bi\bin

    and run  startNodeManager.cmd, then i retried running the status.cmd script and this is the result :

    3.JPG

    any insights?

    i have uploaded the log files on my dropbox :

    bi_server1.log : https://www.dropbox.com/s/ng3g1ibldyd22wh/bi_server1.log?dl=0

    AdminServer.log : https://www.dropbox.com/s/jl830ziga9co4ad/AdminServer.log?dl=0

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    nice clue your .. oracle bi services is not running.. thats the reason why we cant get into xmlpserver, analytics, etc. let met check your log

  • Farzad Soltani
    Farzad Soltani Rank 2 - Community Beginner

    how can i get them to start?

    thanks for checking my log

  • Farzad Soltani
    Farzad Soltani Rank 2 - Community Beginner

    any updates cesar?

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Start the components the BI Server,

    1. Check the AdminServer and BI Server is running

    Screen Shot 2016-10-25 at 1.50.31 PM.png

    2. Go: Enterprise Manager -> bi instances -> Availability

    Screen Shot 2016-10-25 at 1.46.36 PM.png

    * If there some components down, select and start

    Screen Shot 2016-10-18 at 1.41.23 PM.png

    Screen Shot 2016-10-25 at 1.43.38 PM.png

    3. Go: Administration Console -> Deployments, check the state of your deployments are "Active".

    Screen Shot 2016-10-25 at 1.47.48 PM.png

    4. Check again http://localhost:9502/xmlpserver/

  • Farzad Soltani
    Farzad Soltani Rank 2 - Community Beginner

    Cesar, Thanks for the help

    I did exactly what you said to do but this is the error I face :

    Capture.JPG

    and this is what i get when i click on View Log Messages :

    ##Search Criteria# Start Time: 2016-10-27T11:14:05.906+03:30# End Time: 2016-10-27T11:24:05.906+03:30# Message Types:INCIDENT_ERROR, ERROR, WARNING, NOTIFICATION, TRACE, UNKNOWN# ecid [OP_IS_IGNORE_CASE] 5132ee7b-c27c-4d41-be9d-e5811f18a1bf-0000019c#Selected Targets List# /Domain_bi/bi/AdminServer:weblogic_j2eeserver# /Domain_bi/bi/AdminServer/DMS Application(12.2.1.0.0):j2ee_application# /Domain_bi/bi/AdminServer/bi-fmwc-discovery(12.1.4):j2ee_application# /Domain_bi/bi/AdminServer/coherence-transaction-rar:j2ee_application# /Domain_bi/bi/AdminServer/em:j2ee_application# /Domain_bi/bi/AdminServer/opss-rest:j2ee_application# /Domain_bi/bi/AdminServer/state-management-provider-memory-rar:j2ee_application# /Domain_bi/bi/bi_server1:weblogic_j2eeserver# /Domain_bi/bi/bi_server1/DMS Application(12.2.1.0.0):j2ee_application# /Domain_bi/bi/bi_server1/ESSAPP:j2ee_application# /Domain_bi/bi/bi_server1/ESSBASE:j2ee_application# /Domain_bi/bi/bi_server1/adminservice(11.1.1):j2ee_application# /Domain_bi/bi/bi_server1/analytics:j2ee_application# /Domain_bi/bi/bi_server1/asyncadminservice(11.1.1):j2ee_application# /Domain_bi/bi/bi_server1/bi-actions:j2ee_application# /Domain_bi/bi/bi_server1/bi-lcm-rest:j2ee_application# /Domain_bi/bi/bi_server1/bi-security:j2ee_application# /Domain_bi/bi/bi_server1/bi-security-login:j2ee_application# /Domain_bi/bi/bi_server1/biadminservlet(11.1.1):j2ee_application# /Domain_bi/bi/bi_server1/bicomposer(11.1.1):j2ee_application# /Domain_bi/bi/bi_server1/bicontentserver(11.1.1):j2ee_application# /Domain_bi/bi/bi_server1/bidatasetsvc:j2ee_application# /Domain_bi/bi/bi_server1/bimad(11.1.1):j2ee_application# /Domain_bi/bi/bi_server1/bipublisher(11.1.1):j2ee_application# /Domain_bi/bi/bi_server1/bisearch:j2ee_application# /Domain_bi/bi/bi_server1/bitech-analysis-application:j2ee_application# /Domain_bi/bi/bi_server1/biwssoa(12.1.3):j2ee_application# /Domain_bi/bi/bi_server1/coherence-transaction-rar:j2ee_application# /Domain_bi/bi/bi_server1/jbips(11.1.1):j2ee_application# /Domain_bi/bi/bi_server1/mapviewer:j2ee_application# /Domain_bi/bi/bi_server1/obi.datasrc.server(12.2.1):j2ee_application# /Domain_bi/bi/bi_server1/state-management-provider-memory-rar:j2ee_application# /Domain_bi/bi/bi_server1/workspace(11.1.1):j2ee_application# /Domain_bi/bi/bi_server1/wsm-pm:j2ee_application#[2016-10-27T11:22:06.925+03:30] [AdminServer] [WARNING] [] [org.apache.myfaces.trinidad.component.UIXCollection] [host: FarzadHome] [nwaddr: 169.254.80.80] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 5132ee7b-c27c-4d41-be9d-e5811f18a1bf-0000019c,0] [APP: em] [partition-name: DOMAIN] [DSID: 0000LW53XWEBt1wN0EV^6F1O4QpY000002] [tenant-name: GLOBAL] [TARGET: /Domain_bi/bi/AdminServer/em] [TARGET_TYPE: j2ee_application] [LOG_FILE: D:\app\Farzad\product\12.2.1\mw\user_projects\domains\bi\servers\AdminServer\logs\AdminServer-diagnostic.log] The row key or row index of a UIXCollection component is being changed outside of the components context. Changing the key or index of a collection when the collection is not currently being visited, invoked on, broadcasting an event or processing a lifecycle method, is not valid. Data corruption and errors may result from this call. Turn on fine level logging for a stack trace of this call. Component ID: {0}[2016-10-27T11:22:10.955+03:30] [AdminServer] [ERROR] [EM-02665] [oracle.sysman.emai.view.bi.AvailabilityView] [host: FarzadHome] [nwaddr: 169.254.80.80] [tid: Thread-88] [userId: weblogic] [ecid: 5132ee7b-c27c-4d41-be9d-e5811f18a1bf-0000019c,0:2] [APP: em] [partition-name: DOMAIN] [tenant-name: GLOBAL] [TARGET: /Domain_bi/bi/AdminServer/em] [TARGET_TYPE: j2ee_application] [LOG_FILE: D:\app\Farzad\product\12.2.1\mw\user_projects\domains\bi\servers\AdminServer\sysman\log\emoms.trc] Can not start selected component.[[oracle.sysman.emai.model.bi.ModelException: Failed to start the component  at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.processComponent(AvailabilityAssistant.java:1111)  at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.startComponent(AvailabilityAssistant.java:967)  at oracle.sysman.emai.view.bi.AvailabilityView.startComponent(AvailabilityView.java:876)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  at java.lang.reflect.Method.invoke(Method.java:498)  at oracle.sysman.emInternalSDK.sdkas.general.pojo.progress.WorkWrapper.run(WorkWrapper.java:113)  at java.lang.Thread.run(Thread.java:745)]][2016-10-27T11:22:10.960+03:30] [AdminServer] [ERROR] [] [oracle.sysman.emInternalSDK.sdkas.general.pojo.progress.WorkWrapper] [host: FarzadHome] [nwaddr: 169.254.80.80] [tid: Thread-88] [userId: weblogic] [ecid: 5132ee7b-c27c-4d41-be9d-e5811f18a1bf-0000019c,0:2] [APP: em] [partition-name: DOMAIN] [tenant-name: GLOBAL] [TARGET: /Domain_bi/bi/AdminServer/em] [TARGET_TYPE: j2ee_application] [LOG_FILE: D:\app\Farzad\product\12.2.1\mw\user_projects\domains\bi\servers\AdminServer\sysman\log\emoms.trc] WorkWrapper caught exception: [[oracle.sysman.emSDK.app.exception.EMSystemException  at oracle.sysman.emai.view.bi.AvailabilityView.startComponent(AvailabilityView.java:881)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  at java.lang.reflect.Method.invoke(Method.java:498)  at oracle.sysman.emInternalSDK.sdkas.general.pojo.progress.WorkWrapper.run(WorkWrapper.java:113)  at java.lang.Thread.run(Thread.java:745)Caused by: oracle.sysman.emai.model.bi.ModelException: Failed to start the component  at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.processComponent(AvailabilityAssistant.java:1111)  at oracle.sysman.emai.model.bi.mbean.AvailabilityAssistant.startComponent(AvailabilityAssistant.java:967)  at oracle.sysman.emai.view.bi.AvailabilityView.startComponent(AvailabilityView.java:876)  ... 6 more]][2016-10-27T11:22:11.000+03:30] [AdminServer] [TRACE] [HTTP-200] [WebServer] [host: FarzadHome] [nwaddr: 169.254.80.80] [ecid: 5132ee7b-c27c-4d41-be9d-e5811f18a1bf-0000019c,0] [cs-method: POST] [cs-uri: /em/faces/ai/bi/instance?type=oracle_bi_instance&target=%2FDomain_bi%2Fbi%2FBusinessIntelligence&Adf-Window-Id=w0&Adf-Page-Id=1] [bytes: 3382] [TARGET: /Domain_bi/bi/AdminServer] [TARGET_TYPE: weblogic_j2eeserver] [LOG_FILE: D:\app\Farzad\product\12.2.1\mw\user_projects\domains\bi\servers\AdminServer\logs\access.log] POST /em/faces/ai/bi/instance?type=oracle_bi_instance&target=%2FDomain_bi%2Fbi%2FBusinessIntelligence&Adf-Window-Id=w0&Adf-Page-Id=1[2016-10-27T11:22:11.013+03:30] [AdminServer] [WARNING] [] [org.apache.myfaces.trinidad.component.UIXCollection] [host: FarzadHome] [nwaddr: 169.254.80.80] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 5132ee7b-c27c-4d41-be9d-e5811f18a1bf-0000019c,0] [APP: em] [partition-name: DOMAIN] [DSID: 0000LW53XWEBt1wN0EV^6F1O4QpY000002] [tenant-name: GLOBAL] [TARGET: /Domain_bi/bi/AdminServer/em] [TARGET_TYPE: j2ee_application] [LOG_FILE: D:\app\Farzad\product\12.2.1\mw\user_projects\domains\bi\servers\AdminServer\logs\AdminServer-diagnostic.log] row key might not be reset correctly at the end of the request. Component ID: :emT:avl_tt1 ViewId: /ai/bi/instance##Number of messages exported: 5#
  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Try this:

    1. Create a .cmd file

    2. Include the environment paths from 12c environment.

    Sample (set PATH=C:\Java\jdk1.8.0_66\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem call C:\Middleware12\user_projects\domains\bi\bitools\bin\start.cmd)

    4. In a cmd, execute the batch file to set the environment.

    5.  Once the services are started from this .cmd file, all of them come up without any issues.