Error: "Error 404" After Configuration "Set up Shared Services and Registry Database Connection" in EPM 11.1.2.1

Error: "Error 404" After Configuration "Set up Shared Services and Registry Database Connection" in EPM 11.1.2.1 [ID 1303661.1]
Modified 20-APR-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution

Applies to:

Hyperion BI+ - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms

When the Shared Services URL (http://:19000/interop) is accessed, an Error-404 error will appear.

A run of netstat would not show port 28080 (for Shared Services would not stay up due to lack of relational database repository).
Cause

When 'Next' is clicked after the 'Set up Shared Services and Registry Database Connection...' page is configured, the EPM System Configurator tool immediately attempts to write HSS_COMPONENT_* and CSS_* tables (and ESS_CLUSTER_SERVER_MAPPING) to the relational database schema described on that page.
However when the 'Back' button is clicked on the following page and new connectivity information is entered on the 'Set up Shared Services and Registry Database Connection...' page, the newly configured database will lack those tables. Without those repository database tables Shared Services will not run.
Solution

Workaround:

(1) Delete the Hyperion Shared Services database repository tables ('old' Shared Services repository tables are not reused from 9.2.1 or 9.3.3 or 11.1.1.3 in any case...their data is extracted and reimported).

(2) Delete \Oracle\Middleware\user_projects\epmsystem1\config\foundation\11.1.2.0\reg.properties
or
create a new instance name, (to some name other than the default, 'epmsystem1') such as \Oracle\Middleware\user_projects\epmsystem2

(3) Rerun EPM System Configurator 11.1.2.1