IV96865: UPDATE MODELNUM FROM MATRECTRANS TO INVENTORY TABLE NOT WORKING ON ESCALATION ACTION.

APAR status

• Closed as program error.

Error description

• PROBLEM:
  I created an escalation to update MODELNUM from MATRECTRANS
  table to
  INVENTORY table. When escalation trigged, I got the
  notification but it
  did not update the MODELNUM attribute.
  
  Error in logs:
  
  05 May 2017 09:49:03:121 [ERROR] [MIF] [CID-CRON-35332] Failed
  to
  execute action  on escalation: {1110} reference point: {1,315}
  for
  object {MATRECTRANS} with id {536040}
  psdi.util.MXAccessException: BMXAA0024E - The action ADD is not
  allowed
  on object INVVENDOR. Verify the business rules for the object
  and
  define the appropriate action for the object.
   at psdi.mbo.MboSet.checkMethodAccess(MboSet.java:6956)
   at psdi.mbo.MboSet.addAtIndex(MboSet.java:4691)
   at psdi.mbo.MboSet.add(MboSet.java:4624)
   at psdi.mbo.MboSet.add(MboSet.java:4506)
   at
  psdi.app.inventory.Inventory.addUpdateInvVendor(Inventory.java:9
  80)
   at psdi.app.inventory.Inventory.save(Inventory.java:942)
   at psdi.mbo.MboSet.saveMbos(MboSet.java:7854)
   at psdi.mbo.MboSet.validateTransaction(MboSet.java:7834)
   at
  psdi.txn.MXTransactionImpl.validateTransaction(MXTransactionImpl
  .java:37
  5)
  
  PERFORMANCE ISSUE:no
  
  STEPS TO REPRODUCE:
  We use Receiving app to receive rotating and non-rotating item.
  We need
  update model number during Change Inspection Status. There is no
  internal PO in the process.
  
  1. Go to Receiving app.
  
  2. Select a PO in WINSP status.
  
  3. Take an action - Change Inspection Status. Input
  Model(matrectrans.modelnum), click OK.
  4. Escalation take place to update modelnum from
  matrectrans.modelnum
  to inventory.modelnum
  
  Additional information on the Escalation record:
  As a part of the escalation run an Action on Object Matrectrans:
  Type: setvalue
  value: :modelnum
  Parameter/Attribute: Inventory.modelnum
  Accessible from: All
  
  CURRENT ERRONEOUS RESULT:
  Model number not changing in Inventory record
  EXPECTED RESULT:
  Model Number should change in Inventory record
  
  ADDITIONAL INFO:
  
  ENVIRONMENT (SYSTEM INFO):
  App Server IBM WebSphere Application Server 8.5.5.9
  
  Version
  Tivoli's process automation engine 7.6.0.5 Build 20160611-0100
  DB Build
  V7605-45
  
  IBM Maximo Mobile 7.5.1.0 Build 20130305-1333 DB Build V7510-05
  
  IBM TPAE Integration Framework 7.6.0.5 Build 20160610-2330 DB
  Build
  V7605-50
  
  TPAE OSLC Object Structure 7.6.1.0 Build 20160907_132614-0500
  DB Build
  V7610-15
  
  IBM Maximo Anywhere 7.6.1.0 Build 20160907_132639-0500 DB Build
  V7610-10
  
  IBM Maximo Asset Management Work Centers 7.6.0.0 Build
  20160610-1318 DB
  Build V7600-38
  
  IBM Maximo Asset Management 7.6.0.5 Build 20160611-0100 DB
  Build V7604-
  01
  
  
  Server OS Windows Server 2012 R2 6.3
  
  Server DB Oracle 12.1 (Oracle Database 12c Enterprise Edition
  Release
  12.1.0.2.0 - 64bit Production With the Partitioning, OLAP,
  Advanced
  Analytics and Real Application Testing options)
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * UPDATE MODELNUM FROM MATRECTRANS TO INVENTORY TABLE NOT      *
  * WORKING ON ESCALATION ACTION.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• An access check on InvVendor was preventing the escalation from
  successfully completing and updating the ModelNum in Inventory.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.6.0.9 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

  SYSTEM CONFIG

• Fixed component ID

  5724R46S1

Applicable component levels

• R760 PSY

     UP