Search

Your Notifications (0)

There are currently no notifications. You're all set!

Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Image Artist Spectrus, Percepta, Katalyst, Luminata and more
Downloads
Downloads
Community
Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Spotfire client: Unable to save an analysis file larger than 2GB to the Spotfire Library.

Kisiel, Pawel
  • Updated
Problem:

Unable to save an analysis file which is more than 2GB in size to Spotfire Library.

Applicable only while using MS SQL Server as the Spotfire Database.

 

Symptoms:

The following error is returned in the Spotfire Server logs:

-----------------------------------------------------------------------------
com.spotfire.ws.library.StorageException: com.microsoft.sqlserver.jdbc.SQLServerException: Attempting to grow LOB beyond maximum allowed size of 2147483647 bytes., DATABASE_ERROR

at com.spotfire.ws.library.MSSQLPersisterGeneric.updateContent(MSSQLPersisterGeneric.java:504)
:
        :
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:286)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:206)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Attempting to grow LOB beyond maximum allowed size of 2147483647 bytes.
------------------------------------------------------------------------------


Cause:

Data is stored the database as Varbinary and the maximum size of a varbinary(max) column is 2GB.
This is a MS SQL Server limitation.
 

There is no solution to fix this issue if using Microsoft SQL Server as the Spotfire Database.
There is no such limitation when using Oracle or PostgreSQL as the Spotfire Database.

You can also use the option to save the Library Items to the File System, with this all the Library items will be saved to the File System.

 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/abb92811-6c6c-42a9-b104-393e66ce3c38/attempting-to-grow-lob-beyond-maximum

Related articles

Comments

0 comments

Article is closed for comments.