Reset the Hyperion Component Schema's Password

Issue:

• When attempting to login to workspace and EAS console, it will throw the following error

• Workspace:  EPMCSS-00301: Failed to authenticate user. Invalid credentials. Enter valid credentials. EAS console:  Could not connect to admin server.

Symptoms:

• The following services will get down

• The foundation services
• EPMA server
• Reporting Analysis and framework [web]

Cause:

• The database password which we had used for configuring Hyperion got expired.

Solution:

• Reset the password by using the following command
• Alter user username identified by password;
• Check the default password lifetime by issuing the following command
• select * from dba_profiles;
• The PASSWORD_LIFE_TIME field is responsible for expiring of password after 180 days.
• Execute following command to disable this feature:
• ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
• Now Reconfigure the Hyperion using the reset password.