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.
All releases
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
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
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