Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in November 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Custom Stroed Procedures
answered 18-07-2017 13:02:24 -0400

Hi, We are trying to create a custom stored procedure to get the resultset in VDP from custom and when we tried to create one new custom stored proc as mentioned in the documents, it doesnot find the below packages still. In Eclipse, i have added all ...

Answers: 7

Error storing view: "Error accessing the metadata while loading/storing objects" when recreating the view.
answered 18-07-2017 09:40:15 -0400

Hello, there is an issue when I'm recreating (by create or replace command) an existing view: Error storing view: "Error accessing the metadata while loading/storing objects" When I create the same view with another name - it works fine. By the way,...

Answers: 3

kill or abort view in stream
answered 18-07-2017 03:34:58 -0400

Hi, Is there any way to kill, abort or stop a view and send back an error message? For instance, if you are checking for security and the user should not be able to query a table, can we throw an abort and send back a message like 'you do not have prop...

Answers: 1

abort session in view

Error when running CLEAN_CACHE_DATABASE procedure
answered 17-07-2017 08:18:25 -0400

I am getting the following error when I try to run the CLEAN_CACHE_DATABASE stored procedure via VQL shell: select * from CLEAN_CACHE_DATABASE('<vdb_name>'); Finished with error: The user does not have READ privileges on the procedure 'clean_cac...

Answers: 1

Stored Procedures CALL CLEAN_CACHE_DATABASE

VDP Connection error. You can continue working in draft mode
answered 17-07-2017 07:36:21 -0400

Version 6, Last update installed : 20170220 Issue: After logging into Scheduler on local machine, I have added a new server where I actually want to schedule a job for frequent cache load process. After connecting to that server ( using admin credenti...

Answers: 1

VDP administration connection error

View without search methods when applying CAST() or SUM().
answered 17-07-2017 07:07:57 -0400

Hello, there is an error when I'm trying to apply common functions like CAST( text field to date), SUM (decimal fields) and even simple math operations from the base view, which uses XML datasource and contains some obligatory fields. For example, vG...

Answers: 1

Denodo Monitor Service Not Maintaining Running Status
answered 14-07-2017 17:15:59 -0400

Hello, I just finished following this tutorial on two machines. The first machine worked flawlessly and is running well (my local dev machine). However, after performing this on the DEV server (running Windows Server 2012), I am experiencing issues k...

Answers: 2
Related to: Denodo Monitor as a Windows service

Denodo Denodo Monitor Auditing

Using the COALESCE function with Dates
answered 14-07-2017 09:28:34 -0400

Will appreciate if someone can help me with the following using the COALESCE function Query purpose: To return a particular Date value. If no Date value is returned, use January 1 0001 as the default Select coalesce(bv_test.find_my_dt, to_date('MMMM ...

Answers: 1

coalesce

Function is not executable
answered 14-07-2017 05:05:03 -0400

HI, I try to make a simple function it returns me this error "Finished with error: Function righttest is not executable". Below is the java and denodo script. Java: public class righttestVdpFunction { public String execute(String regex) { ...

Answers: 1

Date format used in the fixed WHERE Clause of Derived queries
answered 13-07-2017 09:22:00 -0400

I want to add a WHERE condition to a derived query and the field in the clause is a Date field. What is the formet I need to use in the condition value? In the Derived View > Edit > Where Conditions > add a condition field name = 'InceptionDa...

Answers: 1

dateformat