My Oracle Support Banner

HFM: 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" (Doc ID 2623890.1)

Last updated on AUGUST 28, 2023

Applies to:

Hyperion Financial Management - Version 11.2.0.0.000 and later
Information in this document applies to any platform.

Symptoms

All EPM Configurator Deploy to Application Server tasks failing. 

Using Oracle database:

Configtool.log contains errors:

[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:com.oracle.cie.domain.script.jython.WLSTException: Error updating domain:
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:64254: Error occurred in "TemplateImporter.opss.processing.phase.text" phase execution
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:64254: Encountered error: SecurityContext:
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: Domain Name: EPMSystem
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: JDBC URL: opss-audit-DBDS:$for example jdbc:oracle:thin:@{hostname}:{port}:{sid}$
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: JDBC URL: opss-data-source:$for example jdbc:oracle:thin:@{hostname}:{port}:{sid}$
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: JNDI Name: opss-audit-DBDS:jdbc/AuditAppendDataSource
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: JNDI Name: opss-data-source:jdbc/OpssDataSource
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: Driver Name: opss-audit-DBDS:none
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: Driver Name: opss-data-source:none
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: Persistence Type: DATABASE
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: Platform: WLS
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: Scratch Dir: scratch
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: Reconfig Domain: false
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: Shared Secret Store: null
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: Extension: true
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5: DisableManagementOperations: falseJDBC Properties:
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:user:$Schema prefix used to create RCU$_IAU_APPEND
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:DbmsPassword:$rcu schema password created while running RCU$
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:username:$Schema prefix used to create RCU$_IAU_APPENDJDBC Properties:
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:user:$Schema prefix used to create RCU$_OPSS
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:DbmsPassword:$rcu schema password created while running RCU$
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 73] [ecid: 27e9d972-ad5c-4988-a110-d4bec8325406-00000006,0:1040:737] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:username:$Schema prefix used to create RCU$_OPSS

 

Wlst_debug.log contains errors:

SEVERE [18] oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl - Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: java.lang.ClassNotFoundException: none.
SEVERE [18] oracle.security.opss.tools.lifecycle.cie.OpssSecurityConfiguration - Error while processing initializeSubsystem. Exception oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: java.lang.ClassNotFoundException: none.
SEVERE [18] com.oracle.cie.domain.progress.AbstractProgressGenerator - Error occurred in phase {TemplateImporter.opss.processing.phase.text} execution.
java.lang.IllegalStateException: SecurityContext:
 Domain Name: EPMSystem
 JDBC URL: opss-audit-DBDS:$for example jdbc:oracle:thin:@{hostname}:{port}:{sid}$
 JDBC URL: opss-data-source:$for example jdbc:oracle:thin:@{hostname}:{port}:{sid}$
 JNDI Name: opss-audit-DBDS:jdbc/AuditAppendDataSource
 JNDI Name: opss-data-source:jdbc/OpssDataSource
 Driver Name: opss-audit-DBDS:none
 Driver Name: opss-data-source:none
 Persistence Type: DATABASE
 Platform: WLS
 Scratch Dir: scratch
 Reconfig Domain: false
 Shared Secret Store: null
 Extension: true
 DisableManagementOperations: falseJDBC Properties:
user:$Schema prefix used to create RCU$_IAU_APPEND
DbmsPassword:$rcu schema password created while running RCU$
username:$Schema prefix used to create RCU$_IAU_APPENDJDBC Properties:
user:$Schema prefix used to create RCU$_OPSS
DbmsPassword:$rcu schema password created while running RCU$
username:$Schema prefix used to create RCU$_OPSS

 

Using MS SQL database:

Configtool.log contains errors:

[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 83] [ecid: 1f39f815-72bc-4eaa-83eb-a1dce8609432-00000007,0:2:5] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:com.oracle.cie.domain.script.jython.WLSTException: Error adding Template:
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 83] [ecid: 1f39f815-72bc-4eaa-83eb-a1dce8609432-00000007,0:2:5] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:64056: Error adding templates.
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 83] [ecid: 1f39f815-72bc-4eaa-83eb-a1dce8609432-00000007,0:2:5] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:64056: The Configuration Wizard encountered problems attempting to add templates you selected: com.oracle.cie.domain.ConfigGroupsException: Multiple definitions of server-group WSM-CACHE-SVR are not allowed.
[EPMCFG] [TRACE] [EPMCFG-01001] [oracle.EPMCFG] [tid: 83] [ecid: 1f39f815-72bc-4eaa-83eb-a1dce8609432-00000007,0:2:5] [SRC_CLASS: com.hyperion.hit.tool.deploy.wlst.ScriptWlstConsole] trace: 5:64056: Verify template integrity or select different templates.

Wlst_debug.log contains errors:

SEVERE [18] com.oracle.cie.domain.ConfigMappingHelper - Conneciton not available.
java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot open database "$dbms" requested by the login. The login failed.
    at weblogic.jdbc.sqlserverbase.ddcw.b(Unknown Source)
...
SEVERE [18] com.oracle.cie.domain.progress.AbstractProgressGenerator - Error occurred in phase {Artifacts Generation} execution.
java.lang.IllegalStateException: Servicetable connection not available.

Changes

 Installing and configuring EPM 11.2 for first time

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


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