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
  1. Navigate to $MQ_HOME/bin/migration and create a file named updatesyncoperations.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 retrieve PRODUCTKEYID

    select * from MCT_34819 to get CPRODUCTKEYID of 00005555565578 => 10013

  2. Navigate to $MQ_HOME\bin.
  3. Run the following command:
    updateSyncStatus.bat -cid SYNC1_CATLOG_ID -of Catalog outputmap name -mid organization_ID for the market place
    • CATLOG_ID: selects ID from catalog where NAME=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.