Latest Activity

code

Error during Environment creation: VCS

Hi, We are getting the follwing error during environment creation: Error creating environment: error creating environment: Wrong Repository State: SAFE can you please let us know the root cause and how can we resolve the issue. Thanks

code

Materialized View

Does Materialized View also get invalidated like cached views once the Time to Live reaches? As Materialized View also stored in Cache. Please help.

code

Full Access Interfaces values are not updated to the help Manual

Denodo Team, Recently, we have a requirement to manage Denodo resources based on how they connect to Denodo (Through Web or Client Tool). We want to restrict users based on the interface. When we searched for Denodo help, we didn't find the required ...

code

How to get datasource connection details through jdbc api

Hi guys i need help regarding how to datasource connection details through jdbc or rest api i am using one query like DESC DATASOURCE <datasourcetype> <datasourcename>; by using this query i am facing problem in another environment like a...

code

getmonthsbetween in denodo truncating decimal

Hi, getmonthsbetween(date1,date2) does not provide equivalent result of oracle's MONTHSBETWEEN function. For ex: if we take date1=24-OCT-2021 and date2=23-OCT-2022 then in oracle the result is 11.93... etc which is accurate but in denodo it is 11 (i.e...

code

Unable to set QueryTimeout in DSN-Less connection

I have established a DSN Less connection from Azure DataFactory to Denodo, however I am unable to set queryTimeout parameter and due to this long running jobs are failing after default timeout i.e. 15mins. Can anyone help me here to understand how can ...

code

Push not working: GIT configuration (VCS)

Hi, We did the first commit referring the steps provided and can see the README.md file in the GIT repository. But we are unable to proceed with the push operation with the following error: Error pushing database admin: https://github.com/xxyzz/Denodo...

code

Refresh token not fetched when connecting to Azure Blob Storage

Hi all, I followed the steps accoring to the Denodo Data sources guide (https://community.denodo.com/kb/view/document/How%20to%20connect%20to%20Azure%20Blob%20Storage%20from%20Denodo) and obtained the OAuth2.0 credentials. Everything worked fine but a...

code

Error executing a query due to memory restriction

I have 12 dervied views, using which I have 1 final view with 12 left joins, when I execute the final view I end getting this following error error analysing the query to decide the necessary memory restrictions based on the query limit specified:null...

code

Sql0206 - column or global variable not found - JDBC TO DB2

i am calling an external procedure on db2 from denodo create view from a query. the call has exact number of parameters as the proc expects. I enter the same value on the execution panel as i entered in ibm i (where it works like a charm) but on denodo...