https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions https://community.denodo.com/answers/question/details?questionId=906Qj00000NfDLtIAN&title=Entity%C3%A2%E2%82%AC%E2%80%9Cattribute%C3%A2%E2%82%AC%E2%80%9Cvalue+%28EAV%29+datasource I have JSON-over-HTTP datasource with EAV (Entity-attribute-value) model inside, like this one: https://pastebin.com/raw/XhHgR0VM ``` [ { "id": "cb879cb8-a310-11ef-ba83-bab0678cb5af", "number": "000000000001", "date": "2024-09-10T21:34:55", "template": "96fd7bb1-9bf8-11ef-ba83-bab0678cb5af", "author": "Admin", "fields": [ { "fieldName": "date", "fieldDescription": "", "fieldType": "date", "fieldValue": "2024-09-10T21:34:55" }, { "fieldName": "sex", "fieldDescription": "", "fieldType": "reference", "fieldValue": "Male" }, { "fieldName": "amount", "fieldDescription": "", "fieldType": "number", "fieldValue": "5" }, { "fieldName": "diagnosis", "fieldDescription": "", "fieldType": "reference", "fieldValue": "Dystrophy" }, { "fieldName": "house", "fieldDescription": "", "fieldType": "reference", "fieldValue": "RM-1-2" } ] } ] ``` I want to represent it like a table, like this: ``` date | sex | amount | diagnosis | etc 2024-09-10T21:34:55 | Male | 5 | Dystrophy | ... ``` What is the proper way to get it? Tue, 26 Nov 2024 12:49:29 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000NfDLtIAN&title=Entity%C3%A2%E2%82%AC%E2%80%9Cattribute%C3%A2%E2%82%AC%E2%80%9Cvalue+%28EAV%29+datasource 2024-11-26T12:49:29Z https://community.denodo.com/answers/question/details?questionId=906Qj00000NYyChIAL&title=http%3A%2F%2FXXXX%3A8081%2Fmetrics+not+working Hi team, after configured by steps above, i have error message while start denodo. "Starting Denodo Virtual DataPort Server ... (press ENTER in case shell prompt was not automatically returned) Could not load Logmanager "org.apache.logging.log4j.jul.LogManager" java.lang.ClassNotFoundException: org.apache.logging.log4j.jul.LogManager at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:471)" port 8081 & other ports are up and denodo working fine. but http://XXXX:8081/metrics not able to visit. could you advise? Mon, 25 Nov 2024 08:57:12 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000NYyChIAL&title=http%3A%2F%2FXXXX%3A8081%2Fmetrics+not+working 2024-11-25T08:57:12Z https://community.denodo.com/answers/question/details?questionId=906Qj00000NKa3kIAD&title=Template+for+Element+Descriptions Is there a way to set up a template in the Description field that ensures all descriptions follow the same format? Thu, 21 Nov 2024 18:03:21 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000NKa3kIAD&title=Template+for+Element+Descriptions 2024-11-21T18:03:21Z https://community.denodo.com/answers/question/details?questionId=906Qj00000NJHPjIAP&title=GET+PUBLIC+COLUMN+DEPENDENCIES Hello We are currently using the predefined stored procedure `GET_PUBLIC_VIEW_DEPENDENCIES` to get the direct dependencies between the public views only. We want to do the same for the COLUMNS, but there is no predefined stored procedure for the public columns dependencies. The only available is `COLUMN_DEPENDENCIES` stored procedure which return private views. Hence, Is there a stored procedure to do that? Or how to elemenate the dependency on the private views so that all the direct dependencies are public views? Thu, 21 Nov 2024 12:28:30 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000NJHPjIAP&title=GET+PUBLIC+COLUMN+DEPENDENCIES 2024-11-21T12:28:30Z https://community.denodo.com/answers/question/details?questionId=906Qj00000NIGDxIAP&title=get+server+host+using+vsql Hello, how to query using VSQL server host where Denono is running? In Oracle we can use the query SELECT SYS_CONTEXT ('USERENV', 'SERVER_HOST') FROM DUAL; Thanks Thu, 21 Nov 2024 05:47:56 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000NIGDxIAP&title=get+server+host+using+vsql 2024-11-21T05:47:56Z https://community.denodo.com/answers/question/details?questionId=906Qj00000MzohdIAB&title=XML+DATASOURCE+-+log+stream+output Hi, I'm trying to create a soap web service and I'm using XML formatted in the test environment but everytime that I execute the datasource I got the following error "Unable to establish connection: Error retrieving data from 'https://xxxxxxxxxxxxxx'. HTTP error code: 403." If I checked the log says "Stream Output"... any idea how to solve this issue ? Thankfully, Olga Mon, 18 Nov 2024 09:34:07 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000MzohdIAB&title=XML+DATASOURCE+-+log+stream+output 2024-11-18T09:34:07Z https://community.denodo.com/answers/question/details?questionId=906Qj00000MiAQRIA3&title=Denodo+Express+-+error+during+create_remote_table+trying+to+copy+a+table+from+a+snowflake+data+source+to+a+postgres+data+source Denodo Express 9.0 connected to the following southbound data sources - 1. Snowflake 2. Postgres 3. MySQL 4. SQLite3 Able to copy a table from the MySQL data source to the Postgres data source using create_remote_table() without any issues. But when attempting the same from Snowflake; basically from the Snowflake data source to the same Postgres data source, the following error is encountered - ERROR: java.sql.SQLException: Error executing query. Total time 7.03 seconds. QUERY [SELECTION] [ERROR] CREATE_REMOTE_TABLE [STORED_PROCEDURE] [ERROR] CREATE_REMOTE_TABLE [STORED PROCEDURE] [ERROR] Received exception with message 'Error executing VQL query. QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] [ERROR] QUERY [JDBC ROUTE] [ERROR] Received exception with message 'Cannot invoke "com.denodo.vdb.engine.thread.IWorker.stop(int)" because "this.worker" is null'' I know Denodo Express has some license-restricted limitations and thought maybe this was one of them but given the MySQL/Postgres create_remote_table() success I'm thinking it is likely something else but that error message is challenging. Java version (Express): version=17.0.12 Snowflake driver in Express: version=3.14.3 Postgres driver in Express: version=42.7.2 Queries against the Snowflake data source in Express work smoothly both through VQL Shell and Design Studio as well as with JDBC clients connected to Express. Same for the Postgres data source. Any thoughts as to what is going on? Thu, 14 Nov 2024 05:42:44 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000MiAQRIA3&title=Denodo+Express+-+error+during+create_remote_table+trying+to+copy+a+table+from+a+snowflake+data+source+to+a+postgres+data+source 2024-11-14T05:42:44Z https://community.denodo.com/answers/question/details?questionId=906Qj00000Mdn4FIAR&title=Different+Identifier+charset+settings+between+Dev+and+Test%2FProd+environments+causing+query+issues Our Denodo DEV identifier charset is set to Unicode. Our Denodo TEST\PROD are both set to Restricted. We use Denodo VCS for our promotion strategy. DEV views when promoted to TEST\PROD retain their Unicode query behavior (meaning to successfully query the field names must be in double quotes and are case sensitive) as opposed to adopting that of the host which is set to Restricted. I have found that if I edit the promoted view(s) in TEST\PROD and resave them, then and only then do they adopt the charset of the host which in this case happens to be Restricted. I have validated identifier charset settings at both the server and the vdb levels for each environment to ensure this is not playing a role. Wed, 13 Nov 2024 15:44:27 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000Mdn4FIAR&title=Different+Identifier+charset+settings+between+Dev+and+Test%2FProd+environments+causing+query+issues 2024-11-13T15:44:27Z https://community.denodo.com/answers/question/details?questionId=906Qj00000MWozbIAD&title=Code+Structure denodo. i am designing nicely structured and formatted code. when i open the code again it is all in just one line. how can i resolve this issue Tue, 12 Nov 2024 11:55:32 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000MWozbIAD&title=Code+Structure 2024-11-12T11:55:32Z https://community.denodo.com/answers/question/details?questionId=906Qj00000MTnLfIAL&title=Split+function+in+Derived+View Hello! I have created a derived view in which, for one of the field, I have a requirement to strip a part of the string. That is, I have a string "domain_name\first_name" in one of the fields and am trying to create a new field by taking only the first_name and append "@gmail.com" at the end. The new column would look like 'first_name@gmail.com'. I tried using SPLIT function to split the string using "\", but that gives me an array and am not able to take just one element in the array. Is there a better way of doing it? Mon, 11 Nov 2024 21:16:59 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000MTnLfIAL&title=Split+function+in+Derived+View 2024-11-11T21:16:59Z