KNOWLEDGE BASE

"Error computing capabilities of GROUP BY view java.sql.SQLException" When Using Live Denodo Connection and LOD Calculated Field


Published: 03 May 2019
Last Modified Date: 23 Sep 2019

Issue

When connecting live to Denodo and using a calculated field which references another calculated field containing an LOD with a 4-byte Integer as the dimension declaration, the error "Error computing capabilities of GROUP BY view java.sql.SQLException" occurs.

Note: To verify whether or not the dimension is a 4-byte Integer-type field, right-click the field and select "Describe". The field type is described under "Remote Type".

Environment

  • Tableau Desktop
  • Denodo

Resolution

To avoid this behavior, use one of the following options:


Option 1: Upgrade to Tableau Desktop 2019.3 or later.

Click here for downloads of current and previous versions of Tableau Desktop: Tableau Desktop Downloads and Release Notes.  For more information on current releases, see Upgrade Tableau Desktop and Desktop Upgrade.

Option 2: Wrap the Dimension Declaration in an INT() function.

  1. Open the calculated field which contains the LOD (Level of Detail).
  2. Wrap the dimension declaration in an INT() function as follows:
{Fixed [<integer field>] : SUM([field])} becomes {Fixed INT([<integer field>]) : SUM([field])}

Option 3: Change the field from a 4-byte Integer to another field type.

  1. Right-click the field in question and navigate to "Change Data Type".
  2. Select an alternative field type, such as "Number (Decimal)" or "String".

Option 4: Use an Extract.

Instead of maintaining a live connection to the Denodo datasource, consider using an extract.

Cause

This is a known issue, and currently under investigation by our Development team (ID 904582).
Did this article resolve the issue?