System error submitting a job with more than 80 characters on its name

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

A job throws a system error when submitted if it contains more than 80 characters on its name

Steps to Reproduce:

1. Go to Administration > Data Administration > Reports and Jobs
2. Create a job with more than 80 characters on its name. 
   Job Name: My custom job contains more than 80 characters on the name and therefore it fails
3. Activate the job. 
4. Go to Home > Personal > Reports and Jobs
5. Locate the custom job
6. Submit the job

Expected Results: The job to run successfully
Actual results: System error. Contact system administrator

Some OOTB job translations contain more than 80 characters.
This is the case of the Spanish translation for the OOT  job: 
Remove Job Logs and Report Library entries
Spanish Translation: Eliminación de entradas de los registros de trabajo y de la biblioteca de informes

When running this OOTB job with a user whose language is Spanish it also fails.

Cause

This is caused by DE63922

Resolution

This is fixed in 16.0.2

Workaround: Decrease the job name on the admin side (Administration > Data Administration > Reports and Jobs) so it gets less than 80 characters

For OOTB jobs and language implications, use the translate option to decrease the name length
Example: Decrease the job name in Spanish 
from: Eliminación de entradas de los registros de trabajo y de la biblioteca de informes
to: Eliminación de entradas de los registros de trabajo y de la biblioteca

Additional Information

Log details:
ERROR 2022-01-26 00:09:43,415 [http-nio-1600-exec-1176] niku.xql2 (clarity:admin:5370086__893EC7A3-9546-4641-B32B-49139AB24F02:nmc.addSchedulerProperties) Internal Processing exception
com.niku.union.persistence.PersistenceException: 
SQL error code: 12899
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "XXX"."CMN_SCH_JOBS"."NAME" (actual: 83, maximum: 80)

Executed:
 INSERT  INTO    CMN_SCH_JOBS
            ( ID, JOB_DEFINITION_ID, NAME, START_DATE,
              END_DATE, SCHEDULE_DATE, MINUTES, HOURS,
              MONTHS, DAYS_OF_MONTH, DAYS_OF_WEEK,
              PRIORITY, STATUS_CODE,
              RECURRENCE_TYPE, OUTPUT_FORMAT,
              CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY
              )
    VALUES  ( ?, ?, ?, ?,
              ?, ?, ?, ?,
              ?, ?, ?,
              ?, ?,
              ?, ?,
              ?, ?, ?, ?)