Performance issue when executing data functions against TIBCO Spotfire Statistics Services server due to many old *.SBDF files present inside data\artifacts\spotfire folder.

Performance issue when executing data functions against TIBCO Spotfire Statistics Services server due to many old *.SBDF files present inside data\artifacts\spotfire folder.

book

Article ID: KB0083306

calendar_today

Updated On:

Products Versions
Spotfire Statistics Services All Versions
Spotfire Web Player 7.6 and lower
Spotfire Desktop 7.6 and lower

Description

There may be performance issues when executing data functions in the installed client or Web Player against a TIBCO Spotfire Statistics Services (TSSS) server. In this case, there are many old files present in the <TSSS-Install directory>\data\artifacts\spotfire folder.

Issue/Introduction

This article describes how to fix a performance issue when executing data functions in the installed client or Web Player against a TIBCO Spotfire Statistics Services server due to many old *.SBDF files present in the data\artifacts\spotfire folder.

Resolution

This issue can be caused by many old *.SBDF files present in the \data\artifacts\spotfire folder on TSSS installation which take a significant amount of disk space.
  • <TSSS-Install directory>\data\artifacts\spotfire
The artifacts folder stores the intermediate SBDF files that are needed for the Spotfire and Statistics Services interaction when a Data Function is run in Spotfire. These files are normally automatically cleaned up when a job has completed its execution., but there may be special circumstances like a job crash which will prevent that cleanup, keeping such files permanently and causing disk space to increase and performance to downgrade over the time.

1). On Spotfire 7.6 or earlier versions:  

 It is safe to delete left over files from the \data\artifacts\spotfire folder from TIBCO Spotfire Statistics Services installation directory.

Follow the steps below.
 
  1. Stop the TSSS service.
  2. Take backup of \data\artifacts folder from <TSSS-Install directory> .
  3. Delete all files from \data\artifacts\spotfire .
  4. Start the TSSS service.

2). Use client version TIBCO Spotfire 7.7 or higher
The clean up process has been improved in the installed client and Web Player version 7.7 and higher which prevents this issue from occurring.