Mass Rowid Synchronization Tool
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 <qxo>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.
The utility creates a log file rowidsync<time>.log in the <qxo>/src/tools directory. If the variable DEBUG is set to true in the script start.msync, then it creates an additional debug file rowidsync<time>.debug in the <qxo>/src/tools directory.
The log file has an entry for the first record and for multiples of 100,000 records. You can check this log file periodically to see the progress of the utility.
After the utility finishes, it gives a summary report on:
• Raw Messages Converted
• Message Sections Converted
• Message Sections Unavailable
• Message Locks Converted
• Published Messages Converted
• Subscriber Messages Converted
• Completed in <time in minutes and seconds>