IJ32251: IN THE ASSETS APPLICATION, WHEN HYPERLINKING TO A CLONED APPLICATION THE WHERE CLAUSE USED TO DISPLAY RECORDS IS NOT UPDATED

APAR status

• Closed as program error.

Error description

• PROBLEM:
  In the Assets application, when hyperlinking to a
  cloned application the where clause used to display records is
  not updated, but instead uses a cached value from a previously
  used where clause.
  
  This issue can be reproduced in two
  different ways.
  So there are 2 separate reproduction scenarios
  below.
  
  STEPS TO REPRODUCE - Scenario 1:
   1. Create a clone of
  the Work Order application:
  
  Application Name =
  MMWORKORDER
  Application Description = Work Order Tracking -
  MM
  
  2. In the Security Groups application, for the MAXADMIN
  group create this data restriction:
  
  Object:
  WORKORDER
  Application: MMWORKORDER
  Type: Qualified
  Condition
  Expression: :WORKTYPE in ('CP')
  
  3. In the Work Order
  application create a Work Order (1318) add Asset 1001 to it and
  set the Work Type to "CP".
  
  4. Create another clone of the Work
  Order application:
  
  Application Name = MM1WOTRACK
  Application
  Description = Work Order Tracking PM
  
  5. In the Security Groups
  application, for the MAXADMIN group create this data
  restriction:
  
  Object: WORKORDER
  Application: MM1WOTRACK
  Type:
  Qualified
  Condition Expression: :WORKTYPE in ('PM')
  
  6. Go to
  the Assets application and find asset 1001 and go to the "Work"
  tab.
  Choose WO 1318 (description MM1 - CP Work Type) and
  hyperlink to the "Work Order Tracking - MM" application.
  The
  work order displays.
  
  Go to the list tab and view the where
  clause it is:
  
  ((siteid = 'BEDFORD' and wonum = '1318')) and
  (1=1) and ((workorder.worktype in ('CP')))
  
  Click Cancel and
  return to the Assets application.
  
  7. Select the same Work
  Order (1318) and now hyperlink to the "Work Order Tracking PM"
  application.
  
  No data is displayed, view the where clause it
  is:
  
  ((siteid = 'BEDFORD' and wonum = '1318')) and (1=1) and
  ((workorder.worktype in ('CP')))
  
  It is expected that the where
  clause should show:
  
  ((siteid = 'BEDFORD' and wonum = '1318'))
  and (1=1) and ((workorder.worktype in ('PM')))
  
  Because we are
  accessing the "Work Order Tracking PM" application.
  
  8. Click
  cancel and return to the assets application.
  
  Refresh the
  record by going to the "Find Asset" field and searching on
  Asset 1001.
  
  Repeat step 7. The where clause now shows as
  expected:
  
  ((siteid = 'BEDFORD' and wonum = '1318')) and (1=1)
  and ((workorder.worktype in ('PM')))
  
  CURRENT ERRONEOUS
  RESULT:
  A cached where clause from a previous query is
  used.
  
  EXPECTED RESULT:
  The where clause is updated when
  hyperlinking from the asset record.
  
  LOCAL FIX:
  If you refresh
  the Asset record (by searching on it) and then follow the repro
  steps, then the correct where clause is then used.
  
  REPORTED
  IN:
  Tivoli's process automation engine
  7.6.0.8-IFIX20171025-1353 Build 20170512-0100 DB Build V7608-63
  HFDB Build HF7608-07
  
  STEPS TO REPRODUCE - Scenario 2:
  1)
  Create Global Data Restriction Object Restriction
  Application
  -> name of cloned app Type -> Qualified
  
  Condition
  :worktype in
  (select worktype from worktype where type='CAL')
  
  2) Clone the
  Work Order Tracking Application
  
  3) log off/on
  
  4) Go to
  Service Requests
  
  5) Open a Service Request which has a
  location
  
  6) Select View Work Details from the Detail Menu of
  the Location (this requires one or more WOs specifying the same
  location to already exist)
  ==> this produces a list of work
  orders
  
  7) From the list of work orders, select a Work Order
  and click on the detail menu
  
  8) Go To cloned application
  
  9)
  View where clause
  ==> note that the condition has been appended
  to the where clause
  
  10) Return
  
  11) Go To Work order Tracking
  from the detail menu for the work order
  
  12) View where
  clause
  
  CURRENT ERRONEOUS RESULT:
  ==> the condition is still
  appended
  
  EXPECTED RESULT:
  The condition should not be
  appended
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * IN THE ASSETS APPLICATION, WHEN HYPERLINKING TO A CLONED     *
  * APPLICATION THE WHERE CLAUSE USED TO DISPLAY RECORDS IS NOT  *
  * UPDATED                                                      *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 7.6.1.3 Product
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels