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.
GKontos
Comments