tmDeleteTaskInstanceTree - performance optimization

Products

• IT Management Suite

Issue/Introduction

Occasionally task instance deletion (as well as some task instance deletions via ASDK) either takes a long time to execute or timeout completely.

Environment

ITMS 8.6, 8.7

Cause

Known issue. There were some stored procedures that needed optimization:

tmDeleteTaskInstanceTree
CtsStopTaskInstanceChildrenNotStartedNsTime
CtsStopTaskInstanceChildrenStarted

Resolution

A fix will be available under our ITMS 8.7 RU1 release.

In the meantime, the customer can apply SQL from "tmCte-to-fn.txt" using SQL management studio for ITMS 8.6 RU3 or ITMS 8.7 RTM release. See the attachments section.

Note:
This is expected to see this error because ITMS 8.6 RU3 and ITMS 8.7 RTM don't have this new function "fnTmGetTaskInstanceTree".