OBIEE 12c Install Error - Configuration.sh -> Failed single shot step: Essbase

chillychin

I am on the final step of an install for a prototype OBIEE 12c and I keep hitting an error.

I am running the following script

<oracle_home>/bi/bin/config.sh

When I run this, I get to the last step [Configuration Process]

I start with BI Configuration and it gets to 7% Progress

On the step with "Essbase" I hit an error

Failed single shot step: Essbase with: Execution of [/itadm/u01/obiee/Middleware/obiee12c_home/oracle_common/common/bin/wlst.sh, /itadm/u01/obiee/Middleware/obiee12c_home/bi/modules/oracle.bi.configassistant/essbase.py, /itadm/u01/obiee/Middleware/obiee12c_home, /itadm/u01/obiee/Middleware/obiee12c_domain_home/user_projects/domains/bi, weblogic, Expanded, edwsnd, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//detection:1521/INFDEV, SND, jdbc:oracle:thin:@//detection:1521/INFDEV, ] failed with exit value 1

The rest of the log is as follows

------------------------------------------------------------------------------------------------------------------------

Failed single shot step: Essbase with: Execution of [/itadm/u01/obiee/Middleware/obiee12c_home/oracle_common/common/bin/wlst.sh, /itadm/u01/obiee/Middleware/obiee12c_home/bi/modules/oracle.bi.configassistant/essbase.py, /itadm/u01/obiee/Middleware/obiee12c_home, /itadm/u01/obiee/Middleware/obiee12c_domain_home/user_projects/domains/bi, weblogic, Expanded, edwsnd, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//detection:1521/INFDEV, SND, jdbc:oracle:thin:@//detection:1521/INFDEV, ] failed with exit value 1

[2017-03-06T10:37:28.850-05:00] [bi] [ERROR] [] [oracle.bi.install.config.actions] [tid: 45] [ecid: 0000Le^7rmIE^Mxho9aASY1OjNIU000004,0] Non-skipped failure during configuration action: Execution of [/itadm/u01/obiee/Middleware/obiee12c_home/oracle_common/common/bin/wlst.sh, /itadm/u01/obiee/Middleware/obiee12c_home/bi/modules/oracle.bi.configassistant/essbase.py, /itadm/u01/obiee/Middleware/obiee12c_home, /itadm/u01/obiee/Middleware/obiee12c_domain_home/user_projects/domains/bi, weblogic, Expanded, edwsnd, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//detection:1521/INFDEV, SND, jdbc:oracle:thin:@//detection:1521/INFDEV, ] failed with exit value 1[[

oracle.bi.exec.ExecutionStatusException: Execution of [/itadm/u01/obiee/Middleware/obiee12c_home/oracle_common/common/bin/wlst.sh, /itadm/u01/obiee/Middleware/obiee12c_home/bi/modules/oracle.bi.configassistant/essbase.py, /itadm/u01/obiee/Middleware/obiee12c_home, /itadm/u01/obiee/Middleware/obiee12c_domain_home/user_projects/domains/bi, weblogic, Expanded, edwsnd, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//detection:1521/INFDEV, SND, jdbc:oracle:thin:@//detection:1521/INFDEV, ] failed with exit value 1

  at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:76)

  at oracle.bi.exec.ExecScript.executeScript(ExecScript.java:164)

  at oracle.bi.exec.ExecScript.executeSynchronousScript(ExecScript.java:96)

  at oracle.bi.exec.ExecWLST.executeWLSTScript(ExecWLST.java:62)

  at oracle.bi.install.config.steps.WLSTStep.executeSingleShot(WLSTStep.java:58)

  at oracle.bi.install.config.basesteps.SingleShotActionStep.execute(SingleShotActionStep.java:32)

  at oracle.bi.install.config.basesteps.StepList.execute(StepList.java:85)

  at oracle.bi.install.config.actions.BIConfigAction.doExecute(BIConfigAction.java:129)

  at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:405)

  at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:88)

  at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:108)

  at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)

  at oracle.as.install.engine.modules.configuration.action.RequestQueue.performSequentialExecution(RequestQueue.java:284)

  at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:260)

  at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:185)

  at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:82)

  at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:87)

  at java.lang.Thread.run(Thread.java:745)

]]

[2017-03-06T10:37:28.858-05:00] [bi] [NOTIFICATION] [] [oracle.bi.install.config.actions] [tid: 45] [ecid: 0000Le^7rmIE^Mxho9aASY1OjNIU000004,0] Zipping up config assistant log files to /itadm/u01/obiee/Middleware/obiee12c_domain_home/user_projects/domains/bi/bilogs/bieeconfiglogs_2017-03-06_09-39-04AM.zip

