Size limit of items stored in the TIBCO Spotfire Library

Size limit of items stored in the TIBCO Spotfire Library

Size limit of items stored in the TIBCO Spotfire Library

book

Article ID: KB0070962

calendar_today

Updated On:

Products	Versions
Spotfire Server	All Versions

Description

TIBCO Spotfire does not impose any size limitations on the data stored in the TIBCO Spotfire library, but there are limitations imposed by the database used for the TIBCO Spotfire application database. By default, all library items are stored within the application database and are limited by any database specific limitations.

If a storage limit is reached, you may see an error as described in the following KB article:

KB 000019945: Unable to save analysis file which is more than 2GB in size to Spotfire Library(applicable only while using MS SQL Server as the Spotfire Database).

Issue/Introduction

Size limit of items stored in the TIBCO Spotfire Library.

Resolution

TIBCO Spotfire Server supports the following databases:

Microsoft SQL Server
Oracle
PostgreSQL (from TIBCO Spotfire Server 10.9)

See the System Requirements page for full details: https://docs.tibco.com/pub/spotfire/general/sr/sr/topics/tibco_spotfire_server.html. Additionally, you can also choose to store the actual data of library items outside of the database on the server's file system or on Amazon S3. In this case there are no explicit size limits. The Library item size limits per library location are as follows:

Microsoft SQL Server

Maximum Size: Maximum storage size is 2^31-1 bytes, or 2GB.
Reference: https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

Oracle

Maximum Size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB)
Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28320/limits001.htm

PostgreSQL

Maximum Size: 4TB
Reference: https://www.postgresql.org/docs/14/lo-intro.html

External Library Data Storage

Maximum Size: There are no explicit size limitations, only the disk capacity needs to be considered.
Reference: https://docs.tibco.com/pub/spotfire_server/latest/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/library_content_storage_outside_of_the_spotfire_database.html

Additional Information

TIBCO Spotfire Server System Requirements:

https://docs.tibco.com/pub/spotfire/general/sr/sr/topics/tibco_spotfire_server.html

Microsoft SQL Server:

https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

Oracle

https://docs.oracle.com/cd/B28359_01/server.111/b28320/limits001.htm

PostgreSQL

https://www.postgresql.org/docs/14/lo-intro.html

Doc: Library content storage outside of the Spotfire database

https://docs.tibco.com/pub/spotfire_server/latest/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/library_content_storage_outside_of_the_spotfire_database.html

Feedback

thumb_up Yes

thumb_down No