Attached SLA through fix script

[Poonam Mahajan]

Hi All,

We have requirement to attached the SLA for the existing record and set the has breached flag depending upon the created and actual start date difference.

If difference > sla duration then has breached we need to set to true else false.

In the script we are updating the run sla flag in sc_task which will attached the SLA and in the same script we are adding the logic to set has breached and updating in the task_sla.

However, its not updating the has breached flag on the task_sla first time when we are running the script.  

If we run the script for the second time then its updating.

Is there any reason why its happening or do we have any method to pause after first update on sc_task.

Please check the below code snippet and kindly assist.

var hasBreached = false;

var grTask = new GlideRecord("sc_task");

grTask.addEncodedQuery('numberSTARTSWITHSCTASK0065226');

grTask.query();

if(grTask.next()){

    grTask.x_tsigh_sem_digit_run_sla = true;

    //grTask.setWorkflow(false);

    grTask.update();

    //if(grTask.update()){

        var scheduleID = '08fcd0830a0a0b2600079f56b1adb9ae';

        var created = grTask.sys_created_on;

        var firstUpdated = grTask.work_start;

        var taskCreated_DT = new GlideDateTime(created);

        var firstUpdated_DT = new GlideDateTime(firstUpdated);

        var durCalc = new DurationCalculator();

        durCalc.setSchedule(scheduleID);

        var dur = durCalc.calcScheduleDuration(taskCreated_DT,firstUpdated_DT);

        var dur_hours = dur/(60*60);

        if(dur_hours > 5){

            hasBreached = true;

        }

        var grTaskSla = new GlideRecord('task_sla');

        grTaskSla.addEncodedQuery('task='+grTask.sys_id);

        grTaskSla.query();

        if(grTaskSla.next()){

            gs.info("in if");

            grTaskSla.has_breached = hasBreached;

            grTaskSla.update();

        }

   // }

}

Thanks 

[Aman Kumar S]

This could be beacuse you will have multiple SLAs associated with a single task, you can better, point to the specific SLA which you are looking to update, you can add query like, resolution SLA, state is one of in progress or complete.

[Poonam Mahajan]

Hi Aman,

I have single SLA attached to the task.

[Aman Kumar S]

1. Ensure that the code to update the has_breached field on the task_sla table is executed after the update on the task sla table. Make sure there are no other scripts or business rules that might interfere with the order of operations.

2. By default, the update() function in ServiceNow is synchronous, meaning it waits for the update to complete before proceeding. However, you have commented out the line grTask.setWorkflow(false)that could have potentially disabled synchronous updates. Remove the comment and try executing the script again to ensure that the update on sc_task completes before moving to the task_sla update.

3. Check if there are any other asynchronous processes or scheduled jobs that might be running concurrently. It's possible that the task_slarecord is not yet available for update when the script runs for the first time, resulting in the update being successful on subsequent executions.