Rally - On-premises: Error when uploading new attachment

Products

• CA Agile Central On Premise (Rally)

Issue/Introduction

When attaching a file to a work item, the following error is seen and the file fails to attach:

There was an unknown error when uploading your file.

 

 

Environment

All releases

Cause

This can be caused by the LOB_DATA tablespace filling to max capacity and subsequently not being able to auto-extend.

 

This can be verified through the following steps

2018.1 and lower

Method 1

1. Log into the Control Panel
2. Click Server Diagnostics
3. Click "Download output" from the "Oracle Database free space: (Download output)" section
4. Open the downloaded file
5. Look for the LOB_DATA line
6. If the %Used line is close to 100, the tablespace has likely grown to max

Method 2

1. Log into the Control Panel
2. Click Server Diagnostics
3. Click Log Files
4. Open the downloaded file
5. Open the alm-application.log file
6. Search for the presence of "ORA-01691"
7. If found then this will confirm the tablespace cannot grow further

 

2.0 and higher

SSH into the DB VM as ops

Switch user to root

$ sudo su

 

Switch user to oracle

# su - oracle

 

Load sqlplus

# sqlplus / as sysdba

 

Run the following SQL command

> select file_id, bytes, maxbytes, (bytes/maxbytes)*100 as percent from dba_data_files where tablespace_name = 'LOB_DATA';

 

If the PERCENT column is close to 100 then the file is likely out of space

Resolution

If environment is 2018.1 or lower

1. Log into the appliance as root

 

If environment is 2.0 or higher

1a. Login into the services VM as ops

1b. Switch user to root

# sudo su

 

Continue with the following commands regardless of version

2. Switch user to oracle

# su - oracle

 

3. Run sqlplus as sysdba

# sqlplus / as sysdba

 

4. Find the current sequentially highest tablespace

> select tablespace_name, file_name from dba_data_files where tablespace_name = 'LOB_DATA';

 

Sample output:

TABLESPACE_NAME
------------------------------
FILE_NAME
--------------------------------------------------------------------------------
LOB_DATA
/orahome/data/f4wp1/oradata/lob01_data.dbf

5. After identifying the highest LOB_DATA tablespace, create a new datafile, incrementing the datafile number by one

> alter tablespace LOB_DATA add datafile '<path to datafile>/<datafile name>' size 128M autoextend on next 128m;

 

Example:

> alter tablespace LOB_DATA add datafile '/orahome/data/f4wp1/oradata/lob02_data.dbf' size 128M autoextend on next 128m;

 

6. Exit sqlplus and log out of the oracle session

7. Try uploading an attachment again