Unable to enter negative allocation in periods ('Number must not be negative.')
search cancel

Unable to enter negative allocation in periods ('Number must not be negative.')

book

Article ID: 271937

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Unable to update TSV (Allocation) from Staff tab in project or staffing 

Steps to Reproduce: 

  1. Login to mux and navigate to Project 
  2. Ensure to add Staff module in Project Blueprint
  3. Navigate to staff and create a per period metric
  4. Now on the per period metric add a negative value on the allocation 

Expected Results: Clarity should accept negative allocation values 

Actual Results: Number must not be negative is shown 

Prior to 16.1.x MUX allowed negative values to be entered 

Environment

Release : 16.1.1, 16.1.2, 16.1.3

Resolution

Negative allocations can be enabled by following these steps:

On-Premise Customers:

  • Stop all the Clarity services 
  • Run the below SQL statements 
    • Oracle & PostgreSQL 
      • call CMN_OPTIONS_INS_SP('ALLOW_NEGATIVE_ALLOC','Allow negative allocations','Allow negative allocations',1,1,1);
      • call CMN_OPTION_VALUES_INS_SP('ALLOW_NEGATIVE_ALLOC',null,null,'1',1);
      • call CMN_OPTIONS_INS_SP('ATTR_VALIDATION_OVERRIDES_TEAM','ATTR_VALIDATION_OVERRIDES_TEAM','ATTR_VALIDATION_OVERRIDES_TEAM',1,1,1);
      • call CMN_OPTION_VALUES_INS_SP('ATTR_VALIDATION_OVERRIDES_TEAM',null,null,'prallocdefault.minValue.-99999999',1);
      • call CMN_OPTION_VALUES_INS_SP('ATTR_VALIDATION_OVERRIDES_TEAM',null,null,'prallocsum.minValue.-9999999999',1);
      • call CMN_OPTION_VALUES_INS_SP('ATTR_VALIDATION_OVERRIDES_TEAM',null,null,'hard_sum.minValue.-9999999999',1);
    • MS SQL Server 
      • exec CMN_OPTIONS_INS_SP 'ALLOW_NEGATIVE_ALLOC','Allow negative allocations','Allow negative allocations',1,1,1
      • exec CMN_OPTION_VALUES_INS_SP 'ALLOW_NEGATIVE_ALLOC',null,null,'1',1
      • exec CMN_OPTIONS_INS_SP 'ATTR_VALIDATION_OVERRIDES_TEAM','ATTR_VALIDATION_OVERRIDES_TEAM','ATTR_VALIDATION_OVERRIDES_TEAM',1,1,1
      • call CMN_OPTION_VALUES_INS_SP'ATTR_VALIDATION_OVERRIDES_TEAM',null,null,'prallocdefault.minValue.-99999999',1;
      • call CMN_OPTION_VALUES_INS_SP'ATTR_VALIDATION_OVERRIDES_TEAM',null,null,'prallocsum.minValue.-9999999999',1;
      • call CMN_OPTION_VALUES_INS_SP'ATTR_VALIDATION_OVERRIDES_TEAM',null,null,'hard_sum.minValue.-9999999999',1;

SaaS Customers:

  • Please open a new case with Support.