Article - CS411701
In Thingworx Navigate, an error occurs when displaying the View Drawing for some Parts.
Modified: 23-Feb-2024
Applies To
- Windchill Navigate (formerly ThingWorx Navigate) 9.5
Description
- Long running method context executed on Windchill
- with ODATA :
/Windchill/sslClientAuth/v6/ProdMgmt/Parts('OR%3Awt.part.WTPart%3AXXXX')?$expand=PartDocAssociations($expand=RelatedCADDoc($select=ID,LastModified,Name,Version;$expand=Representations($select=AdditionalFiles,ID),Representations($filter=DefaultRepresentation eq true));$filter=RelatedCADDoc/Category/Value eq 'CADDRAWING')
- SQL request:
SELECT A1.blob$entrySetadHocAcl,A1.classnameA2A2,A1.branchIdA2typeDefinitionRefe,A1.idA3A2ownership,A1.idA2A2,A1.typeadministrativeLock,A1.classnamekeydomainRef,A1.securityLabels,A1.entrySetadHocAcl,A1.statestate,A1.idA3domainRef,A1.classnamekeyA2ownership,A2.blob$entrySetadHocAcl,A2.classnameA2A2,A2.branchIdA2typeDefinitionRefe,A2.idA3A2ownership,A2.idA2A2,A2.typeadministrativeLock,A2.classnamekeydomainRef,A2.securityLabels,A2.entrySetadHocAcl,A2.statestate,A2.idA3domainRef,A2.classnamekeyA2ownership,A1.idA2A2,'wt.epm.EPMDocument',A0.administrativeLockIsNull,A0.typeadministrativeLock,A0.classnamekeyC10,A0.idA3C10,A0.authoringAppVersion,A0.classnamekeyB10,A0.idA3B10,A0.blob$entrySetadHocAcl,A0.blob$expressionData,A0.boxExtentsIsNull,A0.AxD10,A0.AyD10,A0.AzD10,A0.BxD10,A0.ByD10,A0.BzD10,A0.checkoutInfoIsNull,A0.statecheckoutInfo,A0.classnamekeycontainerReferen,A0.idA3containerReference,A0.dbKeySize,A0.derived,A0.description,A0.classnamekeydomainRef,A0.idA3domainRef,A0.entrySetadHocAcl,A0.eventSet,A0.expressionData,A0.extentsValid,A0.familyTableStatus,A0.classnamekeyA2folderingInfo,A0.idA3A2folderingInfo,A0.classnamekeyB2folderingInfo,A0.idA3B2folderingInfo,A0.classnamekeyformat,A0.idA3format,A0.hasHangingChange,A0.hasPendingChange,A0.hasResultingChange,A0.hasSuspect,A0.hasVariance,A0.indexersindexerSet,A0.inheritedDomain,A0.iopStateinteropInfo,A0.stateinteropInfo,A0.branchIditerationInfo,A0.classnamekeyD2iterationInfo,A0.idA3D2iterationInfo,A0.classnamekeyE2iterationInfo,A0.idA3E2iterationInfo,A0.iterationIdA2iterationInfo,A0.latestiterationInfo,A0.classnamekeyB2iterationInfo,A0.idA3B2iterationInfo,A0.noteiterationInfo,A0.classnamekeyC2iterationInfo,A0.idA3C2iterationInfo,A0.stateiterationInfo,A0.lengthScale,CONVERT(varchar,A0.datelock,120),A0.classnamekeyA2lock,A0.idA3A2lock,A0.notelock,A0.classnamekeymasterReference,A0.idA3masterReference,A0.maximumAllowed,A0.minimumRequired,A0.missingDependents,A0.oneOffVersionIdA2oneOffVersi,A0.classnamekeyA2ownership,A0.idA3A2ownership,A0.placeHolder,A0.referenceControlIsNull,A0.geomRestrE10,A0.geomRestrRecursiveE10,A0.scopeE10,A0.violRestrictionE10,A0.revisionNumber,A0.classnamekeyrootItemReferenc,A0.idA3rootItemReference,A0.securityLabels,A0.atGatestate,A0.classnamekeyA2state,A0.idA3A2state,A0.statestate,A0.teamIdIsNull,A0.classnamekeyteamId,A0.idA3teamId,A0.teamTemplateIdIsNull,A0.classnamekeyteamTemplateId,A0.idA3teamTemplateId,A0.enabledtemplate,A0.templatedtemplate,CONVERT(varchar,A0.createStampA2,120),A0.markForDeleteA2,CONVERT(varchar,A0.modifyStampA2,120),A0.idA2A2,A0.updateCountA2,CONVERT(varchar,A0.updateStampA2,120),A0.branchIdA2typeDefinitionRefe,A0.idA2typeDefinitionReference,A0.verified,A0.versionIdA2versionInfo,A0.versionLevelA2versionInfo,A0.versionSortIdA2versionInfo,A0B.CADName,A0B.authoringApplication,A0B.collapsible,A0B.classnamekeycontainerReferen,A0B.idA3containerReference,A0B.defaultUnit,A0B.docSubType,A0B.docType,A0B.genericType,A0B.globalID,A0B.name,A0B.documentNumber,A0B.classnamekeyorganizationRefe,A0B.idA3organizationReference,A0B.ownerApplication,A0B.series,CONVERT(varchar,A0B.createStampA2,120),A0B.markForDeleteA2,CONVERT(varchar,A0B.modifyStampA2,120),A0B.classnameA2A2,A0B.idA2A2,A0B.updateCountA2,CONVERT(varchar,A0B.updateStampA2,120),A0B.branchIdA2typeDefinitionRefe,A0B.idA2typeDefinitionReference,'wt.epm.structure.EPMReferenceLink',A4.asStoredChildName,A4.depType,A4.hasIBAValues,A4.referenceType,A4.required,A4.classnamekeyroleAObjectRef,A4.idA3A5,A4.classnamekeyroleBObjectRef,A4.idA3B5,CONVERT(varchar,A4.createStampA2,120),A4.markForDeleteA2,CONVERT(varchar,A4.modifyStampA2,120),A4.idA2A2,A4.updateCountA2,CONVERT(varchar,A4.updateStampA2,120),A4.branchIdA2typeDefinitionRefe,A4.idA2typeDefinitionReference,A4.uniqueLinkID,A4.uniqueNDId FROM EPMDocument A0 INNER JOIN EPMDocumentMaster A0B ON (A0.idA3masterReference = A0B.idA2A2),WTPart A1,EPMDocument A2,EPMBuildRule A3,EPMReferenceLink A4,(SELECT A2.idA2A2 seed_id,A0.idA2A2 otherside_id,RANK() OVER ( PARTITION BY A2.idA2A2,A0.idA3masterReference ORDER BY A0.versionSortIdA2versionInfo DESC,(REPLICATE(' ',60 - LEN(COALESCE((SELECT A0.iterationIdA2iterationInfo FROM (SELECT 1 wtnc) NT0 WHERE ((A0.oneOffVersionIdA2oneOffVersi IS NULL ))),(SELECT N'z' FROM (SELECT 1 wtnc) NT0 WHERE ((A0.oneOffVersionIdA2oneOffVersi IS NOT NULL ) AND (A6.oneOffVersionIdA2oneOffVersi IS NOT NULL ))),A6.iterationIdA2iterationInfo,N'-'))) + CONVERT(varchar,COALESCE((SELECT A0.iterationIdA2iterationInfo FROM (SELECT 1 wtnc) NT0 WHERE ((A0.oneOffVersionIdA2oneOffVersi IS NULL ))),(SELECT N'z' FROM (SELECT 1 wtnc) NT0 WHERE ((A0.oneOffVersionIdA2oneOffVersi IS NOT NULL ) AND (A6.oneOffVersionIdA2oneOffVersi IS NOT NULL ))),A6.iterationIdA2iterationInfo,N'-'))) DESC,(REPLICATE(' ',60 - LEN(COALESCE(A0.oneOffVersionIdA2oneOffVersi,N'-'))) + CONVERT(varchar,COALESCE(A0.oneOffVersionIdA2oneOffVersi,N'-'))) DESC,(REPLICATE(' ',60 - LEN(A0.iterationIdA2iterationInfo)) + CONVERT(varchar,A0.iterationIdA2iterationInfo)) DESC,COALESCE((SELECT 3 FROM (SELECT 1 wtnc) NT0 WHERE ((A0.statecheckoutInfo = N'wrk') AND (A0.idA3A2ownership = 11))),(SELECT 2 FROM (SELECT 1 wtnc) NT0 WHERE ((A0.statecheckoutInfo <> N'wrk') AND (A0.statecheckoutInfo <> N'wrk-p'))),(SELECT 1 FROM (SELECT 1 wtnc) NT0 WHERE ((A0.statecheckoutInfo = N'wrk-p') AND (A0.idA3A2ownership = 11))),0) DESC) rank,SUM(COALESCE((SELECT 1 FROM EPMDocument Z0,EPMAsStoredMember Z1 WHERE ((Z1.idA3A5 = A0.idA3C10) AND (Z1.idA3B5 = Z0.idA2A2) AND (Z0.idA3masterReference = A2.idA3masterReference) AND (Z0.versionSortIdA2versionInfo >= A2.versionSortIdA2versionInfo))),0)) OVER ( PARTITION BY A2.idA2A2,A0.idA3masterReference) exclude FROM ControlBranch A5 LEFT OUTER JOIN EPMDocument A6 ON (A5.idA3C5 = A6.idA2A2),EPMDocument A0,WTPart A1,EPMDocument A2,EPMBuildRule A3,EPMReferenceLink A4 WHERE (((A1.branchIditerationInfo = A3.branchIdA3B5)) AND ((A0.idA2A2 = A4.idA3A5)) AND ((A2.branchIditerationInfo = A3.branchIdA3A5)) AND ((A4.idA3B5 = A2.idA3masterReference)) AND (((((((((A1.latestiterationInfo = :1 ) AND (A2.latestiterationInfo = :2 )) AND (A3.idA3A6 = :3 )) AND ((A2.statecheckoutInfo <> :4 ) OR (A1.statecheckoutInfo = :5 ))) AND (A4.referenceType = :6 )) AND (A3.buildType = :7 )) AND ((A1.latestiterationInfo = :8 ) OR ((A1.latestiterationInfo = :9 ) AND (A0.latestiterationInfo = :10 )))) AND (A1.idA2A2 = :11 ))) AND (A0.branchIditerationInfo = A5.idA2A2) AND (((A2.classnamekeycontainerReferen <> :12 ) AND (A0.classnamekeycontainerReferen <> :13 )) OR ((A2.classnamekeycontainerReferen = :14 ) AND ((A2.idA3containerReference = A0.idA3containerReference) OR EXISTS (SELECT 1 FROM SharedContainerMap X0 WHERE ((X0.idA3D5 = A2.idA3containerReference) AND ((X0.idA3A5 = A0.idA2A2) OR (X0.branchIdA3B5 = A0.branchIditerationInfo))))))))) A5 WHERE (((A1.branchIditerationInfo = A3.branchIdA3B5)) AND ((A0.idA2A2 = A4.idA3A5)) AND ((A2.branchIditerationInfo = A3.branchIdA3A5)) AND ((A4.idA3B5 = A2.idA3masterReference)) AND (((((((((A1.latestiterationInfo = :15 ) AND (A2.latestiterationInfo = :16 )) AND (A3.idA3A6 = :17 )) AND ((A2.statecheckoutInfo <> :18 ) OR (A1.statecheckoutInfo = :19 ))) AND (A4.referenceType = :20 )) AND (A3.buildType = :21 )) AND ((A1.latestiterationInfo = :22 ) OR ((A1.latestiterationInfo = :23 ) AND (A0.latestiterationInfo = :24 )))) AND (A1.idA2A2 = :25 ))) AND (A2.idA2A2 = A5.seed_id) AND (A0.idA2A2 = A5.otherside_id) AND (A5.rank = :26 ) AND (A5.exclude = :27 ))
- and code:
O-app//com.ptc.odata.windchill.servlet.WcRestServlet.service(WcRestServlet.java:200) count=218(%100,00)
O-app//com.ptc.odata.windchill.entity.service.RetryableRequestMediator.process(RetryableRequestMediator.java:476) count=218(%100,00)
O-app//org.apache.olingo.server.core.ODataHttpHandlerImpl.process(ODataHttpHandlerImpl.java:88) count=218(%100,00)
O-app//org.apache.olingo.server.core.LocalODataHttpHandlerImpl.process(LocalODataHttpHandlerImpl.java:31) count=218(%100,00)
O-app//org.apache.olingo.server.core.ODataHttpHandlerImpl.process(ODataHttpHandlerImpl.java:74) count=218(%100,00)
O-app//org.apache.olingo.server.core.ODataHandlerImpl.process(ODataHandlerImpl.java:89) count=218(%100,00)
O-app//org.apache.olingo.server.core.ODataHandlerImpl.processInternal(ODataHandlerImpl.java:168) count=218(%100,00)
O-app//org.apache.olingo.server.core.ODataDispatcher.dispatch(ODataDispatcher.java:119) count=218(%100,00)
O-app//org.apache.olingo.server.core.ODataDispatcher.handleResourceDispatching(ODataDispatcher.java:153) count=218(%100,00)
O-app//org.apache.olingo.server.core.ODataDispatcher.handleEntityDispatching(ODataDispatcher.java:525) count=218(%100,00)
O-app//org.apache.olingo.server.core.ODataDispatcher.handleSingleEntityDispatching(ODataDispatcher.java:621) count=218(%100,00)
O-app//com.ptc.odata.windchill.entity.service.WcEntityProviderProcessor.readEntity(WcEntityProviderProcessor.java:265) count=218(%100,00)
O-app//com.ptc.odata.core.entity.processor.EntityProviderProcessor.readEntity(EntityProviderProcessor.java:326) count=218(%100,00)
O-app//com.ptc.odata.core.entity.navigation.ExpandProviderProcessor.processExpandOption(ExpandProviderProcessor.java:173) count=218(%100,00)
O-app//com.ptc.odata.core.entity.navigation.ExpandProviderProcessor.expandEntities(ExpandProviderProcessor.java:188) count=218(%100,00)
O-app//com.ptc.odata.core.entity.navigation.ExpandProviderProcessor.expandLevels(ExpandProviderProcessor.java:241) count=218(%100,00)
O-app//com.ptc.odata.core.entity.navigation.ExpandProviderProcessor.expandLevel(ExpandProviderProcessor.java:279) count=218(%100,00)
O-app//com.ptc.odata.windchill.entity.processor.PersistableEntityProcessor.getRelatedEntityCollection(PersistableEntityProcessor.java:415) count=218(%100,00)
O-app//com.ptc.odata.windchill.caddocument.entity.processor.PartDocAssociationsDelegateProcessor.getRelatedEntityCollection(PartDocAssociationsDelegateProcessor.java:56) count=218(%100,00)
O-app//com.ptc.odata.windchill.caddocument.entity.processor.PartDocAssociationsDelegateProcessorHelper.expandAssociatedLinks(PartDocAssociationsDelegateProcessorHelper.java:92) count=218(%100,00)
O-app//com.ptc.odata.windchill.caddocument.entity.processor.PartDocAssociationsDelegateProcessorHelper.fetchAssociations(PartDocAssociationsDelegateProcessorHelper.java:122) count=218(%100,00)
O-app//com.ptc.odata.windchill.caddocument.entity.service.PartAssociationHelper.getAssociationsToSourceObjs(PartAssociationHelper.java:399) count=218(%100,00)
O-app//wt.epm.navigator.EPMNavigateHelper.navigate(EPMNavigateHelper.java:48) count=218(%100,00)
O-app//wt.epm.navigator.EPMNavigateHelper.navigate(EPMNavigateHelper.java:100) count=218(%100,00)
O-app//wt.epm.navigator.EPMNavigateHelper._navigate(EPMNavigateHelper.java:120) count=218(%100,00)
O-app//wt.epm.navigator.EPMNavigator.execute(EPMNavigator.java:213) count=218(%100,00)
O-app//wt.epm.navigator.EPMNavigator.execute(EPMNavigator.java:232) count=218(%100,00)
O-app//wt.epm.navigator.ExecutionContext.execute(ExecutionContext.java:239) count=218(%100,00)
O-app//wt.epm.navigator.ExecutionContext.process(ExecutionContext.java:273) count=218(%100,00)
O-app//wt.epm.navigator.Relationship.processRecursion(Relationship.java:235) count=218(%100,00)
O-app//wt.epm.navigator.relationship.AssociatedCADDocs.process(AssociatedCADDocs.java:523) count=218(%100,00)
O-app//wt.epm.navigator.relationship.AssociatedCADDocs.processCalculated(AssociatedCADDocs.java:676) count=218(%100,00)
O-app//wt.epm.navigator.relationship.CalculatedLinks.process(CalculatedLinks.java:349) count=218(%100,00)
O-app//wt.epm.navigator.Relationship.process(Relationship.java:254) count=218(%100,00)
O-app//wt.epm.navigator.relationship.CalculatedLinks$PartToDocHandler.process(CalculatedLinks.java:610) count=218(%100,00)
O-app//wt.epm.navigator.relationship.CalculatedLinks$PartToDocHandler.getBuildLinksResults(CalculatedLinks.java:693) count=218(%100,00)
O-app//wt.epm.navigator.query.NavigatorQuery.execute(NavigatorQuery.java:599) count=218(%100,00)
O-app//wt.epm.navigator.query.NavigatorQuery.execute(NavigatorQuery.java:613) count=218(%100,00)
O-app//wt.epm.query.Query.execute(Query.java:65) count=218(%100,00)
O-app//wt.epm.query.AbstractQuery.execute(AbstractQuery.java:258) count=218(%100,00)
O-app//wt.epm.query.pom.impl.POMProcessor.execute(POMProcessor.java:340) count=218(%100,00)
O-app//wt.epm.query.pom.impl.POMProcessor.executeInternal(POMProcessor.java:286) count=218(%100,00)
O-app//wt.epm.query.pom.impl.ConfigSpecEvaluator.execute(ConfigSpecEvaluator.java:76) count=218(%100,00)
O-app//wt.epm.query.pom.impl.ConfigSpecEvaluator.execute(ConfigSpecEvaluator.java:89) count=218(%100,00)
O-app//wt.epm.query.pom.impl.ConfigSpecEvaluator.processConfigSpecOrNavigationCriteria(ConfigSpecEvaluator.java:123) count=218(%100,00)
O-app//wt.epm.query.pom.impl.MultiLineConfigSpecProcessor.process(MultiLineConfigSpecProcessor.java:76) count=218(%100,00)
O-app//wt.epm.query.pom.impl.ConfigSpecProcessorUtils.processSingleConfigSpec(ConfigSpecProcessorUtils.java:64) count=218(%100,00)
O-app//wt.epm.query.pom.LatestFoundHandler.process(LatestFoundHandler.java:79) count=218(%100,00)
O-app//wt.epm.query.pom.impl.POMProcessor.execute(POMProcessor.java:1719) count=218(%100,00)
O-app//wt.epm.query.pom.impl.POMProcessor.execute(POMProcessor.java:1737) count=218(%100,00)
O-app/jdk.proxy2/jdk.proxy2.$Proxy.find(Unknown Source) count=218(%100,00)
O-app//wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) count=218(%100,00)
[email protected]/java.lang.reflect.Method.invoke(Method.java:568) count=218(%100,00)
[email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) count=218(%100,00)
O-jdk.internal.reflect.GeneratedMethodAccessor345.invoke(Unknown Source) count=218(%100,00)
O-app//wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:673) count=218(%100,00)
O-app//wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2083) count=218(%100,00)
O-app//wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:2052) count=218(%100,00)
O-app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077) count=218(%100,00)
O-app//wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:880) count=218(%100,00)
O-app//wt.pds.BasicResultCursor.next(BasicResultCursor.java:83) count=218(%100,00)
O-app//wt.pds.BasicResultCursor.advance(BasicResultCursor.java:235) count=218(%100,00)
- Windchill database tempdb is growing drastically
- No error reported in Windchill log files
- No error reported in Thingworx log files
This is a printer-friendly version of Article 411701 and may be out of date. For the latest version click CS411701