Forum Stats

  • 3,760,116 Users
  • 2,251,647 Discussions
  • 7,870,985 Comments

Discussions

EPM 11.2.4 'Deploy to application server' fails

User_K7ZS3
User_K7ZS3 Member Posts: 4 Red Ribbon
edited Feb 12, 2021 1:13AM in EPM System Infrastructure

OS:

Windows Server 2019


DB:

Microsoft SQL Server 2016 (SP2)


Distributed Architecture:

Server 1: Foundation Server

Server 2: HFM server


Installation:

Server 1: Installed all modules for Foundation, HFM

Server 2: Installed modules for HFM


DB User:

hyperiondev (with sysadmin role) - used as the database owner for RCU and all Hyperion schemas


Databases created:

1. EPMRCU : To be used for RCU configuration (db owner hyperiondev)

2. FOUNDATION : To be used for Hyperion Foundation, (db owner hyperiondev)

Configuration Steps

1. Configured RCU successfully - no issues here (DEVEPM as prefix)

2. Updated RCUSchema.properties file (dbURL=jdbc:weblogic:sqlserver://hostName:port;databaseName=databaseName)

3. Started configuring Hyperion Foundation (common, db config and deploy to app server)

Issues:

'Deploy to Application Server' step is failing .

RCUSchema.properties file is not getting encrypted after running the config


EDIT: Every time the config fails, I have renamed the user_projects directory and then performed the config all over again.


** All pre-requisite steps have been done completely. Also explicitly granted full permissions to the \Oracle directory for the hyperion user account.


In the wlst_debug.log file

~~~~~~~~~~~~~~

In the wlst_debug.log file


Does someone know why we are getting this error?

Why is it not reading and encrypting the RCUSchema.properties file?

Please note that I have downloaded the binaries again and performed the install from scratch but we are getting same error.

--------------------------------------------------------


2021-02-11 18:38:42,375 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)



2021-02-11 18:38:42,375 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.

LocalSvcTbl Schema: 64205: Unspecified property.

64205: The Password must be specified.

64205: Specify the property.

LocalSvcTbl Schema: 64207: Mismatched passwords.

64207: The Password and Confirm Password do not match.

64207: Correct the password.

WLS Schema: 64205: Unspecified property.

64205: The Password must be specified.

64205: Specify the property.

WLS Schema: 64207: Mismatched passwords.

64207: The Password and Confirm Password do not match.

64207: Correct the password.

OPSS Audit Schema: 64205: Unspecified property.

64205: The Password must be specified.

64205: Specify the property.

OPSS Audit Schema: 64207: Mismatched passwords.

64207: The Password and Confirm Password do not match.

64207: Correct the password.

OPSS Audit Viewer Schema: 64205: Unspecified property.

64205: The Password must be specified.

64205: Specify the property.

OPSS Audit Viewer Schema: 64207: Mismatched passwords.

64207: The Password and Confirm Password do not match.

64207: Correct the password.

OPSS Schema: 64205: Unspecified property.

64205: The Password must be specified.

64205: Specify the property.

OPSS Schema: 64207: Mismatched passwords.

64207: The Password and Confirm Password do not match.

64207: Correct the password.

~~~~~~~~~~~~~~

Answers