FDMEE Runs Out of Resources


Dears,

From last month we noticed that FDMEE software has been going down multiple times a day. Below error message we are receiving in the logs

Error Message: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool aif_datasource to allocate to applications, please increase the size of the pool and retry..

Increase the connection pool for jdbc source (aif-source) from default 120 to 200 then 300

so we check and Currently the Maximum JVM heap Size is set to a large value, but the minimum JVM heap Size does not match the Max. Follow below steps to update.

A) Update the Min and Max JVM heap Sizes to Match each other (xms 5120 from xms 128 as an example to increase to 5 GB)

Start > Run > RegEdit

HKEY_LOCAL_MACHINE > Software > Hyperion Solutions > ERPintegrator0 > HyS9AIFWeb_epmsystem1

Locate the JVMOption value for -Xmsxxxm

Locate the JVMOption value for -Xmx5120m

Make sure the two match

B) Verify that the AIF_DataSource JDBC Connection Pool Max is set to a large enough value (depends on number of users)

C Verify that the ODIMASTER JDBC Connection Pool Max is set to the same value as the AIF_Datasource JDC Connection Pool

D) Recycle the FDMEE Web Application

Thanks,

~KKT~

Advertisements

FDMEE – Unable To See Newly Created PBCS Plan Type When Creating Data Load Rule


After creating new Plan Type in PBCS, it cannot be used in Data Management as a Target a Plan Type. When creating Data Load Rule in Data Management (FDMEE), the Target Plan Type drop down will not show the newly created Plan Type.

Follow the below steps to see the newly created Plan Type under Target Plan Type in Data Management.

– Add a new Cube at Administration > Manage > Cubes
– Refresh Database as usual
– Check that the new cube appears at the Planning Application windows
– Refresh Metadata and Members at Data Management Target Application window
– Click on Save
– Check that the new cube is not shown in the Plans list at Data Load Rule creation

Thanks,

~KKT~

FDMEE – Export the ODI Operator Log from the ODI Console


Hi,

I am frequently getting this query for 11.1.2.3. Below solution

This is a simple procedure that can be carried out by anyone who has access to the ODI console and knows the username and password for the ODI Console.

  1. Logon to the ODI Console by going to http://server:19000/odiconsole in a web browser (where server is the server where FDMEE is installed).
  2. Expand ‘Runtime’, then expand ‘Sessions/Load Plan Executions’ and you should be able to see the ODI sessions that have been run.
  3. Click on ‘Sessions/Load Plan Executions’ & then click the ‘Export’ icon (a small white square with a blue arrow pointing upwards on the ‘Browse’ tab).

Show the Operator logs

4. In the ‘Export Log’ screen, select a date and time for the ‘From’ and ‘To’ values that match when the FDMEE process started and finished (so that only a relevant subset of the logs are exported).

Set date filters for the export

5. Click the export button and you will get logs.

Thanks,

~KKT~

Load Data From FDMEE To ARM Error:” Export terminated due to mismatched currency buckets.”


When loading data to ARM  from FDMEE getting the error message:
Export terminated due to mismatched currency buckets “XXXXXX”. Ensure that Financial Data
Quality Management, Enterprise Edition Category names match ARM currency/buckets.

Error

To Fix-

Verify that currency bucket in ARM match currency in FDM:

Check currency mappings in FDMEE:

1. Log into Workspace

2. Navigate->Administer-> Setup->  Category Mapping ->  Application Mapping

3. Ensure that Target Application is “Account Reconciliation Manager”.

4. Make sure that you have appropriate Categories Setup.

FDMEE_Category

Thanks,

~KKT~

FDMEE – LCM Migration Failing Error: “Service unavailable’ “


Hi,

I was working on FDMEE and found this issue and here reference for you –

Error-

