OBIEE 12c: Configuration Assistent (biee.py) Failed with Exit Value 1 (Doc ID 2221805.1)

Last updated on SEPTEMBER 09, 2024

Applies to:

Symptoms

You got hanging at step 8 of 9 during OBI 12c Configuration Assistant. It is around progress 18%.

install2018-11-29_04-21-33PM.log

[2018-11-29T16:31:35.218+09:00] [bi] [NOTIFICATION] [] [oracle.bi.install.config.basesteps] [tid: 42] [ecid: 0000MTUM^f91Vctsoc7EDm1RztE2000004,0] Failed single shot step: BIEE with: Execution of [/u01/app/oracle/middleware/oracle_common/common/bin/wlst.sh, /u01/app/oracle/middleware/bi/modules/oracle.bi.configassistant/biee.py, /u01/app/oracle/middleware, /u01/app/oracle/middleware/user_projects/domains/bi, weblogic, Expanded, hxfpr371, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//<Hostname or IP Address>:1521/<Service Name>, TST1, jdbc:oracle:thin:@//<Hostname or IP Address>:1521/<Service Name>, ] failed with exit value 1
[2018-11-29T16:31:35.219+09:00] [bi] [ERROR] [] [oracle.bi.install.config.actions] [tid: 42] [ecid: 0000MTUM^f91Vctsoc7EDm1RztE2000004,0] Non-skipped failure during configuration action: Execution of [/u01/app/oracle/middleware/oracle_common/common/bin/wlst.sh, /u01/app/oracle/middleware/bi/modules/oracle.bi.configassistant/biee.py, /u01/app/oracle/middleware, /u01/app/oracle/middleware/user_projects/domains/bi, weblogic, Expanded, hxfpr371, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//<Hostname or IP Address>:1521/<Service Name>, TST1, jdbc:oracle:thin:@//<Hostname or IP Address>:1521/<Service Name>, ] failed with exit value 1[[
oracle.bi.exec.ExecutionStatusException: Execution of [/u01/app/oracle/middleware/oracle_common/common/bin/wlst.sh, /u01/app/oracle/middleware/bi/modules/oracle.bi.configassistant/biee.py, /u01/app/oracle/middleware, /u01/app/oracle/middleware/user_projects/domains/bi, weblogic, Expanded, hxfpr371, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//<Hostname or IP Address>:1521/<Service Name>, TST1, jdbc:oracle:thin:@//<Hostname or IP Address>:1521/<Service Name>, ] failed with exit value 1
at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:106)
at oracle.bi.exec.ExecScript.executeScript(ExecScript.java:191)
at oracle.bi.exec.ExecScript.executeSynchronousScript(ExecScript.java:95)
at oracle.bi.exec.ExecWLST.executeWLSTScript(ExecWLST.java:62)
at oracle.bi.install.config.steps.WLSTStep.executeSingleShot(WLSTStep.java:55)
at oracle.bi.install.config.basesteps.SingleShotActionStep.execute(SingleShotActionStep.java:31)
at oracle.bi.install.config.basesteps.StepList.execute(StepList.java:85)
at oracle.bi.install.config.actions.BIConfigAction.doExecute(BIConfigAction.java:127)
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:748)

]]

config2018-11-29_04-21-33PM\wlst_biee.log
---------------------------------------------------------------

2018-11-29 16:31:35,163 Severe [1] com.oracle.cie.domain.script.jython.CommandExceptionHandler - Error: runCmd() failed.
com.oracle.cie.domain.script.jython.WLSTException: 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.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:69)
at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:2983)
at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptContext.java:735)
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 org.python.core.PyReflectedFunction.__call__(Unknown Source)
at org.python.core.PyMethod.__call__(Unknown Source)
at org.python.core.PyObject.__call__(Unknown Source)
at org.python.core.PyInstance.invoke(Unknown Source)
at org.python.pycode._pyx40.command$1(/tmp/WLSTOfflineIni5335503856425638150.py:19)
at org.python.pycode._pyx40.call_function(/tmp/WLSTOfflineIni5335503856425638150.py)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyFunction.__call__(Unknown Source)
at org.python.pycode._pyx40.getDatabaseDefaults$68(/tmp/WLSTOfflineIni5335503856425638150.py:263)
at org.python.pycode._pyx40.call_function(/tmp/WLSTOfflineIni5335503856425638150.py)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyFunction.__call__(Unknown Source)
at org.python.core.PyObject.invoke(Unknown Source)
at dbargs$py.configureSimpleDefaultDataSources$3(/u01/app/oracle/middleware/bi/modules/oracle.bi.configassistant/pymodules/dbargs.py:137)
at dbargs$py.call_function(/u01/app/oracle/middleware/bi/modules/oracle.bi.configassistant/pymodules/dbargs.py)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyFunction.__call__(Unknown Source)
at org.python.core.PyObject.invoke(Unknown Source)
at bieeimpl$py.configureBIEE$2(/u01/app/oracle/middleware/bi/modules/oracle.bi.configassistant/pymodules/bieeimpl.py:40)
at bieeimpl$py.call_function(/u01/app/oracle/middleware/bi/modules/oracle.bi.configassistant/pymodules/bieeimpl.py)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyFunction.__call__(Unknown Source)
at org.python.core.PyObject.invoke(Unknown Source)
at org.python.pycode._pyx145.f$0(/u01/app/oracle/middleware/bi/modules/oracle.bi.configassistant/biee.py:20)
at org.python.pycode._pyx145.call_function(/u01/app/oracle/middleware/bi/modules/oracle.bi.configassistant/biee.py)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyCode.call(Unknown Source)
at org.python.core.Py.runCode(Py.java:1226)
at org.python.util.PythonInterpreter.execfile(Unknown Source)
at weblogic.management.scripting.WLST.main(WLST.java:186)
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 weblogic.WLST.main(WLST.java:47)
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.jython.WLSTState.processCommand(WLSTState.java:242)
at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptContext.java:729)
... 45 more
Caused by: com.oracle.cie.domain.script.jython.WLSTException: 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.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:69)
at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:2983)
at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3952)
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 com.oracle.cie.domain.script.jython.WLSTState.processCommand(WLSTState.java:225)
... 46 more
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:4001)
at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3948)
... 51 more
Caused by: com.oracle.cie.common.CommonException: Failed to build JDBC Connection object:
Root Cause: java.sql.SQLRecoverableException: IO　Error: Connection reset, Authentication lapse 65076 ms.
at com.oracle.cie.domain.jdbc.CommonDBHelper.bindShadowTableData(CommonDBHelper.java:693)
at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:3981)
... 52 more

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.