In Workspace 11.1.2.1 Explorer is Missing from the Menu Bar

                In Workspace 11.1.2.1 Explorer is Missing from the Menu Bar

Steps to resolve this issue:

1. Stop FoundationServices and RA Framework webapps, and RA Agent services.

2. Execute the following query against the Shared Services registry database:

select application_id from css_provisioning_info where lower(application_id) like 'hava%'; 

note this application id, e.g. HAVA:0000012b3072bf63-0000-6717-0acc1bac

3. Using the epmsys_registry tool, execute:

epmsys_registry updateproperty RA_FRAMEWORK/@applicationId <the application Id returned from the query above> 

Example using ID above:

epmsys_registry updateproperty RA_FRAMEWORK/@applicationId HAVA:0000012b3072bf63-0000-6717-0acc1bac

4. Restart the services.

Reference: 

In Workspace 11.1.2.1 Explorer is Missing from the Menu Bar (Doc ID 1325933.1)

Thanks, 

Mady

How to change admin password in Hyperion Shared services

                                 Admin password change in Hyperion Shared services


Situation and Goal:
we have installed and configured Hyperion worksapce, shared services and other components in cloud servers. Then we have started migration from client LCM dump, first we did HSS migration. In this case, the admin password (which has given at the time of configuration time) is overwritten.

So, we need to reset password to some known with encrypted with in the CSS users table.

Steps:
1. Login to Shared Services Schema ( The user you used during the shares services configuration) with SQL developer or any other tools and look for “CSS_USERS” table.

2. Run the below command:

update CSS_USERS
set PASSWORD= '{SSH2}mpQoG4jU00otFocLZM6CWWUzpk9ZmSY5In3l3ZzFCH5byRhkG6ow7z4KxXmXWXSo'
where name='admin';

This will setup the admin users password to ‘password'

OR

Run the below command:

update CSS_USERS
set PASSWORD= ‘{SSH2}FvSZVSvSmzvjT/02Nn1TrJyQk8SqNus4Fw4m2cNxa3zkSLe8HFiJy7cT8zUDGiWi’
where name='admin';

Commit the changes

Note: Take backup of CCS_USERS table before do any changes.

Reference:
http://epmcult.blogspot.in/2014/06/resetting-hyperion-workspace-admin.html

Thanks,
Mady

Hyperion Url's

                                                          Hyperion Url's

Example URLs to Check
EXAMPLE ORACLE EPM 11 (11.1.2.1) ENVIRONMENT CHECKS AND MONITORING

Layer1 – Load Balancer URL Check:
https://LoadBalancerURL.local/hfm
https://LoadBalancerURL.local/aps/APS
https://LoadBalancerURL.local/calcmgr/index.htm
https://LoadBalancerURL.local/raframework/index.jsp
https://LoadBalancerURL.local/easconsole/console.html
https://LoadBalancerURL.local/awb/conf/AwbConfig.xml
https://LoadBalancerURL.local/hr/status.jsp
https://LoadBalancerURL.local/interop/index.jsp
https://LoadBalancerURL.local/hfmofficeprovider/HFMOfficeProvider.aspx
https://LoadBalancerURL.local/hfmlcmservice/LCMWS.asmx
https://LoadBalancerURL.local/workspace/status
https://LoadBalancerURL.local/HyperionFDM/AuthorizedPages/LogonPage.asp
https://LoadBalancerURL.local/hyperion-bpma-server/Applications.asmx
https://LoadBalancerURL.local/DataSync/

Layer2 – Oracle HTTP Server Redirection Check:
http://Foundation1.local:19000/hfm
http://Foundation1.local:19000/aps/APS
http://Foundation1.local:19000/calcmgr/index.htm
http://Foundation1.local:19000/raframework/index.jsp
http://Foundation1.local:19000/easconsole/console.html
http://Foundation1.local:19000/awb/conf/AwbConfig.xml
http://Foundation1.local:19000/hr/status.jsp
http://Foundation1.local:19000/interop/index.jsp
http://Foundation1.local:19000/hfmofficeprovider/HFMOfficeProvider.aspx
http://Foundation1.local:19000/hfmlcmservice/LCMWS.asmx
http://Foundation1.local:19000/workspace/status
http://Foundation1.local:19000/HyperionFDM/AuthorizedPages/LogonPage.asp
http://Foundation1.local:19000/hyperion-bpma-server/Applications.asmx
http://Foundation1.local:19000/DataSync/

