SLAs Not Stopping After Work request is closed

[Afrin12]

SLAs Not Stopping After Work Request Auto-Closure

Scheduled job runs every day to close the work request automatically,
Script:

function ProcWorkOrdAuto() {
var wrk = new GlideRecord('u_work_order');
wrk.addEncodedQuery('state=9^ORstate=3^NQstate=4^sys_updated_onONThis week@javascript:gs.beginningOfThisWeek()@javascript:gs.endOfThisWeek()');
wrk.query();

while (wrk.next()) {
var sla = new GlideRecord('task_sla');
sla.addEncodedQuery("task=" + wrk.sys_id + "^sla=a95fe6e9dbfd10905dc552625b96190e^active=true");
sla.query();

while (sla.next()) {
var seconds = sla.u_idb_business_duration.getGlideObject().getNumericValue() / 1000;
if (seconds >= 259200) { // 3 days
wrk.state = "4";
wrk.work_notes = "Work Request automatically closed by system.";
wrk.active = false;
wrk.closed_at = gs.nowDateTime();
wrk.update();
}

if (wrk.state == '4') {
SLACalculatorNG.calculateSLA(wrk, false);
}
}
}
}

But Sla is in progress

Any suggestions on what might be missing? Thanks in Advance.

 

[Dr Atul G- LNG]

Hi @Afrin12 

Could you please try to repair the SLA once and then check also try to remove the condition on complete, i am assuming this is causing the issue.

[Afrin12]

Hi @Dr Atul G- LNG 
I have tried but still having the issue

[Dr Atul G- LNG]

Did you try to remove the complete state condition and then try to repair SLA.

[Afrin12]

yes

[Dr Atul G- LNG]

It should work since everything looks good on my end. Also, are the start and pause conditions functioning properly? Try creating another SLA/OLA in the same table and check if it's working. It seems like there might be a cache issue.