Other database connection issues
Issue: Data cube job or database query never ends or ends in error
- A job that builds or updates your data cube warehouse or in-memory storage 'hangs' or does not complete. An error message may be reported in the job run details or logs when the job completes or is canceled.
- For certain queries or for affected jobs, an error message containing text such as the following (possibly contained within other messages): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Some connections to your database may have been terminated by network infrastructure such as a firewall after a certain period of time or due to other reasons. Some data providers have a keep alive option that offers a potential solution to this problem.
For example when editing a data connector using the Oracle Database data provider in Dundas BI version 10 or later, expand the Advanced section and enable the Keep Alive option. You can read more about the Keep Alive and related Keep Alive Interval and Keep Alive Time settings on Oracle's website.
Similarly, you can edit a data connector using the PostgreSQL data provider in Dundas BI version 10 or later, and expand the Performance section to find the Keepalive and TCP Keepalive options. Each of these options is used in different scenarios. For details, see the Npgsql page on the Keepalive options.