Read timed out creating data source with HTTP data route

Applies to: Denodo 8.0 , Denodo 7.0 , Denodo 6.0
Last modified on: 01 Jun 2020
Tags: Timeout configuration

Download document

You can translate the document:

Denodo 8.0

To avoid timeouts when creating data sources from Denodo Design Studio, first of all, make sure that the Design Studio has a big enough timeout. To change the Design Studio timeout configuration go to file  <DENODO HOME>/DesignStudioBackend.properties. The timeout setting is stored in the  backend.connection.queryTimeout property with a default of 100000.

If creating data sources from the Virtual DataPort Administration tool, to change the Administration tool timeout configuration go to Tools > Admin Tool Preferences > Connection.

In addition to this, it may be necessary to configure the connection timeout for  some data sources. In particular, for those data sources that use HTTP Client as Data Route. By default an http data route has 120000 ms (2 minutes) as timeout configuration. To configure a higher timeout follow these steps:

  1. From the Design Studio, open the data source to modify.
  2. Go to the configuration section of the data source.
  3. Modify the Request timeout value.

This configuration can be applied to any type of data source using HTTP Client as Data Route and will increase the time the Virtual DataPort wrapper will wait for a response from the data source.

Older Denodo Versions

In previous, it may be necessary to configure the connection timeout for  some data sources running a VQL query. To configure a higher timeout follow these steps:

  1. From the Virtual DataPort Administration Tool, open the data source to modify.
  2. Click on the "VQL" button.
  3. Check the option "Replace existing elements" and copy the VQL generated. For instance:

CREATE OR REPLACE DATASOURCE XML ds_timeouttestxml

FOLDER = '/01 - datasources'
ROUTE HTTP 'http.CommonsHttpClientConnection,
120000'

GET 'http://host:8080/timeouttestxml/file.xml'
AUTHENTICATION OFF

PROXY OFF;

  1. Paste the copied VQL into the VQL Shell and modify ROUTE HTTP value. For instance,  to configure 1200000 ms (20 minutes) as timeout:

CREATE OR REPLACE DATASOURCE XML ds_timeouttestxml

FOLDER = '/01 - datasources'
ROUTE HTTP 'http.CommonsHttpClientConnection,
1200000'

GET 'http://host:8080/timeouttestxml/file.xml'
AUTHENTICATION OFF

PROXY OFF;

  1.  Execute the VQL query in the VQL Shell.

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training