Article - CS382905
Purge job failed with an exception "Database query operation interrupted" in Windchill PDMLink
Modified: 25-Aug-2025
Applies To
- Windchill PDMLink 12.0 to 12.1
Description
- EPMDocument checkout failed with errors
ERROR [ajp-nio-127.0.0.1-8010-exec-63] com.ptc.windchill.uwgm.proesrv.StandardRequestDispatcher xxx - StandardRequestDispatcher.dispatchRequest :: Unexpected failure(s) com.ptc.windchill.uwgm.common.conflict.UwgmErrorException: (wt.pds.pdsResource/29) wt.pds.DBOperationInterruptedException:
数据库查询操作中断。
嵌套异常是: (wt.pds.pdsResource/29) wt.pds.DBOperationInterruptedException:
数据库查询操作中断。
at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:875)
at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077)
at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1967)
at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1919)
at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1449)
at wt.epm.structure.EPMNavigateUtility.navigate(EPMNavigateUtility.java:245)
at wt.epm.structure.EPMStandardStructureService.expand(EPMStandardStructureService.java:2762)
at wt.build.BuildServiceUtility.expand(BuildServiceUtility.java:577)- Purge job or Publish Scheduled job (PublishAllEPMDocumentsNoRepresentation) failed with an exception "Database query operation interrupted".
WARN [MethodContextMonitor GC Baiter] wt.method.MethodContextMonitor.lowMemory.gc - Less than MinAvailableHeapThreshold [#########] bytes available; attempting explicit GC WARN [Service Thread] wt.method.MemoryUsageRedirectStrategy - Entering low memory state WARN [MethodContextMonitor GC Baiter] wt.method.MethodContextMonitor.lowMemory.interrupt - Still less than MinAvailableHeapThreshold [#########] bytes available; attempting to interrupt method context 'XXXXXXXXX;XXXXXX;XXXXX;XXXXXX;XXXXX'; based on: result set size WARN [MethodContextMonitor GC Baiter] wt.method.server - Interrupting thread wt.router.5.2.PollingThread WARN [MethodContextMonitor GC Baiter] wt.pds.queryCancel - QueryContext.cancel(): interrupting ... ... ERROR [wt.router.5.2.PollingThread] wt.dataops.purge.StandardPurgeService Administrator - null (wt.pds.pdsResource/29) wt.pds.DBOperationInterruptedException: Database query operation interrupted at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:875) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:986) at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972) at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2008) at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:655) at jdk.internal.reflect.GeneratedMethodAccessor57.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.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) at com.sun.proxy.$Proxy27.find(Unknown Source) at wt.occurrence.StandardOccurrenceService.getUsesOccurrencesForDelete(StandardOccurrenceService.java:3330) at wt.occurrence.StandardOccurrenceService.propagateDeleteToUsesOccurrences(StandardOccurrenceService.java:3051) at wt.occurrence.StandardOccurrenceService$7.notifyVetoableMultiObjectEvent(StandardOccurrenceService.java:256) at wt.events.StandardKeyedEventBranch.intDispatchEvent(StandardKeyedEventBranch.java:306) at wt.events.StandardKeyedEventBranch.dispatchVetoableMultiObjectEvent(StandardKeyedEventBranch.java:268) at wt.events.StandardKeyedEventDispatcher.intDispatchEvent(StandardKeyedEventDispatcher.java:306) at wt.events.StandardKeyedEventDispatcher.dispatchVetoableMultiObjectEvent(StandardKeyedEventDispatcher.java:244) at wt.services.StandardManagerService.intDispatchVetoableEvent(StandardManagerService.java:412) at wt.services.StandardManagerService.dispatchVetoableMultiObjectEvent(StandardManagerService.java:314) at wt.fc.StandardPersistenceManager.dispatchVetoableEvent(StandardPersistenceManager.java:2976) at wt.fc.StandardPersistenceManager.dispatchVetoableEvent(StandardPersistenceManager.java:2959) at wt.fc.StandardPersistenceManager.remove(StandardPersistenceManager.java:2266) at wt.fc.StandardPersistenceManager.processRemoveOids(StandardPersistenceManager.java:2501) at wt.fc.StandardPersistenceManager.processRemoveOids(StandardPersistenceManager.java:2339) at wt.fc.StandardPersistenceManager.remove(StandardPersistenceManager.java:2228) at wt.fc.StandardPersistenceManager.remove(StandardPersistenceManager.java:1764) at wt.fc.StandardPersistenceManager.delete(StandardPersistenceManager.java:851) 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.$Proxy27.delete(Unknown Source) at wt.vc.StandardVersionControlService.deleteIterations(StandardVersionControlService.java:3453) 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.$Proxy55.deleteIterations(Unknown Source) at wt.dataops.purge.StandardPurgeService._purge(StandardPurgeService.java:631) at wt.dataops.purge.StandardPurgeService.purge(StandardPurgeService.java:276) 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.$Proxy151.purge(Unknown Source) at com.ptc.windchill.enterprise.dataops.server.PurgeTask.runPurge(PurgeTask.java:143) at com.ptc.windchill.enterprise.dataops.server.PurgeTask._run(PurgeTask.java:106) at com.ptc.core.task.AtomicTask.run(AtomicTask.java:58) at com.ptc.core.task.Task.execute(Task.java:262) at com.ptc.core.task.Task.executeInBackground(Task.java:474) at com.ptc.core.task.QueueableTaskServerHelper.executeRoutedTask(QueueableTaskServerHelper.java:247) 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.queue.QueueEntry.execute(QueueEntry.java:231) at wt.queue.ProcessingQueue.execEntry(ProcessingQueue.java:312) at wt.queue.ProcessingQueue.execEntries(ProcessingQueue.java:898) at wt.queue.PollingQueueThread.run(PollingQueueThread.java:102) ERROR [wt.router.5.2.PollingThread] com.ptc.core.task.Task Administrator - Task.execute :: (wt.pds.pdsResource/29) wt.pds.DBOperationInterruptedException: Database query operation interrupted. (wt.pds.pdsResource/29) wt.pds.DBOperationInterruptedException: Database query operation interrupted at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:875) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:986) at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972) at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2008) at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:655) at jdk.internal.reflect.GeneratedMethodAccessor57.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.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) at com.sun.proxy.$Proxy27.find(Unknown Source) at wt.occurrence.StandardOccurrenceService.getUsesOccurrencesForDelete(StandardOccurrenceService.java:3330) at wt.occurrence.StandardOccurrenceService.propagateDeleteToUsesOccurrences(StandardOccurrenceService.java:3051) at wt.occurrence.StandardOccurrenceService$7.notifyVetoableMultiObjectEvent(StandardOccurrenceService.java:256) at wt.events.StandardKeyedEventBranch.intDispatchEvent(StandardKeyedEventBranch.java:306) at wt.events.StandardKeyedEventBranch.dispatchVetoableMultiObjectEvent(StandardKeyedEventBranch.java:268) at wt.events.StandardKeyedEventDispatcher.intDispatchEvent(StandardKeyedEventDispatcher.java:306) at wt.events.StandardKeyedEventDispatcher.dispatchVetoableMultiObjectEvent(StandardKeyedEventDispatcher.java:244) at wt.services.StandardManagerService.intDispatchVetoableEvent(StandardManagerService.java:412) at wt.services.StandardManagerService.dispatchVetoableMultiObjectEvent(StandardManagerService.java:314) at wt.fc.StandardPersistenceManager.dispatchVetoableEvent(StandardPersistenceManager.java:2976) at wt.fc.StandardPersistenceManager.dispatchVetoableEvent(StandardPersistenceManager.java:2959) at wt.fc.StandardPersistenceManager.remove(StandardPersistenceManager.java:2266) at wt.fc.StandardPersistenceManager.processRemoveOids(StandardPersistenceManager.java:2501) at wt.fc.StandardPersistenceManager.processRemoveOids(StandardPersistenceManager.java:2339) at wt.fc.StandardPersistenceManager.remove(StandardPersistenceManager.java:2228) at wt.fc.StandardPersistenceManager.remove(StandardPersistenceManager.java:1764) at wt.fc.StandardPersistenceManager.delete(StandardPersistenceManager.java:851) 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.$Proxy27.delete(Unknown Source) at wt.vc.StandardVersionControlService.deleteIterations(StandardVersionControlService.java:3453) 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.$Proxy55.deleteIterations(Unknown Source) at wt.dataops.purge.StandardPurgeService._purge(StandardPurgeService.java:631) at wt.dataops.purge.StandardPurgeService.purge(StandardPurgeService.java:276) 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.$Proxy151.purge(Unknown Source) at com.ptc.windchill.enterprise.dataops.server.PurgeTask.runPurge(PurgeTask.java:143) at com.ptc.windchill.enterprise.dataops.server.PurgeTask._run(PurgeTask.java:106) at com.ptc.core.task.AtomicTask.run(AtomicTask.java:58) at com.ptc.core.task.Task.execute(Task.java:262) at com.ptc.core.task.Task.executeInBackground(Task.java:474) at com.ptc.core.task.QueueableTaskServerHelper.executeRoutedTask(QueueableTaskServerHelper.java:247) 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.queue.QueueEntry.execute(QueueEntry.java:231) at wt.queue.ProcessingQueue.execEntry(ProcessingQueue.java:312) at wt.queue.ProcessingQueue.execEntries(ProcessingQueue.java:898) at wt.queue.PollingQueueThread.run(PollingQueueThread.java:102)
This is a printer-friendly version of Article 382905 and may be out of date. For the latest version click CS382905