IBM Support

Migration of history data fails while upgrading from 9.4 to v10

Troubleshooting


Problem

While executing Migration History Data command, getting build failed error .
  • ${ANT_HOME}/bin/ant -Druntime=<INSTALL_DIR> -Druntime.old=<INSTALL_DIR_OLD> -f buildmigration.xml -logfile <logfile> -Dtarget=upgrade-history-tables migrate
  
From the <INSTALL_DIR>/COM/Migration/9.5/COM_Add-in directory:
  • <INSTALL_DIR>/COM/Migration/9.5/COM_Add-in directory>${ANT_HOME}/bin/ant -f ycdmigration.xml -Druntime=<INSTALL_DIR> -Druntime.old=<INSTALL_DIR_OLD> -DYANTRA_RUNTIME_NEW=<INSTALL_DIR> -Dtarget=upgrade-history-tables migrate -logfile <logfile>
link followed:

Symptom

Check for the following log when build failed error occurs:
/OMS_Install_Directory/Migration/9.4/upgrade-history-tables-9.4-9.5.log
This is where error has occurred first.

Cause

Error observed in /OMS_Install_Directory/Migration/9.4/upgrade-history-tables-9.4-9.5.log:

 

[java]     [java] com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=OMS94B.YFS_COMPONENT_ENDPOINT, DRIVER=4.17.29

    [java]     [java]   at com.ibm.db2.jcc.am.hd.a(hd.java:747)

   ...

 <Errors>

    [java]     [java]    <Error ErrorCode="-204"

    [java]     [java]        ErrorDescription="DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;OMS94B.YFS_COMPONENT_ENDPOINT, DRIVER=4.17.29" ErrorRelatedMoreInfo="">

    [java]     [java]        <Attribute Name="ErrorCode" Value="-204"/>

    [java]     [java]        <Attribute Name="ErrorDescription" Value="DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;OMS94B.YFS_COMPONENT_ENDPOINT, DRIVER=4.17.29"/>

    [java]     [java]        <Attribute Name="SQLState" Value="56098"/>

    [java]     [java]        <Attribute Name="TableName" Value="YFS_COMPONENT_ENDPOINT"/>

    [java]     [java]        <Attribute Name="DBErrorCode" Value="-727"/>

    [java]     [java]        <Attribute Name="SQLStatement" Value="Prepared Statement - SELECT    YFS_COMPONENT_ENDPOINT.* FROM YFS_COMPONENT_ENDPOINT YFS_COMPONENT_ENDPOINT    WHERE COMPONENT_NAME = 'YFS_INVENTORY_SUPPLY' AND PURPOSE = 'WRITE' AND ENABLED = 'Y' "/>

    [java]     [java]        <Attribute Name="TransactionIsolationLevel" Value="2"/>

    [java]     [java]        <Error ErrorCode="com.ibm.db2.jcc.am.SqlException"

    [java]     [java]            ErrorDescription="" ErrorRelatedMoreInfo="DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;OMS94B.YFS_COMPONENT_ENDPOINT, DRIVER=4.17.29">

    [java]     [java]            <Stack>com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;OMS94B.YFS_COMPONENT_ENDPOINT, DRIVER=4.17.29& #xd ;

    [java]     [java]   at com.ibm.db2.jcc.am.hd.a(hd.java:752)& #xd ;

    [java]     [java]   at com.ibm.db2.jcc.am.hd.a(hd.java:66)& #xd ;

Resolving The Problem

Migrate the transaction data first and then migrate the history data.

Please check the below detail from the V10 upgrade guide :
Data migration is a two-phase process in which you have to migrate the transaction data, and then the history data.

For more details please refer below link :
http://idev2008server.devlab.ibm.com:9090/support/knowledgecenter/en/SS6PEW_10.0.0/com.ibm.help.upgrade.migrating.oms.doc/upgrade/c_RunningDataMigration_test.html

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"v10","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Sterling OMS; OMS

Document Information

Modified date:
27 February 2019

UID

ibm10872772

Page Feedback