Pages

Tuesday, December 15, 2015

Invoking PushData.sh as ad-hoc or scheduled job from Hyperion Workspace

Background:

Users need to copy the data from the PSBP (Oracle Hyperion Public Sector Planning and Budgeting) manpower cube to the Opex cube (operating expense), since this is on 11.1.2.3.500 the Mapping Planning Applications to Reporting Applications is available already to do the job.
The Catch is there is no individual role available (atleast in 11.1.2.3 500) for running the utility. And giving admin access to run this utility was not a solution.

We need to have a job which can invoke the Pushdata utility and we can give access to a user to access only that job, similar to a FR report or a IR job (yes I am from the IR background J)

Issue:

The solution came to the mind is using publishing a batch file which will call the Pushdata.sh in Workspace so we can provision the job to the required user.
The Challenge was our Foundation & Planning were installed on Linux and the Reporting & Analysis was installed in Windows (this is a different story why it was done this way)
So need to have a perl script to login to the Linux machine from the windows and then need to call the PushData.sh

Solution:

We installed the strawberry perl as the perl which comes with EPM do lack some SSH packages needed for the remote login.

Batch file published to Workspace which calls the below script


Wednesday, November 4, 2015

EAS : "Failed to create client directory to write error file" during data load

A common error message when loading data via EAS console i encountered today,

 "Failed to create client directory to write error file" 

Solution:

Make sure the Path specified under Error file is correct, it might be a glitch that picks a invalid path. 

Edit the path to valid directory and reload the data file, you are good to go.

Upgrading ODI to 11g


The InstallTool.cmd , ConfigTool.cmd and the Opatch needs to be run as administrator especially in the  windows platforms

Background

Issue #1

We were in the middle of a installing EPM 11.1.2.4 for an implementation and the configuration failed. It throws the following error message

[EPMCFG] [TRACE] [EPMCFG-05020] [oracle.EPMCFG] [tid: 18] [ecid: 0000KsXRSDQ5mZ^5xVd9iW1LYPIx000002,0] [SRC_CLASS: com.hyperion.cis.ant.AntEngine] Error: {0}[[
D:\Oracle\Middleware\EPMSystem11R1\common\config\11.1.2.0\resources\preconfig\system\commonComponents.xml:547: Execute failed: java.io.IOException: Cannot run program "D:\Oracle\Middleware\EPMSystem11R1\common\VisualCRedistributable\10.0\vcredist_x86.exe" (in directory "D:\Oracle\Middleware\EPMSystem11R1\common\config\11.1.2.0\resources\preconfig\system"): CreateProcess error=740, The requested operation requires elevation

Monday, November 2, 2015

Why it’s important to run the 11.1.2.x on Windows platform with Admin access


The InstallTool.cmd , ConfigTool.cmd and the Opatch needs to be run as administrator especially in the  windows platforms

Background

Issue #1

We were in the middle of a installing EPM 11.1.2.4 for an implementation and the configuration failed. It throws the following error message

[EPMCFG] [TRACE] [EPMCFG-05020] [oracle.EPMCFG] [tid: 18] [ecid: 0000KsXRSDQ5mZ^5xVd9iW1LYPIx000002,0] [SRC_CLASS: com.hyperion.cis.ant.AntEngine] Error: {0}[[
D:\Oracle\Middleware\EPMSystem11R1\common\config\11.1.2.0\resources\preconfig\system\commonComponents.xml:547: Execute failed: java.io.IOException: Cannot run program "D:\Oracle\Middleware\EPMSystem11R1\common\VisualCRedistributable\10.0\vcredist_x86.exe" (in directory "D:\Oracle\Middleware\EPMSystem11R1\common\config\11.1.2.0\resources\preconfig\system"): CreateProcess error=740, The requested operation requires elevation

Tuesday, October 27, 2015

Deleting a Hyperion Planning dimension member, which refuse to get deleted

Let me explain the issue first and what needs to be done to overcome it.

Background:

Me and my collogue were testing the outline load utility (the option available in the workspace), we created 2 test members under the account dimension and trying to load the data to them.
We selected the Entity as the "Dimension to Import" and selected Account as "Driver Member Specification".
Import&Export-11.1.2.3.jpg


Issue:

We completed the testing and was trying to delete the two account members which were created, we couldn't delete those members. They are not part of any forms,calculation,reports etc....
Throws the error message that is associated with some other object. But there was none (no forms,calculation scripts etc..is is associated)


Sunday, June 28, 2015

ODI-10093 : you are importing an object from another repository with the same identifier. it is forbidden.

ODI-10093 is a generic error message, when we try to import any artefact to the ODI work repository. Well there are many suggestion available but i thought let me share this KB found in oracle support portal for the benefit of all the ODI folks out there.

Solution: 

To avoid this problem with this particular release of the Oracle Knowledge Analytics DO NOT choose any of the following ODI repository IDs during the installation of your ODI software. If you have already installed ODI, verify that the repository IDs do NOT match any of the following:
  • MASTER REPOSITORY ID: 0,353,366,500,541,542,651
  • WORK REPOSITORY ID: 1,36,74,91,129,268,353,366,452,541,542,600,651,656,667,720,789,801,888

Friday, June 19, 2015

Cannot start the Weblogic Admin Server

Well its been a while i written a blog, thought i will share some knowledge to the world and hope it will help someone. Well let me come to fixing the issue

Situation: 

Couldn't start the web logic admin server, it fails with a error message 


<WebLogicServer> <BEA-000386> <Server subsystem failed. Reason: java.lang.AssertionError: weblogic.management.provider.EditFailedException:
java.lang.AssertionError: weblogic.management.provider.EditFailedException:


You could find lot of blogs which will ask you to change the web logic mode to development (in config.xml & setdomainENV.cmd/sh)and change all the passwords to clear text.