System error creating ideas

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Users are receiving a system error when creating any idea in Clarity. This happens in both Classic and MUX

The app-ca.log file records the following error when creating an idea in Classic PPM

ERROR 2025-10-20 00:19:56,465 [http-nio-1631-exec-31] niku.xql2 (clarity:myuser:mysession:pma.ideaCreateSubmit) (d5bf4461-8e0e-4370-8f4d-d88f972e1262) Internal Processing exception
com.niku.union.persistence.PersistenceException: 
SQL error code: 1400
Error message: ORA-01400: cannot insert NULL into ("MYCLARITY"."INV_INVESTMENTS"."ASSGN_POOL")

Below the log error when creating an idea in MUX:

ERROR 2025-10-20 01:27:30,589 [http-nio-1631-exec-41] rest.validation (clarity:myuser:mysession:PPM_REST_API) (6285cb42-a7cc-43c8-b6d9-3bc1bfcb23a1) ExceptionInfo ::  Could not create resource. Resource name: ideas. Error code: internal Error message: System error. Contact system administrator.
ERROR 2025-10-20 01:27:30,590 [http-nio-1631-exec-41] ppm.rest (clarity:myuser:mysession:PPM_REST_API)(6285cb42-a7cc-43c8-b6d9-3bc1bfcb23a1) 
com.ca.ppm.rest.exception.BadRequestException: System error. Contact system administrator.

 

Environment

Clarity 16.3.1 and below

Cause

The Assignment Pool attribute default value is blank at the idea object

Resolution

This has been fixed in Clarity 16.3.2 as part of an internal defect DE165298.

As part of the fix, the attribute has now been marked as required and therefore in Classic the field is visible at the Idea creation page.

The field can not be hidden.