User Receive “Service unavailable’ error when attempting to migrate FDMEE Planning application metadata via LCM.
[2015-05-21T14:08:12.625-05:00] [FoundationServices1] [TRACE] [EPMLCM-54037] [oracle.EPMLCM] [tid: 156] [userId: ] [ecid: 00iTJ48khon13j15nvK6yZ0001Sg000MOa,0:1:4:3:1:3:3:3:3:4:3:3:4:4:4:4:3:3:4:4:3:3:3:4:3:4:3:3:4:3:3:4:4:3:3:3:3:3:3:3:4:3:3:3:3:4:4:4:4:3:4:4:4:3:3:3:3:3:3:1:1:1] [APP: SHAREDSERVICES#11.1.2.0] [URI: /workspace/logon] [SRC_CLASS: com.hyperion.lcm.handler.util.status.TaskStatus] [SRC_METHOD: getMessageContext:69] A task type error has occurred when performing the operation for task 0 defined in the migration definition file.
[2015-05-21T14:08:12.625-05:00] [FoundationServices1] [NOTIFICATION] [EPMLCM-13000] [oracle.EPMLCM] [tid: 156] [userId: ] [ecid: 00iTJ48khon13j15nvK6yZ0001Sg000MOa,0:1:4:3:1:3:3:3:3:4:3:3:4:4:4:4:3:3:4:4:3:3:3:4:3:4:3:3:4:3:3:4:4:3:3:3:3:3:3:3:4:3:3:3:3:4:4:4:4:3:4:4:4:3:3:3:3:3:3:1:1:1] [APP: SHAREDSERVICES#11.1.2.0] [URI: /workspace/logon] Service currently not available.
[2015-05-21T14:08:12.625-05:00] [FoundationServices1] [ERROR] [EPMLCM-37066] [oracle.EPMLCM] [tid: 156] [userId: ] [ecid: 00iTJ48khon13j15nvK6yZ0001Sg000MOa,0:1:4:3:1:3:3:3:3:4:3:3:4:4:4:4:3:3:4:4:3:3:3:4:3:4:3:3:4:3:3:4:4:3:3:3:3:3:3:3:4:3:3:3:3:4:4:4:4:3:4:4:4:3:3:3:3:3:3:1:1:1] [APP: SHAREDSERVICES#11.1.2.0] [URI: /workspace/logon] [SRC_CLASS: com.hyperion.lcm.common.LCMLogger] [SRC_METHOD: logMessages:939] Status document parsing failed. Nested exception is [[
org.xml.sax.SAXParseException: The reference to entity “Prom” must end with the ‘;’ delimiter.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:195)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:174)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:388)
at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1427)
at com.sun.org.apache.xerces.internal.impl.XMLScanner.scanAttributeValue(XMLScanner.java:881)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanAttribute(XMLDocumentFragmentScannerImpl.java:1547)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1320)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2756)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:647)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:511)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:808)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:119)
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:232)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:284)
at weblogic.xml.jaxp.RegistryDocumentBuilder.parse(RegistryDocumentBuilder.java:163)
at com.hyperion.lcm.handler.Task.updateStatusDocument(Task.java:422)
at com.hyperion.lcm.handler.util.Migration._importGroupingUnit(Migration.java:681)
at com.hyperion.lcm.handler.util.Migration.migrate(Migration.java:303)
at com.hyperion.lcm.handler.TaskHandler.processMigrationQueue(TaskHandler.java:609)
at com.hyperion.lcm.handler.TaskHandler.runTasks(TaskHandler.java:420)
at com.hyperion.lcm.handler.TaskHandler.execute(TaskHandler.java:86)
at com.hyperion.lcm.clu.async.AsyncMigrator.run(AsyncMigrator.java:54)
at java.lang.Thread.run(Thread.java:662)

 

In some cases the LCM export would not check that all the dependencies have been met when exporting so sometimes you get failures when importing it again

Workaround:
——————-

Set Skip Validation to Yes.

Navigate to Administration>Migration Options –>Import Options

ERP Integrator – Skip Validation Yes/ No. Set to Yes.

Thanks,

~KKT~

FDM claissic time to say ‘GoodBye’


Dears,

I was personally very strong fan of FDM and doing stuff with VB was real magic with all sorts of mapping etc.

Bu now FDMEE is the future and we have to move ahead with Jython .

FDM classic will be supported till 11.1.2.3.500 and after also patch .700.  After that version there will no longer be further bug fixes.

So Starting from 11.1.2.4 you can have only FDMEE where a migration from FDM to FDMEE would be required.

Thanks,

~KKT~

ODI – view FDMEE Scheduled tasks


Follow the below steps to view FDMEE tasks.

1.) Open ODI Studio and click Connect To Repository.
2.) From the login screen, click the green Plus sign.
3.) Enter a name for the Login (can be anything).
4.) ODI Connection User is SUPERVISOR.
5.) Enter ODI Connection Password.
6.) Master Repository User is the FDMEE database username.
7.) Choose Microsoft SQL Server Datadirect Driver from the Drive List dropdown.
8.) Enter the URL: jdbc:weblogic:sqlserver://<db host>;databaseName=<database name>.
9.) Select Work Repository radio button and click the magnifying icon, then select desired FDMEE repository.
10.) Click the Test button (if you do not see “Successful Connection” the information provided is incorrect). Click OK, and then OK one more time.
11.) The log in screen should be visible again at this point. Select the Login Name created and press OK to log in to your FDMEE Work Repository.
12.) Click on the Operator tab in ODI Studio.
13.) Expand the Scheduling selection in the Operator tab.
14.) Expand the All Schedules selection to view scheduled tasks in ODI.
15.) Expand Scheduling under your scheduled batch.
16.) Right click OracleDIAgent and click Open.
17.) This screen will show the scheduled times/dates of which it should run.

