Overview

By default the InterAction web client API is set to return a maximum of 10,000 results which means that you will only be able to send to the first 10,000 contacts on any InterAction list and, you will be unable to load in the complete data for unsubscribe and bounces lists that are larger than this size.

The threshold applies separately to the lists you are sending to, your unsubscribe suppression folders and your bounce suppression folder.

So if your threshold is 10K then Vuture can only download the first 10K of contacts you are sending to, the first 10K of contacts in your combined suppression lists for that send and the first 10K contacts in your bounce suppression list.

It is important you set this value to a higher value than the largest of:  your largest send size, your largest combined suppression list (global unsubscribes + email type unsubscribes) and your bounce suppression list.

The value of these settings can be verified by accessing the following IA web client page: https://myIAUrl/evreport

Increasing the 10,000 result limit
There are three settings in the InterAction.cfg file that need to be changed in order to ensure InterAction does not limit the records that are returned to Vuture.

1. maxResultCountCeiling: This is the absolute maximum number of records returned. This default is 10,000 but we recommend this is increased to 50,000 or the size of your anticipated largest list size.

2. maxDBResultThreshold: This is the maximum number of records returned from the database for memory intensive requests. The default is 10,000 but we recommend this is increased to 50,000 or the size of your anticipated largest list size.

3. inClauseThreshold: The number of items (e.g. contacts) used in the where clause before switching to a temp table join. The default is 100 but we recommend this is increased to 500.

It is possible to change these settings to 0 in order to disable any kind of record limiting from InterAction, but both Vuture Support and InterAction Support recommend that you do not do this for performance reasons.

When evaluating your largest anticipated list size please consider:

• your largest potential mailing list
• the total number of contacts in your global unsubscribe list or lists (if you have more than one global unsubscribe list then add the list sizes together as these are downloaded as one list) with room to grow
• the total number of contacts in your bounce suppression list, with room to grow

Altering your InterAction.cfg file

These steps should only be carried out by an InterAction administrator. Please contact Vuture and/or Lexis Nexis support if you have any concerns about editing these configuration settings.To change these setting find your InterAction.cfg file which lives in your iahome directory:

Open the file in a text editor and search for each configuration setting updating the values as required:

Once updated save the file. 

You will need to restart your InterAction Application Server for the changes to take effect. Please note this may be required in more than one location based on your CRM setup;  for example in your InterAction server and your separate Vuture InterAction server. LexisNexis will be best placed to help you determine this.

Please let Vuture know when you have completed this and the new threshold value as we will need to update the configuration setting "Admin.System.InterAction.InterAction Max Results" to match this value.

Vuture Admins can check a client's IA threshold values by going to "Admin.Goto" and clicking on "View InterAction thresholds"