My Oracle Support Banner

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 [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

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
 


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.