Thanks,

~KKT~

FDMEE LCM Import issue for IMPORT_FORMAT Artifact


Issue: Unable to import , LCM IMPORT_FORMAT artifact alone. But rest of the Artifacts able to import except IMPORT_FORMAT.

ErpIntegrator.log having below errors.

[2016-02-16T10:34:41.141+01:00] [ErpIntegrator0] [ERROR] [ERPI-102101] [oracle.apps.erpi.model] [tid: 25] [userId: <anonymous>] [ecid: 00iYbO0Pq8SDOd85njDCiZ0001lk0000yA,0:1:4:3:3:4:3:3:3:4:4:4:4:4:3:4:3:3:3:3:3:4:3:1:1:1:3] [APP: AIF#11.1.2.0] [URI: /workspace/logon] [SRC_CLASS: com.hyperion.aif.lcmintegration.util.XmlImportExportViewObjectImpl] [SRC_METHOD: importXML] Exception encountered while importing artifact[[
oracle.jbo.ReadXMLException: JBO-25025: Rowset with XML tag ImportGroupsAdapterVO cannot be loaded.

Caused by: oracle.jbo.RowReadXMLException: JBO-25026: Row oracle.jbo.Key[BC_Format_Import ] with XML tag ImportGroupsAdapterVORow cannot be loaded.

Caused by: oracle.jbo.AttributeReadXMLException: JBO-25027: Attribute ImportFormatItemAdapterVO at index 21 with XML tag ImportFormatItemAdapterVO cannot be loaded.

Caused by: oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[BC_Format_Import ERP 1 ].
at oracle.jbo.server.ViewObjectImpl.updateRowSetFromXML(ViewObjectImpl.java:18546)
… 39 more
## Detail 0 ##
oracle.jbo.RowReadXMLException: JBO-25026: Row oracle.jbo.Key[BC_Format_Import ] with XML tag ImportGroupsAdapterVORow cannot be loaded.

The issue is caused by duplicate Records for Source Import_Format artifact in  TBHVIMPITEMADAPTER DB table

select * from TBHVIMPITEMADAPTER where impgroupkey = ‘BC_Format_Import’;

“IMPSEQ” “IMPGROUPKEY” “IMPMAPTYPE” “IMPFLDFIELDNAME” “IMPSOURCECOLUMNID1” “IMPSOURCECOLUMNID2” “IMPSOURCECOLUMNID3” “IMPSOURCECOLUMNID4” “IMPSOURCECOLUMNID5” “IMPCONCATCHAR”
“1” “BC_Format_Import” “ERP” “ICP” “10134” “” “” “” “” “”
“2” “BC_Format_Import” “ERP” “UD1” “10136” “” “” “” “” “”
“3” “BC_Format_Import” “ERP” “UD2” “10135” “” “” “” “” “”
“4” “BC_Format_Import” “ERP” “ACCOUNT” “10135” “” “” “” “” “”
“5” “BC_Format_Import” “ERP” “ENTITY” “10133” “” “” “” “” “”
“6” “BC_Format_Import” “ERP” “ICP” “10134” “” “” “” “” “”
“7” “BC_Format_Import” “ERP” “UD1” “10136” “” “” “” “” “”
“8” “BC_Format_Import” “ERP” “UD2” “10135” “” “” “” “” “”
“9” “BC_Format_Import” “ERP” “ACCOUNT” “10135” “” “” “” “” “”
“10” “BC_Format_Import” “ERP” “ENTITY” “10133” “” “” “” “” “”

To Fix this

Remove the duplicate records in TBHVIMPITEMADAPTER DB table based on IMPSEQ column.

Then Re_Export LCM and do the Import LCM

Note : IMPSEQ is not Primary key (Sometime IMPSQL having duplicates) . so use RowId to delete duplicate records.

Eg:

DELETE FROM “FDMEE”.”TBHVIMPITEMADAPTER” WHERE ROWID = ‘AAASrkAAAAAAETWAAA’ AND ORA_ROWSCN = ‘11987502’ and ( “IMPSEQ” is null or “IMPSEQ” is not null )
DELETE FROM “FDMEE”.”TBHVIMPITEMADAPTER” WHERE ROWID = ‘AAASrkAAAAAAETWAAB’ AND ORA_ROWSCN = ‘11987502’ and ( “IMPSEQ” is null or “IMPSEQ” is not null )
DELETE FROM “FDMEE”.”TBHVIMPITEMADAPTER” WHERE ROWID = ‘AAASrkAAAAAAETWAAC’ AND ORA_ROWSCN = ‘11987502’ and ( “IMPSEQ” is null or “IMPSEQ” is not null )

Thanks,

~KKT~

Does FDMEE adaptors available for Hyperion strategic finance


In FDM G4-F driver was available to load data from Essbase/Planning to HSF rather than HSF Batch & Map.
Since FDMEE 11.1.2.3.000 users can’t see any reference to HSF as a valid target.
Is there any ODI target / driver for HSF? No Currently thats supported in FDM classic and not in FDMEE.

Below are valid EPM target applications for FDMEE.

Supported EPM target applications (Oracle Hyperion EPM Architect and Classic) are:

– Planning
– The Planning module, Oracle Hyperion Public Sector Planning and Budgeting
– Financial Management
– Essbase aggregate storage and Essbase block storage—If Essbase has been deployed in
standalone mode, it must be registered with Shared Services since it does not work directly
with FDMEE. Planning applications that rely on the standalone Essbase application cannot
work directly with FDMEE either.

– Account Reconciliation Manager (ARM)

=>The HSF adapter is only supported at the moment for FDM. You can use FDM in 11.1.2.3 and the HSF adapter to load HSF.

The HSF adapter is on the road map for FDMEE for a release after 11.1.2.4.

Data Export From FDMEE To HFM Hangs and Never Completes


Issue-

Data Export from FDMEE to HFM hangs, with a timeout error after a few minutes: A connection to the server has failed. (status=503), even though there is no issue accessing the HFM application via Workspace.

1. In Process Details, the job stays on the timer icon and never changes. After 5-10 mins, a timeout error “A connection to the server has failed. (status=503)” is returned. Even after leaving 2-3 hours, it never completes.

With debug option set to 5, when clicking on show Log in Process Details , the last action which is recorded within seconds of the start of the export is:

2013-07-31 13:08:16,750 DEBUG [AIF]: HFM Load command:
%EPM_ORACLE_HOME%/products/FinancialDataQuality/bin/HFM_LOAD.vbs “133” “+Rgrz%2Fu506JtoCFjpuMkLm5X0V614WUiWjH5QYbzTJdC0fQ4Mq9CAyc5jjgXwWmnSSyaUDMqPspXis9imet8ar8wyUsAo%2FzKSfO5XSuFsMhujldu0JdoZQJScjeGMfGcO08NdnUpeA8cxs9rzyGksyk5cYlIzedZfaexuNNwYqTiOJgPhIgbIMSsXUJumy8V5QllwlJKkTiU3l%2FvsRqXzTsA4ZYHjG8HmdUQJH3gVOMZR5y1pe6DN44fyKCnM9NwgR8LdeeFG4PeBq6fXQZevP4bDyx0xbRu%2Bgtp66oxBRa%2FkDOaYRbL%2BqsL9jpU4Mngbe%2FtG0JIsUcVRJhtj%2BLhVmX0VFj5Xrdl2sv40%2Bi5xrQUB0VEjI7GQVQ8cCApSko4VpMeKFW4UMcGH6Tt4WMJgKegurkaR8VKn6x1TtHo7DzU%3D%0D” “F%3A%5Capps%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem1” “%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35”

2. In ODI studio, there is no progress either . The lightning bolt remains on HFM Load Data – Procedure – HFM Load Data – and there is no error seen in ODI when double-clicking on those procedures.
3. HFM application is not started by launching the export, as there is no hsvdatasource process in Task Manager.

to fix-

On Windows server, the default host script is wscript. This needs to be switched to cscript, as the FDMEE code is issuing a cscript command from ODI to launch the HFM_LOAD.vbs script.

Additionally, short session timeout setting on OHS server may contribute to this issue.

1. Open a command prompt window as Administrator.
2. Run the following command:
cscript //H:cscript
3. This changes the default host script to cscript, and allows the HFM_LOAD.vbs to be executed.

When using Oracle HTTP Server (OHS) as the web server the default timeout is set at 5 minutes. In order to increase the timeout the following must be performed:

1. In the C:\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component directory you will find a mod_wl_ohs.conf file. In this file you will find:
WLForwardUriUnparsed ON
KeepAliveEnabled ON
KeepAliveSecs 20
DynamicServerList OFF
2. Add the following two lines just after the KeepAliveSecs 20 line (1800 seconds is 30 minutes)
WLIOTimeoutSecs 1800
HungServerRecoverSecs 1800
3. Save the file and restart the OHS Service and ERPi Web Service.

Thanks,
~KKT~