Creating or updating a table in the database

The table definitions that you create in the Schema Manager don't actually add tables to your database. They just define the structure of your agency's personalized tables. Creating or updating tables in the database based on your table definitions is a separate process. Infor Public Sector adds or updates all tables when you synchronize a product family, and you can also add and update tables individually. Note that creating or updating an individual table doesn't create or update the business object that Infor Public Sector requires to interact with the table. The only way to generate business objects in the Schema Manager is to synchronize the product family.

Note: When you update the database 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 at this time 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.

  1. Select System > Agency Personalization > Schema Manager.
  2. In the Enhancement Product Families tree, browse to the table you want to create or update in the database.
  3. Right-click the node and select Create/Update Database Table.
  4. In the Generation Options dialog box, ensure that the Mark as Requiring Updating check box is selected.
  5. Click OK.
    Infor Public Sector adds or updates the table as required. When the process is complete Infor Public Sector shows a dialog box that you can use to view a log of the update. Each log entry shows the SQL statement used to add or update the 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.