4 Replies Latest reply on Jun 21, 2016 3:05 PM by Dario Bassan

    OBIEE 12c configuration fails

    vai

      my OBIEE 12c configuration fails at essbase .. i tried installing twice, but it fails at essbase configuration or BIP configuration.

      Below are log file output. Can  anyone please help me in resolving the issue.

       

       

      [2016-06-06T19:03:51.836+05:30] [bi] [NOTIFICATION] [] [oracle.bi.install.config.basesteps] [tid: 43] [ecid: 0000LK_r5Z2CGv15zvt1iW1NLNQs000004,0] Failed single shot step: BI Publisher (BIP) with: Execution of [/home/oracle/Oracle/Middleware/Oracle_Home/oracle_common/common/bin/wlst.sh, /home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/bip.py, /home/oracle/Oracle/Middleware/Oracle_Home, /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi, weblogic, Expanded, localhost, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//localhost:1521/dwhtest, DEV2, jdbc:oracle:thin:@//localhost:1521/dwhtest, ] failed with exit value 1

      [2016-06-06T19:03:51.837+05:30] [bi] [ERROR] [] [oracle.bi.install.config.actions] [tid: 43] [ecid: 0000LK_r5Z2CGv15zvt1iW1NLNQs000004,0] Non-skipped failure during configuration action: Execution of [/home/oracle/Oracle/Middleware/Oracle_Home/oracle_common/common/bin/wlst.sh, /home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/bip.py, /home/oracle/Oracle/Middleware/Oracle_Home, /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi, weblogic, Expanded, localhost, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//localhost:1521/dwhtest, DEV2, jdbc:oracle:thin:@//localhost:1521/dwhtest, ] failed with exit value 1[[

      oracle.bi.exec.ExecutionStatusException: Execution of [/home/oracle/Oracle/Middleware/Oracle_Home/oracle_common/common/bin/wlst.sh, /home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/bip.py, /home/oracle/Oracle/Middleware/Oracle_Home, /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi, weblogic, Expanded, localhost, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//localhost:1521/dwhtest, DEV2, jdbc:oracle:thin:@//localhost:1521/dwhtest, ] 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)

       

       

      ]]

      [2016-06-06T19:03:51.839+05:30] [bi] [NOTIFICATION] [] [oracle.bi.install.config.actions] [tid: 43] [ecid: 0000LK_r5Z2CGv15zvt1iW1NLNQs000004,0] Zipping up config assistant log files to /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/bilogs/bieeconfiglogs_2016-06-06_06-42-20PM.zip

      [2016-06-06T19:03:51.843+05:30] [bi] [NOTIFICATION] [] [oracle.bi.install.config.actions] [tid: 43] [ecid: 0000LK_r5Z2CGv15zvt1iW1NLNQs000004,0] Zipping up the following log files and directories: [[

      /home/oracle/app/oraInventory/logs/install2016-06-06_06-42-20PM.out

      /home/oracle/app/oraInventory/logs/install2016-06-06_06-42-20PM.log

      /home/oracle/app/oraInventory/logs/config2016-06-06_06-42-20PM

        • 1. Re: OBIEE 12c configuration fails
          rmoff

          All that log tells you is that bip.py exited with an error code, thus causing the install to fail. Have a dig around and see if you can find the output/error in the execution of that particular step.

          • 2. Re: OBIEE 12c configuration fails
            vai

            found below errors in the config logs of wlst_bip.log

             

             

            2016-06-06 19:02:50,103 INFO  [1] com.oracle.cie.domain.script.ScriptExecutor - find JDBCSystemResource!JdbcResource!JDBCDriverParams!Properties "LocalSvcTblDataSource!LocalSvcTblDataSource!NO_NAME_0!NO_NAME_0" as obj6

            2016-06-06 19:02:50,103 WARNING [1] com.oracle.cie.domain.aspect.XBeanConfigAspect - Unable to locate property:Name on type:class com.oracle.cie.domain.xml.configxb.weblogic.x90.impl.JDBCDriverParamsTypeImpl

            2016-06-06 19:02:50,104 INFO  [1] com.oracle.cie.domain.script.ScriptExecutor - succeed: find JDBCSystemResource!JdbcResource!JDBCDriverParams!Properties "LocalSvcTblDataSource!LocalSvcTblDataSource!NO_NAME_0!NO_NAME_0" as obj6

            2016-06-06 19:02:50,105 WARNING [1] com.oracle.cie.domain.aspect.XBeanConfigAspect - Unable to locate property:Name on type:class com.oracle.cie.domain.xml.configxb.weblogic.x90.impl.JDBCDriverParamsTypeImpl

            2016-06-06 19:02:50,105 WARNING [1] com.oracle.cie.domain.aspect.XBeanConfigAspect - Unable to locate property:Name on type:class com.oracle.cie.domain.xml.configxb.weblogic.x90.impl.JDBCPropertiesTypeImpl

            2016-06-06 19:03:51,773 SEVERE [1] com.oracle.cie.domain.jdbc.CommonDBHelper - Failed to build JDBC Connection object:

            java.sql.SQLRecoverableException: IO Error: Connection reset

              at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:752)

              at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)

              at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

              at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)

              at com.oracle.cie.domain.jdbc.JDBCConnectionTester.createConnection(JDBCConnectionTester.java:336)

              at com.oracle.cie.domain.jdbc.JDBCConnectionTester.createConnection(JDBCConnectionTester.java:461)

              at com.oracle.cie.domain.jdbc.CommonDBHelper.buildConnection(CommonDBHelper.java:569)

              at com.oracle.cie.domain.jdbc.JdbcConnectionHelper.buildConnection(JdbcConnectionHelper.java:43)

              at com.oracle.cie.domain.jdbc.WlsJdbcConnectionHelper.buildConnection(WlsJdbcConnectionHelper.java:117)

              at com.oracle.cie.domain.jdbc.CommonDBHelper.bindShadowTableData(CommonDBHelper.java:633)

              at com.oracle.cie.domain.script.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2932)

              at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3299)

              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:216)

              at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptContext.java:670)

              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._pyx38.command$1(/tmp/WLSTOfflineIni4539773478893914508.py:19)

              at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni4539773478893914508.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._pyx38.getDatabaseDefaults$66(/tmp/WLSTOfflineIni4539773478893914508.py:251)

              at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni4539773478893914508.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(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/dbargs.py:137)

              at dbargs$py.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/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 bipimpl$py.configureBIP$1(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/bipimpl.py:18)

              at bipimpl$py.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/bipimpl.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._pyx139.f$0(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/bip.py:22)

              at org.python.pycode._pyx139.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/bip.py)

              at org.python.core.PyTableCode.call(Unknown Source)

              at org.python.core.PyCode.call(Unknown Source)

              at org.python.core.Py.runCode(Unknown Source)

              at org.python.util.PythonInterpreter.execfile(Unknown Source)

              at weblogic.management.scripting.WLST.main(WLST.java:181)

              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: java.net.SocketException: Connection reset

              at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)

              at java.net.SocketOutputStream.write(SocketOutputStream.java:153)

              at oracle.net.ns.DataPacket.send(DataPacket.java:209)

              at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:215)

              at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:302)

              at oracle.net.ns.NetInputStream.read(NetInputStream.java:249)

              at oracle.net.ns.NetInputStream.read(NetInputStream.java:171)

              at oracle.net.ns.NetInputStream.read(NetInputStream.java:89)

              at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)

              at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)

              at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:429)

              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:397)

              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)

              at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:437)

              at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:954)

              at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:639)

              ... 62 more

            2016-06-06 19:03:51,775 SEVERE [1] com.oracle.cie.domain.script.ScriptExecutor - Unable to execxute getDatabaseDefaults

            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)

              at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3299)

              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:216)

              at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptContext.java:670)

              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._pyx38.command$1(/tmp/WLSTOfflineIni4539773478893914508.py:19)

              at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni4539773478893914508.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._pyx38.getDatabaseDefaults$66(/tmp/WLSTOfflineIni4539773478893914508.py:251)

              at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni4539773478893914508.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(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/dbargs.py:137)

              at dbargs$py.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/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 bipimpl$py.configureBIP$1(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/bipimpl.py:18)

              at bipimpl$py.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/bipimpl.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._pyx139.f$0(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/bip.py:22)

              at org.python.pycode._pyx139.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/bip.py)

              at org.python.core.PyTableCode.call(Unknown Source)

              at org.python.core.PyCode.call(Unknown Source)

              at org.python.core.Py.runCode(Unknown Source)

              at org.python.util.PythonInterpreter.execfile(Unknown Source)

              at weblogic.management.scripting.WLST.main(WLST.java:181)

              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)

            2016-06-06 19:03:51,780 SEVERE [1] com.oracle.cie.domain.script.jython.WLSTState - Exception executing command getDatabaseDefaults

            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:2360)

              at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3303)

              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:216)

              at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptContext.java:670)

              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._pyx38.command$1(/tmp/WLSTOfflineIni4539773478893914508.py:19)

              at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni4539773478893914508.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._pyx38.getDatabaseDefaults$66(/tmp/WLSTOfflineIni4539773478893914508.py:251)

              at org.python.pycode._pyx38.call_function(/tmp/WLSTOfflineIni4539773478893914508.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(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/dbargs.py:137)

              at dbargs$py.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/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 bipimpl$py.configureBIP$1(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/bipimpl.py:18)

              at bipimpl$py.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/pymodules/bipimpl.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._pyx139.f$0(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/bip.py:22)

              at org.python.pycode._pyx139.call_function(/home/oracle/Oracle/Middleware/Oracle_Home/bi/modules/oracle.bi.configassistant/bip.py)

              at org.python.core.PyTableCode.call(Unknown Source)

              at org.python.core.PyCode.call(Unknown Source)

              at org.python.core.Py.runCode(Unknown Source)

              at org.python.util.PythonInterpreter.execfile(Unknown Source)

              at weblogic.management.scripting.WLST.main(WLST.java:181)

              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.ScriptExecutor.getDatabaseDefaults(ScriptExecutor.java:2946)

              at com.oracle.cie.domain.script.jython.WLScriptContext.getDatabaseDefaults(WLScriptContext.java:3299)

              ... 51 more

            Caused 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)

            • 3. Re: OBIEE 12c configuration fails
              rmoff

              Looks like the DB you're trying to use for your RCU schema is having problems, and/or you've mis-specified its connection details.

              • 4. Re: OBIEE 12c configuration fails
                Dario Bassan

                I had similar problem on my Linux box and I was able to solve following this link:

                 

                https://community.oracle.com/thread/943911?tstart=0

                 

                I guess there are known problem in Oracle on "java.sql.SQLRecoverableException:  during products install on Linux/Unix.

                In the previous link I read "I opened a ticket with Oracle and this is what they told me".

                 

                The problem is related to this JDK class: "java.security.SecureRandom"

                 

                Looking at the source in the latest JDK you can find:

                 

                " * Note: Depending on the implementation, the {@code generateSeed} and

                * {@code nextBytes} methods may block as entropy is being gathered,

                * for example, if they need to read from /dev/random on various Unix-like

                * operating systems.

                "

                 

                So I followed the work-around from the forum and added -Djava.security.egd=file:///dev/../dev/urandom to WLST shell command

                 

                [MW_HOME]/oracle_common/common/bin/wlst.sh

                 

                " .....

                JVM_ARGS="-Djava.security.egd=file:///dev/../dev/urandom ${WLST_PROPERTIES} ${JVM_D64} ${UTILS_MEM_ARGS} ${CONFIG_JVM_ARGS}"

                if [ -d "${JAVA_HOME}" ]; then

                eval '"${JAVA_HOME}/bin/java"' ${JVM_ARGS} weblogic.WLST '"$@"'

                else

                exit 1

                fi

                ...."

                 

                And this fix it.

                 

                Before this I tried several times having always the same "IO Error: Connection reset" problem in different steps of installation process.

                 

                Hope this help.

                 

                Ciao

                Dario