Size limit of items stored in the TIBCO Spotfire Library

Product:TIBCO Spotfire Server
Versions:All Versions

Summary:
Size limit of items stored in the TIBCO Spotfire Library.

Details:
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).

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