Q&A

HAProxy Load balancer error
answered 02-08-2022 09:05:34 -0400

root@denodo-01-sm:/etc/haproxy# sudo systemctl restart haproxy root@denodo-01-sm:/etc/haproxy# systemctl status haproxy ● haproxy.service - HAProxy Load Balancer Loaded: loaded (/lib/systemd/system/haproxy.service; enabled; vendor preset: enabled) Acti...

Answers: 1

load balancer haproxy

Rollback Job Scheduler
answered 29-07-2022 14:28:20 -0400

Hi Team, Assume we have some 5 jobs and all have been set to job dependency of each other. Job 1,2,3,4 are dependency of Job 5. In Job 1 and Job 2 , I do exporting the data to JDBC (SQL server table) . Job 3 is just the extraction and Job 4 is again e...

Answers: 1

Job scheduler Rollback

Denodo scheduler dependencies
answered 29-07-2022 12:10:01 -0400

Hi, We are facing the below problem in setting the dependencies in denodo scheduler. Sequence of job - 1.filecheck job - say JOB1 2.JOB2 3.JOB3 4.JOB4 5.Backup job - say JOB 5 Scenario 1: JOB 1 - dont have any dependencies and it should execute at trig...

Answers: 5

Cache job status related
answered 28-07-2022 13:08:03 -0400

Hi Team, We are doing full cache on final view,which is created using 5 views with join and union but it is getting successfull even after one of the dependend view having connectivity issue.

Answers: 1

Cache

DataSource types
answered 27-07-2022 17:22:51 -0400

Hi, Suppose I have 100's of databases and within the databases I have 1000's of datasources. Now I want to find the datasource types what all I have in all my databases at once orin each database individually. Is there any procedure created or any way...

Answers: 2

datasource type

Case Clause on Max Date
answered 27-07-2022 06:03:43 -0400

I am building a query for the where part of a dervied view to only return data with a load date -1. If load day falls on a Monday, to obtain previous date ignoring weekends, I use the getdayofweek function. bond_pricing_ytm.load_date = (SELECT addday...

Answers: 1

Getting Error on Solution manager URL "Solution manager not started correctly"
answered 26-07-2022 16:10:26 -0400

is there a sequence we need to start Solution manager ? why am i getting this error.

Answers: 1

solutionmanager8 Starting @solnmgr

Disable "Execute and Download"
answered 25-07-2022 18:08:14 -0400

Can I disable the "Execute and Download" feature in Design Studio?

Answers: 1

Denodo Design Studio

Job misfire in denodo schedular
answered 25-07-2022 13:58:12 -0400

What happens excatly after the job gets misfired other than sending the alert? Does the job runs after misfire too or it will run in the next scheduled time? if this is the case then is there any other option to retry the job for misfire too for the sa...

Answers: 1

Select all columns from one table and add another column based on matching value from another table
answered 25-07-2022 07:18:50 -0400

I am trying to join two tables to pull a value e.g. table 1 column a column b column c table 2 column a column d So, I want to pull all columns from table 1 and then, where column a appears in table 2, I want to pull column d How can I implement ...

Answers: 1