Skip Navigation
Searching for a contact with an underscore in the email address causes query processes too much data error
Answer ID 6094   |   Last Review Date 01/08/2019

When trying to search for a contact containing an email with an underscore character, why are we receiving a query processes too much data error?


Oracle B2C Service, Analytics, All versions


In SQL, the underscore character is treated as a wildcard character, similar to the % symbol. If the report you are using contains a filter based on and using the LIKE operator, searching for a contact that contains an underscore in the email will treat the underscore as a wild card. For example, searching for, will search for all occurrences of:

and so on. Because of the wildcard character, more rows will need to be processed when performing this search and you may receive the query processes too much data error. Please see the following answer for additional information about this error, Answer 4278: Report is processing too much data.

To prevent this from happening, you can use the backslash escape character in your search so that the underscore character will be treated literally and not as a wildcard. For example:


Or you can edit the report's filter to use the EQUALS operator instead of the LIKE operator. Please see the following answer on how to edit report filters: Answer 2509: Creating a basic custom report