IV86035: TPAE7506-DB ERROR DURING TRANSFERR OF BIG NUMBER OF ROTATING ASSETS

APAR status

• Closed as program error.

Error description

• PROBLEM DESCRIPTION:
  TPAE7506-DB Error during transferring a big number of rotating
  items in ICD 7.5
  
  ENVIRONMENT:
  Tivoli's process automation engine 7.5.0.6-IFIX20140617-1631
  Build
  20140404-0005 DB Build V7506-33 HFDB Build HF7506-01
  Asset Management for IBM SmartCloud Control Desk 7.5.1.2 Build
  201407211230 DB Build V7512-03
  IBM Maximo for Service Providers 7.5.1.2-20140630-1659 Build
  20130520-1027 DB Build V7512-13 HFDB Build HF7512-04
  7.5.1.1-MIF_7511_IFIX.20140618-1039 Build 20140411-2000 DB Build
  V7511-01
  
  App Server IBM WebSphere Application Server 7.0.0.17
  Server OS  Linux 2.6.32-358.el6.x86_64
  Server DB  DB2/LINUXX8664 9.7 (SQL09075)
  
  STEPS TO REPRODUCE:
  
  Pre Setup Steps:
  
  1) Go to Item Master. Create a new item ROT10 in BEDFORD.
  Rotating is checked. Order and Issue Unit is EACH.
  Create Specifications with 10 attributes.
  Change Status to Active to Organization and Inventory.
  Add Items to Storeroom. Site=BEDFORD and Storeroom=CENTRAL.
  Issue Cost Type=AVERAGE.
  Add Items to Storeroom. Site=FLEET and Storeroom=ATLANTA. Issue
  Cost Type=AVERAGE.
  2) Go to PO. Create a PO. In POLine, Item=ROT10. Quantity=2000.
  Unit Cost=1. Storeroom=CENTRAL.  Save and Approve.
  3) Go to Receiving app, click Select Ordered Items. Select
  POLine 1. Save.
  Then Action->Receiving Rotating Assets. Click Autonumber. OK.
  4) Increase out of box property mxe.inventory.maxInvUseLineLimit
  value.
  Go to System Properties, find mxe.inventory.maxInvUseLineLimit
  Change the global value to 2000. Save the change and do a Live
  Refresh.
  After the Live Refresh, the current value is 2000.
  5) Click Profile. Change Default Insert Site to FLEET.
  6) Creating a HOLDING type of Location in FLEET site.
  Go to Locations. Create a new Location=RECEIVING.Type=HOLDING.
  GL Account=6170-400-000.
  7) Click Profile. Change Default Insert Site to BEDFORD.
  8) Creating Cross Site Shipment.
  Go to Inventory Usage. Create a new record. From
  Storeroom=CENTRAL. Usage Type=TRANSFER.
  Create New Row. Item=ROT10. To Site=FLEET. To Storeroom=ATLANTA.
  Quantity=2000. Save.
  9) Change Status to Shipped. Split Usage Quantity dialog will be
  displayed.
  Click Auto Spilt to get 1000 Rotating Assets. Click OK
  10) Create Shipment dialog will be displayed. Note the
  Shipment#. Click OK.
  11) Based on attached ShipReceivingEasierUsage.docx to create
  "Select All Shipped Items" in Select Shipped Items dialog.
  This document is well written and easy to follow.
  12) Please refer to IV85563 for new property
  mxe.app.receiving.countOfRecordsForCommit.
  The default value is set to 50 based on a typical
  environment/memory.
  Client could set it to a smaller number if their
  environment/memory is smaller.
  ============================
  
  Steps in Shipment Receiving:
  
  1) Go To Shipment Receiving. Find Step 10 Shipment#. Site is
  FLEET.
  Click "Select Shipped Items" button.
  2) After Step 11, you will see "Select All Shipped Items"
  button.
  
  The Shipped Items dialog only displayed 15 items Out of box.
  
  PLEASE NOTE:
  (also mentioned in ShipReceivingEasierUsage.docx)
  Click the Select All Shipped Items.  This will mark all 1000
  records as selected even though the screen is showing only 15
  records. Please note, due to the restriction without system UI
  code, you will not see the records checked, but the auto
  scripting code calls all the records to be selected. Click OK.
  This will create all 1000 records and return to the
  Shipment screen.
  SAVE.
  Result: 2000 MatRecTrans will be created. Type is SHIPRECEIPT.
  Status is WASSET.
  3) Action->Receiving Rotating Items, 1000 Asset will be
  displayed.
  click OK.
  
  Result:
  2000 MatRecTrans TRANSFER Type COMP Status will be created.
  2000 MatRecTrans SHIPRECEIPT Type, Status is updated to COMP.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ERROR DURING TRANSFER (SHIPMENT RECEIVING) OF BIG NUMBER OF  *
  * ROTATING ASSETS WITH 10 ATTRIBUTES CROSS SITES               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply Release 7.5.0.11 of Base Services or request an        *
  * interim fix                                                  *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  		 | Release 7.5.0.11 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

  SYSTEM PERFORMA

• Fixed component ID

  5724R46PF

Applicable component levels