https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions https://community.denodo.com/answers/question/details?questionId=906Qj00000JE12vIAD&title=Error+saving+view%3A+Unexpected+error+executing+operation%3A+Error+loading+database I 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 Thor Wed, 18 Sep 2024 10:19:50 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000JE12vIAD&title=Error+saving+view%3A+Unexpected+error+executing+operation%3A+Error+loading+database 2024-09-18T10:19:50Z https://community.denodo.com/answers/question/details?questionId=906Qj00000JAoyHIAT&title=Denodo+is+converting+Date+format+from+Oracle+to+timestamp Oracle has a date column which only has dates like this 2023-01-01, however when its coming into denodo over a view its automatically called as timestamp and it shows like this which is not really correct(2023-01-01 00:00:00) Now i tried to refresh the Baseview and checked if it gives date/localdate instead of timpestamp but it doesnt work, pleas suggest EDIT 18th Sep: Any updates please? Tue, 17 Sep 2024 15:42:55 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000JAoyHIAT&title=Denodo+is+converting+Date+format+from+Oracle+to+timestamp 2024-09-17T15:42:55Z https://community.denodo.com/answers/question/details?questionId=906Qj00000JA8PfIAL&title=Any+way+to+clear+saved+server+names+in+VDP+admin+tool I 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. Tue, 17 Sep 2024 14:55:02 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000JA8PfIAL&title=Any+way+to+clear+saved+server+names+in+VDP+admin+tool 2024-09-17T14:55:02Z https://community.denodo.com/answers/question/details?questionId=906Qj00000J4lTeIAJ&title=Missing+entries+when+full+joining+multiple+tables Hi, 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? Mon, 16 Sep 2024 08:25:01 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000J4lTeIAJ&title=Missing+entries+when+full+joining+multiple+tables 2024-09-16T08:25:01Z https://community.denodo.com/answers/question/details?questionId=906Qj00000Iy061IAB&title=Automating+Denodo+Tasks+on+Linux+Desktops%3A+Recommended+Scripting+Languages+and+Tools Hello 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, Steve Fri, 13 Sep 2024 10:08:45 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000Iy061IAB&title=Automating+Denodo+Tasks+on+Linux+Desktops%3A+Recommended+Scripting+Languages+and+Tools 2024-09-13T10:08:45Z https://community.denodo.com/answers/question/details?questionId=906Qj00000Ixl5NIAR&title=Base+View+and+Derive+view+can+be+treated+as+same%3F Is 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. Fri, 13 Sep 2024 07:16:22 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000Ixl5NIAR&title=Base+View+and+Derive+view+can+be+treated+as+same%3F 2024-09-13T07:16:22Z https://community.denodo.com/answers/question/details?questionId=906Qj00000IqIuYIAV&title=Text4shell+%C3%A2%E2%82%AC%CB%9CCVE-2022-42889%C3%A2%E2%82%AC%E2%84%A2+KB+article Is 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? Wed, 11 Sep 2024 14:39:24 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IqIuYIAV&title=Text4shell+%C3%A2%E2%82%AC%CB%9CCVE-2022-42889%C3%A2%E2%82%AC%E2%84%A2+KB+article 2024-09-11T14:39:24Z https://community.denodo.com/answers/question/details?questionId=906Qj00000IpKAPIA3&title=How+to+insert+bit+type+value%28b%2710101010%27%29+into+Boolean+in+denodo I 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 same Wed, 11 Sep 2024 10:03:04 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IpKAPIA3&title=How+to+insert+bit+type+value%28b%2710101010%27%29+into+Boolean+in+denodo 2024-09-11T10:03:04Z https://community.denodo.com/answers/question/details?questionId=906Qj00000IpA1NIAV&title=Unable+to+connect+and+license+key How can I get my license key? And I am unable to connect with my Denondo Tools Wed, 11 Sep 2024 08:06:59 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IpA1NIAV&title=Unable+to+connect+and+license+key 2024-09-11T08:06:59Z https://community.denodo.com/answers/question/details?questionId=906Qj00000IlsPCIAZ&title=Tag+search I 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? Tue, 10 Sep 2024 14:31:21 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IlsPCIAZ&title=Tag+search 2024-09-10T14:31:21Z