Article - CS279730
Import project plan in 'Sync' mode is slow in Windchill ProjectLink 11.0 M030
Modified: 31-Jul-2018
Applies To
- Windchill ProjectLink 11.0 M030
Description
- Import project plan in 'Sync' mode takes 1 to 2 minutes
- Stack trace for repeating SQL from Windchill Profile:
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 = ?))
This is a printer-friendly version of Article 279730 and may be out of date. For the latest version click CS279730