IBM Support

Jazz CCM 7.0.3 DB2 to Oracle Migration Fails with ORA-12899 Error

Question & Answer


Question

IBM Jazz Team Server 7.0.3 CCM3 import fails with ORA-12899 error during DB2 to Oracle migration due to column length mismatch in DEPENDENCYBOARD_DEPENDENCY_BRD table.

Answer

To resolve the import issue in IBM Jazz Team Server 7.0.3 when migrating from DB2 to Oracle, follow these steps:
 Add the following JVM argument to the repotools command: 
Windows

set DEFINE=%DEFINE% "-Dcom.ibm.team.repository.migration.internal.service.sql.DBColumn.not_convertable=DEPENDENCYBOARD_DEPENDENCY_BRD.ITEM_ID"

Linux

set DEFINE="$DEFINE -Dcom.ibm.team.repository.migration.internal.service.sql.DBColumn.not_convertable=DEPENDENCYBOARD_DEPENDENCY_BRD.ITEM_ID"
Clear the cache, restart services, and retry the import.

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSF34G","label":"IBM Engineering Lifecycle Management Suite"},"Component":["Jazz Foundation Services"],"ARM Category":[{"code":"a8m0z000000CbOBAA0","label":"Jazz Foundation Services"}],"ARM Case Number":"TS021746355","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Product Synonym

ELM Suite;DOORS;Method Composer;Workflow Management;Test Management;DOORS Next;Publishing;Rhapsody;Engineering Insights;Engineering Lifecycle Mgmt Suite;Automotive Compliance

Document Information

Modified date:
08 May 2026

UID

ibm17271509

Page Feedback