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 number
IJ32251
Reported component name
MAXIMO ASST MGM
Reported component ID
5724R46AM
Reported release
760
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-04-21
Closed date
2021-10-19
Last modified date
2021-10-19
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
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760"}]
Document Information
Modified date:
20 October 2021