sc_task state has changed to 8 (which doesn't exist in choice list) for a handful of closed records

captainpugwash
Kilo Expert

Hey Everyone, 

An Agent reported noticing that a few of their closed reqtsk records states had changed to 8,

When I open one of these records I can click the "state" drop down and see the label 8 in the list, if I click the "state" drop down on another record the 8 isn't visible.

The choice list also doesn't have any records for that tabel with either a label or value of 8.

This isn't a show stopper as it only appears to be happening on a small number of closed records but Any help would be appreciated!

Thank you! 

1 ACCEPTED SOLUTION

captainpugwash
Kilo Expert

Ok solved! The Tasks with the spurious state of (8) were orphaned tasks, we have a state "awaiting user info" which used to have a value of 8, The value was recently changed to 5 to keep the records as active. 

When this was changed any records that were currently marked as "awaiting user info" were orphaned and left with their previous value as the state...

I would have assumed that changing the value for a state would be updated for all records with that state... Live and learn!

 

Appreciate the comments guys!

View solution in original post

5 REPLIES 5

Harish KM
Kilo Patron
Kilo Patron

Can you check workflows or business rule scripts to check whether there is a script setting as 8 to state values?

Regards
Harish

Hi Harish, Nothing in any request workflows, i'm yet to check BR's will reply once I have

Musab Rasheed
Tera Sage
Tera Sage

Hello,

Looks like some code either through BR, workflow or Scheduled job or any other place trying to set State value to '8' hence you are seeing that, If you see choice table value '8' refers to 'Cancelled' state in at least incident table so just check which code is affecting and correct accordingly.

Mark my answer as correct if that helps

Regards

Please hit like and mark my response as correct if that helps
Regards,
Musab

Hi Musab. There are no choices with a label or value that matches 8, on the sc_request table. I will check to see if there are any BR's or scheduled tasks doing this,