FDMEE Configuration issue JAVA crashed without creating Services

FDMEE Configuration issue JAVA crashed without creating Services..

While working on FDMEE configuration today on Windows server 2012 Operating susyem, i have face one issue.

Issue is, while doing confuging especially deploy to Application server, Java crashed with below error.

When checking View problem details

Problem signature:
  Problem Event Name: APPCRASH
  Application Name: HyS9aifWeb_epmsystem1.exe
  Application Version: 1.0.0.2
  Application Timestamp: 512cbfcc
  Fault Module Name: ATL100.DLL
  Fault Module Version: 6.3.9600.19478
  Fault Module Timestamp: 5d6aa558
  Exception Code: c0000135
  Exception Offset: 00000000000ecf30
  OS Version: 6.3.9600.2.0.0.400.8
  Locale ID: 1033
  Additional Information 1: ac05
  Additional Information 2: ac0507478d1c5bd693cfc4fe3987e900
  Additional Information 3: ac05
  Additional Information 4: ac0507478d1c5bd693cfc4fe3987e900

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=280262

If the online privacy statement is not available, please read our privacy statement offline:
  C:\Windows\system32\en-US\erofflps.txt


Problem signature:
  Problem Event Name: APPCRASH
  Application Name: HyS9aifWeb_epmsystem1.exe
  Application Version: 1.0.0.2
  Application Timestamp: 512cbfcc
  Fault Module Name: ATL100.DLL
  Fault Module Version: 6.3.9600.19478
  Fault Module Timestamp: 5d6aa558
  Exception Code: c0000135
  Exception Offset: 00000000000ecf30
  OS Version: 6.3.9600.2.0.0.400.8
  Locale ID: 1033
  Additional Information 1: ac05
  Additional Information 2: ac0507478d1c5bd693cfc4fe3987e900
  Additional Information 3: ac05
  Additional Information 4: ac0507478d1c5bd693cfc4fe3987e900

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=280262

If the online privacy statement is not available, please read our privacy statement offline:
  C:\Windows\system32\en-US\erofflps.txt

So, for this to get resolve we need to install the below:

Go to path D:\Oracle\Middleware\EPMSystem11R1\common\VisualCRedistributable\10.0

Install vcredist_x86.exe and vcredist_x64.exe

Then try to deploy to application server, it will create FDMEE Service.

Thanks,

Madhusudhan

FDMEE Links

FDMEE
Data Management

Workflow:

Data Load:

Data Load Workbench
https://docs.oracle.com/cd/E57185_01/AGFDE/setting_system-level_profiles.htm

Data Load Rule
https://docs.oracle.com/cd/E57185_01/AGFDE/defining_data_load_rule_details.htm

Data Load Mapping
https://docs.oracle.com/cd/E57185_01/AGFDE/fus_data_mapping_116x52092843.htm

Metadata:

Metadata Rule
https://docs.oracle.com/cd/E57185_01/AGFDE/erpi_app_dim_rule.htm

Other:

Batch Execution
Report Execution
Script Execution

Monitor:

Process Details

Setup:

Configure:

System Settings
Application Settings
Security Settings
User Settings

Register:

Source System
Target Application
Source Accounting Entity
Source Adapter

Integration Setup:

Import Format
Location
Period Mapping
Category Mapping
Excel Interface

Data Load Setup:

Logic Group
Check Rule Group
Check Entity Group

Scripts:

Script Editor
Script Registration

Reports:

Query Defination
Report Defination

Batch:

Batch Defination

FDMEE Tuning tips

FDMEE Performance tuning Guide

This tips are applicable to 11.1.2.3.000 or higher version

1. JVM tuning

2. Data Sources

3. Batch Size

4. ODI (Oracle Data integrator) setting

5. Database

Configure JVM Tuning for ERPI (FDMEE)

1JVM Tuning

The JVM (Java Virtual Machine) allocates and manages the heap memory based on how much each Java application needs. When a Java application is running, the systematic usage and release of heap memory is managed through a “garbage collector”.

The two settings to change for heap memory are:

-Xms   - the minimum size of the heap

-Xmx   - the maximum size of the heap

VM Heap Registry Settings in Windows Server

1. Open the Windows Registry.

2. Navigate to below location 

3. HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\ErpIntegrator(n)\HyS9aifWeb_epmsystem(n) Where ErpIntegrator(n)

