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 September 2019.

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.

Query to get the execution as output
answered 14-02-2019 12:56:21 -0500

Select * from view_name trace is giving me the query output which is the view data but I’m unable to get the execution trace as data. Please hlp me to get the execution trace or EXECUTION PLAN() as output so that I can redirect the same to a file for f...

Answers: 1

limit the tables involved in the select query
answered 14-02-2019 06:57:54 -0500

In a normal scenario for a data model, I think a query should only bring the tables(in JOINS) that are involved in the select query. However in Denodo, the select query is brining in all the tables involved in the model(the model is created based on 10...

Answers: 1

Decode oracle function in denodo
answered 13-02-2019 03:17:16 -0500

Hi How i am supose to implement following function in denodo DECODE (B.Blue,'1', 'Test' ,'2' ,'Test2' ,B.Blue)||' - '||B.Red ``

Answers: 1

JDBC: How to find the description of a user within java program
answered 13-02-2019 03:07:14 -0500

Hi, Denodo Version 6 From within java program, using JDBC connection to Denodo, is there any way to find the description of a user that is available from the "desc user" VDP command? Regards, Subrata

Answers: 1

jdbc desc user

Java Heap space error while running query
answered 13-02-2019 00:07:14 -0500

Hello, while executing select on a view, I am getting the error- "Finished with error: Error occurred in server thread; nested exception is: java.lang.OutOfMemoryError: Java heap space" Can you please help me on the issue, where I can increase the hea...

Answers: 1

Base view java Select Query 'Java heap space'

solution manager question
answered 12-02-2019 18:16:43 -0500

When i create a revision from development environment. by dbname is db1_dev. But when i want to promot it to sit environment . it should be db1_sit. where can i change it? i am using solution manager for deployments.

Answers: 1

#Deployments

Issue with SSL
answered 12-02-2019 10:24:23 -0500

Hi Denod Team, We are facing issues when we try connecting denodo as data source in OBIEE RPD. Issue with SSL enabled Denodo server. 1. We have denodo on machine A which is Windows server. We have enable SSL. 2. We are trying to connect Denodo D...

Answers: 2

Connection timed out (Write failed) - How to keep connection open?
answered 12-02-2019 04:55:55 -0500

Hi, We have a schedulaled caching-job that suddenly started to fail with the following error after arbetray time, a span from 2 hours to 3.30 hours: [CACHELOADERROR] There was an error while inserting data : I/O Error: Connection timed out (Write f...

Answers: 1

keepAlive Connection

how to perform recursive CTE in VQL
answered 12-02-2019 03:15:16 -0500

WITH cte1(inventory_item_id,related_item_id,recursivecallnumber) AS( SELECT inventory_item_id,related_item_id, 1 recursivecallnumberFROM MTL_RELATED_ITEMS B where inventory_item_id=5364273--5623321--142783 and relationship_type_id=6 UNION ALL SELECT e....

Answers: 1

Copying ntlmauth.dll to DENODO_HOME/jre/bin
answered 10-02-2019 22:01:51 -0500

Hi, I would like to add my experience with Denodo 5.5 in Windows 2012 64 bit. I had to copy ntlmauth.dll to %DENODO_HOME%/jre/bin and restart the server instead of %SYSTEMROOT%/system32. The latter wouldn't work and raised a "SSO Failed: Native SS...

Answers: 1
Related to: Accessing MS SQL Server using Windows Authentication

NTLM JDBC Data Sources SQL Server SSO