FDMEE Deployment Failed

Error:
com.hyperion.hit.tool.deploy.utils.TemplateUtil] trace: Unable to find template file for name 'Oracle Data Integrator - Agent', null returned
[2015-10-27T07:48:11.281-07:00] [EPMCFG] [ERROR] [EPMCFG-01020] [oracle.EPMCFG] [tid: 57] [ecid: 0000L2djFHKFg4w6wFedMG1MBscp00000D,0:1120:698:852:6858] [SRC_CLASS: com.hyperion.cis.config.AntDeploymentApiAdapter] Error: [[
java.lang.NullPointerException
 at java.util.zip.ZipFile.<init>(ZipFile.java:119)
 at java.util.jar.JarFile.<init>(JarFile.java:135)
 at java.util.jar.JarFile.<init>(JarFile.java:99)
 at com.hyperion.hit.tool.deploy.utils.TemplateUtil.getCachedDomainType(TemplateUtil.java:547)
 at com.hyperion.cis.config.AntDeploymentApiAdapter.preDeploy(AntDeploymentApiAdapter.java:329)
 at com.hyperion.cis.config.AntDeploymentApiAdapter.preDeploy(AntDeploymentApiAdapter.java:146)
 at com.hyperion.config.wizard.impl.RunAllTasks.executeAppDeploymentTask(RunAllTasks.java:588)
 at com.hyperion.config.wizard.impl.RunAllTasks.execute(RunAllTasks.java:302)
 at com.hyperion.config.wizard.impl.RunnAllTasksState.run(RunnAllTasksState.java:92)
 at java.lang.Thread.run(Thread.java:662)


Description:
 FDMEE app deployment fails during configuration.

Cause:
This occurs if HFM ADM Driver configuration is missed

Solution:
Check the "HFM ADM driver" along with "Deploy to Application Server" and configure the FDMEE application.

I have seen similar issue in Reporting and Analysis. 

Read More

On FDMEE Server

There are different distribution packages for various JRE versions and hardware processors available

sapjco3-ntamd64-3.0.13.zip for a 64-bit JRE running on a 64-bit AMD or INTEL x86 processor is used here.

Note: Before installing JCo, please install the latest Microsoft Visual Studio 2005 C/C++ runtime libraries as described in note 684106.

Note: Do not copy the sapjco3.dll neither into the {windows-dir}\system32 nor into the {windows-dir}\SysWOW64 directory. This will break the operability of other JCo versions that are already installed on the same system. Furthermore you would risk that the current installation also would not work anymore, if the sapjco3.dll gets replaced in the respective Windows system directory in the future.

•        To install JCo for Windows unzip the appropriate distribution package into an own arbitrary directory {sapjco3-install-path}. D:/sapjco
•        Add the path of {sapjco3-install-path} to PATH environment variable
•        Finally, add {sapjco3-install-path}\sapjco3.jar to your CLASSPATH environment variable.
•     Refer screenshot below
• 
  

FDMEE SAP Bristlecone Installation

Configure ODI for use with SAP Source System

1.       Download the Open Tool for SAP from Bristlecone website (http://www.bristleconelabs.com/edel/login.html)

2.       Copy it to an arbitrary location ex D:/Open Tool for SAP

3.       Copy odi-sap.jar to below locations, overwrite

a.       <ODI_HOME>\oracledi.sdk\lib path

b.      <EPM_MIDDLEWARE_HOME>\odi\oracledi.sdk\lib.

c.       <EPM_MIDDLEWARE_HOME\EPMSystem11R1\products\FinancialDataQuality\AppServer\InstallableApps. Open aif.ear with 7-zip, drag and drop odi-sap.jar file to lib folder.

4.         Run the script updateODIEAR.

                 <EPM_ORACLE_HOME>\products\FinancialDataQuality\bin\updateODIEAR.bat

5.       Connect to the ODI Designer and go to the menu option ODI  Add/Remove Open Tools. Type the Class Name oracle.odi.sap.km._OdiSapAbapExecute in the Open Tool Class Name text box and press the Add Open Tool button. If added successfully the Open Tool version 10.1.3.20 will be shown.

Read More