Article - CS327061
Slow workspace or EPM Documents requests in Windchill PDMLink with Microsoft SQL Server
Modified: 21-Jul-2024
Applies To
- Windchill PDMLink 11.1 M020 to 13.0
- Microsoft SQL Server
Description
- Takes 8 - 9 minutes to load, activate, Check-in, check-out in workspace with thousands objects
- Happens in standalone Web Browser also
- The table view is OOTB
- No dominant JDBC bottleneck from Windchill point
- Small workspaces with small number of objects get loaded correctly
- Creo hangs or takes long time to load when switching to a large Workspace
- CAD Document information page is slow
- e.g. EPM Document Details > WVS attributes, Content > Representations/Annotations table may takes 1 minute to display.
- SQL below returns large data to Method Server
SELECT 'wt.content.ApplicationData',A0.authoredBy,A0.blob$clientData,A0.category,A0.chapterDelegate,A0.checksum,A0.clientData, A0.comments,A0.classnamekeyA4,A0.idA3A4,A0.description,A0.distributable,A0.fileName,A0.fileSize,...,A1.idA3B5,...A1.idA2A2,A1.updateCountA2,CONVERT(varchar,A1.updateStampA2,120) FROM ApplicationData A0,HolderToContent A1 WHERE ((A0.role = ?)) AND ((A1.idA3B5 = A0.idA2A2) AND (A1.idA3A5 IN (SELECT item FROM #wtarray13236_1057413564)))
- The elapsed time distribution is as below
wt.session.SessionContextDestroyer.doFilterInternal [100%] . wt.httpgw.FilterChainImpl.doFilter [100%] . | wt.httpgw.HTTPAuthGatewayServlet.serviceWithoutFilters [100%] . | . wt.httpgw.HTTPGatewayServlet.serviceWithoutFilters [100%] . | . | wt.httpgw.MethodRequestHandler.handleRequest [100%] . | . | . wt.httpgw.HTTPServer.processRequest [100%] . | . | . | java.lang.reflect.Method.invoke [100%] . | . | . | . sun.reflect.DelegatingMethodAccessorImpl.invoke [100%] . | . | . | . | sun.reflect.GeneratedMethodAccessor495.invoke [100%] . | . | . | . | . com.ptc.windchill.uwgm.soap.impl.uwgm.BinaryRequestHandler.getCacheDescriptor [100%] . | . | . | . | . | com.ptc.windchill.uwgm.soap.impl.uwgm.BinaryRequestHandler.processRequest [100%] . | . | . | . | . | . com.ptc.windchill.uwgm.proesrv.ProeService.execute [100%] . | . | . | . | . | . | com.ptc.windchill.uwgm.proesrv.ProeService.executeTransaction [100%] . | . | . | . | . | . | . com.ptc.windchill.uwgm.proesrv.UwgmTransactionExecuterImpl.executeTransaction [100%] . | . | . | . | . | . | . | com.ptc.windchill.uwgm.proesrv.UwgmTransactionExecuterImpl.execute [100%] . | . | . | . | . | . | . | . com.ptc.windchill.uwgm.proesrv.StandardRequestDispatcher.scanRequests [100%] . | . | . | . | . | . | . | . | com.ptc.windchill.uwgm.proesrv.ProeServiceRequestDispatcher.postScanRequests [100%] . | . | . | . | . | . | . | . | . com.ptc.windchill.uwgm.proesrv.rrc.RequestResultCache.postProcess [100%] . | . | . | . | . | . | . | . | . | com.ptc.windchill.uwgm.proesrv.rrc.RequestResultCache.processProductViewInfo [63.33%] . | . | . | . | . | . | . | . | . | . com.ptc.windchill.uwgm.proesrv.rrc.RRCVisualizationHelper.setPVInfo [63.33%] . | . | . | . | . | . | . | . | . | . | com.ptc.wvs.server.ui.UIHelper.getPartStructurePVHTML [63.33%] . | . | . | . | . | . | . | . | . | . | . com.ptc.wvs.server.ui.UIHelper.getProductViewHTML [40%] . | . | . | . | . | . | . | . | . | . | . | com.ptc.wvs.server.ui.UIHelper.initializeCreoViewUrl [40%] . | . | . | . | . | . | . | . | . | . | . | . com.ptc.wvs.server.util.PublishUtils.hasAccess [40%] . | . | . | . | . | . | . | . | . | . | . | . | com.ptc.wvs.server.util.PublishUtils.checkDownloadPermissionsForRepresentations [40%] . | . | . | . | . | . | . | . | . | . | . | . | . com.ptc.wvs.server.util.FileHelper.getEdFile [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | com.sun.proxy.$Proxy262.getContentsByRole [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.services.ServiceFactory$ServerInvocationHandler.invoke [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | java.lang.reflect.Method.invoke [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . sun.reflect.DelegatingMethodAccessorImpl.invoke [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | sun.reflect.GeneratedMethodAccessor698.invoke [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.content.StandardContentService.getContentsByRole [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | wt.fc.StandardPersistenceManager.query [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.fc.StandardPersistenceManager.query [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | wt.fc.StandardPersistenceManager._query [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.pom.PersistentObjectManager.query [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | wt.pom.PersistentObjectManager.query [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.pds.SQLDatabasePds.query [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | wt.pds.BasicResultCursor.next [40%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.pds.SequentialResultBuilder.build [33.33%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | wt.pds.StandardACProcessor.processResults [33.33%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.pds.PersistableItemBuilder.build [33.33%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | wt.pds.WTResultSet.readObject [33.33%] . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.content._ApplicationData.readExternal [26.67%]
This is a printer-friendly version of Article 327061 and may be out of date. For the latest version click CS327061