Home / Q&A / All Questions

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.

Denodo view with (many) empty fields takes all Denodo memory (leading to unusable VDP server, no memory left)
answered 20-06-2018 10:11:24 -0400

HI, I am trying out a view with many temporary empty columns until I can map them to an underlying datasource. I tried with a derived view and an interface to create constant null columns (as text) by setting the unmapped fields to cast("text", NULL)...

Answers: 1

Support portal access for downloads
answered 20-06-2018 05:50:00 -0400

Hello, I spoke with one of the engineers today and he indicated that he believed there was a way to add other individuals on a partner's team to have access to support. We have two designees with access to the support portal. In my case, I need to be...

Answers: 1

support

Virtual Data Port Error
answered 20-06-2018 02:47:43 -0400

Hi Team I have issue logging into the VDP admin tool. Below is the error am getting: "Connection error. Unrecognized SSL message. Plaintext Connection?" Last month i was able to access the Denodo, but dont know what happened past two weeks am getting ...

Answers: 1

Denodo server starting trouble.

Search Configuration (Search Index)
answered 20-06-2018 02:44:56 -0400

Hi, I am using Denodo Express 6.0 and I am trying to implement search in view using indexing. I am following "Search Configuration" document and implementing VDPIndexer Job. I have filled up the information in Extraction Section and can able to see the...

Answers: 3

Index

ERROR: operator does not exist: timestamp without time zone >= character varying'
answered 19-06-2018 12:38:06 -0400

Hello, I am new to Denodo and because I have a strong background in SQL I have been using my SQL skills by creating base views off a query. When I get to the next step of creating my derived view witha a date parameter I continue to receive the followi...

Answers: 1

query Parameter Date timestamp

Denodo problem with view that joins underlying fully cached views.
answered 19-06-2018 12:10:12 -0400

When I execute: select * from myview I get instant results myview is a star shaped join query with codes (one table for each field with codes). The tables that resolve these codes are fully cached. I do this because underlying to these tables with...

Answers: 1

host name issue while installing Denodo 7.0
answered 19-06-2018 06:51:43 -0400

Hi Team, I have succefully installed Denodo Solution manager as per provided Lincece Key file . But I am facing issue while configuring Lincence for Denodo7.0 . Denodo Solution Manager works on below IP Address : 192.168.1.2 Port : 10091 ( For Lince...

Answers: 1

installation

Denodo monitor finished or stopped query remains without state (session remains open)
answered 19-06-2018 06:16:21 -0400

Denodo monitor shows 'finished' or manually 'stopped' query (as active - white) in the requests tab, with a start time but no end time and no state (empty value in state column). (other finished queries have the state OK and are greyed out). How can t...

Answers: 1

Accepting json data as input in Denodo stored procedure
answered 18-06-2018 11:19:48 -0400

Hi, My requirement is to develop a stored procedure which accepts application/json data as input and output some result. Later point of time on top of this stored procedure i need to create a REST service and returns JSON response.I am aware of GET RE...

Answers: 3

Denodo stored procedure

Cache Tables not getting truncated or cleared.
answered 18-06-2018 07:52:39 -0400

Hi Team, We have a derived view which is configured to have full cache and related data base user is having full access on the tables to truncate table but when I run the Job through Job or try to invalidate the cache through VDP data in Cache table i...

Answers: 1