IBM Support

Creating a WO using SR from the Catalog takes too long

Troubleshooting


Problem

It takes 30 to 60 seconds to create a WO when creating a WO using Service Request (SR) from the Service Catalog. This is with SRM 7.1.0.3 and Maximo 7.1.1.4.

Cause

Overly complex where clause in database relationships for some Maximo objects. For example, see this relationship's where clause:

Name: DOCLINKS
Parent: WOACTIVITY
Child: DOCLINKS
WhereClause:
(ownertable='WOACTIVITY' and ownerid=:workorderid) or (ownertable='WOACTIVITY' and ownerid in (select workorderid from workorder where parent=:wonum and istask=:yes and siteid=:siteid)) or (ownertable='ASSET' and ownerid in (select assetuid from asset where assetnum=:assetnum and siteid=:siteid)) or (ownertable='LOCATIONS' and ownerid in (select locationsid from locations where location=:location and siteid=:siteid)) or (ownertable='JOBPLAN' and ownerid in (select jobplanid from jobplan where jpnum=:jpnum and (siteid is null or siteid=:siteid))) or (ownertable='PM' and ownerid in (select pmuid from pm where pmnum=:pmnum and siteid=:siteid)) or (ownertable='SAFETYPLAN' and ownerid in (select safetyplanuid from safetyplan,wosafetyplan where safetyplan.safetyplanid=wosafetyplan.safetyplanid and wosafetyplan.wonum=:wonum and wosafetyplan.siteid=:siteid)) or (ownertable in ('SR','INCIDENT','PROBLEM') and ownerid in (select ticketuid from ticket,relatedrecord where ticketid=recordkey and ticket.class = relatedrecord.class and relatedrecclass='WOCHANGE' and relatedreckey=:wonum and relatedrecsiteid=:siteid)) or (ownertable in ('WORKORDER','WOCHANGE','WORELEASE') and ownerid in (select workorderid from workorder,relatedrecord where wonum=recordkey and workorder.woclass = relatedrecord.class and relatedrecclass='WOCHANGE' and relatedreckey=:wonum and relatedrecsiteid=:siteid)) or (ownertable='COMMLOG' and ownerid in (select commloguid from workorder,commlog where workorderid=ownerid and ownertable='WOACTIVITY')) or (ownertable='SLA' and ownerid in (select PLUSPSERVAGREEID from sla,slarecords,workorder where sla.slanum=slarecords.slanum and slarecords.ownerid=workorder.workorderid and sla.objectname='WOCHANGE' and slarecords.ownertable='WOACTIVITY' and workorder.wonum=:wonum))

Environment

SRM 7.1.0.3 (and earlier versions)
Maximo 7.1.1.4 (and earlier versions)

Resolving The Problem

This is fixed in Maximo Base Services (TPAE or MBS) 7.1.1.5. If you cannot go to that level or later at this time then do these steps to correct the issue. As this is a circumvent, back up your database prior to makeing the change and after the change test it to confirm it is behaving as you wish.

1) Open "Database Configuration"
2) On the list tab, find each of these objects and in turn make changes listed later.
- WOACTIVITY
- WORKORDER
- WOCHANGE
- PMSCSO
3) Go to the Relationships tab
4) Filter for the DOCLINKS relationship with child object of DOCLINKS
5) Change the Where Clause to the following for the given Object:
- WOACTIVITY
(ownertable='WOACTIVITY' and ownerid=:workorderid)
- WORKORDER
(ownertable='WORKORDER' and ownerid=:workorderid)
- WOCHANGE
(ownertable='WOCHANGE' and ownerid=:workorderid)
- PMSCSO
(ownertable='PMSCSO' and ownerid=:poid)


Note: This changes the behavior of the query. Yes, it is faster, but it no longer shows when there are attachments on the parent record. Consider whether this makes sense for your environment.

[{"Product":{"code":"SS6HJK","label":"Tivoli Service Request Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF027","label":"Solaris"},{"code":"PF016","label":"Linux"},{"code":"PF002","label":"AIX"}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
27 February 2019

UID

swg21448072