Denodo community Q&A RSS feed https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions Denodo license https://community.denodo.com/answers/question/details?questionId=906Qj00000ESfOLIA1&title=Denodo+license License cores are only applicable to VDP Server,s? If we run the web container in different server will count license core? Tue, 25 Jun 2024 05:18:34 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000ESfOLIA1&title=Denodo+license 2024-06-25T05:18:34Z Killing a long running query via linux server https://community.denodo.com/answers/question/details?questionId=906Qj00000EHisbIAD&title=Killing+a+long+running+query+via+linux+server Hi team, I tried to kill or stop a long running query using query monitor > Stop Query. But it didnt work. Is there any other way we can kill this query? PS: we donot use diagnostic monitoring tool. Fri, 21 Jun 2024 06:52:22 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000EHisbIAD&title=Killing+a+long+running+query+via+linux+server 2024-06-21T06:52:22Z Order to bring down the denodo servers https://community.denodo.com/answers/question/details?questionId=906Qj00000EHifhIAD&title=Order+to+bring+down+the+denodo+servers We use Scheduler, data catalog, vdp tool, design studio, dignostic monitoring tool. Is there any particular order to follow in bringing down these denodo services.? If so please let me know the order along with the script name to bring down the services Fri, 21 Jun 2024 06:49:25 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000EHifhIAD&title=Order+to+bring+down+the+denodo+servers 2024-06-21T06:49:25Z Denodo query with Median errors when all values are null https://community.denodo.com/answers/question/details?questionId=906Qj00000EFMrNIAX&title=Denodo+query+with+Median+errors+when+all+values+are+null Version 8.0 Crafted a query along these lines: select product id, median(qty_sold) from (select product_id, order_id, qty_sold from order_table) Query runs along and produces results, and then errors out with a Java error including the message **Received exception with message "bound must be postive"**. I narrowed down the issue to a particular product, where the qty_sold value for all rows was null. When at least 1 row for given product was not null I got the desired result (which is that the median ignores the nulls and gives me the median of all the non-null values in the tuple). Has anyone seen this issue before? I'm expecting the query to succeed in all cases, and in the special case when all the rows for a tuple contain a value of null, I'd like it to return null as the median for that tuple. All other aggregations work without failing (stddev, var, avg, sum, etc.) Thanks in advance for any thoughts you may have! Thu, 20 Jun 2024 17:10:31 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000EFMrNIAX&title=Denodo+query+with+Median+errors+when+all+values+are+null 2024-06-20T17:10:31Z denodo-graphql-service - Whitelabel Error Page https://community.denodo.com/answers/question/details?questionId=906Qj00000EDc2dIAD&title=denodo-graphql-service+-+Whitelabel+Error+Page Hi I have a user that is administrator on the application. However when calling the graphql services. but getting this error Whitelabel Error Page This application has no explicit mapping for /error, so you are seeing this as a fallback. Thu Jun 20 09:48:02 CAT 2024 There was an unexpected error (type=Unauthorized, status=401). Invalid credentials However, when testing with the admin user then the graphql service works Thu, 20 Jun 2024 07:52:59 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000EDc2dIAD&title=denodo-graphql-service+-+Whitelabel+Error+Page 2024-06-20T07:52:59Z How to connect to Universal Analytics platform via Google Analytics Reporting API v4 https://community.denodo.com/answers/question/details?questionId=906Qj00000E3NZVIA3&title=How+to+connect+to+Universal+Analytics+platform+via+Google+Analytics+Reporting+API+v4 How to connect to Universal Analytics platform (not GA4) from Denodo. Is there any document for reference.? I have gone through the Denodo Templates for Google Analytics - Quick Use Guide 20231109, but this document was refererring to GA4 property ID but not UA ID. Could you please help. Mon, 17 Jun 2024 14:21:49 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000E3NZVIA3&title=How+to+connect+to+Universal+Analytics+platform+via+Google+Analytics+Reporting+API+v4 2024-06-17T14:21:49Z Java classes missing in Denodo 8.0 or the present document needs an update ? https://community.denodo.com/answers/question/details?questionId=906Qj00000DvkHzIAJ&title=Java+classes+missing+in+Denodo+8.0+or+the+present+document+needs+an+update+%3F Hello, We try to connect to Denodo from IBM Web Sphere, using the info from this article. We noticed that these jar's are no longer present in the Denodo Home path: <DENODO_HOME>/lib/contrib/commons-dbcp.jar -->instead we found commons-dbcp2.jar <DENODO_HOME>/lib/contrib/commons-pool.jar --> instead we found commons-pool2.jar Can you help us with updated info on this ? Best regards, Fri, 14 Jun 2024 09:16:06 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000DvkHzIAJ&title=Java+classes+missing+in+Denodo+8.0+or+the+present+document+needs+an+update+%3F 2024-06-14T09:16:06Z "Untrusted domain" issue https://community.denodo.com/answers/question/details?questionId=906Qj00000DoeArIAJ&title=%22Untrusted+domain%22+issue Hi, Facing the "Unable to establish connection: Login failed. The login is from an untrusted domain and cannot be used with Integrated Authentication? with driver 10.x Do I have to intall a 9.x driver ? KR, Laurent Wed, 12 Jun 2024 09:55:58 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000DoeArIAJ&title=%22Untrusted+domain%22+issue 2024-06-12T09:55:58Z Denodo export function in Data Catalog - Personalization https://community.denodo.com/answers/question/details?questionId=906Qj00000Dl6x4IAB&title=Denodo+export+function+in+Data+Catalog+-+Personalization We have a question about the export function in Data Catalog. For privacy reasons, we don't want our Denodo users to have the grants to EXPORT all views in Data Catalog. In the export configuration section in Data Catalog we tuned on the function named "Only allow to export user with role "data_catalog_exporter" in VDP server." For test_user we added the role "data_catalog_exporter" but this means ALL views of test_user can be exported. We only want 1 of his 10 views to have the export grants. Could you please help and find a way to give grants on VIEW level so our Denodo users are not able to export all their views? Tue, 11 Jun 2024 13:43:11 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000Dl6x4IAB&title=Denodo+export+function+in+Data+Catalog+-+Personalization 2024-06-11T13:43:11Z Cache DB selection between SQL server and Netezza https://community.denodo.com/answers/question/details?questionId=906Qj00000DksIrIAJ&title=Cache+DB+selection+between+SQL+server+and+Netezza I want to enable cache, but I am curious to know which one is best for use from SQL Server and Netezza? Can you provide a comparison sheet or you can help me to understand between them as which is one benificial to use? Tue, 11 Jun 2024 10:10:57 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000DksIrIAJ&title=Cache+DB+selection+between+SQL+server+and+Netezza 2024-06-11T10:10:57Z