Hi,
In general, if a query takes more time to retrieve the data from the source API, then the token expiration time needs to be changed accordingly since it will use the opened connection to process the entire request. For example, if my query requires one hour to process the entire data from the API, then I would change the expiration time of the token to more than one hour for retrieving all the rows without any errors.
To increase the token expiration time, I would do the following steps:
* Open the required data source from the Virtual DataPort and in the **"Authentication"** tab for OAuth authentication, increase the **"Access Token expires in"** time with the required value.
* Save the data source for the changes to take effect.
For more information, you could also refer to the section [OAuth Authentication](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/http_path#oauth-authentication) of Virtual DataPort Administration Guide.
If the issue persists, I would check the **vdp.log** file available in the <DENODO_HOME>\logs\vdp\ folder to get more information about the error.
Hope this helps!!