Planning - Essbase -Location Alias Issue

 Hi Everyone, Today we found one issue with Hyperion Planning application, mainly in business rules.

While Launching/Executing Business Rules from Planning, We found error below.

Initially, We tried to check error in below ways:

1. We tried refreshing database from Planning to Essbase to check connect.
2. Even We tried checking Data Source of Planning to check Essbase Connection before first step.
3. Essbase side - Application is fine, no issues there.

We tried to check Location Alias for Cube, there we got same error. As we found one article from Oracle Support which is pointing same.

So, We verified Location Alias, it is giving error. We have updated Cluster name instead of Server name in Essbase Node section, It is verified successfully.

Now, Business Rules from Planning and executed successfully.

Oracle support: Doc ID: 1922470.1

Thanks,

Mady

In weblogic production mode if Admin Server abruptly shuts down do other managed servers continue to work???

 In WebLogic production mode if Admin Server abruptly shuts down do other managed servers continue to work??

Yes, Other Managed servers will not dependent on Admin server. Admin server is used for connecting Weblogic URL, where we can check all managed servers status and we can set all settings for all managed servers.

We can check below in Admin Server:

1. All Managed servers deployed in to that domain.
2. All Settings related to Managed server in that domain.
3. Settings, like Stuck Thread values, Time out settings, port number, Host names etc.

Thanks,

Madhusudhan

How to trace Essbase errors and check logs - Part2

Essbase logs, we need to check for any issues.

ESSBASE.LOG                                        —    Essbase Server activities and errors

ESSBASE_ODL.log                                 —    Essbase Server activities and errors

dataload_ODL.err                                     —    Data load and dimension build errors

log0000x.xcp                                            —    Errors that result when Essbase Server stops abnormally

leasemanager_server_HOSTNAME.log  —    Essbase Server Lease Manager information

leasemanager_essbase_HOSTNAME.log—    Essbase Agent Lease Manager information

log00001.xcp                                            —    Errors that result when the agent stops unexpectedly

easserver.log                                             —    Administration Services Server activity

EssbaseAdminServices0.log                    —    Administration Services Java web application activity

opmn.log                                                  —    Information about when Essbase starts, stops, and how                                                                                 many stop and start retry attempts are made

console~ESSBASE_CLUSTER_NAME~ESSBASE_PROCESS_TYPE~AGENT~1.LOG — All console messages are directed to a file that is called the "console" output file for a managed process, in this case, Essbase.

Note: ESSBASE.LOG and ESSBASE_ODL.log contain the same information in different formats.

Thanks,

Mady

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

Email powershell code

$Body = "Sample Email Body" 
$SmtpServer = 'smtp.gmail.com' 
$SmtpUser = 'madhu.hyp2011@gmail.com' 
$smtpPassword = 'M@dhu123@#' 
$MailtTo = 'madhu.hyp2011@gmail.com' 
$MailFrom = 'madhu.hyp2011@gmail.com' 
$MailSubject = "Testing Mail Attachments using $SmtpServer" 
$Credentials = New-Object System.Management.Automation.PSCredential -ArgumentList $SmtpUser, $($smtpPassword | 
ConvertTo-SecureString -AsPlainText -Force) 
Send-MailMessage -To "$MailtTo" -from "$MailFrom" -Subject $MailSubject -Body "$Body" -SmtpServer $SmtpServer -BodyAsHtml -UseSsl -Credential $Credentials 
write-Output "Custom Message : Attachment Email Sent to Business Users"  

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