Windu takes too long to execute Detect Missing Audites for Change Object workitems (8h)

Question

I am using Windchill PDMLink Release 11.0 and Datecode with CPS M030-CPS22 The system needs to be upgraded to 12. When executing windu in 11.0M030, the following problems occur:During the execution of windu, "Detect Missing Audites for Change Object workitems" remains Started for a long time (8h). Is this normal?After the execution, you need help analyzing and solving the problems reported by the windu task; 
  
----------------------------------- 
Translated the text from Simplified Chinese to English using google translateSubject: windu执行Detect Missing Audites for Change Object workitems时间过长（8h）Body: 系统需要升级至12，在11.0M030中执行windu出现以下问题： windu执行过程中“Detect Missing Audites for Change Object workitems”长时间（8h）处于Started，是否正常？ 执行结束后需要帮忙分析解决一下windu任务报告的问题；- By community Moderation team----------------------------------------

Rocket_Max · Answer

Hi @ZW_9537235

If the data volume is large, this task is very time-consuming. The background of the task is to run this SQL:

SELECT DISTINCT A0.classnameA2A2,A0.idA2A2,A0.classnamekeyB4,A1.classnameA2A2,A1.idA2A2,A1.name 
FROM WorkItem A0,WTUser A1 
WHERE ((A0.completedBy IS NOT NULL ) 
AND (A0.status = @P0) 
AND (A1.name LIKE A0.completedBy))

Please note that this task is not a mandatory upgrade task, so if your goal is to upgrade, you can skip this task

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded