Fusion Payroll: Unable to Generate Error Report Using PBL - "ADFDI-05577: Failed to retrieve table row data from the server. The remote server returned an error: (504) Gateway Timeout. (Doc ID 2233045.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Global Payroll - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to retrieve error reports using PBL the following error occurs.
We observed that this error occurs when file has record count more than 3000 rows.
We are using PBL for loading element entries.
It is still working, but looks like this is the issue with file size.

ERROR
-----------------------
"ADFDI-05577: Failed to retrieve table row data from the server.
The remote server returned an error: (504) Gateway Timeout.

~~~~~~~~~~
DownloadFailedException: ADFDI-05577: Failed to retrieve table row data from the server.
Source: adfdi-excel-runtime
Stack:
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableDownloadHelper.DoDownload()
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableDownloadHelper.Download()
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableActionHelper.DownloadTableData(DownloadType downloadType)
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableActionHelper.Invoke(RTComponentAction rtAction)
  at oracle.adf.client.windows.excel.runtime.uicomponent.RTBaseTable.Invoke(RTComponentAction rtAction)
  at oracle.adf.client.windows.excel.runtime.uicomponent.RTComponentAction.Invoke()
  at oracle.adf.client.windows.excel.runtime.uicomponent.RTActionCollection.DoInvoke(ExcelRange targetCell)
Inner:
WebException: The remote server returned an error: (504) Gateway Timeout.
Source: System
Stack:
  at System.Net.HttpWebRequest.GetResponse()
  at oracle.adf.client.windows.common.internet.http.ManagedHttpResponse.get_HttpWebResponse()
  at oracle.adf.client.windows.common.internet.http.ManagedHttpResponse.CacheResponseInfo()
  at oracle.adf.client.windows.common.internet.http.ManagedHttpResponse.DoInMemoryRequest()
  at oracle.adf.client.windows.common.internet.http.ManagedHttpResponse.DoReadResponse()
  at oracle.adf.client.windows.common.internet.http.ManagedHttpResponse.GetStatusCode()
  at oracle.adf.client.windows.datamanager.servletrequest.SyncRequest.BeginResponse()
  at oracle.adf.client.windows.datamanager.servletrequest.BindingContainerRequest.BeginResponse()
  at oracle.adf.client.windows.datamanager.servletrequest.MultiSyncModelRequest.EndRequest()
  at oracle.adf.client.windows.datamanager.servletrequest.MultiSyncModelRequest.InternalCallSyncServlet()
  at oracle.adf.client.windows.datamanager.servletrequest.SyncServletRequest.CallSyncServlet(Boolean retry)
  at oracle.adf.client.windows.datamanager.ADFBindingContext.SendSyncServletRequest(SyncServletRequest request)
  at oracle.adf.client.windows.datamanager.ADFBindingContext.InvokeBindingContainerRequest(BindingContainer bc, BindingContainerRequest request)
  at oracle.adf.client.windows.datamanager.ADFBindingContext.DoMultiSyncModel()
  at oracle.adf.client.windows.datamanager.MultiSyncRequestHelper.EndMultiSync()
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableDownloadHelper.FlushMultiSyncRowsToCache(List`1 listMultiSyncRows)
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableDownloadHelper.DoDownload()"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. PBL
2. Error comes when we are in Batch Content Sheet and try to fetch error records by double clicking on one the Task action name with batch line status : "Error" .
 



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms