Q&A

"error accessing the metadata while loading/storing objects"
answered 14-01-2021 14:18:48 -0500

Hi I get this error for any operation performed on the database. - "error accessing the metadata while loading/storing objects" Denodo Platform 6.0 on a Linux VM OS - CentOS Linux release 7.2.1511 (Core) Last week, we were able to create a new view s...

Answers: 2

How to debug a custom handler?
answered 13-01-2021 06:21:56 -0500

I am developing a custom handler to be used for some of our scheduled jobs. Is there a step-by-step tutorial for debuging custom handler code? What I have found so far are for custom extentions of VDP functinalities (functions or stored procedure). Fo...

Answers: 3

Denodo4E

Unable to test OData Url in Postman
answered 13-01-2021 05:04:43 -0500

Hi Team, I've installed Denodo express 8 in my local system which is Windows10 operating system to practice myself. I've created local database tutorial connecting to my Oracle DB. Tested the connection it was successful. When i place the below Odata u...

Answers: 1

"SELECT top 1 1 as ID FROM <base view> uanble to excute
answered 13-01-2021 02:26:45 -0500

We have connected the SAP Database. when we are unable to excute the below query "SELECT top 1 1 as ID FROM &lt;base view&gt; " for the expected result ID 1 what changes can be done as the expected result thanks in Advance

Answers: 1

Top N SAP DENODO SAP BW/4HANA denodo with tableau

The version of Denodo on which window (analytic) function of SQL can be used
answered 12-01-2021 07:09:17 -0500

&lt;Reference&gt; https://community.denodo.com/answers/question/details?questionId=90670000000k9oHAAQ&amp;title=When+will+Denodo+support+analytic+functions+(i.e.+RANK%2C+NTILE%2C+PARTITION+BY....)%3F &lt;Denodo VDP Version&gt; 6.0 Administration tool:...

Answers: 1

DENODO #Analytic function

Unable to establish connection: IO Error: Unknown host specified
answered 11-01-2021 07:41:29 -0500

Hi Experts, Getting the following error while perfroming the test connection in denodo 8 Unable to establish connection: IO Error: Unknown host specified But the same set of connectivity information is working in denodo 7. Please let me know what k...

Answers: 1

unknown host

Continuous Error at Excel Microsoft Query data retrieval from Denodo (6.0) through ODBC connectivity
answered 08-01-2021 05:42:07 -0500

All the time when retrieving data from Denodo (6.0) to Microsoft Excel using Excel Microsoft Query intermediated by ODBC connectivity, I faces next error, and can't retrieve data to Excel from Denodo. &lt;Error Description when retrieving data from De...

Answers: 1

ODBC Excel Microsoft Query DENODO data types

POST Rest Webservice Failling
answered 08-01-2021 04:45:01 -0500

Hi, I am using the sample stored procedureCalculateAvgRevenue . I created a rest webservice. http://localhost:9090/server/tutorial/p_getrev/views/p_getrev POST with X-HTTP-Method-Override GET below request works JSON Request { “$filter”:”taxid_list...

Answers: 1

REST API REST REST Webservice REST Web Service Data Source

Unable to establish connection: The JDBC driver was not found. Check that the driver exists in the class path of the data source.
answered 07-01-2021 13:20:20 -0500

Hi Team, I am getting the below Error while connecting the oracle database. Unable to establish connection: The JDBC driver was not found. Check that the driver exists in the class path of the data source. And le us konw what should we provide in D...

Answers: 2

odata filter on array type
answered 07-01-2021 11:42:08 -0500

Hi, I am trying to use filter for array type column like below http://localhost:9090/server/tutorial/denodo-odata4-service/denodo-odata.svc/?$filter=srvlcdin_list={ ROW('') } Its giving error message as { "error": { "code": null, "message": "A col...

Answers: 2

ODATA OData