Campaign Load Error: [nQSError: 42029] Subquery contains too many values for the IN predicate. (Doc ID 980576.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Email Marketing Server - Version 7.8.2 SIA [19213] and later
Information in this document applies to any platform.
Checked for relevance on 3 June 2013

Symptoms

The customer is encountering the following error message in campaign load while loading a segment:
"Error/Warning : Error invoking service 'Mktg Data Load Service', method 'CampaignLoad' at step 'Load Segment Tree Cells/Segments'.(SBL-BPR-00162)
The SOAP request '15' to the Analytics Web server failed. For more information on the error, navigate to the Siebel Analytics Web Administration > Manage Marketing Jobs console.

Detailed error message: Job request of type "WriteListFiles" failed. Error executing the list generation SQL. Error in executing cursor for WorkNode (Id:0) Odbc driver returned an error (SQLExecDirect). State: S1000. Code: 10058. [NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred.

[nQSError: 42029] Subquery contains too many values for the IN predicate. (S1000) SQL Issued: SET VARIABLE DISABLE_CACHE_HIT=1 , DISABLE_CACHE_SEED=1 :SELECT saw_0 saw_0, saw_1 saw_1, saw_2 saw_2, ……DT (SBL-MKT-00471).

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