After loading for a while, Qlik REST connector fails with the following error messages:
- QVX_UNEXPECTED_END_OF_DATA: Timeout when waiting for HTTP response from server
- QVX_UNEXPECTED_END_OF_DATA: Failed to receive complete HTTP response from server
This happens even when Timeout parameter of the REST connector is already set to a high value (longer than the actual timeout)
Environment
Qlik Sense Enterprise on Windows
Timeout parameter in Qlik REST connector is for the connection establishment, i.e connection statement will fail if the connection request takes longer than the timeout value set. This is documented in the product help site at https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Create...
When connection establishment is done, Qlik REST connector does not have any time limit for the actual data load. For example, below is a test of loading the sample dataset "Crimes - 2001 to present" (245 million rows, ~5GB on disk) from https://catalog.data.gov/dataset?res_format=JSON. Reload finished successfully with default REST connector configuration:
Therefore, errors like QVX_UNEXPECTED_END_OF_DATA: Timeout when waiting for HTTP response from server and QVX_UNEXPECTED_END_OF_DATA: Failed to receive complete HTTP response from server are most likely triggered by the API source or an element in the network (such as proxy or firewall) rather than Qlik REST connector.
To resolve the issue, please review the API source and network connectivity to see if such timeout is in place.