Product: TIBCO Spotfire®
ORA-01653 error seen when attempting to import users or member groups.
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.
You need to increase/extend the required tablespace for your Spotfire Database with the help of your Oracle DBA as per your requirements.
Please refer below links for your reference to increase tablespace:- https://community.oracle.com/thread/2414456?tstart=0
Comments
0 comments
Article is closed for comments.