From time to time, you probably need to perform Progress database dump and load procedures for various maintenance-related reasons. The dump and load procedures change the assigned rowids in the QAD Enterprise Applications database; it means that the rowids are no longer synchronized with the original rowids stored in the QXO database. This reassignment of rowids results in erroneous messages being generated by QXO.
Note: Use this tool only if your source application type is set to use rowids as the identifier (see Creating a New Source Application Type). Do not run this tool for source applications that use OIDs.
To correct the rowid mismatch and resolve this issue, after performing a Progress database dump and load, run the QXO mass rowid synchronization utility, which is located in the src/tools directory.This utility iterates through the records in the Event Message section table of qxodb and queries the QAD Enterprise Applications database to determine if the rowids match. If there is a mismatch, the utility synchronizes the Event Message section record rowid to that of the QAD Enterprise Applications rowid.The utility comprises the following files:
• Startup script (start.msync)
• Mass rowid sync program (rowid-msync.p)
You run the synchronization utility from the command line. Before running the utility, Edit start.msync to specify the following:
• DLC: Progress home directory
• QXOSRV: QXO server directory
• SRCAPP: QXO source application to synchronize
• PROFILELIST: Optional list of profiles to synchronize. If not specified, it synchronizes all the profiles.