Q&A

The remote license is not found.The server is not registered in solution manager
asked 04-12-2022 07:13:41 -0500

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

Answers: 0

VDP server

SSAS tabular model
asked 03-12-2022 03:04:41 -0500

What about if we use SSAS tabular model in our SSAS development?

Answers: 0
Related to: SSAS as data source

Interpolation variable from powerbi to denodo
answered 02-12-2022 12:27:24 -0500

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

Answers: 1

#interpolationvariable#parameter #powerbi

Summary Table Acceleration is not being Utilized
answered 02-12-2022 07:36:37 -0500

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,...

Answers: 1

summary optimization

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?
answered 02-12-2022 03:26:53 -0500

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

Answers: 1

unable to login denodo path
answered 01-12-2022 20:57:48 -0500

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

Answers: 1

SSL #HTTP Paths

Denodo Scheduler - Deadlock issue in Derby DB
answered 01-12-2022 12:10:18 -0500

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

Answers: 1

deadlock

query timeout after certain input values.
answered 01-12-2022 07:18:07 -0500

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

Answers: 1

query error timeout

I use case when function, I got error message below
answered 01-12-2022 02:22:12 -0500

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

Answers: 1

AWS HIVE JDBI Connection URI

input parameter at run time
answered 30-11-2022 21:12:31 -0500

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

Answers: 3

Parameter runtime parameter