Campaign Load Error: [nQSError: 42029] Subquery contains too many values for the IN predicate.
(Doc ID 980576.1)
Last updated on AUGUST 03, 2018
Applies to:Siebel Email Marketing Server - Version 7.8.2 SIA  and later
Information in this document applies to any platform.
Checked for relevance on 3 June 2013
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).
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|