Clarity: Process XOG will successfully XOG in a description field of >250 characters even though description fields >250 characters are not allowed in the UI.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Description:

If you XOG in a process with a description field that has more than 250 characters (ours was 259 characters), it will XOG in without an error. You can validate and activate the process. But, if you try to change that process to an On Hold or Draft status, when you click the Save button both the ID field and the description field duplicate the information in the field so it looks like it was entered twice. In addition, you see the error message "Value too large".

For instance if your process id = process_1, after the save it will show up as "process_1process_1". The same thing happens to the description field. If you open a second window to view the process list you will see these changes as well.

Once you close the process and re-open it, those changes are gone.

NOTE: If you create a process via the UI and add more than 250 characters to the description field, it will error out with the same "Value too large" message. So it is not possible to create a process with a description field with more than 250 characters.

STEPS TO REPRODUCE:

1. XOG a process out of Clarity.
   
   
2. Edit the XOG file and change the description field so that it contains more than 250 characters. (We used 259 characters.)
   
   
3. Change the name and ID of the process.
   
   
4. XOG the process back into Clarity.

EXPECTED RESULTS: The XOG should error out and tell the user that the description field is too large.

ACTUAL RESULTS: The process is xogged successfully into Clarity.

Solution:

WORKAROUND:

for 8.1.2 and above, you can XOG the process back in with a shorter description field.

for 8.1.0 or 8.1.1, you will need to run an update query on the database.

update CMN_CAPTIONS_NLS
set description = '<put text here>'
where pk_id = <process ID here>

Note: You will need to modify this query if the description is translated in different languages.

STATUS/RESOLUTION:

This issue has been documented as CLRT-52004 and is assigned to development for review. If you are experiencing this problem and the workaround above does not significantly help, please contact CA Clarity Technical Support.

KEYWORDS: CLARITYKB, CLRT-52004, clarity8open, clarity12open, bpm, process, description, error, value too large, duplicate id, duplicate description.

Environment

Release:
Component: STUDIO