Re-configure Essbase

If you have tried re-configuring Essbase you would notice that it is not able to connect to Shared Service anymore. Authentication error is thrown every time you connect to Essbase from different clients. Reason: The reason is Essbase is not able to connect with Shared Services. It is unable to create "EssbaseCluster-1" Application group and neither add new application to it as it already exists. Following...

Read More

Unable to start Web Analysis.

Problem:WebAnalysis URL not reachable/accessible.Weblogic has started but the application WebAnalysis.ear file is in prepared state hence the URL is not accessible.Error:weblogic.application.ModuleException: [HTTP:101216]Servlet: "InitServlet" failed to preload on startup in Web application: "WebAnalysis". com.hyperion.atf.services.ServiceManager$ServiceRecursiveInitException: Could not start critical...

Read More

Hyperion 11.1.2.3 user provisioning issue

ARCHITECTURE: ============== Hyperion Version : 11.1.2.3 DB -  11.2.0.3 single instance exadata DB Exalytic Linux - PCM, EAS, ESS, Planning, EIS , OHS, Calcmanager,APS, Essbase Server Exalytic Win - FCM, HFM, HSF, Foundation(shared Services and workspace), FR, WA, FDM, IR, Reporting and Analysis, SOA, ISSUE DETAILS...

Read More

Important Views in Oracle DB

1. dba_tablespaces SQL> desc dba_tablespaces; Name                                      Null?    Type ----------------------------------------- -------- ---------------------------- TABLESPACE_NAME                          ...

Read More

xhost command in Linux

xhost  Description        The xhost program is used to add and delete host names or user names to       the list allowed to make connections to the X server.  In the  case  of       hosts, ...

Read More

Essbase Spreadsheet ad-in Installation Error

Version :  11.1.2.0  and later Error: Error 1904 Module C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient\bin\essegd.dll failed to register. HRESULT -2147220473. Contact your support personnel  Solution:  Try registring the dll manually by using regsvr32 command CMD> regsvr32  C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient\bin\essegd.dll   If...

Read More

Unable to lock central inventory

Error: Unable to lock central inventory Description: There could be many reasons for this error Troubleshooting:  Check permissions on .patch_storage Cause: Central inventory has a lock hence current opatch process is not able to obtain lock on it. Meanwhile there are a lot of toher Solu...

Read More