Unable to update object in MUX with ORA-01428 on custom attribute

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

You are unable to update one specific instance of a CIT. Error is thrown in MUX: System Error - Contact System Administrator

The error in logs is:

ORA-01428: argument '-17' is out of range

Note: This may happen on other screens / objects in MUX 

Environment

All Supported Clarity Releases

Resolution

• This is a data issue. In logs we are able to see a custom calculated attribute dynamic lookup is failing
  • ORA-01428: argument '-17' is Oracle's domain error for POWER(m, n) when m is negative and n is not an integer.
• We suggest correcting the attribute query to fix the problem