You can translate the question and the replies:

Error gathering the statistics of the view

Hi Team, I am getting the below error while trying to gather statistics for a derived view. This derived view is created from 3 derived view and 3 db tables. Could you please help? **Error messages** Error gathering the statistics of the view: Error executing query. Total time 80.756 seconds.
user
16-11-2017 06:36:05 -0500
code

1 Answer

Hi, I have got this error "Error gathering the statistics of the view: Error executing query.", when I tried to gather statistics for a derived view having many records. In order to avoid this error, I would increase the value of timeout defined in the property "Query timeout(milliseconds)" by clicking on the "Administration"-> "Server Configuration"-> "Stored Procedures" of the Virtual DataPort Administration Tool. For more information, you can have a look at the section [Gathering the Statistics of Views](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/optimizing_queries/cost-based_optimization/gathering_the_statistics_of_views#how-the-gathering-statistics-process-works) of Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
17-11-2017 06:11:37 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here