IJ37505: RECEIVED ERROR BMXAA4210E ? DATABASE ERROR FOR INVALID SEQUENCE WHEN REVISING A CONTRACT

APAR status

• Closed as program error.

Error description

• PROBLEM:
  When revising a contract that was previously approved, received
  error BMXAA4210E ? Database error for Invalid sequence when
  revising a contract when saving the record.  Revising the
  contract either by updating to data or changing the status upon
  Save causes the error to display but the updates are applied
  successfully.
  
  STEPS TO REPRODUCE:
  1. Move to the Warranty Contracts application
  2. Create a new contract
  3. Populate the vendor field
  4. Move to the Contract Lines tab
  5. Under Contact Lines select the New Row button
  6. Enter in the required information (Item description,
  Duration, Time Unit)
  7. Under More Actions select Authorize Sites
  8. Select the Bedford site and select the OK button
  9. Change the status of the Contract to APPR
  10. Move to the Associated Assets tab
  11. Under the Assets/Locations section select the New Row button
  
  12. Populate the Asset field
  13. Save the Contract
  14. Under More Actions select Revise Contract
  15. Populate the description field and select the OK button
  16. In the Revise contract that was just created, change the
  status to APPR
  17. Under More Actions select Revise Contract again (the
  revision number should be 2)
  18. Populate the description field and select the OK button
  
  
  Expected Results:
  The contract should be revised successfully
  
  Results:
  Error BMXAA4210E - Database error number 17274 has occurred.
  Invalid SQL queries are logged in the log file gets thrown when
  attempting to revise the contract
  
  
  Reported In Version:
  Tivoli's process automation engine 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PROBLEM:                                                     *
  * When revising a contract that was previously approved,       *
  * received                                                     *
  * error BMXAA4210E                                             *
  ****************************************************************
  

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