IV37214: DATABASE ERROR NUMBER 17006 ON ASSET STATUS CHANGE AFTER TAMIT UPGRADE/BASE SERVICES UPGRADE

APAR status

• Closed as user error.

Error description

• Upon upgrading to TAMIT 7.2.2.1/Base Services 7.1.1.10, the
  client gets
  an error message when changing status of either one, or multiple
  assets;
  
  Other symptoms:
  An overwhelming number of iface/JMS errors in Systemerr log;
  Example entry from systemerr.log:
  [8/27/12 11:45:19:786 PDT] 00000046 SystemErr     R Caused by:
  psdi.util.MXSystemException: BMXAA4210E - Database error number
  17006
  has occurred.
  
  Steps to Reproduce:
  On the Assets List tab/Change Status dialog, select multiple
  records;
  Click on the Change Status button on the toolbar and select a
  new
  status, such as Operating; click OK
  Error message appears(listed for each record):
  "BMXAA4210E - Database error number 17006 has occurred."
  
  Same result when performing status change on a single record in
  Assets
  application
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• The problem is a NO_REP.  After user reapplied the hotfixes and
  the problem was resolved.  There was no code changes for this
  apar. The L2 support person informed me that the PMR was closed.
  

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

  ASSETS

• Fixed component ID

  5724R46AS

Applicable component levels