Denodo community Q&A RSS feedLatest Denodo community answered questionsError saving view: Unexpected error executing operation: Error loading database2024-09-18T10:19:50Z2024-09-18T10:19:50ZI am trying to save a small change to a table 'Customer' in one database. I am getting this error relating to an different database that was deleted.
**> Error saving view: Unexpected error executing operation: Error loading database 'cards'**
Also when I select 'Used By' I get a simular error 'Error loading database 'cards''
Is there a way to rebuild og refrech the dependancies?
regards
Kristinn Thor2024-09-18T10:19:50ZAny way to clear saved server names in VDP admin tool2024-09-17T14:55:02Z2024-09-17T14:55:02ZI am currently running the java version of the VDP Admin Tool on my windows laptop. For each environment I connect to, the name is saved in the drop-down list under VIRTUAL DATAPORT SERVER.
Is there any way to remove or edit an entry in that list. For each new server I must connect to the admin database first.
Now I often click on the server name with "admin" as the database instead of my application DB.2024-09-17T14:55:02ZMissing entries when full joining multiple tables2024-09-16T08:25:01Z2024-09-16T08:25:01ZHi, I'm facing some issue with missing fields.
Background:
I've joined 9 intermediate views (view 1, 2, 3, ... 9) containing 2 fields (a primary key, and a field created with group_concat ('grouped' field)) into 1 derived view 'dv_grouped'.
All the group_concat fields are derived from multiple fields of distinct base views.
So, 9 base view (pkey + multiple fields) > 9 intermediate view (pkey + 1 group_concat field) > 1 derived view (pkey + 9 group_concat fields)
Issue:
There are no issue with missing entries when moving from base view to intermediate view. The issue appears when checking particular pkeys in the derived view.
Any ideas what's causing this?2024-09-16T08:25:01ZAutomating Denodo Tasks on Linux Desktops: Recommended Scripting Languages and Tools2024-09-13T10:08:45Z2024-09-13T10:08:45ZHello Community,
Iâ??m looking to streamline my workflow by automating Denodo tasks on a [Linux desktop](https://www.lenovo.com/us/en/d/linux-laptops-desktops/) environment. Specifically, Iâ??m interested in learning more about the best practices and tools available for scripting Denodo tasks.
Here are a few areas where I could use some guidance:
Scripting Languages: What scripting languages are most effective for automating Denodo tasks? Are there any specific languages that integrate particularly well with Denodoâ??s APIs or command-line interface?
Tools and Libraries: Are there any tools, libraries, or frameworks that you recommend for scripting and automation in this context? For example, are there any open-source tools that can help with task automation or integration with Denodo?
Best Practices: What are some best practices for setting up and managing automation scripts for Denodo on a Linux desktop? Are there common pitfalls or tips that can help ensure smooth operation?
Iâ??d greatly appreciate any insights or experiences you can share. Thank you in advance for your help!
Best regards,
Steve2024-09-13T10:08:45ZBase View and Derive view can be treated as same?2024-09-13T07:16:22Z2024-09-13T07:16:22ZIs there a jdbc url property which does not distinguish base views and derive views?
Because, with bind values for base views it is returning the number of records getting inserted but with derive views it is always returning 1, irrespective of number of records.
is there are property that unify base view and derive views?
i tried publishViewsAsTables=true didnt help.2024-09-13T07:16:22ZText4shell â??CVE-2022-42889â?? KB article2024-09-11T14:39:24Z2024-09-11T14:39:24ZIs there a Knowledge Base article related to the Text4shell â??CVE-2022-42889â??vulnerability that can confirm that this vulnerability is either not a thread or has been resolved by the patch which includes commons-text-1.10.0.jar for the design studio and the scheduler admin?2024-09-11T14:39:24ZHow to insert bit type value(b'10101010') into Boolean in denodo2024-09-11T10:03:04Z2024-09-11T10:03:04ZI have a scenario, where mysql data source has a table with BIT(8) data type.
I have created a view for this mysql table and in denodo BIT type is converted as BOOLEAN by default.
When I am trying to perform INSERT INTO BitTest (bit_col)
VALUES (b'10101010'); in view
i am getting `Syntax error: Exception parsing query near '''
`How we can insert bit values into Boolean type. Can you provide the syntax for the same2024-09-11T10:03:04ZUnable to connect and license key2024-09-11T08:06:59Z2024-09-11T08:06:59ZHow can I get my license key?
And I am unable to connect with my Denondo Tools2024-09-11T08:06:59ZTag search2024-09-10T14:31:21Z2024-09-10T14:31:21ZI am on V8 of Denodo. I have a tag applied to 4 views. In Data Catalog, when I enter that tag in the search bar, it only returns one of the views. Why?2024-09-10T14:31:21ZHow to insert binary value to BLOB type2024-09-10T10:53:05Z2024-09-10T10:53:05ZI have a Mysql table with BINARY AND BLOB types.
Created a Base view via Administration tool, where BINARY AND BLOB types taken as BLOB by default
If I want to perform insert operation with Hexadecimal values (0x68656C6C6F) in to the Binary col and Blob columns , I am getting `Exception parsing query near 'x68656C6C6F'.
`what is the right way to handle this scenario. What is the correct syntax
And How denodo differentiate Binary and BLOB types2024-09-10T10:53:05Z