KNOWLEDGE BASE

Incorrect Data Displays for Incremental Refreshes When Using a Non-Unique Key With 2023.1


Published: 17 Mar 2023
Last Modified Date: 04 Apr 2023

Issue

When performing an incremental extract refresh using a non-unique key (e.g. date), the job succeeds however the extracted data may be incorrect.

Environment

 
  • Tableau Cloud (between 2/20/2023 and 3/21/23)
  • Tableau Server 2023.1.0, 2023.1.1
  • Tableau Desktop 2023.1.0
  • Tableau Bridge 20231.23.0216.1709
  • Incremental Extract Refreshes

Resolution

All Impacted Products (Cloud, Server, Desktop) 

Tableau Cloud

Follow the steps under the Run a refresh on Tableau Cloud section in our Product Help.

Tableau Bridge

Scenario 1 - Using Tableau Bridge 20231.23.0216.1709 (March 14, 2023 release)

 
  1. If you are using Tableau Bridge 20231.23.0216.1709 (March 14, 2023 release), you need to install Tableau Bridge version 20224.23.0312.0353 (March 28, 2023 release) instead. The 20231.23.0216.1709 version may cause duplicative rows to be added to the incremental extract or missing data. 
  2. Follow the steps under the Run a refresh on Tableau Cloud section in our Product Help

Scenario 2 - Tableau Bridge 20224.23.0209.1653 or earlier

Follow the steps under the Run a refresh on Tableau Cloud section in our Product Help 

Tableau Desktop (version 2023.1.0 only)

Option 1:
Install an earlier version of Tableau Desktop

Option 2: 

Disable the NonUniqueIncrementalKey feature flag by taking the following steps:

Windows:

  1. Open the Windows Registry Editor.
  2. Navigate to Computer -> HKEY_CURRENT_USER -> Software -> Tableau -> Tableau 2023.1
  3. Add a new key named Debug if one does not exist.
  4. Add the string value FeatureOverrideOff to the Debug key
  5. In the Value data field, add feature flag NonUniqueIncrementalKey

Mac:

Open a terminal window

Run:

  • sudo defaults write /Library/Preferences/com.tableau.Tableau-2023.1 Debug.FeatureOverrideOff "NonUniqueIncrementalKey"

If you do not have sudo permission, run the following command

  • defaults write ~/Library/Preferences/com.tableau.Tableau-2023.1 Debug.FeatureOverrideOff "NonUniqueIncrementalKey"

Tableau Server (versions 2023.1.0 and 2023.1.1 only)

Run the below TSM commands to disable the non-unique incremental key feature.

tsm configuration set -k features.NonUniqueIncrementalKey -v false

tsm pending-changes apply

See tsm Command Line Reference for more information.

Cause


This is a Known Issue that is under investigation and being addressed by the Tableau Development team with ID 1505333.

Additional Information

Regarding Non-Unique key, “unique” means the source database must have a uniqueness constraint for the column. If it doesn’t, then the extract may be impacted, regardless of whether every row is unique or not.

The window of time in which incremental refreshes were affected on Tableau Cloud, was from the time that the pod was upgraded to version 2023.1 until 5:45 PM UTC on March 21, 2023. Content affected during this window must use the options from the resolution section to address the issue.

 

POD

2023.1 UPGRADE

eu-west-1a

2/21/2023 10:50 PM UTC - 2/23/2023 12:00 AM UTC

3/1/2023 9:00 PM UTC

10az, us-west-2b, prod-uk-a, prod-ca-a

3/8/2023 12:00 AM

prod-apsoutheast-a, prod-apnortheast-a

3/13/2023 3:00 9M UTC

10ay, us-east-1, dub01, prod-useast-a, prod-useast-b

3/13/2023 11:00 PM UTC

Did this article resolve the issue?