"Available Project Tablespace running low" alert at Empower 3 login - WKB83424

SYMPTOMS

• At login for all users message appears: "Available PROJECT Tablespace running low"

ENVIRONMENT

• Empower 3 FR5 and up

CAUSE

The amount of free space within the Oracle database files has dropped below the 80% threshold. This threshold cannot be changed.

FIX or WORKAROUND

1. Add additional data files to the Oracle database using the Waters Database Management Utility.
2. Change the amount of space available by extending the maximum size of the database until MaxSize is 32GB.

ADDITIONAL INFORMATION

Prior to FR5 where this can be performed through the WDM, you used the OEM, the Oracle Enterprise Management console to perform the same function.

You must extend the datafile size (enlarge both bytes and maxbytes). In this case, the Oracle engine updates only bytes and blocks, but not maxbytes and maxblocks in the DBA_DATA_FILES view, which results in bytes and blocks that are much bigger than maxbytes and maxblocks. Empower uses maxbytes and maxblocks as the total available tablespace; that's why this issue happens.

Please refer to Oracle Note 197244.1.

There are few options to fix this:

1. The best option would be for Oracle to fix its issue and update the DBA_DATA_FILES view.

2. Waters usually recommends that you add datafiles instead of manually enlarging them.

3. If the datafile is extended, the DBA should issue the following command:

Alter database datafile 'F:\EMPOWERDATABASE\ORADATA\WAT12\USERS01.DBF' autoextend on maxsize 25000M;

Where F drive is the location of the database files, Users01.dbf thru Users00.dbf are the database files, and maxsize is what the DBA set as the maximum file size. In this case, 25 GB.