How to solve campaign WriteListFile error: [nQSError: 42029] Subquery contains too many values for the IN predicate (Doc ID 2021228.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Marketing - Version 8.1.1.4 SIA [21225] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.4 SIA [21225] version, Siebel Marketing

When attempting to run WriteListFiles from campaigns,
the following error occurs.

ERROR
-----------------------

 [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 42029] Subquery contains too many values for the IN predicate


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create campaign, offer and treatment
2. Create segment tree with 73 nodes
3. Associate the segment to the campaign.
4. Run the campaign load
5. Review WriteListFiles generated by OBI.
6. Note that for the specific IN condition on node 65 the SQL in fact shows 65 nested conditions and then confirm the error
 [nQSError: 42029] Subquery contains too many values for the IN predicate

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the campaign associated to this new segment tree.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms