Article - CS158431

Deadlock detected on Representation creation in Windchill 10.0

Modified: 09-Sep-2015   


Applies To

  • Windchill PDMLink 10.0 F000 to 10.1 M040
  • Windchill PDMLink 10.2 F000 to M010-CPS08

Description

  • Deadlock detected on Representation creation
  • Deadlock generated by PublisherQueue (Windchill Visualization Service - WVS)
  • Occurs when 2 separate  publish jobs started from different Publisher queues are requesting locks for the same object (DerivedImage)
  • Creation of such jobs can be triggered by several actions like workflow, user check in....
  • Error message displayed in BackgroundMethodServer log:
 PublisherQueue2.PollingThread: ViewMarkUpService: Error postStoreDerviedImage e=wt.pom.DeadlockDetectedException: Deadlock is detected on the Representation - default object in the database. Nested exception is:
 PublisherQueue2.PollingThread:     java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
 PublisherQueue2.PollingThread:
 PublisherQueue2.PollingThread: ERROR : wt.wvs.loader.EDRHelper user - Unexpected exception
 PublisherQueue2.PollingThread: wt.util.WTException: wt.pom.DeadlockDetectedException: Deadlock is detected on the Representation - default object in the database. Nested exception is:
 PublisherQueue2.PollingThread:     java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445).......
.....
at wt.viewmarkup.StandardViewMarkUpService.postStoreDerivedImage(StandardViewMarkUpService.java:982)
at sun.reflect.GeneratedMethodAccessor398.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
at $Proxy62.postStoreDerivedImage(Unknown Source)
at com.ptc.wvs.server.loader.EDRHelper.endCreateRepresentation(EDRHelper.java:984)
at com.ptc.wvs.server.loader.EDRLoader.start(EDRLoader.java:1073)
at com.ptc.wvs.server.publish.PublishHelper.storeRepresentation(PublishHelper.java:499)
at com.ptc.wvs.server.publish.PublishHelper.storeRepresentation(PublishHelper.java:457)
at com.ptc.wvs.server.publish.CadConvertPROE.storeDrawingRepresentation(CadConvertPROE.java:825)
at com.ptc.wvs.server.publish.PublishJob.publishDrawing(PublishJob.java:1243)
at com.ptc.wvs.server.publish.PublishJob.publishObject(PublishJob.java:945)
at com.ptc.wvs.server.publish.PublishJob.executePublishJob(PublishJob.java:788)
at com.ptc.wvs.server.publish.PublishJob.processJob(PublishJob.java:558)
at com.ptc.wvs.server.publish.WVSProcessingJob.doMyJob(WVSProcessingJob.java:427)
at com.ptc.wvs.server.publish.WVSProcessingJob.doJobSynchronously(WVSProcessingJob.java:393)
at com.ptc.wvs.server.publish.WVSProcessingJob.doJob(WVSProcessingJob.java:373)


 
This is a printer-friendly version of Article 158431 and may be out of date. For the latest version click CS158431