Clarity PPM - Error "ORA-01652: unable to extend temp segment by 128 / 256 in tablespace TEMP"

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The following error message appears in the Clarity logs: 
[Oracle] ORA-01652: unable to extend temp segment by 128 (256, etc) in tablespace TEMP

 

This may happen on any OOTB or custom action in Clarity, Jobs, Processes etc. 

Environment

This can apply to both Clarity and Jaspersoft, and all databases - Clarity, DWH and Jaspersoft.

Oracle Only

Cause

• The root cause for this error message is that the tablespace needs to be extended.
• This is not a Clarity issue, but an Oracle Database issue.
• It may occur on another tablespace used by Clarity and in this case the solution is the same

Resolution

1. Ask your DBA team to extend the Oracle TEMP tablespace, provide them with the error code.
2. Restart the Clarity services if errors were thrown in Clarity screens when browsing

Additional Information

• In some rare cases we find a specific job in Clarity always causing this message, whilst the tablespace amount for TEMP is sufficient.
• This might be caused by an inefficient execution plan.
• Check out with your DBA if they can tune the execution plans/create a new sql profile for the queries taking up TEMP