Upgrade - Transaction Data Migration

Technote (troubleshooting)


Problem(Abstract)

Transaction data migration script fails due to factory setup data missing from YFS_SCAC table.
Upgrade script is trying to update non-existing data which leads to failure

Symptom

The following error will be thrown in the logs:

Caused by: java.lang.NullPointerException
at com.yantra.shared.dbclasses.YFS_SCACDBHome.update(YFS_SCACDBHome.java:1323)

Cause

Factory Setup data deleted from YFS_SCAC table

Diagnosing the problem

In multi hop upgrade process logs are available from the last hop folder located under <INSTALL_DIR>/Migration directory

Resolving the problem

IBM Sterling OMS 9.2 documentation includes the following information about Factory Setup records in the DB ( Migrate Transaction Data - Step 5 ):


If you deleted any factory setup records and the upgrade-transaction-tables target fails, you must add the deleted records to the database before continuing the upgrade.

First step is to delete the custom records if any have been placed in the table:

delete from YFS_SCAC where SCAC_KEY in ('EXEL','Purolator');

To restore the records back in table, you can use SQL command for each row as follows ( this is the Factory Setup data based on YFS_SCACList.xml ):

INSERT INTO YFS_SCAC( SCAC_KEY,SCAC,SCAC_DESC,ORGANIZATION_CODE,SYSTEM_INTG_FOR_DOMESTIC_REQD,SYSTEM_INTG_FOR_INTL_REQD,LOCALECODE,PRO_NO_LENGTH,CARRIER_ADAPTER_IMPL_KEY,LOCKID,CREATETS,MODIFYTS,CREATEUSERID,MODIFYUSERID,CREATEPROGID,MODIFYPROGID)VALUES ('FEDX','FEDX','FEDX','DEFAULT','Y','Y','en_US_EST','0', 'PierbridgeAdaptor','0','01-JUN-10','01-JUN-10', 'SYSTEM','YFSMDC3','YFX-Carrier','YDKConfigDeploy')


INSERT INTO YFS_SCAC( SCAC_KEY,SCAC,SCAC_DESC,ORGANIZATION_CODE,SYSTEM_INTG_FOR_DOMESTIC_REQD,SYSTEM_INTG_FOR_INTL_REQD,LOCALECODE,PRO_NO_LENGTH,CARRIER_ADAPTER_IMPL_KEY,LOCKID,CREATETS,MODIFYTS,CREATEUSERID,MODIFYUSERID,CREATEPROGID,MODIFYPROGID)VALUES ('UPSA','UPSA','UPSA','DEFAULT','Y','Y','en_US_EST','0', 'PierbridgeAdaptor','0','01-JUN-10','01-JUN-10', 'SYSTEM','YFSMDC3','YFX-Carrier','YDKConfigDeploy')


INSERT INTO YFS_SCAC(
SCAC_KEY,SCAC,SCAC_DESC,ORGANIZATION_CODE,
SYSTEM_INTG_FOR_DOMESTIC_REQD,SYSTEM_INTG_FOR_INTL_REQD,LOCALECODE,PRO_NO_LENGTH,
CARRIER_ADAPTER_IMPL_KEY,LOCKID,CREATETS,MODIFYTS,
CREATEUSERID,MODIFYUSERID,CREATEPROGID,MODIFYPROGID)
VALUES
('UPSC','UPSC','UPSC','DEFAULT',
'Y','Y','en_US_EST','0',
'PierbridgeAdaptor','0','01-JUN-10','01-JUN-10',
'SYSTEM','YFSMDC3','YFX-Carrier','YDKConfigDeploy')


INSERT INTO YFS_SCAC(
SCAC_KEY,SCAC,SCAC_DESC,ORGANIZATION_CODE,
SYSTEM_INTG_FOR_DOMESTIC_REQD,SYSTEM_INTG_FOR_INTL_REQD,LOCALECODE,PRO_NO_LENGTH,
CARRIER_ADAPTER_IMPL_KEY,LOCKID,CREATETS,MODIFYTS,
CREATEUSERID,MODIFYUSERID,CREATEPROGID,MODIFYPROGID)
VALUES
('UPSE','UPSE','UPSE','DEFAULT',
'Y','Y','en_US_EST','0',
'PierbridgeAdaptor','0','01-JUN-10','01-JUN-10',
'SYSTEM','YFSMDC3','YFX-Carrier','YDKConfigDeploy')


INSERT INTO YFS_SCAC(
SCAC_KEY,SCAC,SCAC_DESC,ORGANIZATION_CODE,
SYSTEM_INTG_FOR_DOMESTIC_REQD,SYSTEM_INTG_FOR_INTL_REQD,LOCALECODE,PRO_NO_LENGTH,
CARRIER_ADAPTER_IMPL_KEY,LOCKID,CREATETS,MODIFYTS,
CREATEUSERID,MODIFYUSERID,CREATEPROGID,MODIFYPROGID)
VALUES
('UPSL','UPSL','UPSL','DEFAULT',
'Y','Y','en_US_EST','0',
'PierbridgeAdaptor','0','01-JUN-10','01-JUN-10',
'SYSTEM','YFSMDC3','YFX-Carrier','YDKConfigDeploy')


INSERT INTO YFS_SCAC(
SCAC_KEY,SCAC,SCAC_DESC,ORGANIZATION_CODE,
SYSTEM_INTG_FOR_DOMESTIC_REQD,SYSTEM_INTG_FOR_INTL_REQD,LOCALECODE,PRO_NO_LENGTH,
CARRIER_ADAPTER_IMPL_KEY,LOCKID,CREATETS,MODIFYTS,
CREATEUSERID,MODIFYUSERID,CREATEPROGID,MODIFYPROGID)
VALUES
('UPSN','UPSN','UPSN','DEFAULT',
'Y','Y','en_US_EST','0',
'PierbridgeAdaptor','0','01-JUN-10','01-JUN-10',
'SYSTEM','YFSMDC3','YFX-Carrier','YDKConfigDeploy')


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Sterling Order Management
Installation

Software version:

9.0, 9.1, 9.2

Operating system(s):

All

Software edition:

Foundation

Reference #:

1627028

Modified date:

2013-04-24

Translate my page

Machine Translation

Content navigation