Q&A

Add Column Description doesn't work with UNION when appending record
asked 27-05-2022 19:33:54 -0400

I am trying to append a specific record to a derived view with UNION. The view can be created without DESCRIPTION. But when I do CREATE OR REPLACE VIEW xxx DESCRIPTION = ‘xxx’ (columnname (DESCRIPTION = ‘xxx’)), it will give me an error saying the firl...

Answers: 0

COLUMN_DESCRIPTION UNION

Add Column Description doesn't work with UNION
asked 27-05-2022 19:29:47 -0400

I am trying to append a specific record to a derived view with UNION. The view can be created without DESCRIPTION. But when I do CREATE OR REPLACE VIEW xxx DESCRIPTION = 'xxx' (columnname (DESCRIPTION = 'xxx')), it will give me an error saying the firl...

Answers: 0

COLUMN_DESCRIPTION UNION

Has anyone had success integrated a VCS like GIT and Azure Devops and performning DevOps like deployment practices? Ideally, i would be able to initiation a build and release using git and deploy without any user interaction.
answered 27-05-2022 09:15:55 -0400

Hi Team, I would like load latest VQL file from git and want to automate the deployment with denodo is it possible?is any plugin identified for the same. or i want to create vql file and deploy same in to different env like dev,qa, prod how we can a...

Answers: 1

Devops

[JDBC ROUTE] [CONNECTION_ERROR] Unexpected error creating a connection
answered 27-05-2022 09:09:34 -0400

Finished with error: Error executing query. Total time 0.422 seconds.QUERY [PROJECTION] [ERROR] AR_10_ASSETCLASSDESCRIPTIONS [BASE] [ERROR] AR_10_ASSETCLASSDESCRIPTIONS [ODBC WRAPPER] [ERROR] AR_10_ASSETCLASSDESCRIPTIONS#0 [JDBC ROUTE] [CONNECTION_ERRO...

Answers: 1

Denodo Monitor Error: Non-JRMP server at remote endpoint
answered 26-05-2022 12:23:09 -0400

Denodo Version: v20220126 After configuring the ConfigurationParameters.properties file with the relevant credentials and host:port details, the Denodo Monitor throws a ConnectionIOException - non-JRMP server at the remote endpoint. My initial hunch ...

Answers: 1

non-JRMP server at remote endpoint Denodo Monitor

Azure Automated Cloud Denodo 8.0 Installation Error
answered 26-05-2022 08:19:55 -0400

Hi Team, After Configuring and installing Denodo 8.0 in Azure Automated Cloud Mode I am getting below error. "Cluster marked as error because it was longer than expected in AWAITING_SERVICES" I am able to access all VDP, DataCatalog and Scheduler Serv...

Answers: 1

Azure Automated Cloud Cluster Error

How to renewal certificate of specific servers in version 8
answered 25-05-2022 16:53:13 -0400

Our license to this server (sjgdvapppocn02) is going to expire in 20 days, Please provide the steps to renewal

Answers: 1

QueryTimeout on DB2 Datasource Level
answered 25-05-2022 16:06:18 -0400

I would like to setup the querytimeout on DB2 datasource connection string. I don't want to do it on server level. The below example for sqlserver , which is working jdbc:sqlserver://34.75.137.211:41200;databaseName=iqzdemo;queryTimeout=0; But for...

Answers: 1

JDBC query QueryTimeout

Denodo 8 Admin tool update issue
answered 25-05-2022 12:37:27 -0400

I downloaded denodo-v80-update- 20220126 from below link. https://support.denodo.com/resources/update/details/3086 . Followed below steps Launch the Denodo Platform Control Center by running the command <DENODO HOME>bin\denodo_platform.bat Choose...

Answers: 1

update

Parameterizing GET_STATS_FOR_FIELDS Scheduler job to automatically refresh the stats for all enabled views.
answered 25-05-2022 09:30:57 -0400

Hey, we are trying to use GETSTATSFORFIELDS in a Scheduler job to automatically refresh the stats for all views with statistics enabled. With LIST VIEWSTATSUMMARIES on myVdb I can get a list of all the views in the VDB, that have statistics enabled. N...

Answers: 1

Gather Statistics Denodo Scheduler 8.0