HPS Employee is not available in Shared Services Console version 11.1.1.2

HPS Employee is not available in Shared Services Console version 11.1.1.2 [ID 824283.1]
Modified 18-NOV-2010 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
References

Applies to:

Hyperion Performance Scorecard - Version: 11.1.1.0.00 to 11.1.1.0.00 - Release: 11.1 to 11.1
Information in this document applies to any platform.
Symptoms


Error occurs in HSS when click on the HPS application and attempt to associate a newly created employee to the HPS login user.

This can work successfully on the first attempt but always on the second attempt it will fail

"Performance scorecard is having difficulty fulfilling your request. Consult your performance scorecard administrator"
Cause


Caused by current charset used by customer.

Changing charset resolved the issue .
Solution

If unable to change charset, the following workaround will also resolve;


1. Reconfigure HPS to use Oracle JDBC driver instead of DataDirect driver.

2. Copy the Oracle driver to \webapps\HPSWebReports\WEB-INF\lib

3. Open HPSConfig.properties:
Modify this part of the file:

hyperion.hps.main_data_store.url=jdbc:hyperion_pmd:sqlserver://:<
server-port>;DatabaseName=
hyperion.hps.main_data_store.user_name=
hyperion.hps.main_data_store.password=
hyperion.hps.main_data_store.driver_class_name=com.hyperion.pmd.jdbc.sqlserver.SQLServerDriver
hyperion.hps.main_data_store.castor_engine=sql-server

It has to look like this :

hyperion.hps.main_data_store.url=jdbc:oracle:thin:: :
hyperion.hps.main_data_store.user_name=
hyperion.hps.main_data_store.password=
hyperion.hps.main_data_store.driver_class_name=oracle.jdbc.driver.OracleDriver

hyperion.hps.main_data_store.castor_engine=oracle

Add another line in it:

hyperion.hps.use_db_info_from_config_file=true

4. Save it.

5. Restart HPS.