Open topic with navigation

ibi™ MDM Add-on for Global Data Synchronization 4.0.0

# Updating Synchronization Status Using Utility

By using the `updateSyncStatus` utility, you can correct the synchronization status of a record in ibi MDM. Run the utility if the synchronization status of records in 1WorldSync and ibi 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.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

ibi™ MDM Add-on for Global Data Synchronization

Copyright © 1999-2023. Cloud Software Group, Inc. All Rights Reserved.