|Applies To||RSA Product Set: Identity Governance & Lifecycle|
RSA Product/Service Type: Enterprise Software
|Issue||The following error is displayed in the log files (including aveksaServer.log, alert_AVDB.log, Workpoint.log) :|
From the application perspective, this can occur in any part of the application, depending on the database operation required.
|Cause||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.|
Technical Notes: 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.
|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 resolution queries below and submit a new support ticket to RSA customer support for analysis.|
Determine the status of TEMP tablespace
The query above might show different segment types (the SEGTYPE column). Most of the time, the SORT segment type is the one we need to check.
However, temp space can also be used by any open cursor in a given session. The SQL query found above may not necessarily be the culprit. if the query above had a null value for the sql_id, get the sid of the row and check it from v$sql using the following:
For each suspected query found from the queries above, run the query below to get the explain plan:
|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.|
Note that due to a database limit of 32 GB per temp file extent, if any of the extents were created or show as "Unlimited" the maximum size is still 32 GB.
To increase TEMP tablespace, add another temp file segment file.
This command may take two to five minutes to complete.