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