You can translate the question and the replies:

Error when trying Gather the Statistics for a Base View (JDBC Oracle database)

When I try to gather the statistics for a Base View (based on a Oracle 12g JDBC database), I am getting the error: "Error gathering the statistics of the view: Error loading jdbc data source 'ds_edsm_orcl'." and I get the following for the same Base View when I run from the Tools > ViewStatisticsManager menu option "Error generating statistics of view bv_tdo_user_ref. Error loading datasource" I am able to Execute the Base View and get rows in the result set. What am I doing wrong here? By the way, I am able to Gather Statistics for DB2 Mainframe, DB2 LUW, SQL Server, and Postgres databases. Just not for Oracle.
Generate stats Denodo 6.0 JDBC oracle database connection
user
12-06-2017 19:08:16 -0400
code

1 Answer

Hi, I’ve faced similar error when trying to gather statistics for a view when the query tried to find average size of a blob field. I would verify the log file **vdp.log** present under *<DENODO_HOME>/logs/vdp* in order to get more information about the problem. If there is not enough information then I would set the log level at debug by running **call logcontroller(‘com.denodo’,’debug’)** so you could review the logs at more granular level. You may refer to the [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)section of Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
13-06-2017 06:11:21 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here