Product: TIBCO Spotfire®
ORA-01653 error seen when attempting to import users or member groups.
Product: TIBCO Spotfire Server Version: All Supported Versions OS: All Supported Operating Systems Spotfire Application Database Type: Oracle -------------------- 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 -------------------------------------------- The import of users and/or groups into Spotfire fails. The following error is seen in the "server.log" (\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. The "ORA-01653 unable to extend table in tablespace" error indicates that there is a table space issue on the tables pace 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 tables pace indicated. Consult with your Oracle DBA to increase/extend the required tablespace as per your requirements. Please refer below links for your reference to increase tablespace: • https://community.oracle.com/thread/2414456?tstart=0