Monitoring external library storage and fixing inconsistencies

Because there is no guarantee of referential integrity when using external library storage, the administrator should regularly check for inconsistencies between the metadata in the Spotfire database and the files in external storage.

Procedure

On the command line, enter the command check-external-library to check for discrepancies. (For details on using the Spotfire command line, see Executing commands on the command line.)
A discrepancy report is generated, including where discrepancies occur and any available information to help identify the "orphan" files. This is an excerpt from a report:

Discrepancies should be rare, but if they occur, it might be possible to manually fix some or all the discovered issues. If a file is found in external storage that is not referenced in the Spotfire database, you can download the file and examine it further. Note that the file might be compressed with gzip so you need to unzip it before you can examine the content (using a text editor or similar). Some types of library items can be opened directly using the installed Spotfire client (like data (.sbdf) files), whereas a Spotfire analysis file must have the file extension .dxp before you can open it. See Spotfire item types for a list of types that you might encounter and the extension it needs. Other orphan items can contain XML contents which might be useful to recreate, for example, a data source.

If metadata is found in the database for a file that does not exist, you can simply delete the metadata.


If you want to	Do this
Retrieve orphan items from Amazon Web Services (AWS) S3.	Download using the command s3-download.
Retrieve orphan items in AWS, Azure Blob storage, or Google Cloud storage.	Download using the command external-download.
Retrieve an orphan file from an external file system.	Manually copy it from the file system.
Import content to the library.	Use the command import-library-content, or use the installed client to save analysis files or data to the library.
Delete files from AWS, Azure Blob, or Google Cloud storage.	Use the command delete-library-content.
Delete files from an external file system.	Manually delete the files.
Delete metadata from Spotfire Server.	Use the command delete-library-content.