JR42978: TEAMWORKS 6.X TO BPM 7.5.1 MIGRATION FAILS TO MIGRATE ACTIVE INSTANCES IN SOME CASES

Version 8.0 Refresh Pack 1 for the IBM Business Process Manager products
Version 7.5.1 Fix Pack 1 for the IBM Business Process Manager products

APAR status

• Closed as fixed if next.

Error description

• migration can map the numeric id to the UUID successfully, but
  it try to insert the "ID<POType.BpdEvent>" to the database
  directly, it will call object toString, which return the
  "BpdEvent.96dc8fb4-8565-4883-991c-cf532ab86f94" for example, it
  longer than the length defined at the database, it can cause the
  "Invalid column type" SQL exception.
  
  Oracle show this exception is very misleading, because it's not
  the type invalid, the length violation actually.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  User migrating from Teamworks 6.x with in   *
  *                  flight instances.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQL exception is thrown when            *
  *                      attempting to migrate from Teamworks    *
  *                      6.x.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Migration can map the numeric id to the UUID successfully for
  the table LSW_INST_MSG_EXCL. But it tries to insert the
  "ID<POType.BpdEvent>" to the database directly, and it will
  call object toString, which then returns a string that is
  longer than the length defined at database, thus can cause
  the "Invalid column type" SQL exception.
  

Problem conclusion

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

Applicable component levels

• R750 PSY

     UP