4.

5. (ErpIntegrator0, ErpIntegrator1, depending on how many FDMEE web servers are deployed and which server you are updating.

6. Locate the two JVMOptions –Xms and –Xmx   (Data Type is REG_SZ).

7. Double click the option to change. (For example, JVMOptionnn)

8. In the Value Data, change the numerical value of –Xms2064m to the new value,

9. Repeat this step for the –Xmx value.

10. Restart the HyS9aifWeb service.

Note:   -Xms and –Xmx values should be set to the same number

In Linux Server

To change the JVM heap entries for Linux do the following:

1. Edit this file: /user_projects/epmsystemx/bin/deploymentScripts/setCustomParamsErpIntegrator.sh.

2. Find the section JAVA_OPTS=”-Xms512m –Xmx512m….”

3. Change the numerical values to the new desired heap memory value, save the changes.

4. Restart the “Oracle Hyperion FDM Enterprise Edition - Java Web App” service.

Weblogic Data Sources:

Increase the default number of data sources. WebLogic data sources are the number of pooled connections made available to FDMEE for a JDBC (database) data source.

Tips…  for error

If your application runs out of WebLogic data sources you might see in your log file, “ResourceLimitException”, or “Reached maximum capacity of pool”.

To start Oracle WebLogic Server Administration Console:

1. Select Start, then Programs, then Oracle WebLogic, then User Projects, then EPMSystem, and then Start Admin Server for WebLogic Server Domain.

2. When the Admin Server displays “RUNNING”,

3. Select Start, then Programs, then Oracle WebLogic, then User Projects, then EPMSystem, and then Admin Server Console.

4. To access the WebLogic Server Administration Console from the browser type in the following URL: » http://servername:7001/console

5. Login to WebLogic Server Administration Console with the credentials used during the system configuration

6. From Domain Structure, select Services, and then Data Sources.

7. Select either aif_datasource or odiMasterRepository by selecting the hyperlink in the Name column.

8. Select the Configuration tab and then the Connection Pool tab

9. Click Lock & Edit button to modify the “Maximum Capacity” setting.

10. In Maximum Capacity, type the new value for the data source connections.

11. Once the setting is changed, click Save. Repeat steps four through eight to change the odiMasterRepository data source connection pool.

Batch Size:

Specify the number of rows read at a time from the file to memory. This parameter is mainly used for performance.

Batch Size Batch Size refers to the number of import records that are “batched up” before a commit occurs on the database.

The “Batch Size” parameter is set at the system level.

Default setting for “Batch Size” is 1000.

This setting is changed by selecting Data Management, then on the Setup tab, select Configure, System Settings. On the System Settings screen, type the new value in the Batch Size field and click Save.

Smaller imports, such as < 10,000 records, would suffice to use the default batch size.  If you have < 100000 records, keep the batch size setting as 10000.

Note: A setting too large or too small can have adverse performance effects.

Oracle Data Integrator (ODI)

ODI has three significant tuning components to explore if you are having problems loading large data sets.

1. Array Fetch Size  

2. Batch Update Size   (These can be found in “Topology” tab of ODI Studio in the Physical Architecture section for your data server.

3. Maximum number of sessions   (The Maximum number of sessions setting is found under the agent.

Tips..

Optimal values for

Array Fetch Size and Batch Update Size is “100”   for better performance, low memory and CPU usage.

Open ODI Studio and connect to FDMEE repositories

Go ODI Navigator

Go to   Physical architecture à Technologies à Oracle à Data Server  ( EBS_DATA_SERVER or FDMEE_DATA_SERVER)

The “Maximum number of sessions” value depends on the capabilities of the machine running the agent. Oracle Data Integrator allows you to load balance parallel session execution between physical agents. Each agent has a maximum number of sessions it can execute simultaneously from a work repository.

The default value for Maximum number of sessions is 1000

HFR Reports Migation - DB connections not showing up

Generally, when we do migration from existing environment to freshly installed environment, especially Reports, Database connection details for that must be there to replace details with current environment details.

For example: We have upgraded Hyperion 11.1.2.3 to 11.1.2.4 version, now migrating artifacts to new servers from Temporary server. Reports migrated using LCM and all reports migrated but while trying to reports popup with error Nested error. Because it is not connected to any DB Connection.

DB connection contains details of Name, Component type, Cluster or Server Name, user name and password and then application.

Here, we do not get existing connections. So, we can't replace connection with current one. For this kind of issue, we may try below options to get existing connections, so that you can change to your current.

1. From the Explore Repository, select the item to export.
2. Select File, and then Export.
3. Select the artifacts to export, and then click OK.

While importing Turn on User POV in user preferences and try to open report. It will ask you for DB connection. So you can change it.

Some time, just try to open reports, it will pop up with error that connection details wrong mentioned and to correct them, so that you can change them in Database connection Manager. POV must be Turn ON

Some times, Importing LCM by selecting some reports like for example one time 3-4 reports like that, after importing them you may get option to change DB connection.


Thanks,
Madhusudhan

HFM Copy of EPMA HFM application

With SQL

With Oracle

Oracle Hyperion - Weblogic Admin server as a windows service

To set Weblogic Admin server as a service, follow below steps

Go to weblogic Path: E:\Oracle\Middleware\wlserver_10.3\server\bin
Create a File named as InstallAdminService.cmd (Name would be any)

edit the same file and copy below text and save it.

SETLOCAL
SET DOMAIN_NAME=EPMSystem
SET USERDOMAIN_HOME=D:\Oracle\Middleware\user_projects\domains\EPMSystem
SET SERVER_NAME=AdminServer
set PORT=7001
set WL_HOME=D:\Oracle\Middleware\wlserver_10.3
SET PRODUCTION_MODE=true
SET MEM_ARGS=-Xms512m -Xmx1024m
SET JAVA_OPTIONS=-Dweblogic.Stdout="D:\Oracle\Middleware\user_projects\domains\EPMSystem\stdout.txt" -Dweblogic.Stderr="D:\Oracle\Middleware\user_projects\domains\EPMSystem\stderr.txt"
CALL "D:\Oracle\Middleware\user_projects\domains\EPMSystem\bin\setDomainEnv.cmd"
CALL "D:\Oracle\Middleware\wlserver_10.3\server\bin\installSvc.cmd"
ENDLOCAL

Go to installSvc.cmd file and Update Service (As per your requirement)
E:\Oracle\Middleware\wlserver_10.3\server\bin

Once updated above 2 files, run InstallAdminService.cmd file, it will create Service in Services Panel.

Change it from automatic to manual and logon if needed.

Test cases:
Check out Weblogic console is working or not
Check out Weblogic console is working or not with only port (with out console in URL)
Check out Weblogic console is starting or not using command line (using start admin server for weblogic server domain)

Thanks,
Madhusudhan

Hyperion 11.2 Updates

HYPERION ENTERPRISE PERFORMANCE MANAGEMENT (EPM) 11.2 ON-PREMISE RELEASE INFORMATION


Planned features of Hyperion EPM (On-Prem) 11.2.x include:

Hyperion Planning:

Smart Push
Dimension Editor SV extension
Extended Attribute support
Valid Intersections
Data Relationship Management
Batch scripts to ease EPMA replacement
Enhanced DRG Experience
DRG Mass Approvals
SFTP Connection

Hyperion Financial Management:

Automated Consolidations
Configurable by admin
Native Metadata Editor
Purging source tables after import
Performance improvements
SV, DB batch processing, etc.
Profitability and Cost Management
Expanded Custom Calcs for complex logic
POV Copy support for large outlines Tax Provisioning
Tax Automation Trace where the source is ICP
Enhanced Deferred Tax Classification logic
Financial Reports
Multi-Report Editing via Web Studio
Replace R&A repository
Book/Batch to output to MS Office Smart View
Chrome support for web launch (SUI)
Limited functional release for Office 365 Web/All clients

Hyperion EPM (On-Prem) Product/Features Discontinued in 11.2:

Hyperion Financial Management

Financial Management Analytics
Essbase Analytics Link for Hyperion Financial Management
Quantitative Management and Reporting for Solvency

Hyperion BI+

Interactive Reporting (IR)
Production Reporting  (SQR)
Web Analysis (WA)



Hyperion Planning:

Hyperion Strategic Finance
Crystal Ball (replaced by Predictive Planning)
Simplified User Interface (SUI)
Workforce Planning
Capital Expense Planning
Project Financial Planning
Offline Planning

Additional

EPM Architect (EPMA)
Disclosure Management
EPM Mobile



Thanks,
Madhusudhan