Latest Activity

code

The remote license is not found.The server is not registered in solution manager

I'm in the process of automating vdp and Solution manager installation process.The Solution manager is installed and services are up .While installing VDP I'm copying the Solution manager license file to <DENODO_HOME>/conf/ location in VDP server...

code

Interpolation variable from powerbi to denodo

I have a denodo view that has 3 date columns (sale_date,start_date,end_date). I created two view parameters startdate_p,enddate_p and where clause sale_date > startdate_p and sale_date < enddate_p. I see that these two parameters are being pul...

code

Summary Table Acceleration is not being Utilized

We are facing a senario where Summary Table Acceleration is not being considered as best plan for execution. We have followed the exact steps available in the Denodo Guide where we are creating a summary table on agreegated transformation. First case,...

code

I want to copy column value of above row to below rows (which have value 0) until a greater value is found in the same table. How this can be achieved?

I want to copy column value of above row to below rows (which have value 0) until a greater value is found in the same table. How this can be achieved? date duration26-oct 2 27-oct 0 28-oct 0 29-oct 4 expected reuslt date duration26-oct 2 27-oct 2 28...

code

unable to login denodo path

Hi team, Unable to login Denodo path. showing as below error Request to please help. error during JRMP connection establishment;nested exception is:javax.net.ssl.SSLHandshakeException:sun.security.validator.ValidatorException:PKIX path validation fa...

code

Denodo Scheduler - Deadlock issue in Derby DB

Saw Denodo Scheduler Job failure because of the locking issue. Any workaround or Denod updates available to address this issue? Error: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, SCHED_ELEMENTS, (253,8) W...

code

query timeout after certain input values.

Hi , I have a 3 way joined view - 1 impala source , 2 azure sources , which is supposed to accept input parameters at runtime , if i enter input values more than 30 , it starts giving me this query timeout error message . [JDBC ROUTE] [CONNECTION_ERRO...

code

I use case when function, I got error message below

I am tring to create a new column using: case when MAR_ADDL_INFO.LINE = 1 then MAR_ADDL_INFO.ERX_ID else null end then I got error maessage: com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: The following...

code

input parameter at run time

Hi , I want one input parameter field to be provided at the run time of a base view . I'm using this query in create from base view option in data source tab. select * from edl_cs_space_plan_analysis.v_lab_building_floor_space_org_alllocation where spa...

code

interpolation variables

Hi team can someone please help me for how to take input parameter values in base views?