Skip to Main Content
Spotfire Ideas Portal
Status To be Reviewed
Categories caching
Created by Guest
Created on Aug 22, 2023

Add primary keys to the cache management table DDL generation in TDV Studio

Customer: Qualcomm

This idea is important for the team as they are using MYSQL data source as the cache target that was enabled for "Group replication" - in this scenario, any insert statements that were being run by TDV for cache refresh which includes updating cache_status, cache_tracking, and cache target tables have been failing.


When "Group replication" is enabled, any table we create or insert into should contain primary keys. Since TDV's DDL was not automatically creating primary keys for the above cache tables.

To work around it, we created these tables manually using the DDL generated by TDV but added one statement defining primary keys.

For the cache_status and cache_tracking tables, we considered (the cache key, server id, and create time) as the primary key.


Qualcomm priority: Medium


  • Attach files