APAR status
Closed as program error.
Error description
steps to replicate: maxdemo 6.2.3 with Calibration 6.5 , weblogic 8.1 SP4, oracle 10g steps to add Copy link doc to work order Adding/Exposing the COPYLINKTOWO check box The customer will have to add the COPYLINKTOWO checkbox to two common dialogs in order to be able to set the value: ??ttachment Properties?dialog ??reate a file Attachment?dialog This change needs to be made to the LIBRARY.XML file: 1. Login to MXES 2. Open the Application Designer application 3. Select the Action to Export System XML 4. Export the LIBRARY.XML file Once the LIBRARY.XML has been exported, open the file and make the following changes. Change to Attachment Properties (search for ?ttachment Properties? and add the bold blue line below <dialog id="linkproperties" label="Attachment Properties" > <section id="linkproperties_1" border="true" > <textbox id="linkproperties_1_2" label="Created in Folder:" dataattribute="doctype" inputmode="readonly" /> <textbox id="linkproperties_1_3" dataattribute="doctypes.description" /> <checkbox id="linkproperties_1_4" label="Print with Work Pack:" dataattribute="printthrulink" /> <checkbox id="linkproperties_1_5" label="Copy Link to WO:" dataattribute="COPYLINKTOWO" /> <textbox id="linkproperties_1_6" label="Version:" dataattribute="docversion" /> <textbox id="linkproperties_1_7" dataattribute="urlname" label="Path:" /> <textbox id="linkproperties_1_8" dataattribute="description" /> <textbox id="linkproperties_1_9" label="Created By:" dataattribute="createby" /> <textbox id="linkproperties_1_10" dataattribute="createdate" label="Created Date:" /> </section> Change to Create a file Attachment (search for ?reate a file Attachment? <dialog id="addnewattachmentfile" label="Create a File Attachment" relationship="DOCLINKS" beanclass="psdi.webclient.beans.doclinks.AddDocLinksBean" > <defaultvalue id="addnewattachments_file_d1" dataattribute="urltype" value="FILE" /> <section id="addnewattachments_file_1" > <combobox id="addnewattachments_file_1_2" label="Select a Folder" dataattribute="doctype" displayattribute="doctype" /> <attachdoc id="addnewattachments_file_1_8" label="Specify a file" /> <multiparttextbox id="addnewattachments_file_1_4" label="Name the document" dataattribute="document" descdataattribute="description" /> </section> <section id="addnewattachments_file_2" label="Advanced Options" collapsed="true" > <checkbox id="addnewattachments_file_2_row2_col1_1_1" label="Copy document to the default location set by your administrator (recommended)" dataattribute="upload" /> <checkbox id="addnewattachments_file_2_row3_col1_1_1" label="Add document to the document library for others to use" dataattribute="show" /> <checkbox id="addnewattachments_file_2_1" label="Print document with work pack" dataattribute="printthrulink" /> <checkbox id="addnewattachments_file_2_2" label="Copy Link to WO" dataattribute="COPYLINKTOWO" /> </section> Import the Updated LIBRARY.XML Save the LIBRARY.XML file after making the changes and then in Application Designer use the Import Application Definition action (toolbar button), select the LIBRARY.XML file you just updated and click the OK button to import the changed file. You?l now see the Copy Link to WO? Checkbox in the Create a file Attachment, Advanced section and will be able to check it to enable this for the newly attached file. You?l also be able to modify this option for previously attached documents when you click on the Attachment Properties (information icon) within the View Attached Documents dialog. When the Attachment Properties dialog is opened, the Copy Link to WO checkbox will be available. Check the box to enable this functionality. ------------------------------------------ login to maximo go to locations (cal) app, attach a new document to location ADDR2001 click advanced option tick the Copy link to WO checkbox go to job plans app, bring up a job plan called IT-ISSUE add 172 tasks to the job plan save and change the status to ACTIVE go to work order tracking app create a new work order enter location ADDR2001 enter job plan IT-ISSUE tab out select value dialog box comes up untick Show Job Plans for the Work Order's Asset and Location Only? checkbox click refresh select IT-ISSUE it takes a long time for the job plan field to be populated with IT-ISSUE below is the sql statement that's causing the full table scan: select * from doclinks where (ownertable='WORKORDER' and ownerid= 2068 ) or (ownertable='WORKORDER' and ownerid in (select workorderid from workorder where parent= '1172' and istask=1 and siteid= 'BEDFORD' )) or (ownertable='ASSET' and ownerid in (select assetuid from asset where assetnum= '' and siteid= 'BEDFORD' )) or (ownertable='LOCATIONS' and ownerid in (select locationsid from locations where location= 'ADDR2001' and siteid= 'BEDFORD' )) or (ownertable='JOBPLAN' and ownerid in (select jobplanid from jobplan where jpnum= 'IT-ISSUE' and (siteid is null or siteid= 'BEDFORD' ))) or (ownertable='PM' and ownerid in (select pmuid from pm where pmnum= '' and siteid= 'BEDFORD' )) or (ownertable='SAFETYPLAN' and ownerid in (select safetyplanuid from safetyplan,wosafetyplan where safetyplan.safetyplanid=wosafetyplan.safetyplanid and wosafetyplan.wonum= '1172' and wosafetyplan.siteid= 'BEDFORD' )) or (ownertable in ('SR','INCIDENT','PROBLEM') and ownerid in (select ticketuid from ticket,relatedrecord where ticketid=recordkey and ticket.class = relatedrecord.class and relatedrecclass='WORKORDER' and relatedreckey= '1172' and relatedrecsiteid= 'BEDFORD' )) or (ownertable in ('WOCHANGE','WORELEASE','WOACTIVITY') and ownerid in (select workorderid from workorder,relatedrecord where wonum=recordkey and workorder.woclass = relatedrecord.class and relatedrecclass='WORKORDER' and relatedreckey= '1172' and relatedrecsiteid= 'BEDFORD' )) or (ownertable='COMMLOG' and ownerid in (select commloguid from workorder,commlog where workorderid=ownerid and ownertable='WORKORDER')) or (ownertable='SLA' and ownerid in (select slaid from sla,slarecords,workorder where sla.slanum=slarecords.slanum and slarecords.ownerid=workorder.workorderid and sla.objectname='WORKORDER' and slarecords.ownertable='WORKORDER' and workorder.wonum= '1172' )) 12 Sep 2009 10:25:25:859 [INFO] USER = (WILSON) SPID = (Unable to get spid) app (null) object (DOCINFO) :select * from docinfo where docinfoid= 11
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: ALL * **************************************************************** * PROBLEM DESCRIPTION: steps to replicate: * * * * maxdemo 6.2.3 * * * * steps to add Copy link doc to work * * order * * * * Adding/Exposing the COPYLINKTOWO check * * box * * * * The customer will have to add the * * COPYLINKTOWO checkbox to two * * * * common dialogs in order to be able to * * set the value: * * * * ??ttachment Properties?dialog * * * * ??reate a file Attachment?dialog * * * * This change needs to be made to the * * LIBRARY.XML file: * * * * 1. Login to MXES * * * * 2. Open the Application Designer * * application * * * * 3. Select the Action to Export System * * XML * * * * 4. Export the LIBRARY.XML file * * * * Once the LIBRARY.XML has been exported, * * open the file and make * * * * the following changes. * * * * Change to Attachment Properties (search * * for ?ttachment * * * * Properties? and add the bold blue line * * below * * * * <dialog id="linkproperties" * * label="Attachment Properties" > * * * * <section id="linkproperties_1" * * border="true" > * * * * <textbox id="linkproperties_1_2" * * label="Created in * * * * Folder:" dataattribute="doctype" * * inputmode="readonly" /> * * * * <textbox id="linkproperties_1_3" * * * * dataattribute="doctypes.description" /> * * * * <checkbox id="linkproperties_1_4" * * label="Print with Work * * * * Pack:" dataattribute="printthrulink" /> * * * * <checkbox id="linkproperties_1_5" * * label="Copy Link to WO:" * * * * dataattribute="COPYLINKTOWO" /> * * * * <textbox id="linkproperties_1_6" * * label="Version:" * * * * dataattribute="docversion" /> * * * * <textbox id="linkproperties_1_7" * * dataattribute="urlname" * * * * label="Path:" /> * * * * <textbox id="linkproperties_1_8" * * * * dataattribute="description" /> * * * * <textbox id="linkproperties_1_9" * * label="Created By:" * * * * dataattribute="createby" /> * * * * <textbox id="linkproperties_1_10" * * * * dataattribute="createdate" * * label="Created Date:" /> * * * * </section> * * * * Change to Create a file Attachment * * (search for ?reate a file * * * * Attachment? * * * * <dialog id="addnewattachmentfile" * * label="Create a File * * * * Attachment" relationship="DOCLINKS" * * * * beanclass="psdi.webclient.beans.doclink * * s.AddDocLinksBean" > * * * * <defaultvalue * * id="addnewattachments_file_d1" * * * * dataattribute="urltype" value="FILE" /> * * * * <section id="addnewattachments_file_1" * * > * * * * <combobox * * id="addnewattachments_file_1_2" * * label="Select a * * * * Folder" dataattribute="doctype" * * displayattribute="doctype" /> * * * * <attachdoc * * id="addnewattachments_file_1_8" * * label="Specify * * * * a file" /> * * * * <multiparttextbox * * id="addnewattachments_file_1_4" * * * * label="Name the document" * * dataattribute="document" * * * * descdataattribute="description" /> * * * * </section> * * * * <section id="addnewattachments_file_2" * * label="Advanced * * * * Options" collapsed="true" > * * * * <checkbox * * id="addnewattachments_file_2_row2_col1_ * * 1_1" * * * * label="Copy document to the default * * location set by your * * * * administrator (recommended)" * * dataattribute="upload" /> * * * * <checkbox * * id="addnewattachments_file_2_row3_col1_ * * 1_1" * * * * label="Add document to the document * * library for others to use" * * * * dataattribute="show" /> * * * * <checkbox * * id="addnewattachments_file_2_1" * * label="Print * * * * document with work pack" * * dataattribute="printthrulink" /> * * * * <checkbox * * id="addnewattachments_file_2_2" * * label="Copy Link * * * * to WO" dataattribute="COPYLINKTOWO" /> * * * * </section> * * * * Import the Updated LIBRARY.XML * * * * Save the LIBRARY.XML file after making * * the changes and then in * * * * Application Designer use the Import * * Application Definition * * * * action (toolbar button), select the * * LIBRARY.XML file you just * * * * updated and click the OK button to * * import the changed file. * * * * You?l now see the Copy Link to WO? * * Checkbox in the Create a * * * * file Attachment, Advanced section and * * will be able to check it * * * * to enable this for the newly attached * * file. * * * * You?l also be able to modify this * * option for previously * * * * attached documents when you click on * * the Attachment Properties * * * * (information icon) within the View * * Attached Documents dialog. * * * * When the Attachment Properties dialog * * is opened, the Copy Link * * * * to WO checkbox will be available. * * Check the box to enable this * * * * functionality. * * * * * * * * * * * * * * * * * * * * 1. Create a Jobplan X that has 38 * * tasks, status = ACTIVE * * * * 2. Attach a doc to Asset ABC (status is * * operating) and check "copy link to * * workorder" for that document * * * * 3. Create a new workorder for Asset ABC * * and Jobplan X that has 38 tasks * * * * 4. also you can see lots of attachment * * to the work order via the view * * attachment dialog box. Query the * * DOCLINK table for the new workorder - * * the unexpected result is that there are * * 39 DOCLINK records, not 1 * * * **************************************************************** * RECOMMENDATION: * * * * * * * **************************************************************** PERFORMANCE PROBLEM WHEN ATTACHING JOB PLAN WITH ATTACHED DOC
Problem conclusion
Fixed in a script. Available in Hotfix 6.2.3 and 6.2.4.
Temporary fix
Comments
APAR Information
APAR number
IZ60370
Reported component name
WORK ORDER TRAC
Reported component ID
5724R46WO
Reported release
621
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2009-09-10
Closed date
2009-09-17
Last modified date
2009-09-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
MAXIMO
Fix information
Fixed component name
WORK ORDER TRAC
Fixed component ID
5724R46WO
Applicable component levels
R621 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHPPU","label":"Work Order Tracking"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"621","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
17 September 2009