Opening a file with linked data in TIBCO Spotfire shows several 'Loading embedded data' messages that slow down the opening of the file.

Opening a file with linked data in TIBCO Spotfire shows several 'Loading embedded data' messages that slow down the opening of the file.

book

Article ID: KB0072472

calendar_today

Updated On:

Products Versions
Spotfire Analyst All

Description

Description:
When opening a file that uses linked data and you use calculated columns you may see something similar to this in the Open file dialogue after clicking 'Show Details':

11:48:08 Loading item from Library.
11:48:34 Loading document.
11:48:39 Unpacking compressed data.
11:48:44 Handling compatibility.
11:48:46 Loading embedded data.
11:48:47 Loading embedded data.
11:49:14 Unpacking compressed data.
11:49:20 Opening connection to database...
11:49:22 Reading data from data source...
11:49:22 Reading data.
11:49:44 Configuring document.
11:49:45 Opening connection to database...
11:49:45 Reading data from data source...
11:49:45 Reading data.
11:49:54 Configuring document.
11:50:26 Calculating column.
11:50:27 Calculating column.
11:50:34 Calculating column.
11:50:34 Configuring document.
11:50:35 Compressing data.
11:50:36 Compressing data.
11:50:37 Configuring document.
11:50:37 Done

Even though you have saved the file using linked data you see 'Loading embedded data.' when opening the file

Symptoms:
Files with linked data may open slower than normal and you see multiple 'Loading embedded data.' messages in the File open dialogue.

Cause:
Data that is loaded into the analysis when saving will automatically be embedded in the file if you have calculated columns, even though you choose to use linked data.

Resolution

There is a preference - CacheCalculatedColumnsDefaultBehavior - that can be used to disable embedding data when doing calculations.  

1. Go to Tools menu->Administration Manager->Preferences

2. Select the group you want to apply this for and chose Application->Persistence and set CacheCalculatedColumnsDefaultBehavior to 'False'.

Note: Only Spotfire Administrators (i.e. users with both the TIBCO Spotfire Administrator license and membership in the Administrator group) can do this. 

Issue/Introduction

Opening a file with linked data in TIBCO Spotfire client shows several 'Loading embedded data' messages that slow down the opening of the file.