Siebel Marketing Guide > Initializing Siebel Marketing > Siebel Marketing Initialization Checklist >

Adjusting the Max EAI Records Parameter


During the campaign load process, text files containing information about the contacts and prospects for the campaign are created in the [Siebel File System]\Marketing\EAI directory. These files are used to check for records in the Siebel Contacts table (S_CONTACT) and create new records prior to populating the Marketing external key table (S_DD_USER_KEY) and the Campaign Contacts table (S_CAMP_CON).

The size of these files is controlled by the MAX EAI Records parameter in the Marketing Server component. By default, the system creates one file for every 10,000 contacts. When 10,000 contacts have been read into a file the file is saved (committed).

Adjusting the MAX EAI Records parameter is not needed to run the marketing application. However, you may need to increase or decrease the value of this parameter based on your business needs.

Reducing the Max EAI Records parameter. Loading a campaign is an all-or-none process because the commit occurs only after the campaign load process completes successfully. If record 10,000 fails during a campaign load, the previous 9,999 records that were inserted will not be saved in a file. Siebel Marketing does not support partial commits and there is no way to restart the process. However, you can reduce the number of records that load for each commit by decreasing the Max EAI Records parameter from its default of 10,000. You set the Max EAI Records parameter on the Marketing Server (MktgSrvr) component. Reducing the Max EAI Records can also help prevent a time out from causing a load to fail.

To clean up records from an earlier EAI load, you can use EIM to delete the old records. If a campaign load fails, an administrator uses EIM to back out of the committed records in the EIM promotion history table for each campaign. This deletes S_CAMP_CON records for that campaign.

NOTE:  You need to delete records only from S_CAMP_CON. You do not need to delete records from S_DD_USER_KEY because these records are reused.

Increasing the Max EAI Records parameter. If your EAI transaction volume is very high, you may need to increase the value of this parameter to improve performance.

To view or change the Max EAI Records parameter

  1. From the application-level menu, choose View > Site Map > Server Administration > Components.
  2. In the Components list, select Marketing Server.
  3. Click the Component Parameters view tab.
  4. In the Component Parameters list, locate Max EAI Records.
  5. To change the value, use one of the following steps:

 Siebel Marketing Guide, Version 7.5, Rev. A 
 Published: 18 April 2003