IV25578: BMXAA3114E ERROR LOADING EMAIL/PHONE/SMS WITH MIF AND MXPERSON B

APAR status

• Closed as program error.

Error description

• Updating PHONE, EMAIL, or SMS records via MIF fails when
  
  attempting to delete existing records in order to replace
  them.
  
  
  Steps to replicate:
  
  1.  People appplication, query LIBERI.
  2.  Modify EMAIL records (click lookup next to Primary email
  field)
      so that there are three email addresses, flag the second
   one as the primary.  Click OK.
  3.  Create an external system for Flat file input, assign
  MXPERSONInterface
      and enable it.  (May need to first
   enable MXPERSON object structure for flatfile.)
  4.  Import this flat file, change "ext sys name" to your
  external system
  
      ext sys name,MXPERSONInterface,Replace,EN
   PERSONID,EMAILADDRESS,MAIL_ISPRIMARY
   LIBERI,liberi01@us.ibm.com,1
   LIBERI,liberi02@us.ibm.com,0
   LIBERI,liberi03@us.ibm.com,0
  
  This will error when deleting the existing records in order to
  replace
  them
  because the default flag is on second record.  Cannot delete
  primary
  email
  unless it's the last record.  (Deletes need to be sorted so that
  primary
  is
  deleted last.  I think this once existed but has been lost)
  
  If the existing email records have the last record flagged as
  default
  this will work.
  If default is not last, then error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: maximo                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: BMXAA3114E ERROR LOADING                *
  *                      EMAIL/PHONE/SMS WITH MIF AND MXPERSON   *
  *                      B                                       *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  BMXAA3114E ERROR LOADING EMAIL/PHONE/SMS WITH MIF AND MXPERSON
  B
  

Problem conclusion

• <This is a no_rep because the sorting of the records on EMAIL,
  PHONE, and SMS was fixed by an earlier apar 10-11316. I tried
  the xml import method and the flat file method, both worked in
  7.5.0.3. 10-11316 was fixed REL 7500 so it should work in REL
  7502. One thing to note is: in the flat file, trailing blanks
  would cause the last column not recognized by MEA. I had got
  the sample lines via Retain that contained trailing blanks for
  the last attribute which was the most critical attribute
  ISPRIMARY. I could still see the problem testing with the flat
  file.  After I removed the trailing blanks, the data in my test
  flat file imported successfully.>
  
  
  
  
  
  The fix for this APAR is contained in the following maintenance
  package:
  
    | release\fix pack | Release 7.5.0.4 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

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels

• R711 PSY

     UP