1. Home
  2. Support
Article - CS1354

Poorly performing Sql Query during upload from PRO/Engineer in Windchill PDMLink 9.1

Modified: 25-Apr-2013   


Applies To

Windchill PDMLink 9.1 F000-M040

Description

  • Poorly performing Sql Query during upload from PRO/Engineer in Windchill
  • Related SQL
SELECT 'wt.epm.structure.EPMReferenceLink', A1.asStoredChildName
...
  FROM EPMDocument A0, EPMDocumentMaster A0B, EPMReferenceLink A1, BaselineMember A2
 WHERE (A0.idA3masterReference = A0B.idA2A2)
   AND (
           (
               (
                   (
                       A1.idA3A5 IN (
                        SELECT /*+ CARDINALITY(wtot 400) */ *
                          FROM TABLE(cast(? as TABLE_OF_NUMBER)) wtot
                         WHERE (ROWNUM                 > 0)
                           AND (column_value IS NOT NULL)
                       )
                   )
               AND (A1.idA3B5              = A0.idA3masterReference)
               )
           )
       AND (
               (A2.idA3A5              = ?)
           AND (A0.idA2A2              = A2.idA3B5)
           )
       ):count                 = 1
  • Related Stack trace observed in a Windchill Profile
com.ptc.core.adapter.server.impl.SimpleTaskDispatcher$ServiceThread.run(SimpleTaskDispatcher.java:532)
com.ptc.core.adapter.server.impl.SimpleTaskDispatcher$ServiceThread.processRequest(SimpleTaskDispatcher.java:998)
com.infoengine.soap.RPCHandler.postProcess(RPCHandler.java:1212)
com.infoengine.soap.RPCHandler.postProcess(RPCHandler.java:1377)
com.infoengine.SAK.ManagementWebject.invoke(ManagementWebject.java:81)
com.infoengine.webject.mgt.DispatchTasks.invoke(DispatchTasks.java:618)
com.infoengine.SAK.Task.executeTask(Task.java:1944)
com.infoengine.SAK.Task.invoke(Task.java:1730)
com.infoengine.SAK.Task.executeTaskRemotely(Task.java:2059)
com.infoengine.procunit.adapter.Adapter.send(Adapter.java:390)
wt.method.WTAdapterImpl.processRequest(WTAdapterImpl.java:477)
wt.method.WTAdapterImpl.processTask(WTAdapterImpl.java:688)
com.infoengine.SAK.Task.invoke(Task.java:1783)
com.infoengine.compiledTasks.file.opt.ptc$2ddc.windchill.tasks.com.ptc.windchill.uwgm.execute$2exml.invoke(execute$2exml.java:65)
com.infoengine.SAK.ExternalWebject.invoke(ExternalWebject.java:119)
com.infoengine.SAK.Webject.invoke(Webject.java:491)
com.infoengine.procunit.webject.WebjectProcessor.processTask(WebjectProcessor.java:210)
com.infoengine.procunit.webject.WebjectProcessor.invokeWebject(WebjectProcessor.java:573)
java.lang.reflect.Method.invoke(Method.java:597)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
sun.reflect.GeneratedMethodAccessor651.invoke(Unknown Source)
com.ptc.windchill.uwgm.soap.impl.uwgm.Service_aux.execute(Service_aux.java:68)
com.ptc.windchill.uwgm.soap.impl.uwgm.Service_i.execute(Service_i.java:171)
com.ptc.windchill.uwgm.soap.impl.uwgm.ProEServiceHandler.doExecute(ProEServiceHandler.java:86)
com.ptc.windchill.uwgm.proesrv.ProeService.execute(ProeService.java:75)
com.ptc.windchill.uwgm.proesrv.ProeService.executeTransaction(ProeService.java:97)
com.ptc.windchill.uwgm.proesrv.UwgmTransactionExecuterImpl.executeTransaction(UwgmTransactionExecuterImpl.java:49)
com.ptc.windchill.uwgm.proesrv.UwgmTransactionExecuterImpl.execute(UwgmTransactionExecuterImpl.java:86)
com.ptc.windchill.uwgm.proesrv.StandardRequestDispatcher.scanRequests(StandardRequestDispatcher.java:733)
com.ptc.windchill.uwgm.proesrv.StandardRequestDispatcher.dispatchRequest(StandardRequestDispatcher.java:849)
com.ptc.windchill.uwgm.proesrv.request.EpmUploadRequest.executeRequest(EpmUploadRequest.java:111)
com.ptc.windchill.uwgm.proesrv.upload.UwgmUploadHelper.upload(UwgmUploadHelper.java:115)
com.ptc.windchill.uwgm.proesrv.upload.UwgmUploadHelper.uploadND(UwgmUploadHelper.java:140)
com.ptc.windchill.uwgm.proesrv.action.UwgmAction.execute(UwgmAction.java:77)
com.ptc.windchill.uwgm.proesrv.action.UploadNDAction.executeAction(UploadNDAction.java:121)
wt.epm.upload.EPMUploadManagerFwd.upload(EPMUploadManagerFwd.java:84)
wt.epm.upload.EPMStandardUploadManager.upload(EPMStandardUploadManager.java:320)
wt.epm.upload.EPMStandardUploadManager.staticUpload(EPMStandardUploadManager.java:415)
wt.epm.upload.EPMUpload.execute(EPMUpload.java:560)
wt.epm.upload.Cache.queryAndCacheDocumentsWithDependents(Cache.java:709)
wt.epm.upload.Cache.loadDependencies(Cache.java:865)
wt.epm.query.Query.executeList(Query.java:70)
wt.epm.query.Query.execute(Query.java:65)
wt.epm.query.AbstractQuery.execute(AbstractQuery.java:229)
wt.epm.query.pom.impl.POMProcessor.execute(POMProcessor.java:328)
wt.epm.query.pom.impl.POMProcessor.executeInteranal(POMProcessor.java:274)
wt.epm.query.pom.impl.ConfigSpecEvaluator.execute(ConfigSpecEvaluator.java:56)
wt.epm.query.pom.impl.ConfigSpecEvaluator.execute(ConfigSpecEvaluator.java:69)
wt.epm.query.pom.impl.ConfigSpecEvaluator.processConfigSpec(ConfigSpecEvaluator.java:109)
wt.epm.query.pom.impl.ConfigSpecEvaluator.processMultiLineConfigSpec1(ConfigSpecEvaluator.java:155)
wt.epm.query.pom.impl.ConfigSpecEvaluator.processConfigSpecLine(ConfigSpecEvaluator.java:269)
wt.epm.query.pom.WTConfigSpecHandler.process(WTConfigSpecHandler.java:45)
wt.epm.query.pom.impl.POMProcessor.execute(POMProcessor.java:1703)
wt.epm.query.pom.impl.POMProcessor.execute(POMProcessor.java:1717)
wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:3524)
wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:4346)
wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:4448)
wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1146)
wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:808)
wt.pds.BasicResultCursor.next(BasicResultCursor.java:530)
This is a printer-friendly version of Article 1354 and may be out of date. For the latest version click CS1354