Article - CS350639

Tech Pack is not getting generated and blocking in Queue TechPackGenQueue0 in FlexPLM

Modified: 12-Aug-2021   


Applies To

  • FlexPLM 11.0

Description

  • Tech Pack is not getting generated and blocking in Queue TechPackGenQueue0
  • Method Server reported below error:
2021-07-30 16:19:28,175 ERROR [ajp-nio-127.0.0.1-8011-exec-87] wt.licenseusage.StandardLicenseUsageService <UserName>- Error in recordLicenseUsage for user <User……>
wt.pom.ObjectLockedException: The Individual License Usage -
         IndividualLicenseUsage[…] object is already locked in the database.
Nested exception is: java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
         at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
         at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
         at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
         at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
         at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
         at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
         at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
         at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
         at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
         at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
         at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
         at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
         at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
         at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
         at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
         at wt.pds.SQLDatabasePds.lock(SQLDatabasePds.java:1279)
         at wt.pom.PersistentObjectManager.lock(PersistentObjectManager.java:905)
         at wt.fc.StandardPersistenceManager.lock(StandardPersistenceManager.java:1303)
         at wt.fc.StandardPersistenceManager.lock(StandardPersistenceManager.java:1311)
         at wt.licenseusage.StandardLicenseUsageService.checkAndrecordIndividualLicenseUsage(StandardLicenseUsageService.java:1549)
         at wt.licenseusage.StandardLicenseUsageService.recordLicenseUsage(StandardLicenseUsageService.java:1012)
         at wt.licenseusage.StandardLicenseUsageService.access$000(StandardLicenseUsageService.java:88)
         at wt.licenseusage.StandardLicenseUsageService$2.notifyVetoableMultiObjectEvent(StandardLicenseUsageService.java:248)
         at wt.events.StandardKeyedEventBranch.intDispatchEvent(StandardKeyedEventBranch.java:298)
         at wt.events.StandardKeyedEventBranch.dispatchVetoableEvent(StandardKeyedEventBranch.java:250)
         at wt.events.StandardKeyedEventDispatcher.intDispatchEvent(StandardKeyedEventDispatcher.java:304)
         at wt.events.StandardKeyedEventDispatcher.dispatchVetoableEvent(StandardKeyedEventDispatcher.java:228)
         at wt.services.StandardManagerService.intDispatchVetoableEvent(StandardManagerService.java:406)
         at wt.services.StandardManagerService.dispatchVetoableEvent(StandardManagerService.java:302)
         at wt.content.StandardContentService.dispatchVetoableEvent(StandardContentService.java:6681)
         at wt.content.StandardContentService.dispatchVetoableEvent(StandardContentService.java:393)
         at wt.content.StandardContentService.dispatchReadContentEvent(StandardContentService.java:4300)
         at wt.content.StandardContentService.checkPropAndDispatchReadContentEvent(StandardContentService.java:2658)
         at wt.fv.FvItem.retrieveStream(FvItem.java:156)
         at wt.content.StandardContentService.findContentStream(StandardContentService.java:477)
         at com.lcs.wc.document.LCSDocumentLogic.downloadContentFile(LCSDocumentLogic.java:3346)
         at com.lcs.wc.document.LCSDocumentLogic.downloadContentFile(LCSDocumentLogic.java:3321)
         at com.lcs.wc.document.StandardLCSDocumentService.downloadContent(StandardLCSDocumentService.java:470)
         at com.lcs.wc.document.StandardLCSDocumentService.downloadContent(StandardLCSDocumentService.java:576)
         at sun.reflect.GeneratedMethodAccessor1528.invoke(Unknown Source)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         at java.lang.reflect.Method.invoke(Method.java:498)
         at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
         at com.sun.proxy.$Proxy261.downloadContent(Unknown Source)
         at com.vrd.wc.document.VRDImagePagePDFGenerator.createPDFCell(VRDImagePagePDFGenerator.java:399)
         at com.vrd.wc.document.VRDImagePagePDFGenerator.createPDFTable(VRDImagePagePDFGenerator.java:540)
         at com.vrd.wc.document.VRDImagePagePDFGenerator.getPDFContent(VRDImagePagePDFGenerator.java:596)
         at com.vrd.wc.product.VRDPDFImagePagesCollection2.getPDFContentCollection(VRDPDFImagePagesCollection2.java:72)
         at com.vrd.wc.product.VRDPDFProductSpecificationGenerator2.generateSpec(VRDPDFProductSpecificationGenerator2.java:635)
         at com.lcs.wc.specification.FlexSpecLogic._generateTechPackImpl(FlexSpecLogic.java:1943)
         at com.lcs.wc.specification.FlexSpecLogic.generateTechPackImpl(FlexSpecLogic.java:1790)
         at com.lcs.wc.specification.StandardFlexSpecService.generateTechPack(StandardFlexSpecService.java:359)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         at java.lang.reflect.Method.invoke(Method.java:498)
         at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
         at com.sun.proxy.$Proxy273.generateTechPack(Unknown Source)
         at org.apache.jsp.rfa.vrd.jsp.product.PDFProductSpecGenerator2_jsp._jspService(PDFProductSpecGenerator2_jsp.java:471)
         ……
