IV19049: BMXAA4219E - RECORD ALREADY EXISTS ADDING A NEW ROW TO THE JOB PLAN PREREQUITSITE

APAR status

• Closed as program error.

Error description

• Prob: adding a new row to the Job Plan Prerequitsite error
  BMXAA4219E - Record already exists. Part of T&D product.
  
  
  
  Envir: BS 7118, database?, Websphere 6.1, OS win2003
  
  
  Addon: Utilities 7.1.2 (T&D), Spatial 711, Scheduler 711,
  Project
  
  
  Client description:
  
  When adding a new row to the Job Plan Prerequitsite tab Error
  encountered "BMXAA4219E - Record already exists for
  Organisation=
  EAGLENA, Site=BEDFORD, Job Plan = JP11220, Task=10, Job Plan
  Revision
  Number=0"
  
  Client Fix:
  
   Customer advised
   The fix is very simple. Just add PLUSDISPREREQ as part of
   JOBTASK_NDX1, that way both Pre-requisites and Job Plan Tasks
  can
   have the same sequence number.
  
  ----------------------------------------------------------------
  
  Raised to L2 to confirm a bug and fix is correct remedy.
  ----------------------------------------------------------------
  
  
   http://mxeam8.torolab.ibm.com/maximo
  
  Tested in lab with T&D can reproduce the problem.
  
  Steps
  
  1. Logon to Maximo
  2. Goto the jobplan (T&D) application
  3. Select a jobplan (eg INS11200)
  4. On  Prerequisites add a entry "10" you will find you receive
  a error.
  
  BMXAA4129E - Record already exists for Organization=EAGLENA,
  Site=BEDFORD, Job Plan=INS11200, Task=10.
  
  Escalating to L3 asking if can be create a APAR
  
  ---------
  
  After discussion with L3 (M.E) they accepted this was a issue.
  
  Based on comments from Richard Tan, the next taskid/prerequisite
  is not
  being correctly generated in customer's environment. This was
  not clear
  in the first time. Then from now I agree that this is a problem
  and need
  to be fixed in Utilities 7.1.2. The same problema does not
  happen in a
  single Utilities 7.5.0.1 install.
  

Local fix

• none other then to alter index.
  
  Client Fix:
  
   Customer advised
   The fix is very simple. Just add PLUSDISPREREQ as part of
   JOBTASK_NDX1, that way both Pre-requisites and Job Plan Tasks
  can
   have the same sequence number.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Maximo Users on Utilities 712                *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Logon to Maximo                      *
  *                                                              *
  *                      2. Go to the jobplan (T&D) application  *
  *                                                              *
  *                      3. Create a jobplan                     *
  *                                                              *
  *                      4. Create a task 10                     *
  *                                                              *
  *                      5. Create a prerequisites, on the       *
  *                      insertion of new row,                   *
  *                                                              *
  *                      4. On  Prerequisites add a entry "10"   *
  *                      you will find you receive               *
  *                                                              *
  *                      a error.                                *
  *                                                              *
  *                      BMXAA4129E - Record already exists for  *
  *                      Organization=EAGLENA,                   *
  *                                                              *
  *                      Site=BEDFORD, Job Plan=Ixxxx, Task=10.  *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  BMXAA4219E - RECORD ALREADY EXISTS ADDING A NEW ROW TO THE JOB
  PLAN PREREQUITSITE
  

Problem conclusion

• When a new row is inserted into prerequisites, the next
  sequential number would appear, in this case, 20 is populated.
  
  It is important to note that Prerequisites and Tasks are the
  same thing (JOBTASK.JPTASK) behind the scenes and user cannot
  create a prerequisite having a same id of a task.
  
  
  
  
  
  The fix for this APAR is contained in the following maintenance
  package:
  
    | release\fix pack | REL 7.1.2.0 UTIL hotfix
  

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

  MAXIMO UTILITIE

• Fixed component ID

  5724R5600

Applicable component levels

• R711 PSY

     UP