Error ORA-12899 Running Scheduled Job

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

While trying to schedule a job, the following error appears:
System Error. Contact System Administrator

APP log shows:

ERROR 2023-07-17 11:52:07,901 [http-nio-8181-exec-10] niku.xql2 (clarity:user:session: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 "CLARITY"."CMN_SCH_JOBS"."NAME" (actual: 81, 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  ( ?, ?, ?, ?,

              ?, ?, ?, ?,

              ?, ?, ?,

              ?, ?,

              ?, ?,

              ?, ?, ?, ?)

Derived from statement:

<?xml version="1.0" encoding="UTF-8"?>

Using input:

{end_date=2023-08-11T16:00:00, hours=16, months=, status_code=NOT_SCHEDULED, minutes=00, days_of_month=, priority=1, days_of_week=, rightName=JobCreatorAuto, job_definition_id=5000646, output_format=, job_id=8458340, execute::batch=false, parameterSet=[], name=[Enter a string that is longer than 80 characters], recurrence_type=0, visitor=com.niku.xql2.XQLVisitor@2c612d46, parameters=[null:job_id:8458340:, null:job_definition_id:5000646:, null:name:Timesheet Notification for Resource Managers August week 1 (8/7/2023 - 8/13/2023):, null:start_date:2023-08-11T16:00:00:, null:end_date:2023-08-11T16:00:00:, null:minutes:00:, null:hours:16:, null:months::, null:days_of_month::, null:days_of_week::, null:recurrence_type:0:, null:status_code:NOT_SCHEDULED:, null:priority:1:, null:output_format::, null:rightName:JobCreatorAuto:], value=nmc.insertJobProperties, start_date=2023-08-11T16:00:00}

 

Environment

Release : 16.0.3

Resolution

Limit the user-defined job name to be less than or equal to 80 characters.