IBM Support

ORA-01654: unable to extend index RM

Troubleshooting


Problem

CRJAZ1791E The migration completed with errors. The imported database is unstable and should not be used without further analysis.

Symptom

The RM addTables command shows an error indicating that content could not be saved:
 
2021-05-18 11:30:04,091 CRJAZ1036E The following content could not be saved: StoredContent(_TKamwLf2EeucfP4DwMBl7w, text/plain, 1789, None, HashCode(0x57f00650))

com.ibm.team.repository.common.ContentStorageException: ORA-01654: unable to extend index RM_DB_USER.REPOSITORY_RPSTR_CNTNT_STRG_PK by 128 in tablespace RM

Cause

The error ORA-01654 means that the server failed to allocate the required number of blocks for an index segment in the specified tablespace.

Resolving The Problem

The RM tablespace size needs to be increased. Ensure that the Oracle tablespace is set to auto extend or add more hard disk space to allow for rapid growth of the index.
Option 1) Resize the tablespace data file.
ALTER TABLESPACE RM
DATAFILE 'ORACLE_BASE/oradata/ELMDB/RM.DBF'
RESIZE 2G;

Option 2) Set the tablespace size to increase automatically, if this is not already set. Check that MAXSIZE is available or set as MAXSIZE UNLIMITED.
ALTER TABLESPACE RM
DATAFILE 'ORACLE_BASE/oradata/ELMDB/RM.DBF'
AUTOEXTEND ON NEXT 50M MAXSIZE 2G;
Option 3) Add a data file by using the ALTER TABLESPACE ADD DATAFILE command to the RM tablespace. This will only work if your TABLESPACE is not a BIGFILE type.
ALTER TABLESPACE RM
ADD DATAFILE 'ORACLE_BASE/oradata/ELMDB/RM2.DBF'
SIZE 1G AUTOEXTEND ON NEXT 50M MAXSIZE 2G;
Note: We recommend initially creating the RM tablespace using these default options.
CREATE BIGFILE TABLESPACE RM 
DATAFILE 'ORACLE_BASE/oradata/ELMDB/RM.DBF' 
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

Document Location

Worldwide

[{"Type":"SW","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSUVLZ","label":"IBM Engineering Requirements Management DOORS Next"},"ARM Category":[{"code":"a8m50000000L3D5AAK","label":"DOORS Next"}],"ARM Case Number":"TS005681556","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0.0;7.0.1;7.0.2"}]

Document Information

Modified date:
01 February 2022

UID

ibm16455873