Single I/O Box for Multi-Logical Ids

This addresses requirements from applications which have multiple sites where an individual connection point is defined per site in ION. These applications use the same Inbox and Outbox table between them. In such situations, messages based on Tenant and based on Logical Id must be processed.

To setup Single I/O Box for Multi-Logical Ids:

  1. Upgrade the I/O Box to version 3.0. Go to the 3.0 folder in your I/O box and run the I/O box script <db>_upgrade.sql.

    The downloaded zip file contains these folders: 1.0 and 3.0. The folder 1.0 contains the scripts to create a base I/O box for the standard databases. This includes: MS SQL server, Oracle, DB2, DB2400 and MySQL.

    The 3.0 folder contains the scripts required to prepare your I/O box to support multiple logical Ids sharing the same I/O box. Run the scripts in the 3.0 folder to create I/O Box tables in your application. For Unicode compatible BOD header fields, you can use the scripts available in the Unicode folder.

  2. Specify the message processing preference to be by logical Id in each connection point defined for your application.

    Go to Connection Point definition > Connection > Advanced > Message processing preference in I/O box.

    Select by Logical ID to be true and select by Tenant to be true.

    Before you proceed, check if the column called C_LOGICAL_ID exists in both COR_OUTBOX_ENTRY and COR_INBOX_ENTRY.

  3. When you publish BODs from your application, ensure that the correct values are specified in these columns:

    • COR_OUTBOX_ENTRY table, specify C_LOGICAL_ID with your actual Logical Id value.
    • COR_OUTBOX_HEADERS table, specify the FromLogicalId key with the correct Logical Id value.
    • Both Logical Ids must match the Logical Id value specified in the connection point.
Note: The Tenant and the Logical Id value are matched in a case-sensitive manner. To avoid inconsistency in tenant processing, specify the Tenant Id and the Logical Id according to the Infor standards.

When these properties are not selected, you must ensure that each Infor application connection point uses its own Inbox and Outbox tables. This will be guaranteed by using different URLs. If you use the same URL in multiple connection points, then use different users. Ensure the users are linked to different database schemas in the database management system.