Oracle Hyperion Enterprise Management (EPM) 11.2 was released on Dec 18th, and I guess that was an important day for the EPM/CPM market. OneStream 5.3 version was also released on the same day.
I opted to download Planning Plus, and the installer size (11 items, including the client installers) is 16 Gb.
I found out that (even in 2019) there are issues with spaces!. Well, part of the problem is I’m using a user name that got spaces and the installer; specifically, when you are installing OPMN (Essbase) doesn’t like spaces.
Installation
Here is the first error during installation.
The log file says Fail opmn assembly was not saved in the SoftwareRegistry.
I was wondering why it wouldn’t save in the register. Now, this started a wild goose chase and finally found the log file E:\Oracle\Middleware\EPMSystem11R1\diagnostics\logs\install\common-opmn-patchset-oui-out.log.
My user name is Celvin Kattookaran (yeah, call me a narcissist 🙂 ), and there you go, it doesn’t like spaces.
Installation went fine when I used a user name without spaces.
Configuration
I went with the assumption that I know this like the back of my hand. Boy, I was wrong about it.
Errors, and more errors.
First, let’s talk about Pre-Configuration failure. That can be a common mistake. I clicked on Config after the installation and, as a result, the below-given error.
Yup, I’m still an Administrator, UAC is turned off. However, I didn’t use the “Run as an Administrator” option.
Before running the configuration, Please make sure that you use the “Run as administrator” option.
Deploy to Application server failure is the result of (me being stupid and not reading the docs) the new Middleware upgrade. EPM 11.2 is now shipped with Weblogic 12 c (12.2) even though the configtool.log says,
[EPMCFG] [TRACE] [EPMCFG-01725] [oracle.EPMCFG] [tid: 64] [ecid: 40662168-3db7-4ea7-b459-c1399a086f20-00000007,0] [SRC_CLASS: com.hyperion.config.wizard.AppServerSelectionField] AppServer selected: WebLogic 10.
Fusion middleware components need schemas before you can configure them, so you cannot skip this step.
Here is the error from wlst_debug.log
Running RCU utility
Point towards your database instance and supply a SYSDBA user and password. If you don’t want to use a SYSDBA user, please go through the link provided.
You can create multiple schemas on the same server by changing the prefixes.
Please provide a password for the schemas, and I went with the same password for all schemas.
Once done, you’ll get an option to manage tablespaces. Once again, I went with the defaults.
A couple of summary screens and you are done with Repository creation utility.
You can read more about RCU and different options here.
If you go through it, you’ll understand that you cannot re-use the same schema on multiple servers.
Once the repositories get created, you must update the RCUSchema.properties file so that the config tool can pick it up.
Here is the screen that I wished(longed) to see.
Now it is time to log in and find out if all the products are new and shiny!
Well, it seems like there is one more missing piece to the puzzle.
Another error during the start-up of Foundation Services.
Caused By: weblogic.security.SecurityInitializationException: Authentication denied: Boot identity not valid. The user name or password or both from the boot identity file (boot.properties) is not valid. The boot identity may have been changed since the boot identity file was created. Please edit and update the boot identity file with the proper values of username and password. The first time the updated boot identity file is used to start the server, these new values are encrypted.
at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.doBootAuthorization(CommonSecurityServiceManagerDelegateImpl.java:1152)
at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.postInitialize(CommonSecurityServiceManagerDelegateImpl.java:1272)
at weblogic.security.service.SecurityServiceManager.postInitialize(SecurityServiceManager.java:586)
at weblogic.security.SecurityService.start(SecurityService.java:130)
at weblogic.server.AbstractServerService.postConstruct(AbstractServerService.java:76)
Truncated. see log file for complete stacktrace
Caused By: javax.security.auth.login.FailedLoginException: [Security:090938]Authentication failure: The specified user failed to log in. weblogic.security.providers.authentication.LDAPAtnDelegateException: [Security:090295]caught unexpected exception, No such object
at com.bea.common.security.utils.ExceptionHandler.throwFailedLoginException(ExceptionHandler.java:62)
at weblogic.security.providers.authentication.LDAPAtnLoginModuleImpl.login(LDAPAtnLoginModuleImpl.java:368)
at com.bea.common.security.internal.service.LoginModuleWrapper$1.run(LoginModuleWrapper.java:117)
at java.security.AccessController.doPrivileged(Native Method)
at com.bea.common.security.internal.service.LoginModuleWrapper.login(LoginModuleWrapper.java:114)
Truncated. see log file for complete stacktrace
>
How is that possible, boot.properties file was generated by the config tool and how can that be wrong?
I did check E:\Oracle\Middleware\user_projects\domains\<epminstancename>\servers\FoundationServices0\security\boot.properties file and that is the correct user name and password.
Taking a cue from another message in the log file, I decided to start the Admin server.
<Dec 23, 2019 10:39:00 AM EST> <Info> <Management> <BEA-141307> <Unable to connect to the Administration Server. Waiting 5 second(s) to retry (attempt number 1 of 3).>
<Dec 23, 2019 10:39:13 AM EST> <Info> <Management> <BEA-141307> <Unable to connect to the Administration Server. Waiting 5 second(s) to retry (attempt number 2 of 3).>
<Dec 23, 2019 10:39:26 AM EST> <Info> <Management> <BEA-141307> <Unable to connect to the Administration Server. Waiting 5 second(s) to retry (attempt number 3 of 3).>
<Dec 23, 2019 10:39:39 AM EST> <Info> <Management> <BEA-141298> <Could not register with the Administration Server: java.rmi.RemoteException:
[from AdminURL 0] weblogic.deploy.service.internal.transport.UnreachableHostException: [Deployer:149145]Unable to contact "null". Deployment is deferred until "null" becomes available. WARNING: If this is a redeploy app and contains JSP pages that have been touched, these JSP changes wont be reflected when the server starts unless precompile is set to true in weblogic.xml; nested exception is:
java.net.ConnectException: Tried all: '2' addresses, but could not connect over HTTP to server: 'Xander', port: '7001'
failed reasons:
[0] address:'Xander/10.0.2.15',port:'7001' : java.net.ConnectException: Connection refused: connect
[1] address:'Xander/fe80:0:0:0:f890:dcb6:9101:5b00%6',port:'7001' : java.net.ConnectException: Connection refused: connect
[from AdminURL 1] weblogic.deploy.service.internal.transport.UnreachableHostException: [Deployer:149145]Unable to contact "null". Deployment is deferred until "null" becomes available. WARNING: If this is a redeploy app and contains JSP pages that have been touched, these JSP changes wont be reflected when the server starts unless precompile is set to true in weblogic.xml; nested exception is:
java.net.ConnectException: Tried all: '1' addresses, but could not connect over HTTP to server: '10.0.2.15', port: '7001'
failed reasons:
[0] address:'/10.0.2.15',port:'7001' : java.net.ConnectException: Connection refused: connect
[from AdminURL 2] weblogic.deploy.service.internal.transport.UnreachableHostException: [Deployer:149145]Unable to contact "null". Deployment is deferred until "null" becomes available. WARNING: If this is a redeploy app and contains JSP pages that have been touched, these JSP changes wont be reflected when the server starts unless precompile is set to true in weblogic.xml; nested exception is:
java.net.ConnectException: Tried all: '1' addresses, but could not connect over HTTP to server: '[fe80:0:0:0:f890:dcb6:9101:5b00%6]', port: '7001'
failed reasons:
I’m not a big fan of running Weblogic in the foreground, so I did install it as a service using a batch file.
Before doing that I did make a slight modification to <middleware home>\wlserver\server\bin\installSvc.cmd.
I did add the following lines after check_server_name function, as shown below.
: check_server_name
if not defined SERVICE_NAME (
set SERVICE_NAME="wlsvc %DOMAIN_NAME%_%SERVER_NAME%"
)
Once the above change is added, it is now time to edit the Install service call.
Here is my install script.
echo off
SETLOCAL
set HOST=Xander
set PORT=7001
set DOMAIN_NAME=XanderEPMSystem
set SERVICE_NAME=Oracle Weblogic Admin Server - Java Web Application (%DOMAIN_NAME%)
set SERVICE_DESCRIPTION=Provides access to Weblogic Adminstration Console
set USERDOMAIN_HOME=E:\Oracle\Middleware\user_projects\domains\%DOMAIN_NAME%
set SERVER_NAME=AdminServer
set PRODUCTION_MODE=false
set JAVA_OPTIONS=-Dweblogic.Stdout="E:\Oracle\Middleware\user_projects\domains\%DOMAIN_NAME%\servers\AdminServer\logs\AdminServer-stdout.log" -Dweblogic.Stderr="E:\Oracle\Middleware\user_projects\domains\%DOMAIN_NAME%\servers\AdminServer\logs\AdminServer-stderr.log"
set MEM_ARGS=-Xms256m -Xmx1024m
call "E:\Oracle\Middleware\user_projects\domains\%DOMAIN_NAME%\bin\setDomainEnv.cmd"
call "E:\Oracle\Middleware\wlserver\server\bin\installSvc.cmd"
ENDLOCAL
Run as an Admin and there you go, a new service got installed.
You might be asking, “Do we really need to install it as a service?”
The answer to that is, “It depends.”
I found that AdminServer must be running for the first time when you start an EPM service.
It is not needed after the first start; However, what I also found was there was a considerable difference in start-up timings when you got AdminServer running and when it is not.
Foundation Services took 1~2 minutes to start – AdminServer running
Foundation Services took 12~15 minutes to start – AdminServer not running.
Great insight on the release notes !!!
I would like to know the updates about 11.2.
Great Post!
Hi Celvin
In case if we want to install 11.2 in distributed windows environment; what is the best configuration and pre-requisites .
Please replay to my email.
Please go through the docs and you will get a pretty good idea.
Hi Ckattookaran, Nice to see you again. I’m not sure how you managed HTTP server. I did not get any issue on installation and configuration but validation saying
——————————————————————
http://epm112:19000/workspace/logon
Error:java.net.ConnectException: Connection refused: connect
Recommended Action:Start application
—————————————————————-
Any suggestion. It’s working on 28080 but not 19000
I tried both OHS http server as well as WLS http server but 19000 port is not working….
As only 28080 port is working so when I’m triying to expand Planning from Calculation Manager I’m getting error more over can not export Planning LCM Please suggest.
Roman, good to see you as well. I didn’t use Oracle HTTP. I went with the embedded one.
I didn’t have an issue with planning or calc manager. Did you perform the web configuration?
Hi Ckattookaran, I did but as I said using 28080 it’s working I’m able to work with Planning as well but when I open Calculation Manager and click on Planning It’s say Application is not running. then from Shared services when I click on Planning application to explore and export It’s stop responding.
Hyperion Provider Services – Release 11.1.2.4.033 Build 007
Copyright (c) 1991, 2019 Oracle and / or its affiliates. All rights reserved.
connection mode : EMBEDDED
java System properties -DESS_ES_HOME: null
( Dec 28, 2019 9:04:50 PM ) Essbase server check successfully completed.
( Dec 28, 2019 9:04:50 PM ) – passed: Validating Essbase Server connection to epm112
( Dec 28, 2019 9:04:50 PM ) DB Connectivity test for repository successfully completed.
( Dec 28, 2019 9:04:50 PM ) – passed: Checking connection to database jdbc:oracle:thin:@epm112:1521:orcl
( Dec 28, 2019 9:04:51 PM ) DB Connectivity test for repository successfully completed.
( Dec 28, 2019 9:04:51 PM ) – passed: Checking connection to database jdbc:oracle:thin:@epm112:1521:orcl
( Dec 28, 2019 9:04:51 PM ) DB Connectivity test for repository successfully completed.
( Dec 28, 2019 9:04:51 PM ) – passed: Checking connection to database jdbc:oracle:thin:@epm112:1521:orcl
( Dec 28, 2019 9:04:51 PM ) DB Connectivity test for repository successfully completed.
( Dec 28, 2019 9:04:51 PM ) – passed: Checking connection to database jdbc:oracle:thin:@epm112:1521:orcl
( Dec 28, 2019 9:04:52 PM ) Web Applications check successfully completed.
( Dec 28, 2019 9:04:52 PM ) – passed: Availability of Web application context http://epm112:13080/aps
( Dec 28, 2019 9:04:52 PM ) Web Applications check successfully completed.
( Dec 28, 2019 9:04:52 PM ) – passed: Availability of Web application context http://epm112:8500/calcmgr/index.htm
( Dec 28, 2019 9:04:53 PM ) Web Applications check successfully completed.
( Dec 28, 2019 9:04:53 PM ) – passed: Availability of Web application context http://epm112:10080/easconsole/console.html
( Dec 28, 2019 9:04:53 PM ) Web Applications check successfully completed.
( Dec 28, 2019 9:04:53 PM ) – passed: Availability of Web application context http://epm112:28080/interop
( Dec 28, 2019 9:04:57 PM ) Web Applications check successfully completed.
( Dec 28, 2019 9:04:57 PM ) – passed: Availability of Web application context http://epm112:8300/HyperionPlanning/
( Dec 28, 2019 9:04:57 PM ) Web Applications check successfully completed.
( Dec 28, 2019 9:04:57 PM ) – passed: Availability of Web application context http://epm112:28080/workspace/status
( Dec 28, 2019 9:05:03 PM ) HTTP Server check successfully completed.
( Dec 28, 2019 9:05:03 PM ) – passed: Checking availability of HTTP context http://epm112:28080/workspace/status
( Dec 28, 2019 9:05:03 PM ) – passed: Checking availability of HTTP context http://epm112:28080/HyperionPlanning/
( Dec 28, 2019 9:05:04 PM ) External Providers check successfully completed.
( Dec 28, 2019 9:05:04 PM ) – passed: Check Native Directory external authentication provider configuration
( Dec 28, 2019 9:05:04 PM ) External Providers check successfully completed.
( Dec 28, 2019 9:05:04 PM ) – passed: Check Native Directory external authentication provider configuration
( Dec 28, 2019 9:05:05 PM ) External Providers check successfully completed.
( Dec 28, 2019 9:05:05 PM ) – passed: Check Native Directory external authentication provider configuration
( Dec 28, 2019 9:05:05 PM ) External Providers check successfully completed.
( Dec 28, 2019 9:05:06 PM ) – passed: Check Native Directory external authentication provider configuration
( Dec 28, 2019 9:05:07 PM ) External Providers check successfully completed.
( Dec 28, 2019 9:05:07 PM ) – passed: Check Native Directory external authentication provider configuration
( Dec 28, 2019 9:05:11 PM ) Login check failed.
( Dec 28, 2019 9:05:11 PM ) – failed: Checking availability of login http://epm112:19000/interop/logon
Error:java.net.ConnectException: Connection refused: connect
( Dec 28, 2019 9:05:13 PM ) Login check failed.
( Dec 28, 2019 9:05:13 PM ) – failed: Checking availability of login http://epm112:19000/workspace/logon
Error:java.net.ConnectException: Connection refused: connect
( Dec 28, 2019 9:05:13 PM ) Missed registry links check successfully completed.
( Dec 28, 2019 9:05:13 PM ) – passed: Checking that all components in the registry have a link to host
( Dec 28, 2019 9:05:13 PM ) Datasource entries existence failed.
( Dec 28, 2019 9:05:13 PM ) Datasource entries existence successfully completed.
( Dec 28, 2019 9:05:13 PM ) – passed: Checking if datasource property exists in the registry
( Dec 28, 2019 9:05:14 PM ) Datasource entries existence successfully completed.
( Dec 28, 2019 9:05:14 PM ) – passed: Checking if datasource property exists in the registry
( Dec 28, 2019 9:05:14 PM ) Datasource entries existence failed.
( Dec 28, 2019 9:05:14 PM ) Datasource entries existence successfully completed.
( Dec 28, 2019 9:05:14 PM ) – passed: Checking if datasource property exists in the registry
( Dec 28, 2019 9:05:14 PM ) Datasource entries existence failed.
( Dec 28, 2019 9:05:15 PM ) Web Server Registry check successfully completed.
( Dec 28, 2019 9:05:15 PM ) – passed: Checking if Web Server linked to the all Web Applications
( Dec 28, 2019 9:05:17 PM ) Shared library targeting test successfully completed.
( Dec 28, 2019 9:05:17 PM ) – passed: Check if all shared libraries are targeted for application “AnalyticProviderServices0”.
( Dec 28, 2019 9:05:18 PM ) Shared library targeting test successfully completed.
( Dec 28, 2019 9:05:18 PM ) – passed: Check if all shared libraries are targeted for application “CalcMgr0”.
( Dec 28, 2019 9:05:19 PM ) Shared library targeting test successfully completed.
( Dec 28, 2019 9:05:19 PM ) – passed: Check if all shared libraries are targeted for application “EssbaseAdminServices0”.
( Dec 28, 2019 9:05:19 PM ) Shared library targeting test successfully completed.
( Dec 28, 2019 9:05:19 PM ) – passed: Check if all shared libraries are targeted for application “FoundationServices0”.
( Dec 28, 2019 9:05:20 PM ) Shared library targeting test successfully completed.
( Dec 28, 2019 9:05:20 PM ) – passed: Check if all shared libraries are targeted for application “Planning0”.
( Dec 28, 2019 9:05:21 PM ) Shared library targeting test successfully completed.
( Dec 28, 2019 9:05:21 PM ) – passed: Check if all shared libraries are targeted for application “FoundationServices0”.
( Dec 28, 2019 9:05:21 PM ) Checking if registry database comply with taxonomy failed.
( Dec 28, 2019 9:05:21 PM ) System path variable length test successfully completed.
( Dec 28, 2019 9:05:21 PM ) – passed: Checking whether system path variable length exceeds 2,000
( Dec 28, 2019 9:05:21 PM ) Check system-jazn-data.xml file for HIT entries successfully completed.
( Dec 28, 2019 9:05:21 PM ) – passed: All HIT entries are present in system-jazn-data.xml
( Dec 28, 2019 9:05:22 PM ) CSS Status Check failed.
( Dec 28, 2019 9:05:22 PM ) – failed: Validating that CSS has been initialized
Error:Connection refused: connect
( Dec 28, 2019 9:05:24 PM ) CES Status Check failed.
( Dec 28, 2019 9:05:24 PM ) – failed: Validating that CES has been initialized
Error:Connection refused: connect
( Dec 28, 2019 9:05:25 PM ) Audit Status Check failed.
( Dec 28, 2019 9:05:25 PM ) – failed: Validating that Audit has been initialized
Error:Connection refused: connect
( Dec 28, 2019 9:05:26 PM ) LCM Status Check failed.
( Dec 28, 2019 9:05:26 PM ) – failed: Validating that LCM has been initialized
Error:Connection refused: connect
( Dec 28, 2019 9:05:27 PM ) HUB Status Check failed.
( Dec 28, 2019 9:05:27 PM ) – failed: Validating that HUB has been initialized
Error:Connection refused: connect
( Dec 28, 2019 9:05:29 PM ) Registry Status Check failed.
( Dec 28, 2019 9:05:29 PM ) – failed: Validating that Registry has been initialized
Error:Connection refused: connect
( Dec 28, 2019 9:05:30 PM ) Configuration tasks state test successfully completed.
( Dec 28, 2019 9:05:30 PM ) – passed: Validating that configuration tasks have been completed
( Dec 28, 2019 9:05:30 PM ) Configuration tasks state test successfully completed.
( Dec 28, 2019 9:05:30 PM ) – passed: Validating that configuration tasks have been completed
( Dec 28, 2019 9:05:31 PM ) Configuration tasks state test successfully completed.
( Dec 28, 2019 9:05:31 PM ) – passed: Validating that configuration tasks have been completed
( Dec 28, 2019 9:05:31 PM ) Configuration tasks state test successfully completed.
( Dec 28, 2019 9:05:31 PM ) – passed: Validating that configuration tasks have been completed
( Dec 28, 2019 9:05:31 PM ) Configuration tasks state test successfully completed.
( Dec 28, 2019 9:05:31 PM ) – passed: Validating that configuration tasks have been completed
( Dec 28, 2019 9:05:31 PM ) Configuration tasks state test successfully completed.
( Dec 28, 2019 9:05:31 PM ) – passed: Validating that configuration tasks have been completed
( Dec 28, 2019 9:05:32 PM ) Configuration tasks state test successfully completed.
( Dec 28, 2019 9:05:32 PM ) – passed: Validating that configuration tasks have been completed
( Dec 28, 2019 9:05:32 PM ) Product registry component test successfully completed.
( Dec 28, 2019 9:05:32 PM ) – passed: Checking if product has only one product node in registry.
( Dec 28, 2019 9:05:32 PM ) Product registry component test successfully completed.
( Dec 28, 2019 9:05:32 PM ) – passed: Checking if product has only one product node in registry.
( Dec 28, 2019 9:05:32 PM ) Product registry component test successfully completed.
( Dec 28, 2019 9:05:32 PM ) – passed: Checking if product has only one product node in registry.
( Dec 28, 2019 9:05:32 PM ) Product registry component test successfully completed.
( Dec 28, 2019 9:05:32 PM ) – passed: Checking if product has only one product node in registry.
( Dec 28, 2019 9:05:33 PM ) Product registry component test successfully completed.
( Dec 28, 2019 9:05:33 PM ) – passed: Checking if product has only one product node in registry.
( Dec 28, 2019 9:05:33 PM ) Product registry component test successfully completed.
( Dec 28, 2019 9:05:33 PM ) – passed: Checking if product has only one product node in registry.
( Dec 28, 2019 9:05:33 PM ) Product registry component test successfully completed.
( Dec 28, 2019 9:05:33 PM ) – passed: Checking if product has only one product node in registry.
( Dec 28, 2019 9:05:34 PM ) Module login test failed.
( Dec 28, 2019 9:05:34 PM ) – failed: Module test for Planning with URL http://epm112:19000/workspace/index.jsp?module=HyperionPlanning.HyperionPlanning
Error:java.net.ConnectException: Connection refused: connect
( Dec 28, 2019 9:05:34 PM ) Web Server link test successfully completed.
( Dec 28, 2019 9:05:34 PM ) – passed: All links are present in the registry.
( Dec 28, 2019 9:05:34 PM ) Total Time Spent: [000 min 53 sec]
null
Roman, are you OHS is started?
I think only Nodemanager gets installed as a service, not OHS. So you need to start OHS using the startcomponent.cmd
Logs was for EMBEDDED weblogic http not oracle HTTP server. anyway, Thanks a lot. If you don’t mind can you run validation in your system… I’m sure it’s not only me facing this issue. I’m confident on Oracle…. 🙂 regarding startcomponent.cmd, it’s asking component name, and I’m not sure about that because i never used the command. Anyway Thanks a lot.
https://docs.oracle.com/middleware/1212/webtier/HSADM/getstart.htm#HSADM845
Hi Celvin, is the GUI interface the same one currently available on 11.1.2.4? I mean the standard one, not the simplified interface. Also, at first glance, are you seeing any big improvements compared with 11.1.2.4 (Other than support for Java 8)?
It is the same interface. I don’t think this release has any new features. It got new third party support like browsers, JRE, and Databases, and Server.
Thank you Celvin. So it seems that this version is essentially the same 11.1.2.4, but just running on Java 8 instead of Java 6 or 7.
Hi ckattookaran
Thanks for your information and reply.
Finally I found how to start OHS via command line:
https://docs.oracle.com/en/applications/enterprise-performance-management/11.2/hitis/starting_ohs_100x805da2e0.html
In my scenario, it will be:
C:\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\bin>startComponent ohs_component
I am a little bit doubt that since in my starter log, it was shown that OHS service was started successfully.
Is this mean that it only start the Node Manager?
And in another way, can I set the WebLogic admin password somewhere for the StartComponent?
I think it will be more convenient to start OHS server automatically.
Hello,
Thanks for your post. It is very informative.
Did you tried to install it in Distributed environment as well?
I am having issues in Distributed Environment while configuring Planning service in Server#3.
Planning – Deploy to Application Server failed.
I checked WLST tool can connect to Weblogic on Server#2. Also no issues in connecting to DB.
Server#1:
OHS (Installed & Configured)
Server#2:
Weblogic (Up and running)
Foundation (Installed & Configured)
Financial Reporting (Installed & Configured)
Calc Manager (Installed & Configured)
Planning (Installed)
Essbase (Installed)
EAS (Installed)
APS (Installed)
Server#3:
Planning (Installed, Failed Planning – Deploy to Application Server)
Essbase (Installed)
EAS (Installed, Planning – Deploy to Application Server)
APS (Installed)
Did you run the repository creation tool on Planning server? Also did you update the RCUSchema properties file.
I didn’t run the RCU utility on planning server. Only on foundation server I ran that. But updated the property file on all servers. I read an oracle document which specified multiple type of RCU implementation and one option was that Single Database Single Domain. I just have 1 weblogic domain. If I run RCU on planning server then it will create new schemas.
Did you update the Schema properties then?
Documentation says you must run it on all servers. Did you catch that part?
I updated the rcu properties file on each server and it worked on ohs configuration fine. I thought Oracle document mentioned install in all server by mistake. What they meant was update in all servers. I will send you the link of rcu document from office.
What is the error you are getting? Did you look the config logs?
I found below article which addresses the same problem that I am having.
http://hyperipwn.blogspot.com/2020/01/epm-112-reusing-single-rcu-repository.html
Please check it.
I do know about it. We talked about it on Twitter. If you look at AJ Martelino’s tweets, you’ll know what I’m talking about.
https://twitter.com/hyperioninfra/status/1222228381405777923?s=21
Thanks very much. I will install the RCU on 2nd server as well and test.
I installed RCU on Planning Server and tried to reconfigure. Still same issue.
Again what is the error? You never posted the error messages from the logs.
This is the excerpt from configtool.log file. Earlier I didsent the one drive link to download the logs.
[2020-02-06T09:49:01.395-05:00] [EPMCMN] [ERROR] [EPMCMN-01001] [oracle.EPMCMN] [tid: 1] [ecid: e081ba80-e36a-4027-9cee-50c2ac6a67ef-00000006,0] [SRC_CLASS: com.hyperion.cis.config.InstallItemsConfigurationInfo] {0}[[
javax.script.ScriptException: TypeError: env.isWindows is not a function in at line number 1
at jdk.nashorn.api.scripting.NashornScriptEngine.throwAsScriptException(NashornScriptEngine.java:470)
at jdk.nashorn.api.scripting.NashornScriptEngine.evalImpl(NashornScriptEngine.java:454)
at jdk.nashorn.api.scripting.NashornScriptEngine.evalImpl(NashornScriptEngine.java:406)
at jdk.nashorn.api.scripting.NashornScriptEngine.evalImpl(NashornScriptEngine.java:402)
at jdk.nashorn.api.scripting.NashornScriptEngine.eval(NashornScriptEngine.java:155)
at javax.script.AbstractScriptEngine.eval(AbstractScriptEngine.java:264)
at com.hyperion.cis.config.ConditionEvaluator.evaluateCondition(ConditionEvaluator.java:47)
at com.hyperion.cis.config.InstallItemsConfigurationInfo.evaluateCondition(InstallItemsConfigurationInfo.java:123)
at com.hyperion.cis.config.InstallItemsConfigurationInfo.initConfigtoolProductsInfo(InstallItemsConfigurationInfo.java:83)
at com.hyperion.cis.config.InstallItemsConfigurationInfo.(InstallItemsConfigurationInfo.java:40)
at com.hyperion.cis.config.InstallItemsConfigurationInfo.(InstallItemsConfigurationInfo.java:35)
at com.hyperion.cis.config.document.DocumentManagerFactory.getInstallableItemsConfigurationInfo(DocumentManagerFactory.java:37)
at com.hyperion.cis.config.document.DocumentManagerFactory.getPS1DocumentManager(DocumentManagerFactory.java:25)
at com.hyperion.cis.config.document.DocumentManagerFactory.getDocumentManager(DocumentManagerFactory.java:13)
at com.hyperion.config.wizard.ConfigToolWizardLoader.loadDefaultProductDescriptors(ConfigToolWizardLoader.java:357)
at com.hyperion.config.wizard.ConfigToolWizardLoader.(ConfigToolWizardLoader.java:89)
at MainHitWizard.main(MainHitWizard.java:290)
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 Main.invokeMethodOrExit(Main.java:242)
at Main.main(Main.java:105)
Caused by: :1 TypeError: env.isWindows is not a function
at jdk.nashorn.internal.runtime.ECMAErrors.error(ECMAErrors.java:57)
at jdk.nashorn.internal.runtime.ECMAErrors.typeError(ECMAErrors.java:213)
at jdk.nashorn.internal.runtime.ECMAErrors.typeError(ECMAErrors.java:185)
at jdk.nashorn.internal.runtime.ECMAErrors.typeError(ECMAErrors.java:172)
at jdk.nashorn.internal.runtime.Undefined.lookup(Undefined.java:102)
at jdk.nashorn.internal.runtime.linker.NashornLinker.getGuardedInvocation(NashornLinker.java:106)
at jdk.nashorn.internal.runtime.linker.NashornLinker.getGuardedInvocation(NashornLinker.java:98)
at jdk.internal.dynalink.support.CompositeTypeBasedGuardingDynamicLinker.getGuardedInvocation(CompositeTypeBasedGuardingDynamicLinker.java:176)
at jdk.internal.dynalink.support.CompositeGuardingDynamicLinker.getGuardedInvocation(CompositeGuardingDynamicLinker.java:124)
at jdk.internal.dynalink.support.LinkerServicesImpl.getGuardedInvocation(LinkerServicesImpl.java:154)
at jdk.internal.dynalink.DynamicLinker.relink(DynamicLinker.java:253)
at jdk.nashorn.internal.scripts.Script$\^eval\_.:program(:1)
at jdk.nashorn.internal.runtime.ScriptFunctionData.invoke(ScriptFunctionData.java:637)
at jdk.nashorn.internal.runtime.ScriptFunction.invoke(ScriptFunction.java:494)
at jdk.nashorn.internal.runtime.ScriptRuntime.apply(ScriptRuntime.java:393)
at jdk.nashorn.api.scripting.NashornScriptEngine.evalImpl(NashornScriptEngine.java:449)
… 21 more
]]
[2020-02-06T09:50:37.570-05:00] [EPMCFG] [ERROR] [EPMCFG-01020] [oracle.EPMCFG] [tid: 48] [ecid: e081ba80-e36a-4027-9cee-50c2ac6a67ef-00000006,0] [SRC_CLASS: com.hyperion.hit.tool.deploy.ant.wrappers.ScriptTaskWrapper] Error: [[
java.lang.reflect.InvocationTargetException
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.hyperion.hit.tool.deploy.ant.wrappers.ScriptTaskWrapper.execute(ScriptTaskWrapper.java:72)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:293)
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.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:435)
at org.apache.tools.ant.Target.performTasks(Target.java:456)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1405)
at org.apache.tools.ant.Project.executeTarget(Project.java:1376)
at com.hyperion.hit.tool.deploy.ant.engine.ProjectRunner.execAtNumber(ProjectRunner.java:137)
at com.hyperion.cis.config.AntDeploymentApiAdapter.deploy(AntDeploymentApiAdapter.java:196)
at com.hyperion.cis.config.AppServerDeployer.deploy(AppServerDeployer.java:240)
at com.hyperion.config.wizard.impl.RunAllTasks.executeAppDeploymentTask(RunAllTasks.java:741)
at com.hyperion.config.wizard.impl.RunAllTasks.execute(RunAllTasks.java:365)
at com.hyperion.config.wizard.impl.RunnAllTasksState.run(RunnAllTasksState.java:92)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.IllegalStateException: Deployment failed, check logs for more info
at com.hyperion.hit.tool.deploy.wlst.WlstConsole.handleError(WlstConsole.java:417)
at com.hyperion.hit.tool.deploy.wlst.WlstConsole.exec(WlstConsole.java:279)
at com.hyperion.hit.tool.deploy.wlst.WlstStaticHelper.exec(WlstStaticHelper.java:29)
at com.hyperion.hit.tool.deploy.wlst.WlstStaticHelper.exec(WlstStaticHelper.java:41)
at com.hyperion.hit.tool.deploy.ant.model.Domain.createOPSSDataSources(Domain.java:594)
at com.hyperion.hit.tool.deploy.ant.model.Domain.openDomain(Domain.java:385)
at com.hyperion.hit.tool.deploy.ant.wrappers.DomainWrapper.openDomain(DomainWrapper.java:19)
… 23 more
]]
[2020-02-06T09:50:37.570-05:00] [EPMCFG] [ERROR] [EPMCFG-01020] [oracle.EPMCFG] [tid: 48] [ecid: e081ba80-e36a-4027-9cee-50c2ac6a67ef-00000006,0] [SRC_CLASS: com.hyperion.cis.config.AntDeploymentApiAdapter] Error: [[
G:\Oracle\Middleware\EPMSystem11R1\common\config\11.1.2.0\resources\ant-repository\build.xml:8: java.lang.IllegalStateException: java.lang.reflect.InvocationTargetException
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:116)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:435)
at org.apache.tools.ant.Target.performTasks(Target.java:456)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1405)
at org.apache.tools.ant.Project.executeTarget(Project.java:1376)
at com.hyperion.hit.tool.deploy.ant.engine.ProjectRunner.execAtNumber(ProjectRunner.java:137)
at com.hyperion.cis.config.AntDeploymentApiAdapter.deploy(AntDeploymentApiAdapter.java:196)
at com.hyperion.cis.config.AppServerDeployer.deploy(AppServerDeployer.java:240)
at com.hyperion.config.wizard.impl.RunAllTasks.executeAppDeploymentTask(RunAllTasks.java:741)
at com.hyperion.config.wizard.impl.RunAllTasks.execute(RunAllTasks.java:365)
at com.hyperion.config.wizard.impl.RunnAllTasksState.run(RunnAllTasksState.java:92)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.IllegalStateException: java.lang.reflect.InvocationTargetException
at com.hyperion.hit.tool.deploy.ant.wrappers.ScriptTaskWrapper.execute(ScriptTaskWrapper.java:76)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:293)
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.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
… 12 more
Caused by: java.lang.reflect.InvocationTargetException
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.hyperion.hit.tool.deploy.ant.wrappers.ScriptTaskWrapper.execute(ScriptTaskWrapper.java:72)
… 18 more
Caused by: java.lang.IllegalStateException: Deployment failed, check logs for more info
at com.hyperion.hit.tool.deploy.wlst.WlstConsole.handleError(WlstConsole.java:417)
at com.hyperion.hit.tool.deploy.wlst.WlstConsole.exec(WlstConsole.java:279)
at com.hyperion.hit.tool.deploy.wlst.WlstStaticHelper.exec(WlstStaticHelper.java:29)
at com.hyperion.hit.tool.deploy.wlst.WlstStaticHelper.exec(WlstStaticHelper.java:41)
at com.hyperion.hit.tool.deploy.ant.model.Domain.createOPSSDataSources(Domain.java:594)
at com.hyperion.hit.tool.deploy.ant.model.Domain.openDomain(Domain.java:385)
at com.hyperion.hit.tool.deploy.ant.wrappers.DomainWrapper.openDomain(DomainWrapper.java:19)
… 23 more
]]
I was able to configure Planning service finally.
I found below document which specified that I need to Delete “domains” folder before re-configure.
Oracle Support Document 2623890.1 (‘Deploy to Application Server’ Tasks Failing in EPM System Configurator 11.2, “Error while processing initializeSubsystem. Exception oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store”) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2623890.1
Thanks very much for your help.
Hi all,
I executed RCU step and then I configured the schema properties file. Every thing went well in configurator part.
Then I tried to start essbase services and epm services. Although I see 4 oracle hyperion process running, I can not enter to EAS or worskpace.
Diagnostics says:
Validating that Audit has been initialized
Error: Connection refused: connect
Recommended Action: Start application
Does anyone know what is happening? Thank you!
Are there error messages in the starter logs?
I think this is because you have not started your OHS service.
You can refer to my previous post here.
https://cpminsights.com/2019/12/23/epm-11-2-is-released/#comment-184
Please also try to use 10080 port to connect to EAS.
regards,
Wade
Hi,
I have installed standalone installation of 11.2 for HFM and FDMEE, everything went well for installation and configuration. when I open workspace I can’t see the Dimension library and Application library. Where to check for deployment of metadata? Could you please advise or help me in this regard.
Thanks
If you didn’t read the “news”. EPMA is dead. There is no EPMA in this version. there are few other modules and products that got scrapped as well.
You can find the news here.
https://blogs.oracle.com/proactivesupportepm/hyperion-enterprise-performance-management-epm-112-on-premises-release-information
For HFM, you need to use a native web metadata editor instead of EPMA Dimension Library of HFM Client.
All HFM applications will become classic mode in this release.
regards,
Wade
thanks for this amazing post.
what about -Configure Web Server- ??
as i see you configured it but no OHS service listed in services.