Updating Synchronization Status Using Utility
By using the updateSyncStatus
utility, you can correct the synchronization status of a record in TIBCO MDM. Run the utility if the synchronization status of records in 1WorldSync and TIBCO MDM is different. The updateSyncStatus.bat
and updateSyncStatus.sh
utility files are available in $MQ_HOME\bin
.
- Procedure
- Navigate to
$MQ_HOME/bin/migration
and create a file namedupdatesyncoperations.txt
and enter the details of a operation (in the following format) that you want to perform:productkeyid,operation,suboperation SQL command to retrieve PRODUCTKEYID
For example,10004,ADD,NEW
SQL command to retrievePRODUCTKEYID
select * from MCT_34819 to get CPRODUCTKEYID of 00005555565578 => 10013 - Navigate to
$MQ_HOME\bin
. - Run the following command:
updateSyncStatus.bat -cid SYNC1_CATLOG_ID -of Catalog outputmap name -mid organization_ID for the market place
: selects ID from catalog where NAME=CATLOG_ID
SYNC1
Catalogoutputmap name
(outputformat):1SYNC
organization_ID for the market place
: selects ID from ORGANIZATION where NAME=1SYNCTEST
For example,
updateSyncStatus.bat -cid 34819 -of 1SYNC -mid 32699
The optional
tradingPartner
attribute is required if you want to publish records to a trading partner.
ResultThe synchronization status is updated. You can synchronize the records.