Layer3 Individual Web Application Server Check:
FOUNDATION1.LOCAL Web/Web App
http://Foundation1.local:80/HyperionFDM/AuthorizedPages/LogonPage.asp
http://Foundation1.local:80/hfm
http://Foundation1.local:80/hfmapplicationservice/application.asmx
http://Foundation1.local:80/hfmlcmservice/LCMWS.asmx
http://Foundation1.local:80/hfmofficeprovider/HFMOfficeProvider.aspx
http://Foundation1.local:28080/interop/index.jsp
http://Foundation1.local:28080/workspace/status
http://Foundation1.local:45000/raframework/index.jsp
http://Foundation1.local:8200/hr
http://Foundation1.local:8500/calcmgr/index.htm

PLANNING1.LOCAL Planning
http://Planning1.local:8300/HyperionPlanning

EAS1.LOCAL Essbase Tools
http://EAS1.local:10080/eas
http://EAS1.local:13080/aps

EPMA1.LOCAL EPMA
http://EPMA1.local/hyperion-bpma-server/folders.asmx
http://EPMA1.local:19091/awb

Workspace:
Layer1 - LB Device
https://LoadBalancerURL.local/workspace/index.jsp

Layer2 – Oracle HTTP Server
http://Foundation1.local:19000/workspace/index.jsp

Layer3 – WebLogic Web
http://Foundation1.local:28080/workspace/index.jsp

FDM:
Layer1 – LB Device
https://LoadBalancerURL.local/HyperionFDM

Layer2 – Oracle HTTP Server
http://Foundation1.local:19000/HyperionFDM

Layer3 – IIS Web
http://Foundation1.local:80/HyperionFDM


HFM app creation:
http://10.177.17.195:19000/hfm/CreateApp/createapp.asp?iscontained=Yes

Source: http://www.openepm.com/epm-monitoring/example-urls-to-check

Thanks,
Mady

JRFWS_JMS_MODULE_SUBDEPLOYMENT_JRFWSJMSServer in deployment JRFWSAsyncJmsModule in hyperion 11.1.2.x

It is possible that Hyperion / Weblogic does not start anymore and weblogic or service sysout log pointing to force shutdown

This can have several causes 
• There is a deploy of web server made through the Configuration Tool (extra deployment)
• There is an extra tool installed in the weblogic server

ERROR::

<Critical> <WebLogicServer> <BEA-000362> <Server failed. Reason:
There are 1 nested errors:
Caweblogic.management.ManagementException: [Management:141266]Parsing Failure in config.xml: The following failures occurred:
-- [JMSExceptions:045047]The SubDeploymentMBean JRFWS_JMS_MODULE_SUBDEPLOYMENT_JRFWSJMSServer in deployment JRFWSAsyncJmsModule
can only be targeted to one JMSServerMBean because an entity that can only be targeted to a single JMS server (for example a queue,
topic or quota) has a sub-deployment-name element with value JRFWS_JMS_MODULE_SUBDEPLOYMENT_JRFWSJMSServer
at weblogic.management.provider.internal.RuntimeAccessImpl.<init>(RuntimeAccessImpl.java:127)
at weblogic.management.provider.internal.RuntimeAccessService.start(RuntimeAccessService.java:41)
at weblogic.t3.srvr.ServerServicesManager.startService(ServerServicesManager.java:461)
at weblogic.t3.srvr.ServerServicesManager.startInStandbyState(ServerServicesManager.java:166)

Sollution:

Locate the config.xml file in the directory:
D:\Oracle\Middleware\user_projects\domains\EPMSystem\config
(at the Weblogic server (HSS server)) Edit this file and look for the following:

<sub-deployment>
<name>JRFWS_JMS_MODULE_SUBDEPLOYMENT_JRFWSJMSServer</name>
<target>FMWebServices</target>
</sub-deployment>

Replace it with the following (only the word ‘FMWebServices’ to ‘JRFWSAsyncJmsServer’)

<sub-deployment>
<name>JRFWS_JMS_MODULE_SUBDEPLOYMENT_JRFWSJMSServer</name>
<target>JRFWSAsyncJmsServer</target>
</sub-deployment>

Try again to start Hyperion.


Thanks,
Mady

Deleting a dimension from Hyperion Planning application 11.x

                     Deleting a dimension from Hyperion Planning application 11.x

To delete dimension from Hyperion Planning application, we can follow the below steps:

John goodwin suggested in OTN like below, one of the simplest way to delete dimension::

You are really not meant to delete a dimension, if possible recreate the application without the dimension.
If you want to take the risk and delete the dimension using SQL then do a search on this forum and you will find some possible solutions.

My Team lead and friend Rahul Sharma suggested, using SQL we can delete dimension using below steps:
This procedure should only be performed by your SQL or Oracle DBA.

BE SURE YOU HAVE A BACKUP OF YOUR APPLICATION BEFORE ATTEMPTING THIS PROCEDURE.

You will need to delete all the children first, then the dimension.

If you have the dimension in forms, you may also need to(after step 5) go into the hsp_form obj_def_mbr table and delete all references of that object ID. Then delete the dim id in the hsp_form_layout table. Recycle services of Planning.

Procedure:
If you create a custom dimension in planning and wish to delete it,here is how you might remove it from SQL manually. We recommend that only someone familiar with relational databases attempt this.

The following assumptions are being made about the dimension:

* No forms have any references to the dimension.
* Any and all attribute dimensions have been removed from the dimension.
* Any and all members have been removed from the dimension.
* All security access has been removed from dimension.
* Any Alias associated with the dimension has been removed.

In this example we have created a dimension called DummyDimension.

1. Open the Enterprise Manager for SQLserver
2. Open the database that has your planning application
3. Open the table HSP_OBJECT
4. You need to find the row that has the dimension name you want to delete:
5. Take note of the OBJECT_ID in my example it is 50051, don't delete it yet.
6. Open the table HSP_MEMBER
7. Find and delete any rows that have a MEMBER_ID equal to the OBJECT_ID from step 5.
8. Close the Table HSP_MEMBER
9. Open the table HSP_MRU_MEMBERS.
10. Find and delete any rows that have a DIM_ID equal to the OBJECT_ID from step 5.
11. Close the table HSP_MRU_MEMBERS.
12. Open the table HSP_DIMENSION
13. Find and delete any rows that have a DIM_ID equal to the OBJECT_ID from step 5.
14. Close the table HSP_DIMENSION
15. Also delete it's reference from the HSP_UNIQUE_NAMES table.
16. Delete the row in the HSP_OBJECT table that you found in step 4.
17. Close the HSP_OBJECT table.
18. Open Essbase Application Manager for the application and remove the dimension from the necessary Essbase outlines. 
19. Restart the application server.

Thanks to John goodwin and Rahul Sharma...!!

For EPMA deployed application:
How Can We Delete Dimensions In Planning Once The application has been deployed From EPMA? [ID 1055007.1]


Thanks,
Mady

How to reset drm admin password??

                                            How to reset drm admin password??

Login as the drm schema/database user

Step 1 Make back up of current table data:

for oracle database execute the following:

         create table rm_user_bak as
         select * from rm_user;


for sql server execute the following:
Make sure that the drm database is being used 
         USE { database }
         SELECT * INTO dbo.rm_user_bak
         FROM dbo.rm_user;

---------------------------------------------------------------------------------

Step 2: Rest password to default::

for oracle execute the following:

update rm_user
set c_password ='S5ZY+Gwo/mR0xJVvh/bgB4e+eioS3lG7JVoO2PtuemrNAXcXc3qivFQAA62kKbUuZF8VceuEiUxgq8pznMUrTg=='

where c_user_name ='ADMIN';
Commit;

for sql server execute:

update dbo.rm_user
set c_password ='S5ZY+Gwo/mR0xJVvh/bgB4e+eioS3lG7JVoO2PtuemrNAXcXc3qivFQAA62kKbUuZF8VceuEiUxgq8pznMUrTg=='
where c_user_name ='ADMIN'

Commit

Step 3: test the changes
 The password has been reset to the default.
 Try logging into the application using user ADMIN and the password Welcome!


Warning: Do NOT update any other user with this password it will NOT work.

if there are any issues restore the the original password from the created back up table 

Could not connect to repository - IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 2 - ODI

IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 2 - ODI

Description::

This error we will get when there is multiple entries in SNP_LOC_REP table.

Solution: Delete latest entry and make sure only one entry will be there in the same table.

Error msg looks like below::

In my case there 2 entries in SNP_LOC_REP table, deleted entry from the same.

                                   After deleting one entry from the SNP_LOC_REP table

                                                    Now ODI logged in successfully.


Thanks,
Mady