IV82067: MAM7506- INVENTORY SHOWS TOOL WHEN ITEMNUM IS OF TYPE ITEM IN ANOTHER ITEMSET

APAR status

• Closed as program error.

Error description

• PROBLEM:
  
  MAM7506- Inventory shows tool when itemnum is of type ITEM in
  another itemset
  
  
  ENVIRONMENT:
  
  IBM WebSphere Application Server 7.0.0.35
  IBM Maximo Asset Management 7.5.0.6 Build 20140404-0000 DB Build
  V7506-00
  IBM Maximo for Transportation 7.5.1.0-20160112-1031 Build
  20160112-1031 DB Build V7510-10 HFDB Build HF7510-31
  Tivoli's process automation engine 7.5.0.6-IFIX20160202-1611
  Build 20140404-0005 DB Build V7506-33 HFDB Build HF7506-32
  IBM Maximo for Service Providers 7.5.3.0-20150129-1213 Build
  20150129-1213 DB Build V7530-19 HFDB Build HF7530-05
  IBM Maximo Asset Configuration Manager 7.5.1.1-20160212-1325
  Build 20110623-0835 DB Build V7511-06 HFDB Build HF7511-33
  IBM Maximo Asset Management Scheduler 7.5.2.0 Build
  20140404-0005 DB Build V7520-158 HFDB Build HF7520-20
  IBM TPAE Integration Framework 7.5.1.1 Build 20140411-2000 DB
  BuildV7511-01
  Windows Server 2008 6.0 build 6002 Service Pack 2
  Oracle 11.2 (Oracle Database 11g Enterprise Edition Release
  11.2.0.4.0
  
  STEPS TO REPRODUCE:
  
  Prereq:
  
  A)
  -Create two different ORG with two different Itemsets
  -Switch insert site before creating the Tool
  (so basically using other itemsetid  that in turn means
  switching
  insert site)
  
  B)
  1)Create item in itemset 1234_I ( itemtype will be set to ITEM)
  2)Add item to storeroom
  3)Create tool with same itemnum in second itemset:5678_I (
  itemtype
  will be set to TOOL?)
  4)Add tool to storeroom
  5)Open ?Stocked tools application? in site with itemset 5678_I
  --> Tool qty will be shown
  6)Open ?Inventory? application in site with itemset 5678_I
  N.B!: Tool will be shown should not be visible here
  
  FURTHER ANALYSIS:
  
  If the Tool is existing in another itemset it will be shown then
  
  If the tool is not existing as item in another itemset, it will
  be
  not shown
  
  But please also look in classfile
  
  Relationship in package psdi.webclient.beans.inventory is wrong:
  
  package psdi.webclient.beans.inventory;
  
  import java.rmi.RemoteException;
  
  import java.util.Hashtable;
  
  import psdi.mbo.MboSetRemote;
  
  import psdi.util.MXException;
  
  import psdi.webclient.system.beans.ResultsBean;
  
  public class InventoryResultsBean extends ResultsBean
  
  {
  
    Hashtable savedInventoryQbeAttributes = new Hashtable();
  
    protected MboSetRemote getMboSetRemote()
  
      throws MXException, RemoteException
  
    {
  
      MboSetRemote mboSetRemote = super.getMboSetRemote();
  
      mboSetRemote.setRelationship("exists (select 1 from item
  where
  itemnum = inventory.itemnum and itemtype in (select value from
  synonymdomain where domainid='ITEMTYPE' and maxvalue =
  'ITEM'))");
  
     mboSetRemote.reset();
  
      return mboSetRemote;
  
    }
  
  Itemset is missing, relationship should be as follows
  
  mboSetRemote.setRelationship("exists (select 1 from item where
  itemnum = inventory.itemnum and itemsetid = inventory.itemsetid
  and
  itemtype in (select value from synonymdomain where
  domainid='ITEMTYPE' and maxvalue = 'ITEM'))");
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Inventory shows tools when the current itemset has tools     *
  * with the same itemnum as items in another itemset.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to latest version.                                   *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following package:
                         | 7.5.0.10 of Base Services.
  

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:

Modules/Macros

• Maximo
  

Fix information

• Fixed component name

  INVENTORY

• Fixed component ID

  5724R46IN

Applicable component levels