Fixes are available
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 number
JR42978
Reported component name
BPM STANDARD
Reported component ID
5725C9500
Reported release
750
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-06-01
Closed date
2012-07-26
Last modified date
2012-07-26
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
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5"}]
Document Information
Modified date:
07 October 2021