"wt.pds.PartialResultException" was thrown when purging audit log in Windchill PDMLink 12.0

• Audit log purge failed with error:

ERROR [auditPurgeQueue.SchedulingThread] wt.audit.AuditReportHelper Administrator - failed to generate Audit Report wt.util.WTException: org.xml.sax.SAXException: (wt.pds.pdsResource/22) wt.pds.PartialResultException: The returned query result has exceeded the query limit, and only 250,000 result returned.
(wt.pds.pdsResource/22) wt.pds.PartialResultException: The returned query result has exceeded the query limit, and only 250,000 result returned.
Nested exception is: org.xml.sax.SAXException: (wt.pds.pdsResource/22) wt.pds.PartialResultException: The returned query result has exceeded the query limit, and only 250,000 result returned.
(wt.pds.pdsResource/22) wt.pds.PartialResultException: The returned query result has exceeded the query limit, and only 250,000 result returned.
	at wt.query.template.ResultProcessorResultSAXSource.produceEvents(ResultProcessorResultSAXSource.java:239)
	at wt.query.template.CompositeSAXSource.produceEvents(CompositeSAXSource.java:216)
	at com.ptc.core.query.report.client.generation.AbstractReportSAXTransform.execute(AbstractReportSAXTransform.java:78)
	at com.ptc.core.query.report.client.generation.ReportGenerationHelper.generate(ReportGenerationHelper.java:521)
	at wt.audit.AuditReportHelper._generateReport(AuditReportHelper.java:645)
	at wt.audit.AuditReportHelper.generateReport(AuditReportHelper.java:598)
	at wt.audit.StandardAuditService.createAuditPurgeJob(StandardAuditService.java:2162)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
	at com.sun.proxy.$Proxy33.createAuditPurgeJob(Unknown Source)
	at com.ptc.windchill.enterprise.auditing.server.AuditSchedulingHelper.executeAuditPurgeSchedule(AuditSchedulingHelper.java:393)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at wt.scheduler.ScheduleItem.execute(ScheduleItem.java:325)
	at wt.scheduler.StandardSchedulingService.executionKernel(StandardSchedulingService.java:1306)
	at wt.scheduler.StandardSchedulingService.executeScheduledItem(StandardSchedulingService.java:603)
	at jdk.internal.reflect.GeneratedMethodAccessor354.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at wt.queue.ScheduleQueueEntry.execute(ScheduleQueueEntry.java:264)
	at wt.queue.ScheduleQueue.execEntry(ScheduleQueue.java:336)
	at wt.queue.ScheduleQueue.execEntries(ScheduleQueue.java:457)
	at wt.queue.ScheduleQueueThread.processReadyEntries(ScheduleQueueThread.java:284)
	at wt.queue.ScheduleQueueThread.run(ScheduleQueueThread.java:92)

• Set wt.pom.rowCount logger to log level WARN with below lines added to Windchill/codebase/WEB-INF/log4jMethodServer.properties:

logger.RowCount.name=wt.pom.rowCount
logger.RowCount.level=WARN

• SQL query captured with wt.pom.rowCount logger:

