How to trace Essbase errors and check logs - Part1

     While working with Essbase, we may face lot of issues in our day to day activities. Here, I am going to update how to check errors and validate connections of Essbase. Why because, Essbase runs with OPMN in most of the deployments.

Frist of all, Essbase is an multi-dimensional database, so we will have all data saved into the Essbase Arbor path only. Most of the issues, will be with data only. Example as blow:

1. Error while loading data

2. Error while Retrieving data

3. Error while updating or loading Metadata.

4. smartview data validations etc.

Along with those, lot of admin issues will be happening in our daily activities. Like, connectivity, user access, space getting full, compression not happening, cache setting errors, Restructuring errors etc.

So, whatever issue if our work will get impact, then only It is issue. 😄

You will find errors in below logs:

Fist of all, Essbase log. Navigate to the Essbase.log Path, to find the Essbase.log.

Along with Essbase.log, in the same folder, we can find Essbase_ODL.log files, which log will be rotating and will be created as multiple files.

You can search with error, login name, process key words.

If you find xcp file in application folder, then application may corrupted/recovered from corruption.

If you find xcp file in Database folder, Then Database may corrupted either data or entire database.

(you can try renaming .apb as .app for applications or .dbb as .db for database as initial step. If itwon't work, try to contact with Infra team to restore database/application. You can contact Oracle also to find RootCause for generaing xcp files.)

Will continue in next part about analysis and tracing logs...!! 👍

How to trace Essbase errors and check logs - Part2

Thanks,

Mady

Shared services Provisioning Report

/* Users Provisioned for access to the application */

select CSS_USERS.NAME,CSS_ROLE_LOCALES.NAME,APPLICATION_ID, MEMBER_IDENTITY, ROLE_IDENTITY, MEMBER_TYPE  FROM CSS_PROVISIONING_INFO, CSS_ROLE_LOCALES,CSS_USERS
WHERE LOWER(CSS_ROLE_LOCALES.IDENTITY_ID)= LOWER(CSS_PROVISIONING_INFO.ROLE_IDENTITY)
and CSS_PROVISIONING_INFO.APPLICATION_ID='HFM:DANACASH'
and CSS_ROLE_LOCALES.locale='en'
AND CSS_PROVISIONING_INFO.MEMBER_TYPE=1
AND lower(CSS_USERS.IDENTITY_ID)=lower(CSS_PROVISIONING_INFO.MEMBER_IDENTITY)

To get a list groups provisioned for access to an application, use the following SQL: -

/* Groups Provisioned for access to the application */

select CSS_groups.NAME,CSS_ROLE_LOCALES.NAME,APPLICATION_ID, MEMBER_IDENTITY, ROLE_IDENTITY, MEMBER_TYPE  FROM CSS_PROVISIONING_INFO, CSS_ROLE_LOCALES,CSS_GROUPS
WHERE LOWER(CSS_ROLE_LOCALES.IDENTITY_ID)= LOWER(CSS_PROVISIONING_INFO.ROLE_IDENTITY)
and CSS_PROVISIONING_INFO.APPLICATION_ID='HFM:DANACASH'
and CSS_ROLE_LOCALES.locale='en'
AND CSS_PROVISIONING_INFO.MEMBER_TYPE=2
AND lower(CSS_GROUPS.IDENTITY_ID)=lower(CSS_PROVISIONING_INFO.MEMBER_IDENTITY)

The consolidate ed list of users and groups provisioned for access to an application is as shown in the below SQL: -

/* Consolidated list of users and groups for an application*/

(
select CSS_USERS.NAME,CSS_ROLE_LOCALES.NAME,APPLICATION_ID, MEMBER_IDENTITY, ROLE_IDENTITY, MEMBER_TYPE  FROM CSS_PROVISIONING_INFO, CSS_ROLE_LOCALES,CSS_USERS
WHERE LOWER(CSS_ROLE_LOCALES.IDENTITY_ID)= LOWER(CSS_PROVISIONING_INFO.ROLE_IDENTITY)
and CSS_PROVISIONING_INFO.APPLICATION_ID='HFM:DANACASH'
and CSS_ROLE_LOCALES.locale='en'
AND CSS_PROVISIONING_INFO.MEMBER_TYPE=1
AND lower(CSS_USERS.IDENTITY_ID)=lower(CSS_PROVISIONING_INFO.MEMBER_IDENTITY)
)
UNION
(
select CSS_groups.NAME,CSS_ROLE_LOCALES.NAME,APPLICATION_ID, MEMBER_IDENTITY, ROLE_IDENTITY, MEMBER_TYPE  FROM CSS_PROVISIONING_INFO, CSS_ROLE_LOCALES,CSS_GROUPS
WHERE LOWER(CSS_ROLE_LOCALES.IDENTITY_ID)= LOWER(CSS_PROVISIONING_INFO.ROLE_IDENTITY)
and CSS_PROVISIONING_INFO.APPLICATION_ID='HFM:DANACASH'
and CSS_ROLE_LOCALES.locale='en'
AND CSS_PROVISIONING_INFO.MEMBER_TYPE=2
AND lower(CSS_GROUPS.IDENTITY_ID)=lower(CSS_PROVISIONING_INFO.MEMBER_IDENTITY)
)
To get the list of all users and groups provisioned for access in the Hyperion environment, use the following SQL: -

/* Consolidated access list for users and groups */
(
select CSS_USERS.NAME,CSS_ROLE_LOCALES.NAME,APPLICATION_ID, MEMBER_IDENTITY, ROLE_IDENTITY, MEMBER_TYPE  FROM CSS_PROVISIONING_INFO, CSS_ROLE_LOCALES,CSS_USERS
WHERE LOWER(CSS_ROLE_LOCALES.IDENTITY_ID)= LOWER(CSS_PROVISIONING_INFO.ROLE_IDENTITY)
and CSS_ROLE_LOCALES.locale='en'
AND CSS_PROVISIONING_INFO.MEMBER_TYPE=1
AND lower(CSS_USERS.IDENTITY_ID)=lower(CSS_PROVISIONING_INFO.MEMBER_IDENTITY)
)
UNION
(
select CSS_groups.NAME,CSS_ROLE_LOCALES.NAME,APPLICATION_ID, MEMBER_IDENTITY, ROLE_IDENTITY, MEMBER_TYPE  FROM CSS_PROVISIONING_INFO, CSS_ROLE_LOCALES,CSS_GROUPS
WHERE LOWER(CSS_ROLE_LOCALES.IDENTITY_ID)= LOWER(CSS_PROVISIONING_INFO.ROLE_IDENTITY)
and CSS_ROLE_LOCALES.locale='en'
AND CSS_PROVISIONING_INFO.MEMBER_TYPE=2
AND lower(CSS_GROUPS.IDENTITY_ID)=lower(CSS_PROVISIONING_INFO.MEMBER_IDENTITY)
)

Hyperion Patching update

How to find or read patch details from versioning



Thanks,
Mady

HFM Documents Ownership change

While validating or working with Journal Reports, mainly with Private documents, do not save with different username or with admin user. Because it will save with that user and the user can't see that document with his login.

If it happened, we can update username back with backend table change/update.

Go to database -- execute below query

Formulae to create multiple queries:
=CONCATENATE("Update <ApplicationName>_RPTS Set CreatedUser ='",B1, "' where label = '",A1,"' and ReportType=1 and Private=1;")

Update <ApplicationName>_RPTS Set CreatedUser ='<username>@<domain>' where label = '<document name>' and ReportType=1 and Private=1; Not only Journal Reports, but we can also update any of the document username using the above method. Thanks, Madhusudhan

EPM 11.2.1 update

If we update Oracle EPM suite 11.2 to 11.2.1, No need to do configuration again.

Thanks,

Madhusudhan

Hyperion Workspace Logo change in 11.1.2.4

Permanent Workspace Logo update

1. Navigate to the location "\HYPERION_HOME\Oracle\Middleware\EPMSystem11R1\common\bpmui-common\11.1.2.0"
2. Extract the bpmui.war file using 7-zip
3. Navigate to "bpmui.war\bpmstatic\themes\theme_skyros\images_global\"
4. Replace the logon_panel.gif file
5. Save the bpmui.war file
6. Navigate to
\HYPERION_HOME\Oracle\Middleware\user_projects\domains\EPMSystem\servers\FoundationServices0\tmp\servers\FoundationServices0\tmp\_WL_user\WORKSPACE_11.1.2.0\340u89\war\bpmstatic\themes\theme_skyros\images_global
7. Replace the logon_panel.gif file
8. Restart the foundation services


Temporary Workpsace logo Update:

To change Workspace logon logo to Client logo, go to below path and rename logon_panel.gif as logon_panel_bkp.gif and copy client logo file as named as logon_panel.gif.

go to below path and copy file, and refresh browser.

D:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\FoundationServices0\tmp\servers\FoundationServices0\tmp\_WL_user\WORKSPACE_11.1.2.0\340u89\war\bpmstatic\themes\theme_skyros\images_global


Note: Some times while troubleshooting the any issues, we may remove all tmp and cache from managed servers. for example D:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\FoundationServices0


In that case, we should remember about this logo change.



Thanks
Madhusudhan

HFM: Unable to promote in Process control - EPMHFM-65716: The system was unable to perform the requested task

After upgrading HFM from 2.3 to 2.4 Version, below issue will occur if we miss below step.

In HFM application, Go to Data -- Process Control

If you try to promote, it will error out with below message.

EPMHFM-65716: The system was unable to perform the requested task

Solution:

We need to run "Upgrade Applications from Earlier Release" to avoid this error. It may get success for one scenario and year, but it not pass for all. Sometimes, only one table get created in schema, some times it will not create any.

Thanks,

Madhusudhan