Knowledgebase: FDM
FDM 11.1.2.4.0.79 - large date volume - Validation report failure
Posted by Sahar Mojtahedi, Last modified by Sahar Mojtahedi on 03 May 2017 04:39 PM

Symptoms:

Client reported the error on their FDM import where the import fails and no validation report is created (ticket #5515).
The application was version:
Workspace Version:11.1.2.4.0.79
UI Version:11.1.2.4.0.79

The logs reporting the error:

2017-04-05 08:19:39,870 INFO  [AIF]: -------END IMPORT STEP-------
2017-04-05 08:19:39,877 INFO  [AIF]: -------START VALIDATE STEP-------
2017-04-05 08:19:39,897 INFO  [AIF]:
Validate Data Mappings for Period 'Dec-2015'
2017-04-05 08:19:39,942 INFO  [AIF]: Total Data Rows available for Export to Target: 7695
2017-04-05 08:19:39,942 INFO  [AIF]:
Validate Data Members for Period 'Dec-2015'
2017-04-05 08:19:39,952 INFO  [AIF]: Total Data Rows available for Export to Target: 7695
2017-04-05 08:19:39,955 INFO  [AIF]: Executing the following script: D:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_VALIDATE.py
2017-04-05 08:19:40,067 INFO  [AIF]: Cluster name:  HFMTEST
2017-04-05 08:19:53,236 ERROR [AIF]: The script has failed to execute:
2017-04-05 08:19:53,238 FATAL [AIF]: Error in Comm.executeJythonScript
Traceback (most recent call last):
  File "<string>", line 528, in executeJythonScript
  File "D:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_VALIDATE.py", line 119, in <module>
    raise Exception("Intersection Validation step completed successfully. Intersection errors were found.")
Exception: Intersection Validation step completed successfully. Intersection errors were found.

2017-04-05 08:19:53,238 FATAL [AIF]: Error in CommData.validateData
Traceback (most recent call last):
  File "<string>", line 4464, in validateData
  File "<string>", line 549, in executeVBScript
  File "<string>", line 528, in executeJythonScript
  File "D:\Oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_VALIDATE.py", line 119, in <module>
    raise Exception("Intersection Validation step completed successfully. Intersection errors were found.")
Exception: Intersection Validation step completed successfully. Intersection errors were found.

2017-04-05 08:19:53,259 FATAL [AIF]: Error in COMM Validate Data
2017-04-05 08:19:53,261 INFO  [AIF]: FDMEE Process End, Process ID: 1547

Cause

Under heavy loads or large date volume the port limit may be exceeded so the limit and wait time have to be changed.

Solution

The details have been added from Oracle Support (https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=6ja2218x2_9&_afrLoop=363206963850952)
If you see the following error message in FDMEE Logs
HFM Server is unable to process the number of requests.
Then create the following entries HFM Application Server
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Tcpip\Parameters]
"MaxUserPort"=dword:0000fffe
HKLM\System\CurrentControlSet\Services\Tcpip\Parameters
Value Name: TcpTimedWaitDelay
Value Type: DWORD
Data: 30 (decimal)

Per Development in bug 24408858, registry entries should be added to FDMEE application servers and reboot need to be completed after changes are made.

This issue has been addressed in unpublished Bug 25616928 - minimize calls to hfm metadata api during intersection validation.  Please install Release 11.1.2.4.210 Patch Set Exception (PSE): 25616936
(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: