Shared Services Repository Database User Account Gets Locked Out Periodically
Last updated on MAY 21, 2018
Applies to:Hyperion BI+ - Version 18.104.22.168.500 and later
Information in this document applies to any platform.
1. Periodically the Shared Services repository database account would get locked out. When that happens, the users would see the following symptoms -
When logging into Workspace, the following error is thrown - "The startup page cannot be displayed".
When logging into EAS, the "invalid login credentials" error is thrown.
When logging into DRM, the following error is thrown - Login failed for user <HSS_Repository_db_user> because account is currently locked out.
2. DB trace logs -
<Date> Logon "Login failed for user <HSS_Repository_db_user>".Reason: Password did not match that for the login provided. [CLIENT: xxx.xx.xxx.xx]
The Client IP mentioned in the database trace for the error is the server where the HFM product is installed.
3. The following error in seen in the InteropJava.log located in \Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\hfm folder on one of the HFM servers -
com.hyperion.hit.registry.exceptions.RegistryException: com.hyperion.hit.registry.exceptions.RegistryException: java.lang.OutOfMemoryError: Java heap space
at com.hyperion.hfm.HITRegistryInterop.getDataSourceProperty(Unknown Source)
Caused by: com.hyperion.hit.registry.exceptions.RegistryException: java.lang.OutOfMemoryError: Java heap space
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms