技术文章 - CS279730

在 Windchill ProjectLink 11.0 M030 中以“同步”模式导入项目计划速度很慢

已修改: 26-Dec-2022   


注意:本文已使用机器翻译软件翻译,以方便非英语客户阅读。但翻译内容可能包含语法错误或不准确之处。请注意, PTC对本文所含信息的翻译准确性及使用后果不承担任何责任。请在 此处 查看本文的英文原始版本以便参考。有关机器翻译的更多详情,请单击 此处
感谢您告诉我们。我们将尽快审阅此译文。

适用于

  • Windchill ProjectLink 11.0 M030

说明

  • 在“同步”模式下导入项目计划需要 1 到 2 分钟
  • 从 Windchill 配置文件重复 SQL 的堆栈跟踪:
com.ptc.projectmanagement.msproject.StandardMspService.importPlan(StandardMspService.java:166)
com.ptc.projectmanagement.msproject.MspImporter.importPlan(MspImporter.java:331)
com.sun.proxy.$Proxy246.rollUpStatus(Unknown Source)
wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
java.lang.reflect.Method.invoke(Method.java:498)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
sun.reflect.GeneratedMethodAccessor423.invoke(Unknown Source)
com.ptc.projectmanagement.plan.StandardHealthStatusService.rollUpStatus(StandardHealthStatusService.java:124)
com.sun.proxy.$Proxy247.rollUpHealthStatus(Unknown Source)
wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
java.lang.reflect.Method.invoke(Method.java:498)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
sun.reflect.GeneratedMethodAccessor425.invoke(Unknown Source)
com.ptc.projectmanagement.plan.StandardEPPCustomEventHandlerService.rollUpHealthStatus(StandardEPPCustomEventHandlerService.java:655)
com.ptc.projectmanagement.plan.StandardEPPCustomEventHandlerService.rollupForSummaries(StandardEPPCustomEventHandlerService.java:760)
com.ptc.projectmanagement.plan.PlanHealthStatusRollupHandler.rollUpHealthStatus(PlanHealthStatusRollupHandler.java:62)
com.ptc.projectmanagement.util.PlannableUtils.calculateLocalCriticalPath(PlannableUtils.java:866)
com.ptc.projectmanagement.ilog.ganttmodel.GanttModelSaveUtility.getPersistables(GanttModelSaveUtility.java:75)
com.sun.proxy.$Proxy248.getPersistables(Unknown Source)
wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
java.lang.reflect.Method.invoke(Method.java:498)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
sun.reflect.GeneratedMethodAccessor421.invoke(Unknown Source)
com.ptc.projectmanagement.ilog.StandardILogService.getPersistables(StandardILogService.java:375)
wt.fc.ObjectReference.getObject(ObjectReference.java:735)
wt.fc.DefaultInflator.get(DefaultInflator.java:153)
wt.fc.DefaultInflator$AbstractCache.get(DefaultInflator.java:259)
wt.fc.DefaultInflator$AbstractCache.get(DefaultInflator.java:291)
wt.fc.DefaultInflator$OidCache.inflate(DefaultInflator.java:375)
wt.fc.DefaultInflator$OidCache.inflate(DefaultInflator.java:383)
com.sun.proxy.$Proxy11.refresh(Unknown Source)
wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
java.lang.reflect.Method.invoke(Method.java:498)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
wt.fc.StandardPersistenceManager.refresh(StandardPersistenceManager.java:517)
wt.fc.StandardPersistenceManager.refresh(StandardPersistenceManager.java:1083)
wt.fc.StandardPersistenceManager.restore(StandardPersistenceManager.java:1911)
wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1261)
wt.pom.PersistentObjectManager.refresh(PersistentObjectManager.java:1477)
wt.pds.SQLDatabasePds.refresh(SQLDatabasePds.java:2258)
wt.pds.SQLDatabasePds.refresh(SQLDatabasePds.java:2396)
wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:642)
wt.util.TraceTimingResource.close(TraceTimingResource.java:65)
wt.util.TraceTimingCompositeLogger.addEndEntry(TraceTimingCompositeLogger.java:41)
java.util.concurrent.CopyOnWriteArrayList.forEach(CopyOnWriteArrayList.java:890)
wt.util.TraceTimingCompositeLogger.lambda$addEndEntry$10(TraceTimingCompositeLogger.java:41)
wt.fc.profiling.SQLExecutionTimeProfilingLogger.addEndEntry(SQLExecutionTimeProfilingLogger.java:103)
SELECT 'com.ptc.projectmanagement.plan.PlanActivity',TO_CHAR(A0.actualFinishDate,'dd mm yyyy hh24:mi:ss'),TO_CHAR(A0.actualStartDate,'dd mm yyyy hh24:mi:ss'),A0.administrativeLockIsNull,A0.typeadministrativeLock,A0.afterDeadline,A0.beforeDeadline,TO_CHAR(A0.constraintDate,'dd mm yyyy hh24:mi:ss'),A0.constraintType,A0.classnamekeycontainerReferen,A0.idA3containerReference,A0.critical,TO_CHAR(A0.deadline,'dd mm yyyy hh24:mi:ss'),A0.description,A0.classnamekeydomainRef,A0.idA3domainRef,A0.doneEffortIsNull,A0.durationFormatdoneEffort,A0.millisdoneEffort,A0.durationIsNull,A0.durationFormatduration,A0.millisduration,A0.effortDriven,A0.eventSet,TO_CHAR(A0.finishDate,'dd mm yyyy hh24:mi:ss'),A0.fixedCost,A0.hasDeliverable,A0.healthStatusDescription,A0.healthStatusType,A0.inheritedDomain,A0.lineNumber,A0.milestone,A0.name,A0.classnamekeyA2ownership,A0.idA3A2ownership,A0.classnamekeyparentReference,A0.idA3parentReference,A0.percentWorkComplete,A0.plannableState,A0.remainingEffortIsNull,A0.durationFormatremainingEffor,A0.millisremainingEffort,A0.riskDescription,A0.riskType,A0.rolledUpCost,A0.classnamekeyrootReference,A0.idA3rootReference,A0.securityLabels,A0.showInTimeline,TO_CHAR(A0.startDate,'dd mm yyyy hh24:mi:ss'),A0.summary,A0.taskType,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.totalCost,A0.totalEffortIsNull,A0.durationFormattotalEffort,A0.millistotalEffort,A0.trackingIntent,A0.branchIdA2typeDefinitionRefe,A0.idA2typeDefinitionReference FROM PlanActivity A0 WHERE ((A0.idA2A2 = ?))

这是文章 279730 的 PDF 版本,可能已过期。最新版本 CS279730