OBIEE 12c configuration fails — Oracle Analytics

Oracle Analytics Cloud and Server

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

OBIEE 12c configuration fails

Received Response
92
Views
4
Comments
vai
vai Rank 4 - Community Specialist

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

Answers

  • rmoff
    rmoff Rank 6 - Analytics Lead

    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.

  • vai
    vai Rank 4 - Community Specialist

    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)

  • rmoff
    rmoff Rank 6 - Analytics Lead

    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.

  • Dario Bassan
    Dario Bassan Rank 1 - Community Starter

    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