search cancel

When xogging in Role with Role name that exceeds 32 characters it is throwing an error but UI allows it.


Article ID: 38316


Updated On:


Clarity PPM On Premise



When Xogging in Role with the name exceeding 32 characters you get an error.

Steps to Reproduce:

  1. Login to CA PPM as Admin 
  2. Create Role-Labor and provide role name that exceeds 32 characters in length  
  3. XOG out the role by using roles_read.xml  
  4. Try to XOG that same Role with different ID and observe an error message in the output file  



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

        <Exception><![CDATA['Last Name' is too large. Maximum size is 32.]]></Exception> 


Expected Result: XOG should allow you to enter a Role name that exceeds 32 characters, as the UI allows it.
Actual Result: XOG does not allow you to enter a role with role name that exceeds 32 characters.


Caused by CLRT-79787


Release: ESPCLA99000-14.3-Clarity-Extended Support Plus


This is fixed in 15.2

Additional Information

As per the defect resolution, the following was implemented:

Truncate the last_name/first_name value at 32 characters when adding a role or non-labor resource via XOG or UI. The ui displays the full_name which can accept up to 100 characters and the code was taking this same value and attempting to put it in the last_name/first_name fields. The UI didn't validate so this worked, generally, since the database allows 96 characters (32 * 3 to account for multi-byte charsets). XOG did validate so it failed. Change will allow a long name to be used but truncate the values stored in the (unused) last_name\first_name