SELECT CONVERT(varbinary,NULL),A0.classnameA2A2,NULL,NULL,A0.idA2A2,A0.typeadministrativeLock,A0.classnamekeydomainRef,A0.securityLabels,CONVERT(varchar,NULL),CONVERT(varchar,NULL),A0.idA3domainRef,CONVERT(varchar,NULL),A1.blob$entrySetadHocAclAC,A1.classnameA2A2AC,A1.branchIdA2typeDefinitionRefeAC,A1.idA3A2ownershipAC,A1.idA2A2AC,A1.typeadministrativeLockAC,A1.classnamekeydomainRefAC,A1.securityLabelsAC,A1.entrySetadHocAclAC,A1.statestateAC,A1.idA3domainRefAC,A1.classnamekeyA2ownershipAC,A0.eventLabel C1C0,A0.eventKey C1C1,CONVERT(varchar,A0.eventTime,120) C1C2,A0.userName C1C3,A0.idB5 C1C4,A0.IPAddress C1C5,A0.userOrgName C1C6,A0.targetType C1C7,A0.idC5 C1C8,A0.targetTypeBranchID C1C9,A0.targetName C1C10,A0.targetNumber C1C11,A0.branchID C1C12,A0.workingBranchID C1C13,A0.versionID C1C14,A0.idD5 C1C15,A0.idE5 C1C16,A0.orgContainerName C1C17,A0.idF5 C1C18,A0.appContainerName C1C19,A0.appContainerTypeBranchID C1C20,A0.folderPath C1C21,A0.domainPath C1C22,A0.classnameA2A2,A0.idA2A2,A0.lifecycleState C1C24,A0.transactionDescription C1C25,A0.targetIdentity C1C26,A0.targetSecurityLabels C1C27,A1.classnameA2A2,A1.idA2A2,A0.eventTime TS_C1C2 
FROM AuditRecord A0 
LEFT OUTER JOIN (
SELECT CONVERT(varbinary,NULL) blob$entrySetadHocAclAC,A1.classnameA2A2 classnameA2A2AC,NULL branchIdA2typeDefinitionRefeAC,NULL idA3A2ownershipAC,A1.idA2A2 idA2A2AC,A1.typeadministrativeLock typeadministrativeLockAC,A1.classnamekeydomainRef classnamekeydomainRefAC,A1.securityLabels securityLabelsAC,CONVERT(varchar,NULL) entrySetadHocAclAC,CONVERT(varchar,NULL) statestateAC,A1.idA3domainRef idA3domainRefAC,CONVERT(varchar,NULL) classnamekeyA2ownershipAC,A1.idA3recordReference,A1.markForDeleteA2,'wt.audit.eventinfo.CSRFEventInfo' classnameA2A2,A1.idA2A2 
FROM CSRFEventInfo A1 UNION ALL 
SELECT CONVERT(varbinary,NULL) blob$entrySetadHocAclAC,A1.classnameA2A2 classnameA2A2AC,NULL branchIdA2typeDefinitionRefeAC,NULL idA3A2ownershipAC,A1.idA2A2 idA2A2AC,A1.typeadministrativeLock typeadministrativeLockAC,A1.classnamekeydomainRef classnamekeydomainRefAC,A1.securityLabels securityLabelsAC,CONVERT(varchar,NULL) entrySetadHocAclAC,CONVERT(varchar,NULL) statestateAC,A1.idA3domainRef idA3domainRefAC,CONVERT(varchar,NULL) classnamekeyA2ownershipAC,A1.idA3recordReference,A1.markForDeleteA2,'wt.audit.eventinfo.DownloadEventInfo' classnameA2A2,A1.idA2A2 
FROM DownloadEventInfo A1 UNION ALL 
SELECT CONVERT(varbinary,NULL) blob$entrySetadHocAclAC,A1.classnameA2A2 classnameA2A2AC,NULL branchIdA2typeDefinitionRefeAC,NULL idA3A2ownershipAC,A1.idA2A2 idA2A2AC,A1.typeadministrativeLock typeadministrativeLockAC,A1.classnamekeydomainRef classnamekeydomainRefAC,A1.securityLabels securityLabelsAC,CONVERT(varchar,NULL) entrySetadHocAclAC,CONVERT(varchar,NULL) statestateAC,A1.idA3domainRef idA3domainRefAC,CONVERT(varchar,NULL) classnamekeyA2ownershipAC,A1.idA3recordReference,A1.markForDeleteA2,'wt.audit.eventinfo.ModifyGroupEventInfo' classnameA2A2,A1.idA2A2 
FROM ModifyGroupEventInfo A1 UNION ALL 
SELECT CONVERT(varbinary,NULL) blob$entrySetadHocAclAC,A1.classnameA2A2 classnameA2A2AC,NULL branchIdA2typeDefinitionRefeAC,NULL idA3A2ownershipAC,A1.idA2A2 idA2A2AC,A1.typeadministrativeLock typeadministrativeLockAC,A1.classnamekeydomainRef classnamekeydomainRefAC,A1.securityLabels securityLabelsAC,CONVERT(varchar,NULL) entrySetadHocAclAC,CONVERT(varchar,NULL) statestateAC,A1.idA3domainRef idA3domainRefAC,CONVERT(varchar,NULL) classnamekeyA2ownershipAC,A1.idA3recordReference,A1.markForDeleteA2,'wt.audit.eventinfo.UserSessionEventInfo' classnameA2A2,A1.idA2A2 
FROM UserSessionEventInfo A1 UNION ALL 
SELECT CONVERT(varbinary,NULL) blob$entrySetadHocAclAC,A1.classnameA2A2 classnameA2A2AC,NULL branchIdA2typeDefinitionRefeAC,NULL idA3A2ownershipAC,A1.idA2A2 idA2A2AC,A1.typeadministrativeLock typeadministrativeLockAC,A1.classnamekeydomainRef classnamekeydomainRefAC,A1.securityLabels securityLabelsAC,CONVERT(varchar,NULL) entrySetadHocAclAC,CONVERT(varchar,NULL) statestateAC,A1.idA3domainRef idA3domainRefAC,CONVERT(varchar,NULL) classnamekeyA2ownershipAC,A1.idA3recordReference,A1.markForDeleteA2,'wt.audit.eventinfo.ViewRepresentationsEventInfo' classnameA2A2,A1.idA2A2 
FROM ViewRepresentationsEventInfo A1) A1 ON ((A1.idA3recordReference = A0.idA2A2) 
    AND (A1.markForDeleteA2 = 0)) 
  WHERE (((A0.eventTime >= CONVERT(datetime,?,?)) 
    AND (A0.eventTime <= CONVERT(datetime,?,?)))) 
    AND (A0.markForDeleteA2 = 0) 
ORDER BY TS_C1C2 DESC