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

Request header was not found even the pdf exists in recording
answered 02-10-2017 10:34:07 -0400

I successfully save the pdf when recording the sequence. But when I play the sequence, I got this error. It means that the pdf is exists. => ERROR ( The requested header was not found)

Answers: 1
Related to: Downloading a file from a website

Denodo Scheduler Extracted and Processed tuples
answered 28-09-2017 09:04:47 -0400

Hi Team, I have cached a view and refreshig\loading data from one of the job. My view has around 4.5 million records in DB, same number of records are extracted, but processed tuples would be 19k only, I am not sure why its behaving like that...it supp...

Answers: 1

Protocol to connect Denodo Scheduler from a third party
answered 27-09-2017 04:31:29 -0400

Hi Support, We are planning to centralize all the jobs i.e. Windows Task schduler , SQL and Denodo into one. We have planned to use VisualCron for this. Can you help us with the protocol(FTP/SCP/SMTP/POP3/IMAP/SSH/WebDav) to select to connect Denodo Sc...

Answers: 4

DENODO Denodo Scheduler 6.0

Denodo Monitor log
answered 26-09-2017 09:40:38 -0400

Hi Team, It is possible to get a monitor log,VDP-threads.log,VDP-resource.log for the particular date if the log is not available for that date. Thanks

Answers: 1

records limit in derived view in VDP
answered 26-09-2017 09:15:13 -0400

Hi Team, I have a derived in Denodo with many views joins, i have same SQL code. when I run this SQL in oracle its showing 380000 records but when I run the derived view in denodo it not populating all the records ...at least its now showing the number...

Answers: 3

Virtual dataport security exception: dsa signature not available
answered 26-09-2017 07:04:39 -0400

Hi, I am getting below error while staring VDP . 1 [main] ERROR 2017-09-26T12:05:05.601 com.denodo.vdb.catalog.storage.DBDerbyStorageManager - Unable to initialize databasejava.sql.SQLNonTransientConnectionException: Connection refused : Fatal: There...

Answers: 1

Need to find Pipe character in a column value
answered 26-09-2017 01:11:55 -0400

I need to find the Pipe character ( | ) in the column value of a field in a view.This is the SQL I am using for my query, however I am not having luck in the reults: SELECT * FROM "My_View" where instr(my_column,'|') <> 0 Please let me know the ...

Answers: 1

VQL instr function

Number to date format in Case Statment
answered 26-09-2017 00:48:47 -0400

Hi All, I have one case statment as below case when view1.columname='A' then view2.date else v3.days end but here, v3.days is number, this column shows data as 1, 3 , 4,.. like ..so case stament is not working due to compatbility issues. how would we ...

Answers: 1

Denodo view
answered 25-09-2017 09:33:43 -0400

Hi, is there any internal Denodo function to which if we pass a existing Denodo view name, it should give out the views create script ?

Answers: 1

catalog view to list base view along with data source information
answered 25-09-2017 09:31:13 -0400

Hi , is there a way I can list out all the base view from each data source in Denodo ? I am not looking to manually go and check it under data source, I want something like Denodo view CATALOG_ELEMENTS() which does give me Base view name but not the ...

Answers: 1