Tuesday 8 April 2014

Workspace Accessing issue: Interactive Reporting Error: "Service Temporarily Unavailable Error Occurred Communicating With The Server"

Applies to:

 Hyperion BI+ - Version 11.1.2.1.000 and later
Information in this document applies to any platform.



Symptoms

When attempting to log into Workspace getting the following series of error messages:
"The Startup Document Specified does not exist in the Repository."

Clicking OK, the following error presents:
"A 'Service Temporarily Unavailable' error occurred communicating with the server.
Status 503 - Service Temporarily Unavailable"
Clicking OK, a third error presents:
"A 'Not Found' error occurred communicating with the server.
Status 404 - Not Found"

The "stdout_console_agent.log" log file located in
Oracle\Middleware\user_projects\epmsystem4\diagnostics\logs\ReportingAnalysis directory contains the following error:
"...Caused by: com.sqribe.transformer.DBConnectionException: Database Server error: DBConnectionPool::get: ORA-28001: the password has expired"


Cause

The Repository Database password expired.


Solution



Perform one of these solutions: I followed the first point

A) Ask your Oracle DBA to restore the repository database password and/or make sure passwords are not set to expire. 

B) Reconfigure EPM to use the new repository database password following the process outlined in "epm_install.pdf" chaper 10 "Reconfiguring EPM System Products" section "Changing Repository Passwords and Database Connection Information"



Ref : (Doc ID 1419079.1)