|Applies To||RSA Product Set: Identity Governance & Lifecycle|
RSA Product/Service Type: Appliance
RSA Version/Condition: All
|Issue||The following error is displayed in the log files (including the aveksaServer.log, alert_AVDB.log, and WorkPoint.log) :|
From the application perspective, this error can occur in any part of the application, depending on the database operation required.
|Cause||Temporary tablespaces are used to manage space for database sort operations and or for storing global temporary tables. For example, if you join two large tables and Oracle cannot do the sort in memory, space will be allocated in a temporary tablespace for doing the sort operation.|
This error occurs when the database operation required has failed to allocate an extent file (of the required number of blocks indicated) for a temporary segment in the TEMP tablespace.
|Resolution||If you receive this error, this may indicate a problem with the underlying application packages. To make that determination save the java stack trace from the log file where this error was found, along with the results from the trouble-shooting queries below and submit a new support ticket to RSA Identity Governance & Lifecycle Support for further analysis.|
Determine the status of TEMP tablespace
|Workaround||If the number from the queries above shows that TEMP tablespace is full and/or each segment has reached 32GB, then increase TEMP tablespace size as a workaround. This workaround assumes you have available disk space on your system. Please refer to the following RSA Knowledge Base Articles for more information on disk space usage:|
To increase the size of the TEMP tablespace, add another TEMPFILE to the TEMP tablespace.
On an appliance:
where the 'XX' in 'tempXX.dbf' is the next sequential number available. To see the already existing TEMPFILES: