Data Export From FDMEE To HFM Hangs and Never Completes (Doc ID 1574048.1)

Last updated on SEPTEMBER 23, 2022

Applies to:

Symptoms

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.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.