Inbox and outbox tables

All applications must add some of these new tables to their existing database so that the application can read and write the tables in the same transaction as their business logic:

  • COR_OUTBOX_ENTRY
  • COR_OUTBOX_HEADERS
  • COR_INBOX_ENTRY
  • COR_INBOX_HEADERS
  • ESB_INBOUND_DUPLICATE
Caution: 
When an application adds a new message to the COR_OUTBOX_ENTRY and COR_OUTBOX_HEADER tables, the inserts must be performed within the same transaction. Inserts that are not performed within the same transaction cause data corruption.

To download the scripts to create those tables:

  1. Start ION Desk.
  2. Select Configure > ION Service.

    The Configure ION Service page is displayed.

  3. Click the Configuration Files tab and then click Download Scripts to create I/O Box.
  4. Specify a file name and click Save. A zip file is downloaded.
  5. Extract the zip file and use the db vendor-specific sql files that are applicable to you. For Unicode-compatible BOD header fields, use the scripts available with the _unicode suffix.
Note: The script might also generate a COR_PROPERTY table. This table is included for future use, so you can safely ignore it.