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).
Article ID: KB0075064
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All Versions |
Description
Symptoms:
:
:
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:
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 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 in MS SQL as Varbinary and the maximum size of a varbinary(max) column is 2GB. This is a MS SQL Server limitation.
Issue/Introduction
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).
Environment
MS SQL Server database
Resolution
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.
Refer to the document available at:
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.
Refer to the document available at:
https://docs.tibco.com/pub/spotfire/general/sr/GUID-30D80764-3C7B-4ECF-A61A-15920A718FFA.html . Look for "Microsoft SQL Server-specific notes" on this page.
Additional Information
Feedback
Yes
No
Powered by
