Forum Stats

  • 3,768,651 Users
  • 2,252,827 Discussions
  • 7,874,669 Comments

Discussions

Failed to configure "Deploy to application server" under Essbase while configuration EPM 11.2 on dis

3329037
3329037 Member Posts: 124
edited Aug 7, 2020 3:14AM in EPM System Infrastructure

Hi,

We are installing EPM 11.2 on our distributed linux server. Components are installed as below.

Serv1 : Foundation, Calc, Planning, HFR (these all components was successfully configured)
Serv2 : Essbase server , EAS, Essbase studio (Facing issue while configured "Deployed to application server" under Essbase)
Serv3 : Database 12C

We have successfully installed and configured all the components on Foundation server. But we are facing the issue for "Deploy to Application server" under Essbase.

Before starting configuration, we ran the RCU and edit RCUSchema propeties file as per the RCU utility on both server(made prefix as EPM on Foundation and ESS on Essbase server while running RCU Utility).

Please find error details in next update.

Thanks

Answers

  • 3329037
    3329037 Member Posts: 124
    edited Aug 7, 2020 12:02AM

    Error logs from the file wlst_debug.log

    2020-08-05 08:30:15,793 WARNING [1] com.oracle.cie.domain.jdbc.WlsDBHelper - Invalid section
    com.oracle.cie.domain.ValidateException: 40318: Invalid or missing JDBC datasource connection parameters.
    40318: The JDBC datasource required parameters are invalid or missing.
    40318: Correct the datasource connection parameters.
    at com.oracle.cie.domain.jdbc.WlsDBHelper.validateJdbcResourceAspect(WlsDBHelper.java:687)
    at com.oracle.cie.domain.DomainChecker.getInvalidSectionsDetails(DomainChecker.java:385)
    at com.oracle.cie.domain.WLSGeneratorHelper.validateConfig(WLSGeneratorHelper.java:196)
    at com.oracle.cie.domain.script.ScriptExecutor.updateDomain(ScriptExecutor.java:2484)
    at com.oracle.cie.domain.script.jython.WLScriptContext.updateDomain(WLScriptContext.java:1140)
    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)
    at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptContext.java:729)
    at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source)
    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._pyx5.command$1(/tmp/WLSTOfflineIni5981678575707453796.py:19)
    at org.python.pycode._pyx5.call_function(/tmp/WLSTOfflineIni5981678575707453796.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._pyx5.updateDomain$32(/tmp/WLSTOfflineIni5981678575707453796.py:139)
    at org.python.pycode._pyx5.call_function(/tmp/WLSTOfflineIni5981678575707453796.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.pycode._pyx101.f$0(/tmp/default_batch8941808561133655161.py:65)
    at org.python.pycode._pyx101.call_function(/tmp/default_batch8941808561133655161.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.core.__builtin__.execfile_flags(Unknown Source)
    at org.python.core.__builtin__.execfile(Unknown Source)
    at org.python.core.__builtin__.execfile(Unknown Source)
    at org.python.core.BuiltinFunctions.__call__(Unknown Source)
    at org.python.pycode._pyx100.f$0(<console>:1)
    at org.python.pycode._pyx100.call_function(<console>)
    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.core.Py.exec(Py.java:1252)
    at org.python.util.PythonInterpreter.exec(Unknown Source)
    at org.python.util.InteractiveInterpreter.runcode(Unknown Source)
    at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
    at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
    at weblogic.management.scripting.utils.WLSTInterpreter.runsource(WLSTInterpreter.java:1095)
    at weblogic.management.scripting.WLST.main(WLST.java:232)
    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)
    2020-08-05 08:30:15,793 WARNING [1] com.oracle.cie.domain.jdbc.WlsDBHelper - Datasource validation error: EPMSystemRegistry: 64206: Unspecified properties.
    64206: The following must be specified:       Username, Password
    64206: Provide missing properties.

    EPMSystemRegistry: 64207: Mismatched passwords.
    64207: The Password and Confirm Password do not match.
    64207: Correct the password.
    EPMSystemRegistry: 64208: Invalid value.
    64208: The Port must be an integer.
    64208: Provide integer value.
    com.oracle.cie.domain.ValidateException: 40318: Invalid or missing JDBC datasource connection parameters.
    40318: The JDBC datasource required parameters are invalid or missing.
    40318: Correct the datasource connection parameters.
    at com.oracle.cie.domain.jdbc.WlsDBHelper.validateJdbcResourceAspect(WlsDBHelper.java:687)
    at com.oracle.cie.domain.DomainChecker.getInvalidSectionsDetails(DomainChecker.java:385)
    at com.oracle.cie.domain.WLSGeneratorHelper.validateConfig(WLSGeneratorHelper.java:196)
    at com.oracle.cie.domain.script.ScriptExecutor.updateDomain(ScriptExecutor.java:2484)
    at com.oracle.cie.domain.script.jython.WLScriptContext.updateDomain(WLScriptContext.java:1140)
    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)
    at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptContext.java:729)
    at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source)
    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._pyx5.command$1(/tmp/WLSTOfflineIni5981678575707453796.py:19)
    at org.python.pycode._pyx5.call_function(/tmp/WLSTOfflineIni5981678575707453796.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._pyx5.updateDomain$32(/tmp/WLSTOfflineIni5981678575707453796.py:139)
    at org.python.pycode._pyx5.call_function(/tmp/WLSTOfflineIni5981678575707453796.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.pycode._pyx101.f$0(/tmp/default_batch8941808561133655161.py:65)
    at org.python.pycode._pyx101.call_function(/tmp/default_batch8941808561133655161.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.core.__builtin__.execfile_flags(Unknown Source)
    at org.python.core.__builtin__.execfile(Unknown Source)
    at org.python.core.__builtin__.execfile(Unknown Source)
    at org.python.core.BuiltinFunctions.__call__(Unknown Source)
    at org.python.pycode._pyx100.f$0(<console>:1)
    at org.python.pycode._pyx100.call_function(<console>)
    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.core.Py.exec(Py.java:1252)
    at org.python.util.PythonInterpreter.exec(Unknown Source)
    at org.python.util.InteractiveInterpreter.runcode(Unknown Source)
    at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
    at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
    at weblogic.management.scripting.utils.WLSTInterpreter.runsource(WLSTInterpreter.java:1095)
    at weblogic.management.scripting.WLST.main(WLST.java:232)
    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)
    2020-08-05 08:30:15,800 INFO  [1] com.oracle.cie.domain.script.ScriptExecutor - warning:update domain
    2020-08-05 08:30:15,800 INFO  [1] com.oracle.cie.domain.script.ScriptExecutor - 40318: Invalid or missing JDBC datasource connection parameters.
    40318: The JDBC datasource required parameters are invalid or missing.
    40318: Correct the datasource connection parameters.

  • Krishna Chukkaluru
    Krishna Chukkaluru Member Posts: 164 Silver Badge
    edited Aug 7, 2020 12:43AM

    Please check the details provided in RCUSchema properties (in Essbase server with ESS prefix) are correct. If you update them, before running "Deploy to Application Server" remove the domains folder or else it wont read the changes made in RCUSchema properties file.

    Regards,

    Krishna

  • Srini+K
    Srini+K Member Posts: 253 Blue Ribbon
    edited Aug 7, 2020 12:44AM

    Password wrong?? JDBC datasource required parameters are invalid..or missing..

    some registry messed up issue.. can you run the registry cleanup and reconfigure..

  • 3329037
    3329037 Member Posts: 124
    edited Aug 7, 2020 12:50AM

    Yes, After running RCU utility, we have set the required changes in RCUSchema properties. I did not remove domains folder. So do we need to remove that folder before running EPM configurator ?

  • Krishna Chukkaluru
    Krishna Chukkaluru Member Posts: 164 Silver Badge
    edited Aug 7, 2020 1:16AM

    After your installation, you update the RCUSchema properties file with all the details along with prefix you provided while running RCU utility.

    At this point you did not start your configuration yet and the domains folder does not exist. Your initial deployment should go fine. If your deployment failed and you identified few changes required in RCUSchema properties file and updated them. In this case you need to remove domains folder before deploying again using EPM configurator.

    Regards,

    Krishna

  • 3329037
    3329037 Member Posts: 124
    edited Aug 7, 2020 1:26AM

    I did as you suggested but no luck. Thanks

  • 3329037
    3329037 Member Posts: 124
    edited Aug 7, 2020 2:05AM

    Thanks for the update.

    Currently, I have dropped all schema by running RUC and create it back and update RCUSchema properties file as per the RUC ran. Rename Oracle_Projects  as Oracle_Projects_Old and rerun EPM System Configurator but no luck.

  • 3329037
    3329037 Member Posts: 124
    edited Aug 7, 2020 2:27AM

    Hi All,

    At last, we recognise that we need to install EAS and APS on foundation server(did not configure on foundation server).

    Then copy Config folder from foundation (Middleware->User_projects -> domains->EPMSystem->config) and paste it on Essbase server on the same location (made a backup of current config folder in Essbase server).

    Now, It's successfully completed.

    Thanks team for your support.

    3329037
  • Krishna Chukkaluru
    Krishna Chukkaluru Member Posts: 164 Silver Badge
    edited Aug 7, 2020 3:14AM

    Good to hear that your issue is resolved. That is the prerequisite in a distributed environment to install all your web app components in primary foundation server where you are deploying wep apps to Weblogic server. Let's say if you want to add FDMEE or HFM components in your landscape and go for new server, you have to install the FDMEE and HFM web components in primary foundation server too before you configure them in new server. FYI, the copy of Config folder to your 2nd server is not required usually.

    Regards,

    Krishna

    3329037