Denodo community Q&A RSS feed Latest Denodo community answered questions Killing a long running query via linux server 2024-06-21T06:52:22Z 2024-06-21T06:52:22Z 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. 2024-06-21T06:52:22Z Order to bring down the denodo servers 2024-06-21T06:49:25Z 2024-06-21T06:49:25Z 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 2024-06-21T06:49:25Z Denodo query with Median errors when all values are null 2024-06-20T17:10:31Z 2024-06-20T17:10:31Z 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! 2024-06-20T17:10:31Z denodo-graphql-service - Whitelabel Error Page 2024-06-20T07:52:59Z 2024-06-20T07:52:59Z 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 2024-06-20T07:52:59Z How to connect to Universal Analytics platform via Google Analytics Reporting API v4 2024-06-17T14:21:49Z 2024-06-17T14:21:49Z 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. 2024-06-17T14:21:49Z Java classes missing in Denodo 8.0 or the present document needs an update ? 2024-06-14T09:16:06Z 2024-06-14T09:16:06Z 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, 2024-06-14T09:16:06Z "Untrusted domain" issue 2024-06-12T09:55:58Z 2024-06-12T09:55:58Z 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 2024-06-12T09:55:58Z Denodo export function in Data Catalog - Personalization 2024-06-11T13:43:11Z 2024-06-11T13:43:11Z 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? 2024-06-11T13:43:11Z Cache DB selection between SQL server and Netezza 2024-06-11T10:10:57Z 2024-06-11T10:10:57Z 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? 2024-06-11T10:10:57Z Denodo essentials 2024-06-10T05:58:04Z 2024-06-10T05:58:04Z Denodo essentials videos are available for cost. Please confirm How to get free videos for an certification 2024-06-10T05:58:04Z