ORA-01653 error seen when attempting to import users or member groups.

ORA-01653 error seen when attempting to import users or member groups.

book

Article ID: KB0082480

calendar_today

Updated On:

Products Versions
Spotfire Server All Versions

Description

Description:
The import of users and/or groups into Spotfire fails and the following error (or similar) is seen in the "server.log":
-----------------------------------------------
Caused by: java.sql.SQLException: ORA-01653: unable to extend table GROUP_MEMBERS by 64 in tablespace SPOTFIRE_DATA
-----------------------------------------------

The general version of this exception which you might see is:
--------------------------------------------
java.sql.SQLException: ORA-01653: unable to extend table MYTABLENAME by 64 in tablespace MYTABLESPACENAME
--------------------------------------------

Symptoms:
The import of users and/or groups into Spotfire fails. The following error is seen in the "server.log" (<Spotfire Server Installation Directory>\tomcat\logs\).
--------------------------------------------
ws.userdir.UserDirectoryService: Error importing groups
com.spotfire.server.userdir.DirectoryException: Failed to add principal test_user[a71468cd-3c71-4309-9566-f9c898763628] to group Test_Group[e3b726e1-af28-42e4-a8fd-a6c56a9c424c]
...
Caused by: java.sql.SQLException: ORA-01653: unable to extend table GROUP_MEMBERS by 64 in tablespace SPOTFIRE_DATA
--------------------------------------------

A similar "ORA-01653: unable to extend table" error can occur in multiple places while performing any insert operation if there is a tablespace issue on Oracle based Spotfire application database.

Cause:

The "ORA-01653 unable to extend table in tablespace" error indicates that there is a space issue on the tablespace mentioned in error message. The Oracle server has failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.

Issue/Introduction

ORA-01653 error seen when attempting to import users or member groups.

Resolution

You need to increase/extend the required tablespace for your Spotfire Database with the help of your Oracle DBA as per your requirements.

Additional Information

Please refer below links for your reference to increase tablespace:
  • https://community.oracle.com/thread/2414456?tstart=0