IJ35835: DEPLOY PACKAGE ERROR - BMXAA5736E - DUPLICATE SEQUENCES ARE NOT ALLOWED.

APAR status

• Closed as program error.

Error description

• PROBLEM:
  I am utilizing Tivoli software  "Migration Use Cases with the
  Migration Manager Version 7.5" document for migration manager
  examples and currently on Chapter 7 - Migrating escalations and
  automation scripts.  This chapter uses three Migration Groups -
  BPM, Resources, and System.
  
  The problem is in the Resources Migration Group which has
  migration objects of DMPERSON and DMPERSONGROUP.
  
  
  I am getting an error on the deployment of the package around
  the DMPERSONGROUP object  (BMXAA5736E - Duplicate sequences are
  not allowed.).  I understand what the error means; is there a
  way to define a package and  distribute & deploy that would
  completely overwrite and update the persongroup object on the
  Target system, thus preventing errors with the assignment
  sequence?
  
  PERFORMANCE ISSUE:
  No
  
  STEPS TO REPRODUCE:
  1- Create a Migration Group called PERSONGROUP with Migration
  Object DMPERSONGROUP.
  2- In Migration Manager, create a SNAPSHOT package using
  Replace. Add PERSONGROUP.
  3- In source, modify the CAB person group to add two alternates
  for KAZMIER:
  a- WILSON with Sequence 10
  b- MILLER with Sequence 20
  4- Migrate to target.
  5- In source, modify KAZMIER's alternates as follows:
  a- ROGERS with Sequence 10
  b- MILLER with Sequence 20
  c- WILSON with Sequence 30
  6- Attempt to migrate to target.
  
  It fails with:
  psdi.util.MXApplicationException: BMXAA5736E - Duplicate
  sequences are not allowed.
  at
  psdi.app.persongroup.FldAQSeq.checkGroupSeq(FldAQSeq.java:122)
  
  CURRENT ERRONEOUS RESULT:
  Duplicate sequences are not allowed.
  
  EXPECTED RESULT:
  Be able to use the migration manager without issue
  
  
  ENVIRONMENT (SYSTEM INFO):
  Environment System Information:
  Tivoli's process automation engine 7.6.1.1-IFIX20200324-1612
  Build 20190514-1348 DB Build V7611-365 HFDB Build HF7611-06,
  IBM Maximo Asset Management Work Centers 7.6.0.4 Build $build$
  DB Build V7604-119,
  IBM Maximo Asset Management Scheduler 7.6.7.3 Build
  20190514-1348 DB Build V7673-78 HFDB Build HF7673-11,
  IBM Maximo Anywhere 7.6.4.0 Build 20200117_195427-0500 DB Build
  V7640-12,
  IBM Tpae Integration Framework 7.6.1.1 Build 20190419-2330 DB
  Build V7611-01,
  IBM Maximo Asset Management 7.6.1.1 Build 20190514-1348 DB Build
  V7611-01,
  IBM Maximo for Transportation 7.6.2.5-20200303-1447 Build
  20180730-2210 DB Build V7625-10 HFDB Build HF7625-16,
  IoT Connection Utility 7.6.0.2 Build 20190426-2206 DB Build
  V7602-07,
  TPAE OSLC Object Structure 7.6.4.0 Build 20200219_092917-0500 DB
  Build V7640-04IBM WebSphere Application Server 8.5.5.12
  Server OS 	Windows 6.3
  Server DB 	DB2/LINUXX8664 10.5 (SQL10059)
  (c) Copyright IBM Corp. 2016
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When importing person group data using migration manager,    *
  * the user will get a duplicate sequence error if the new data *
  * includes an existing sequence number but defined against a   *
  * new user.                                                    *
  ****************************************************************
  

Problem conclusion

• Fixed by replacing data (first deleting existing data then
  inserting new data)
  

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 SYSTEMS

• Fixed component ID

  5724R46AV

Applicable component levels