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 April 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

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

WebService URL access from Exteranal services / Desktop
answered 18-06-2018 07:02:56 -0400

I have installed Denodo Express in a Windows Cloud Server . I have created a REST web service and deployed t. I am able to access the web service URL within the Cloud server. Hwoever, I am not able to access it externally from other servers ./ desktop....

Answers: 3

How to Update and Insert Data into Table using source Table in different Environments.
answered 18-06-2018 06:15:22 -0400

Hi Team, Good morning!!!! Good Day!!! I Have a question that I having 3 tables(Table A,Table B and Table C) which or in different Environments so Here I want to Update table B using Table A and I want to Insert into Table C using Table A, simple we ca...

Answers: 1