IV07879: BMXAA4210E OCCURS AFTER UN-CHECK MARK "HAZARDOUS MATERIAL ENABLED?" AND MOVING BACK TO "HAZARDOUS MATERIALS" TAB.

APAR status

• Closed as program error.

Error description

• ENVIRONMENT:
  Customer environment:
  Environment:
  Database: Oracle
  Weblogic Application Server 10.3.5.0
  IBM Maximo for Nuclear Power 7.5.0.0 Build 20110415-2127 DB
  Build V7500-17
  Tivoli's process automation engine 7.5.0.0 Build 20110413-2230
  DB Build
  IBM Maximo Calibration 7.5.0.0 Build 20110413-2230 DB Build
  V7500-13
  IBM Maximo Asset Management 7.5.0.0 Build 20110415-0030 DB Build
  V7500-00
  
  L2 test environment:
  Database : DB2
  App Server   IBM WebSphere Application Server 7.0
  IBM Maximo Asset Management 7.5.0.0 Build 20110415-0030 DB Build
  V7500-00
  Tivoli's process automation engine 7.5.0.0 Build 20110413-2230
  DB Build V7500-721
  IBM Maximo for Nuclear Power 7.5.0.0 Build 20110415-2127 DB
  Build V7500-17
  
  Server OS   Windows Server 2008 R2 6.1 build 7601 Service Pack 1
  
  PROBLEM:
  BMXAA4210E occurs after uncheck mark "Hazardous Material
  Enabled?" and moving to "Hazardous Materials" tab.
  
  LOCATION OF LOGS:
  n/a
  
  STEPS TO RECREATE:
  1) Select menu "Goto > Work Orders > Work Order Tracking(nuc)"
  2) Click "New Work Order" Button.
  3) Click Tab "Safety Plan"
  4) Click button "New Row" on "Hazards and Precautions" tab
  5) Input the "Hazard item" from "Detail Menu", and check mark
  "Hazardou Material Enabled?" option.
  6) Click the tab of the "Hazardous Materials".
  7) Click the tab of "Hazards and Precautions", and uncheck mark
  "Hazardous Material Enabled?" option.
  8) Click the tab of the "Hazardous Materials". The following
  dialog appears.
  
  BMXAA4210E - Database error number 904 has occurred.  Invalid
  SQL queries are logged in the log file.  Check the SQL query to
  identify therror.
  
  Please refer to GUI flows in the following excel file.
  /ecurep/pmr/4/7/47525,999,760/2011-08-29/47525,999,760_0829.zip
  
  <Log message>
  [ERROR] [MXServer] [] BMXAA6714E - Data for the next record in
  the mboset could not be retrieved for the SQL: select * from
  wpmaterialwhere wonum =  '1265'  and itemnum in (select itemnum
  from item where hazardid =  'KK0001'
   java.sql.SQLSyntaxErrorException: ORA-00904: "HAZARDID":
  invalid identifier
  
  
  L3's comment:
  I am able to reproduce the problem within the Base Services Work
  Order application as well.
  

Local fix

• Do not move tabs after un-check mark "Hazardous Material
  Enabled?".
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Maximo Users                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: STEPS TO RECREATE:                      *
  *                                                              *
  *                      1) Select menu "Goto > Work Orders >    *
  *                      Work Order Tracking(nuc)"               *
  *                                                              *
  *                      2) Click "New Work Order" Button.       *
  *                                                              *
  *                      3) Click Tab "Safety Plan"              *
  *                                                              *
  *                      4) Click button "New Row" on "Hazards   *
  *                      and Precautions" tab                    *
  *                                                              *
  *                      5) Input the "Hazard item" from "Detail *
  *                      Menu", and check mark "Hazardou         *
  *                      Material Enabled?" option.              *
  *                                                              *
  *                      6) Click the tab of the "Hazardous      *
  *                      Materials".                             *
  *                                                              *
  *                      7) Click the tab of "Hazards and        *
  *                      Precautions", and uncheck mark          *
  *                      "Hazardous Material Enabled?" option.   *
  *                                                              *
  *                      8) Click the tab of the "Hazardous      *
  *                      Materials". The following dialog        *
  *                      appears.                                *
  *                                                              *
  *                      BMXAA4210E - Database error number 904  *
  *                      has occurred.  Invalid SQL queries are  *
  *                      logged in the log file.  Check the SQL  *
  *                      query to identify the error.            *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  An error (BMXAA4210E) occurs after unchecking the Hazardous
  Material enabled flag and then moving back to the Hazardous
  Materials tab.
  

Problem conclusion

• Modified the query that was used to check if hazard material
  enabled flag could be set to false.
  
  
  
  
  
  The fix for this APAR is contained in the following maintenance
  package:
  
    | release\fix pack | REL 7.5.0.1 - BS
  

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

  WORK ORDERS

• Fixed component ID

  5724R46WO

Applicable component levels

• R750 PSY

     UP