OpenEdge Pro2 6.4 delivers the following updates and enhancements:

Improvements to Queue and Thread Reports

In this release, Pro2 provides an enhanced user experience with the addition of three new reports to the web user-interface. Using these reports, you can manage the replication system efficiently and reduce the frequency of calls to Technical Support. Instead of writing Advanced Business Language (ABL) queries in the Pro2 editor to fetch the queue data, you can get the troubleshooting and report generating options in the Pro2 web interface. This feature primarily benefits users who are not experienced with ABL.

The following reports are added to the Reports/Troubleshooting menu option on the Pro2 web user-interface:

  • Get Replqueue List—Lists the replqueue records with the Not Applied status. The report organizes the records by thread number, source table, and event date.

  • Get Table Configuration—Generates a list of tables and the threads to which the tables are mapped. The report includes the flag values (yes or no) for the Gen Queue Records, Process Queue Records, and the Include/Exclude properties of the tables.

  • Get Table Activity Count—Contains the replqueue activity count for a specific table or multiple tables from the source database. The three activity event types are: create, update, and delete records.

For more information, see Reports/Troubleshooting.

Automated Migration from Pro2 5.5.x to 6.x

Prior to this release, migrating from Pro2 5.5.x to Pro2 6.x was an extremely time-consuming, manual process for the Pro2 consulting team, and cost considerably more than installing Pro2 6.x from scratch.

With the automated migration feature, Pro2 Administrators and Consultants can easily upgrade from Pro2 5.5.x to Pro2 6.x by loading the thread-level configuration along with the table and field mapping details using the Pro2 web user interface. As a result, all the manual steps related to the formatting of the .ini and .map file are automated and require no manual intervention in the migration process.

For more information, see Upgrade-Pro2-5.5.x-to-6.4.

Addition of Include DB Analysis Functionality to BulkLoad Process

Pro2 now supports the Include DB Analysis functionality while running the bulk load process.

Pro2 Administrators and Consultants benefit from the addition of this functionality because it provides them the ability to read the database or table analysis file data and include or exclude the table data depending on the number of records. For example, they can bulk load only the tables that have over 100,000 records, or alternatively, bulk load only the tables that have fewer than 100,000 records. As a result, the bulk load process runs fast and efficiently.

For more information, see Bulk load with Pro2.

Option to Reset Repllogcheck and Statuscheck Control Records

Pro2 now provides the following options to help Pro2 Administrators and Consultants reset the ReplLogCheck and StatusCheck control records from the repl_control table:

  • Reset Status-Check Alarm—Resets the status check alarm to send alerts again if replication stops within the same day. By default, the StatusCheck procedure sends only one email notification per day.
  • Clear Log-Error-Alerts Daily-Limit-Counters—Resets the value of the LOG_ALERT_DAILY_LIMIT property to blank. To set the daily limit on the replication log generation process again, create the LOG_ALERT_DAILY_LIMIT property and assign a value to it.

For more information, see Reset alarms.