My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.