Processes erroring with BPM-0526 error in Clarity PPM due to tablespace issue

book

Article ID: 132288

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM On Premise

Issue/Introduction

Processes are erroring in Clarity PPM with the following error:


Error: BPM-0526: Cannot start process. Process is not active or validated. 


In the app-ca.logs or bg-ca.logs, the below error is seen:


Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01654: unable to extend index CMN_SEC_ASSGND_OBJ_PERM_N2 by 8192 in tablespace CLRT_INDX

ORA-06512: at "CMN_SEC_ASSIGN_INST_RIGHT_SP", line 76

ORA-06512: at line 1


Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01654: unable to extend index CMN_SEC_ASSGND_OBJ_PERM_N2 by 8192 in tablespace CLRT_INDX

ORA-06512: at "CMN_SEC_ASSIGN_INST_RIGHT_SP", line 76

ORA-06512: at line 1


Additional symptoms that may be reported include jobs hanging and the number of initiated processes count being very high. Also XOGs may error out referencing the below:


<Severity>FATAL</Severity>

<Description>This record has not been inserted</Description>

<Exception><![CDATA[SQL Exception with error code : 1654]]></Exception>

Environment

Component: ODENV

Resolution

For On Premise customers:
Ask your DBA team to extend the tablespace for CLRT_INDX (provide them with the error code).
Restart the Clarity PPM services may also be needed if errors were generated in Clarity PPM.
 
For On Demand/SaaS  customers:
Raise a ticket with Broadcom On Demand Support