Synchronizing a product family

Synchronization is the process of generating and updating agency tables and their associated business objects. The business objects are required because Infor Public Sector works with data through the business objects rather than accessing the database directly.

When you synchronize a product family, Infor Public Sector compares the table definitions for that product family to the actual tables in the database, and adds or updates tables as required. Infor Public Sector also generates business objects for the agency data, which are found in the product family's assembly in the Enhancement\bin directory on the server. The source files for the agency objects are in the Enhancement\GeneratedFiles directory.

You can also create and update database tables individually, but the process of creating or updating individual tables doesn't include the business objects. The only way to generate business objects is to synchronize product families.

Note: When you begin a synchronization Infor Public Sector places a lock on the Schema Manager to prevent other users from trying to update the database simultaneously. Other users who try to open the Schema Manager during the synchronization will see an error message saying that an installation process is running and the Schema Manager can't be opened. The lock can also get stuck if the synchronization process is killed before it is completed. You may need to clear the lock.

See Schema Manager lock error.

You also cannot synchronize product families while formulas are being rebuilt. You will get an error message saying that another user is in the middle of the Rebuild All Formulas process. You can use the System Information page to view more details about the compilation that is in progress, and to break the compilation lock if necessary.

See Breaking a compilation lock.

Select System > Agency Personalization > Schema Manager.
In the Enhancement Product Families tree, browse to the product family that you want to synchronize.
Right-click the product family node and select Synchronize.
A dialog box is displayed asking if you're sure you want to synchronize the product family.
Note: You can also right-click the root Enhancement Product Families node and select Synchronize All to synchronize all agency product families simultaneously.
Click OK.
Infor Public Sector adds or updates tables in the database as required to match the data structure defined in the Schema Manager, and generates the associated business objects. When the process is complete Infor Public Sector shows a dialog box that you can use to view a log of the synchronization. Each log entry shows the SQL statement used to add or update a particular table and indicates whether the operation was successful. You can search for log entries based on criteria such as error message text, SQL text, or date.