Unable to save an analysis file in the Spotfire Library(applicable only while using Oracle as the Spotfire Database).

Unable to save an analysis file in the Spotfire Library(applicable only while using Oracle as the Spotfire Database).

book

Article ID: KB0070061

calendar_today

Updated On:

Products Versions
Spotfire Server All Supported Versions

Description

If the user attempts to save an analysis file in the Spotfire library, it fails with the following error:
=========== 

"Error message: Could not publish <analysis file name>.
LibraryException at Spotfire.Dxp.Framework:
An Internal Server Error has occurred. (HRESULT: 80131500)"
===========


In the server.log file from the troubleshooting bundle, the following error stack trace is found:
=========== 
ERROR  [*library-save-job-<id>, <username and domain>, , ] ws.library.LibraryService: An exception occurred in method 'Save'.
com.spotfire.ws.library.StorageException: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

https://docs.oracle.com/error-help/db/ora-30036/, IO_ERROR
    at com.spotfire.ws.library.OraclePersisterGeneric.insertBlob(OraclePersisterGeneric.java:326) ~[spotfire-server.jar:?]
    at com.spotfire.ws.library.OraclePersisterGeneric.insertContent(OraclePersisterGeneric.java:276) ~[spotfire-server.jar:?]
    at com.spotfire.ws.library.LibraryManagerImpl.saveItem(LibraryManagerImpl.java:2416) ~[spotfire-server.jar:?]
    at com.spotfire.ws.library.LibraryManagerImpl.saveItem(LibraryManagerImpl.java:2278) ~[spotfire-server.jar:?]
    at com.spotfire.ws.library.LibraryService.doSave(LibraryService.java:1154) ~[spotfire-server.jar:?]
    at com.spotfire.ws.library.LibraryService.lambda$beginSaveItem$5(LibraryService.java:807) ~[spotfire-server.jar:?]
    at com.spotfire.ws.library.LibraryService.lambda$startJob$6(LibraryService.java:841) ~[spotfire-server.jar:?]
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) ~[?:?]
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
    at java.base/java.lang.Thread.run(Thread.java:840) [?:?]
Caused by: java.io.IOException: ORA-30036: unable to extend segment by 8 in undo tablespace '<tablespace name>'
===========

Environment

Oracle database

Resolution

The “ORA-30036: unable to extend segment by 8 in undo tablespace” error message in Oracle databases indicates that the undo tablespace has run out of space and can’t be extended to accommodate the additional undo data that needs to be generated.

This error is being generated from the Oracle database and is not coming directly from the Spotfire server.

Issue/Introduction

This article will explain the reason for not being able to save an analysis file in the Spotfire Library(applicable only while using Oracle as the Spotfire Database).

Additional Information

For more details, check the information shared in this article:
https://expertoracle.com/2020/01/03/ora-30036-unable-to-extend-segment-by-8-in-undo-tablespace-2/
 
Powered by Wolken Software