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

Farzad Soltani

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

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

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

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.

What am I doing wrong?

Arthur Dayton

These links might help -

OBIEE 11g: Error: “Server not initialized. Please make sure the repository is ready” When Accessing BI Publisher from OB…

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

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

https://www.technicalconfessions.com/posts.php?post_id=201

cesar.advincula.o

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.

And also check the bi_server1.log and AdminServer.log

Farzad Soltani

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 : \app\Farzad\product\12.2.1\mw\user_projects\domains\bi\config

and this its contents :

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 : \app\Farzad\product\12.2.1\mw\bin

Farzad Soltani

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

i was faced with this error :

then i went  to : \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 :

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

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

how can i get them to start?

thanks for checking my log

Farzad Soltani

any updates cesar?

cesar.advincula.o

Start the components the BI Server,

1. Check the AdminServer and BI Server is running

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

* If there some components down, select and start

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

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

Farzad Soltani

Cesar, Thanks for the help

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

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: \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: \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: \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: \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: \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

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.