Clarity: After the 15.9.1 upgrade, some scheduled jobs cannot be displayed with an error "ERROR System error. Contact system administrator."

book

Article ID: 211333

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

After the 15.9.1 upgrade, some scheduled jobs cannot be displayed. When opened the scheduled jobs, the following error message will be displayed and the scheduled information is not shown.

"ERROR System error. Contact system administrator."

app-ca.log shows the following error message.

ERROR 2021-03-24 16:27:26,281 [http-nio-8080-exec-16] niku.xql2 (clarity:admin:6046238__92C64D16-A3A7-4A36-A9B1-FCEB222C4A7D:nmc.jobProperties) Internal Processing exception
java.lang.Exception: Failure while evaluating "toDaysOfWeek(@START_DATE,@DAYS_OF_WEEK)" in expression "{toDaysOfWeek(@START_DATE,@DAYS_OF_WEEK)}" error: Invalid expression toDaysOfWeek(@START_DATE,@DAYS_OF_WEEK): For input string: "1-5"

STEPS TO REPRODUCE: 

  1. Go to 'HOME' > 'Reports and Jobs' and open 'Jobs' tab. 
  2. Open a certain job and click the 'Set Recurrence' link.
  3. Click the radio button next to 'Use Unix Crontab entry format' and specify the schedule that contains "-" in the fifth attribute. E.g. " "0 2 * * 1-5".
  4. Specify required fields and click 'Submit' button.
  5. Open the created scheduled job.
    ---> 
    The error message "ERROR System error. Contact system administrator." is displayed and the specified schedule is not displayed. 

Expected Results: 
The scheduled job is displayed with the specified schedule settings.

Actual Results:
All settings are not displayed with the error message.

Cause

This is caused by defect DE60181.

Environment

Release : 15.9.1

Resolution

Currently our product team is working on this to fix it.

Workaround: 

Currently Cron parser in Clarity does not support "-" or "/" as Cron operators. Clarity supports "," as a separator for days of week. Please change your schedule definition from "1-5" to "1,2,3,4,5" in order to schedule the job.

Attachments