アーティクル - CS449461
同じ選択肢に対して新しい変更されていないリリースアクティビティが作成されると、Windchill ESI レスポンス xml の生成に時間がかかります。
修正日: 25-Jul-2025
適用対象
- Windchill PDMLink 12.1
説明
同じ選択肢に対して新しい変更されていないリリースアクティビティが作成されると、Windchill ESI レスポンス xml の生成に時間がかかります。
プロファイラーからのスタック トレース:-
プロファイラーからのスタック トレース:-
O-cost=147025:SessionThread-50[SQL+Execution Time+Bind Parameters]{4eiixnp3;mdb3sji7;8676;fu04l2;23268}:count=3957681
O-cost=147025:wt.session.SessionThread.run(SessionThread.java:225):count=3957681
O-cost=146884:com.ptc.windchill.esi.txn.ESIResponseGenerator.run(ESIResponseGenerator.java:1706):count=3957555
| O-cost=146884:com.ptc.windchill.esi.tgt.delegate.DefaultESITargetProcessor.doOperation(DefaultESITargetProcessor.java:203):count=3957555
| O-cost=146884:com.ptc.windchill.esi.txn.ESIResponseGenerator.generateResponse(ESIResponseGenerator.java:625):count=3957555
| O-cost=146884:com.ptc.windchill.esi.txn.ESIResponseGenerator.getECN(ESIResponseGenerator.java:1061):count=3957555
| O-cost=146884:com.ptc.windchill.esi.svc.StandardESIService.getECN(StandardESIService.java:2453):count=3957555
| O-cost=146884:com.ptc.windchill.esi.ecn.ESIWTChangeOrder2Renderer.getECN(ESIWTChangeOrder2Renderer.java:1416):count=3957547
| | O-cost=146884:com.ptc.windchill.esi.rnd.BasicESIRenderer.render(BasicESIRenderer.java:1155):count=3957547
| | O-cost=146633:com.ptc.windchill.esi.ecn.ESIWTChangeOrder2Renderer.buildGroups(ESIWTChangeOrder2Renderer.java:592):count=3957508
| | | O-cost=146617:com.ptc.windchill.esi.ecn.ESIWTChangeOrder2Renderer.buildDetail(ESIWTChangeOrder2Renderer.java:900):count=3957493
| | | | O-cost=146617:com.ptc.windchill.esi.bom.ESIBOMRenderer.getBOM(ESIBOMRenderer.java:1065):count=3957481
| | | | | O-cost=146617:com.ptc.windchill.esi.rnd.BasicESIRenderer.render(BasicESIRenderer.java:1155):count=3957481
| | | | | O-cost=145769:com.ptc.windchill.esi.bom.ESIBOMRenderer.buildGroups(ESIBOMRenderer.java:767):count=3955187
| | | | | | O-cost=145769:com.ptc.windchill.esi.rnd.BasicESIRenderer.renderExpressions(BasicESIRenderer.java:2946):count=3955187
| | | | | | O-cost=145769:wt.introspection.ReflectionHelper.dynamicInvoke(ReflectionHelper.java:139):count=3955187
| | | | | | O-cost=145769:wt.introspection.ReflectionHelper.dynamicInvoke(ReflectionHelper.java:175):count=3955187
| | | | | | O-cost=145769:java.base/java.lang.reflect.Method.invoke(Method.java:566):count=3955187
| | | | | | O-cost=145769:java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43):count=3955187
| | | | | | O-cost=145769:java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62):count=3955187
| | | | | | O-cost=145769:java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method):count=3955187
| | | | | | O-cost=145538:com.ptc.windchill.esi.ov.OptionsVariantsHelper.renderExpressions(OptionsVariantsHelper.java:586):count=3953467
| | | | | | | O-cost=145520:com.ptc.windchill.esi.rnd.BasicESIRenderer.render(BasicESIRenderer.java:1155):count=3953440
| | | | | | | | O-cost=145520:com.ptc.windchill.esi.ov.ExpressionRenderer.buildGroups(ExpressionRenderer.java:231):count=3953440
| | | | | | | | O-cost=145520:com.ptc.windchill.esi.ov.ExpressionRenderer.renderOptionsAndChoices(ExpressionRenderer.java:313):count=3953440
| | | | | | | | O-cost=145520:com.ptc.windchill.esi.ov.OptionRenderer.getOptionAndChoices(OptionRenderer.java:168):count=3953440
| | | | | | | | O-cost=145520:com.ptc.windchill.esi.rnd.BasicESIRenderer.render(BasicESIRenderer.java:1155):count=3953440
| | | | | | | | O-cost=144662:com.ptc.windchill.esi.ov.OptionRenderer.buildGroups(OptionRenderer.java:334):count=3948839
| | | | | | | | | O-cost=143831:com.ptc.windchill.esi.ov.OptionRenderer.processChoices(OptionRenderer.java:445):count=3947098
| | | | | | | | | | O-cost=93684:com.ptc.windchill.esi.txn.ESITransactionUtility.latestObjectExport(ESITransactionUtility.java:2643):count=1973722
| | | | | | | | | | | O-cost=93684:com.sun.proxy.$Proxy29.find(Unknown Source):count=1973722
| | | | | | | | | | | O-cost=93684:wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399):count=1973722
| | | | | | | | | | | O-cost=93684:java.base/java.lang.reflect.Method.invoke(Method.java:566):count=1973722
| | | | | | | | | | | O-cost=93684:java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43):count=1973722
| | | | | | | | | | | O-cost=93684:jdk.internal.reflect.GeneratedMethodAccessor293.invoke(Unknown Source):count=1973722
| | | | | | | | | | | O-cost=93684:wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:657):count=1973722
| | | | | | | | | | | O-cost=93684:wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:1998):count=1973722
| | | | | | | | | | | O-cost=93684:wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1967):count=1973722
| | | | | | | | | | | O-cost=93684:wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077):count=1973722
| | | | | | | | | | | O-cost=93684:wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:880):count=1973722
| | | | | | | | | | | O-cost=93684:wt.pds.BasicResultCursor.next(BasicResultCursor.java:82):count=1973722
| | | | | | | | | | | O-cost=92065:wt.pds.BasicResultCursor.advance(BasicResultCursor.java:225):count=1972842
| | | | | | | | | | | | O-cost=92065:DB FETCH: SELECT 'com.ptc.windchill.option.model.Choice',A0.administrativeLockIsNull,A0.typeadministrativeLock,A0.blob$entrySetadHocAcl,A0.checkoutInfoIsNull,A0.statecheckoutInfo,A0.classnamekeycontainerReferen,A0.idA3containerReference,A0.description,A0.classnamekeydomainRef,A0.idA3domainRef,A0.entrySetadHocAcl,A0.eventSet,A0.classnamekeyA2folderingInfo,A0.idA3A2folderingInfo,A0.classnamekeyB2folderingInfo,A0.idA3B2folderingInfo,A0.hasHangingChange,A0.hasInstanceValue,A0.hasPendingChange,A0.hasResultingChange,A0.hasSuspect,A0.hasVariance,A0.indexersindexerSet,A0.inheritedDomain,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,TO_CHAR(A0.datelock,'dd mm yyyy hh24:mi:ss'),A0.classnamekeyA2lock,A0.idA3A2lock,A0.notelock,A0.classnamekeymasterReference,A0.idA3masterReference,A0.classnamekeyA2ownership,A0.idA3A2ownership,A0.securityLabels,A0.atGatestate,A0.classnamekeyA2state,A0.idA3A2state,A0.statestate,A0.teamIdIsNull,A0.classnamekeyteamId,A0.idA3teamId,A0.teamTemplateIdIsNull,A0.classnamekeyteamTemplateId,A0.idA3teamTemplateId,TO_CHAR(A0.createStampA2,'dd mm yyyy hh24:mi:ss'),A0.markForDeleteA2,TO_CHAR(A0.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0.idA2A2,A0.updateCountA2,TO_CHAR(A0.updateStampA2,'dd mm yyyy hh24:mi:ss'),A0.branchIdA2typeDefinitionRefe,A0.idA2typeDefinitionReference,A0.versionIdA2versionInfo,A0.versionLevelA2versionInfo,A0.versionSortIdA2versionInfo,A0B.classnamekeycontainerReferen,A0B.idA3containerReference,A0B.dataValue,A0B.dataValuePrecision,A0B.OptionNumber,A0B.choiceNumber,A0B.optionDataType,A0B.classnamekeyA6,A0B.idA3A6,A0B.series,TO_CHAR(A0B.createStampA2,'dd mm yyyy hh24:mi:ss'),A0B.markForDeleteA2,TO_CHAR(A0B.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0B.classnameA2A2,A0B.idA2A2,A0B.updateCountA2,TO_CHAR(A0B.updateStampA2,'dd mm yyyy hh24:mi:ss'),'com.ptc.windchill.esi.tgt.ESITarget',A2.administrativeLockIsNull,A2.typeadministrativeLock,A2.classnamekeycontainerReferen,A2.idA3containerReference,A2.defaultForContext,A2.description,A2.classnamekeydomainRef,A2.idA3domainRef,A2.eventSet,A2.inheritedDomain,A2.name,A2.ESITargetNumber,A2.responseMetaInfoPath,A2.securityLabels,A2.status,A2.system,A2.taskURI,TO_CHAR(A2.createStampA2,'dd mm yyyy hh24:mi:ss'),A2.markForDeleteA2,TO_CHAR(A2.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A2.idA2A2,A2.updateCountA2,TO_CHAR(A2.updateStampA2,'dd mm yyyy hh24:mi:ss'),A2.branchIdA2typeDefinitionRefe,A2.idA2typeDefinitionReference FROM ATOChoice A0,ATOChoiceMaster A0B,ReleaseActivity A1,ESITarget A2 WHERE (A0.idA3masterReference=A0B.idA2A2) AND ((A2.idA2A2 = A1.idA3B5) AND (A0.idA2A2 = A1.idA3A5) AND (A1.releaseClass = ?) AND ((A1.status = ?) OR (A1.status = ?)) AND (A0.idA3masterReference = ?)) AND ((A0.markForDeleteA2 = 0) AND (A1.markForDeleteA2 = 0) AND (A2.markForDeleteA2 = 0)):count=1972842
| | | | | | | | | | | | '-cost=793:[com.ptc.windchill.esi.Choice, pending, succeeded, 1254052147]:count=4174
| | | | | | | | | | | | '-cost=650:[com.ptc.windchill.esi.Choice, pending, succeeded, 1254051999]:count=8350
| | | | | | | | | | | | '-cost=609:[com.ptc.windchill.esi.Choice, pending, succeeded, 5138898498]:count=8008
| | | | | | | | | | | | '-cost=594:[com.ptc.windchill.esi.Choice, pending, succeeded, 3588083426]:count=4172
| | | | | | | | | | | | '-cost=549:[com.ptc.windchill.esi.Choice, pending, succeeded, 3471982324]:count=8348
.
.
.
,
So on- 非常に多くのSQL実行
FETCH: SELECT 'com.ptc.windchill.option.model.Choice',A0.administrativeLockIsNull,A0.typeadministrativeLock,A0.blob$entrySetadHocAcl,A0.checkoutInfoIsNull,A0.statecheckoutInfo,A0.classnamekeycontainerReferen,A0.idA3containerReference,A0.description,A0.classnamekeydomainRef,A0.idA3domainRef,A0.entrySetadHocAcl,A0.eventSet,A0.classnamekeyA2folderingInfo,A0.idA3A2folderingInfo,A0.classnamekeyB2folderingInfo,A0.idA3B2folderingInfo,A0.hasHangingChange,A0.hasInstanceValue,A0.hasPendingChange,A0.hasResultingChange,A0.hasSuspect,A0.hasVariance,A0.indexersindexerSet,A0.inheritedDomain,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,TO_CHAR(A0.datelock,'dd mm yyyy hh24:mi:ss'),A0.classnamekeyA2lock,A0.idA3A2lock,A0.notelock,A0.classnamekeymasterReference,A0.idA3masterReference,A0.classnamekeyA2ownership,A0.idA3A2ownership,A0.securityLabels,A0.atGatestate,A0.classnamekeyA2state,A0.idA3A2state,A0.statestate,A0.teamIdIsNull,A0.classnamekeyteamId,A0.idA3teamId,A0.teamTemplateIdIsNull,A0.classnamekeyteamTemplateId,A0.idA3teamTemplateId,TO_CHAR(A0.createStampA2,'dd mm yyyy hh24:mi:ss'),A0.markForDeleteA2,TO_CHAR(A0.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0.idA2A2,A0.updateCountA2,TO_CHAR(A0.updateStampA2,'dd mm yyyy hh24:mi:ss'),A0.branchIdA2typeDefinitionRefe,A0.idA2typeDefinitionReference,A0.versionIdA2versionInfo,A0.versionLevelA2versionInfo,A0.versionSortIdA2versionInfo,A0B.classnamekeycontainerReferen,A0B.idA3containerReference,A0B.dataValue,A0B.dataValuePrecision,A0B.OptionNumber,A0B.choiceNumber,A0B.optionDataType,A0B.classnamekeyA6,A0B.idA3A6,A0B.series,TO_CHAR(A0B.createStampA2,'dd mm yyyy hh24:mi:ss'),A0B.markForDeleteA2,TO_CHAR(A0B.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0B.classnameA2A2,A0B.idA2A2,A0B.updateCountA2,TO_CHAR(A0B.updateStampA2,'dd mm yyyy hh24:mi:ss'),'com.ptc.windchill.esi.tgt.ESITarget',A2.administrativeLockIsNull,A2.typeadministrativeLock,A2.classnamekeycontainerReferen,A2.idA3containerReference,A2.defaultForContext,A2.description,A2.classnamekeydomainRef,A2.idA3domainRef,A2.eventSet,A2.inheritedDomain,A2.name,A2.ESITargetNumber,A2.responseMetaInfoPath,A2.securityLabels,A2.status,A2.system,A2.taskURI,TO_CHAR(A2.createStampA2,'dd mm yyyy hh24:mi:ss'),A2.markForDeleteA2,TO_CHAR(A2.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A2.idA2A2,A2.updateCountA2,TO_CHAR(A2.updateStampA2,'dd mm yyyy hh24:mi:ss'),A2.branchIdA2typeDefinitionRefe,A2.idA2typeDefinitionReference FROM ATOChoice A0,ATOChoiceMaster A0B,ReleaseActivity A1,ESITarget A2 WHERE (A0.idA3masterReference=A0B.idA2A2) AND ((A2.idA2A2 = A1.idA3B5) AND (A0.idA2A2 = A1.idA3A5) AND (A1.releaseClass = ?) AND ((A1.status = ?) OR (A1.status = ?)) AND (A0.idA3masterReference = ?)) AND ((A0.markForDeleteA2 = 0) AND (A1.markForDeleteA2 = 0) AND (A2.markForDeleteA2 = 0))
- 多数のSQL実行を引き起こしたAPI
com.ptc.windchill.esi.txn.ESITransactionUtility.latestObjectExport(ESITransactionUtility.java:2643)
最新バージョンはこちらを参照ください CS449461