Cancel old activities

[Guest Paul Alexander]

Is there a way of cancelling OLD activities please? 

We have a whole list of old activities which were set up before the option of 'cancelling activities if the parent call is cancelled' was enabled. 

Some of these go back to June 2017, and unless I go through each one (there are 159 pages of outstanding activities apparently!) and check whether the related SR has been cancelled or not and, if so, cancel this activity, I can't see an easy way of getting rid of them.

Is there a tool I can use to do this for me please?

[Gerry]

@Paul Alexander

We will need to look at what we can do for you, one of our devs will probably need to write a script, as we need to make sure that on dangling tasks are cleared down. Will discuss internally. 

Gerry

[SimonSheldon]

just as a matter of interest where is the "cancelling activities if the parent call is cancelled" setting? Is this usually on by default?

[Guest Paul Alexander]

@SimonSheldon

 

this is the webapp.view.ITSM.serviceDesk.requests.cancel.cancelRelatedActivities

setting in Hornbill Service Manager settings.

 

 

[SimonSheldon]

Thanks Paul!

[SamS]

Hi @Paul Alexander,

We've created the following utility to cancel tasks - https://wiki.hornbill.com/index.php/Task_Cancelation_Utility for those tasks which were created prior to the system setting change.

[Guest Paul Alexander]

Hi @SamS

Thanks for this....I've just tried to use the tool and I'm getting a long list of errors which all say "Task not taskCancel: The specified task was not found"

 

If I set dryRun to true it tells me that 1281 items would have been cancelled (so I've got half of it right...it CAN see the list of orphaned activities!). 

I'm using "Hornbill_Task_Canceller_x64.exe -instance=[Our Instance] -api=[our API key] -listfile=c:\tasks.csv "

Any ideas please?

 

 

[SamS]

Hi @Paul Alexander,

Is there a significant difference (in the .csv file) between the cancelled tasks and those not cancelled (eg missing TSK prefix or so)? You said it was 50-50 success. Was it every second task in the list which worked/not worked? The error suggests that the task does not exist, so obvious question, do the remaining tasks still exist?

[Guest Paul Alexander]

Hi @SamS

The .csv file seems to have all the correct data in it (every line starts with tsk etc). I got this list using the built in 'open tasks on cancelled request' report supplied in the zip file.

It looks like EVERY line is failing (not 50/50)

And yes, if I do a search for the tasks, they DO still exist. 

thanks

 

 

[SamS]

Hi @Paul Alexander,

I think I know what's up. The report export encapsulates the tasks in double-quotes.

If you open the .csv in a text editor and search and replace all double-quotes, you will be OK.

[Guest Paul Alexander]

@SamS

That's better thanks....it's all done and we have a much smaller list of activities.

 

thank you