Caused by: Error : 54, Position : 0, Sql = SELECT idA2A2 FROM IndividualLicenseUsage WHERE idA2A2=:1  FOR UPDATE NOWAIT, OriginalSql = SELECT idA2A2 FROM IndividualLicenseUsage WHERE idA2A2=? FOR UPDATE NOWAIT, Error Msg = ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
         at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
         ... 143 more
2021-07-30 16:19:28,181 INFO  [ajp-nio-127.0.0.1-8011-exec-87] wt.system.err xxx - (wt.pom.pomResource/10) wt.pom.PersistenceException: A commit cannot be done when a rollback is in progress.  The following is the rollback stacktrace.
2021-07-30 16:19:28,181 INFO  [ajp-nio-127.0.0.1-8011-exec-87] wt.system.err xxx -     ROLLBACK: java.lang.Thread.getStackTrace(Thread.java:1559)
2021-07-30 16:19:28,181 INFO  [ajp-nio-127.0.0.1-8011-exec-87] wt.system.err xxx -     ROLLBACK: wt.pom.TransactionManager.rollbackTransaction(TransactionManager.java:750)
……
2021-07-30 16:19:28,182 INFO  [ajp-nio-127.0.0.1-8011-exec-87] wt.system.err xxx -     ROLLBACK: com.sun.proxy.$Proxy261.downloadContent(Unknown Source)
2021-07-30 16:19:28,182 INFO  [ajp-nio-127.0.0.1-8011-exec-87] wt.system.err xxx -     ROLLBACK: com.vrd.wc.document.VRDImagePagePDFGenerator.createPDFCell(VRDImagePagePDFGenerator.java:399)
2021-07-30 16:19:28,182 INFO  [ajp-nio-127.0.0.1-8011-exec-87] wt.system.err xxx -     ROLLBACK: com.vrd.wc.document.VRDImagePagePDFGenerator.createPDFTable(VRDImagePagePDFGenerator.java:540)
2021-07-30 16:19:28,182 INFO  [ajp-nio-127.0.0.1-8011-exec-87] wt.system.err xxx -     ROLLBACK: com.vrd.wc.document.VRDImagePagePDFGenerator.getPDFContent(VRDImagePagePDFGenerator.java:596)
2021-07-30 16:19:28,182 INFO  [ajp-nio-127.0.0.1-8011-exec-87] wt.system.err xxx -     ROLLBACK: com.vrd.wc.product.VRDPDFImagePagesCollection2.getPDFContentCollection(VRDPDFImagePagesCollection2.java:72)
2021-07-30 16:19:28,182 INFO  [ajp-nio-127.0.0.1-8011-exec-87] wt.system.err xxx -     ROLLBACK: com.vrd.wc.product.VRDPDFProductSpecificationGenerator2.generateSpec(VRDPDFProductSpecificationGenerator2.java:635)
2021-07-30 16:19:28,182 INFO  [ajp-nio-127.0.0.1-8011-exec-87] wt.system.err xxx -     ROLLBACK: com.lcs.wc.specification.FlexSpecLogic._generateTechPackImpl(FlexSpecLogic.java:1943)
2021-07-30 16:19:28,182 INFO  [ajp-nio-127.0.0.1-8011-exec-87] wt.system.err xxx -     ROLLBACK: com.lcs.wc.specification.FlexSpecLogic.generateTechPackImpl(FlexSpecLogic.java:1790)
2021-07-30 16:19:28,182 INFO  [ajp-nio-127.0.0.1-8011-exec-87] wt.system.err xxx -     ROLLBACK: com.lcs.wc.specification.StandardFlexSpecService.generateTechPack(StandardFlexSpecService.java:359)
This is a printer-friendly version of Article 350639 and may be out of date. For the latest version click CS350639