Q&A

INetCache 1,000,000 Javascript Files
answered 19-03-2021 09:04:36 -0400

Hello, We are currently running denodo on one of our machines and only denodo and it appears that the INetCache has over 1,000,000 javascript files in it and is using up almost over 100 GB of storage. Does denodo need these files or are these safe to ...

Answers: 1

Cache Error ITPilot

To schedule gather sats for view with few among field
answered 19-03-2021 08:59:59 -0400

1.Help me for scheduling a job to Gather stats for few fields in view(only 1 view). I have to schedule a job to gather only one view, view_a,with fields x,y, and z To do this i have to list the views in the csv file,create base view and call select vi...

Answers: 3

Error: maximum number of concurrent queries by group reached
answered 19-03-2021 08:38:20 -0400

We are getting 'maximum number of concurrent queries by group reached' error in VDP admin tool first time and can't find the reason/solution from community. We are getting this error when we try to even open the existing view and all queries are gettin...

Answers: 1

Denodo 7.0 Error

same DV query, but different runtime from VDP and Excel, VDP query add "trace" in the end of query, but excel dose not have "trace" adding to the end of the query
answered 19-03-2021 07:57:42 -0400

we have query something like below: select column_a, column_b, column_c, column_d, column_e, column_f from denodo_view_a where filter_a = 'aaaaa' and filter_b in ('bbbbb', 'ccc', 'ddd') and (filter_c like '4%' or filter_c = '323456789') and (column_a -...

Answers: 1

trace

Oracle Hint in Denodo
answered 18-03-2021 08:34:03 -0400

Hi, Based on this thread: https://community.denodo.com/answers/question/details?questionId=9060g000000L6u8AAC&title=Oracle+hint#:~:text=To%20take%20advantage%20of%20an,the%20context%20of%20your%20environment., in order to leverage on Oracle Hint o...

Answers: 1

Hint oracle hint comment vs hint

Webpage that Automates Oracle SQL to VQL Converter
answered 18-03-2021 08:33:01 -0400

Hi, I have very quick question -- is there an existing page somwhere that helps convert Oracle SQL queries to VQL? The intent is, through that helpful page (if it exists), we could quickly and easily convince our non-IT users to use Denodo derived view...

Answers: 1

Oracle to Denodo Oracle SQL to VQL Converter SQL to VQL

Cannot create oracle as a data source
answered 18-03-2021 07:52:34 -0400

We have managed to setup the Denodo solution manager and we are in the midst of configuring the oracle data source. The connectivity testing is successful but up on saving we are getting an error stating “Error saving datasource: SourceType (…) are l...

Answers: 1

Data Source Setup

Denodo Platform Control Center
answered 18-03-2021 07:49:44 -0400

Under the Virtual Data Port, the Data Catalog section states: "Not available due to license restrictions" It was available before. Under the scheduler section: Scheduler Server - same message - "Not available due to license restriction". Again, it w...

Answers: 3

Vitrual dataport administrator tool platform cannot be logged in
answered 18-03-2021 07:08:59 -0400

The management platform cannot be logged in, and the login prompts an error message. The logs show the following “Caused by: com.denodo.vdb.vdbinterface.common.connection.VDBConnectionException: authentication error: The username or password is incorre...

Answers: 1

administrator tool

insert operation through postman for multiple unique primary keys
answered 18-03-2021 05:18:50 -0400

Hi Team, issue 1: I have tried inserting record through postman for multiple unique primary key index but not able to achieve can you provide solution for that tried below way: col1:3170167-set as primary key at base view level col2:2107403-set as prim...

Answers: 1