Time Slicing job failing with ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Products

• Clarity PPM SaaS

Issue/Introduction

Time Slicing job failing with ORA-01652: unable to extend temp segment by 128 in tablespace TEMP. This impacts time slices 

Error found in the bg-ca.logs (See KB: 113183 for details on how to access the bg-ca.logs as a SaaS or On Premise customer):

ERROR 2019-06-19 06:25:01,983 [Dispatch Time Slicing : [email protected])] niku.blobcrack (clarity:zzzzzzz:zzzzzzz:Time Slicing) Exception during blobcrack process

com.niku.union.persistence.PersistenceException:

SQL error code: 1652

Error message: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Environment

Component : CA PPM SAAS TIME SLICING

Cause

This issue is due to the Temp tablespace having no more space available.

Resolution

On Premise customers: This can be resolved by your DBA extending / adding more space to the Temp tablespace.

SaaS Customers: Please contact Broadcom support for assistance.

Additional Information

See the following KB 130257: Troubleshooting Time Slicing Job Failures in Clarity PPM if you are facing any different time slicing failure issues.