You can translate the question and the replies:

How to run statistics using Denodo Scheduler

I tried to use Denodo Scheduler to update the stats on a base view following the instructions here: https://community.denodo.com/kb/view/document/How%20to%20update%20the%20statistics%20of%20a%20view%20automatically?category=Scheduler However, I always get an error stating that the view does not exist. I tried adding the database name followed by the view name (e.g., dbname.vwname) and it still came back with same error message. I tried adding "connect database dbname; call generate_stats..." and it too did not work - a different error message: Syntax error: Exception parsing query near 'CALL' What should be the correct way? Thanks
run statistics generate_stats scheduler connect database
user
14-06-2019 22:43:35 -0400
code

1 Answer

Hi, It seems that your datasource is not configured properly to point to the required database. In the Scheduler Admin Tool, navigate to the Data Sources tab. Click on the vdp data source, there in the connection URI, you can see which VDP database is configured. The format of connection URI is //<hostname>:<port>/<database_name>. For example the default is, //localhost:9999/admin. Make sure you have configured the correct database here. You can also add a new data source and configure it accordingly. Refer to this document below for more details https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/data_sources/vdp_data_sources Hope this helps!
Denodo Team
18-06-2019 20:37:32 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here