Size limit of items stored in the TIBCO Spotfire Library.

Size limit of items stored in the TIBCO Spotfire Library.

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

TIBCO Spotfire Server supports two databases:

• Microsoft SQL Server
• Oracle

See the System Requirements page for full details: https://docs.tibco.com/pub/spotfire/general/sr/GUID-D72E1F55-7688-4941-B458-0C1217A84D9A.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://msdn.microsoft.com/en-us/library/ms188362.aspx

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

 

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/7.11.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-9F384681-4B08-4A8B-BBB2-93C0D2CE17E5.html

TIBCO Spotfire Server System Requirements:

• https://docs.tibco.com/pub/spotfire/general/sr/GUID-BBBB8174-55E9-4C53-A80B-D2F6ABA944D3.html

Microsoft SQL Server:

• https://msdn.microsoft.com/en-us/library/ms188362.aspx

Oracle

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

Doc: Library content storage outside of the Spotfire database

• https://docs.tibco.com/pub/spotfire_server/7.11.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-9F384681-4B08-4A8B-BBB2-93C0D2CE17E5.html