[2017-03-06T10:37:28.981-05:00] [bi] [NOTIFICATION] [] [oracle.bi.install.config.actions] [tid: 45] [ecid: 0000Le^7rmIE^Mxho9aASY1OjNIU000004,0] Zipping up the following log files and directories: [[

/itadm/u01/app/oraInventory/logs/install2017-03-06_09-39-04AM.log

/itadm/u01/app/oraInventory/logs/install2017-03-06_09-39-04AM.out

/itadm/u01/app/oraInventory/logs/config2017-03-06_09-39-04AM

]]

[2017-03-06T10:37:29.021-05:00] [bi] [NOTIFICATION] [] [oracle.bi.install.config.actions] [tid: 45] [ecid: 0000Le^7rmIE^Mxho9aASY1OjNIU000004,0] Completed zipping up log files to /itadm/u01/obiee/Middleware/obiee12c_domain_home/user_projects/domains/bi/bilogs/bieeconfiglogs_2017-03-06_09-39-04AM.zip on host edwsnd

[2017-03-06T10:37:29.031-05:00] [as] [ERROR] [] [oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager] [tid: 45] [ecid: 0000Le^7rmIE^Mxho9aASY1OjNIU000004,0] One or More configurations failed. Exiting

------------------------------------------------------------------------------------------------------------------------

Does anyone have any idea what may be the issue?

Everything up to this point has been pretty much perfect, had a few snags here and there but nothing major.

Any insight much appreciated

chillychin

Adding screen shot

chillychin

So I did some more digging around and I was able to find some more log files located under another totally different folder

/u01/app/oraInventory/logs/configYYYY-MM-DD

There are about 6 files in here and I found the last file is

wlst_essbase.log

It looks like the log files that are generated are in order of what was being installed when I was running the config.sh

At the end of the file I see this error

Caused by: com.oracle.cie.domain.script.ScriptException: Got exception when auto configuring the schema component(s) with data obtained from shadow table: Failed to build JDBC Connection object:   at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2946)  at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3299)  ... 51 moreCaused by: com.oracle.cie.common.CommonException: Failed to build JDBC Connection object: Root Cause: java.sql.SQLRecoverableException: IO Error: Connection reset  at com.oracle.cie.domain.jdbc.CommonDBHelper.bindShadowTableData(CommonDBHelper.java:639)  at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2932)  ... 52 more

So Im not sure which error to trouble shoot? My first error that I got was "Failed single shot step"

Upon further digging I find this connection reset error

Has anyone else hit this type of "Failed single shot step error"??

3310714

Hi,

Just curious, did you create the RCU schemas ahead of time?  also, did you verify the JDBC string is correct?

Gianni Ceresa

Can you check something in the log? Is the timestamp of the log lines between the previous successful thing and the error about 5 minutes later?

I just saw something similar to your logs 10 minutes when configuring OBIEE and it was because of the java random vs urandom (so changing the config to use urandom solved the problem).

I'm not saying it's the reason and solution for you too, just something to maybe check, if you aren't having a timeout because of some external factors.

chillychin

I did create the RCU ahead of time

I checked and double checked that the JDBC connection string is right, I was thinking that maybe that was the issue too, but I am sure I entered in the right connection string

chillychin

The time between the first previous item to the error is more then 5 minutes later.

It seems when it gets to the Essbase step it "freezes", but I can still see folders being created so I just left it.

After about half an hour then I hit the error.

Can you elaborate on the java random vs urandom please?

Gianni Ceresa

It's about entropy, or actually the lack of entropy in your system. There are lot of things written about that and I'm not going to try to summarize them here (in case google about java weblogic /dev/random and /dev/urandom and I guess you will find lot of them).

What I did in my OBIEE container to fix the timeout giving the error on configure is what they say here: https://docs.oracle.com/cd/E13209_01/wlcp/wlss30/configwlss/jvmrand.html

First find the java.security file used by your java (the java 1.8 you installed or had to be able to install OBIEE).

There inside look for the row "securerandom.source=file:/dev/random" and change it by adding the "u" to "securerandom.source=file:/dev/urandom".

Do this before to run your configuration.

If you are suffering of that issue it will be solve it directly and your config will just go over all steps fine.

chillychin

Thanks a lot Gianni

After you mentioned entropy and the /dev/random and /dev/urandom, I do recall seeing those terms while browsing through the error logs.

There was mention of a "lack of entropy" in my error logs

I actually took a bit of a short cut and searched in the forums and came across this link

OBIEE 12c configuration fails

I modified the wlst.sh directly and added the line of code -Djava.security.egd=file:///dev/urandom as mentioned in the article and it seemed to do the trick for my installation.

As my OBIEE installation is not "alone" on the server I am installing on, I rather not mess with the Java on the machine, as I am not sure what other processes are using it and felt it may be safer to modify the wlst.sh script instead.

But I am still awarding you correct answer