My Oracle Support Banner

SBL-DAT-00500 Error When Launching Campaign With More Than 10,000 Count (Doc ID 2747495.1)

Last updated on MARCH 17, 2021

Applies to:

Siebel Marketing - Version 20.3 and later
Information in this document applies to any platform.

Symptoms

When executing a Campaign with more than 10,000 counts (whether from a Segment or a List), the following error is observed in the Campaign Task view:

 

Error invoking service 'Wave Execution', method 'CreateFollowUpActivity' at step 'Create Follow-up Activity'.(SBL-BPR-00162)

--

There were more rows than could be returned. Please refine your query to bring back fewer rows(SBL-DAT-00500)


When executing a Campaign with a count less than 10,000, the process completes without any errors. In the log file, we see the query is coming from the 'Campaign Recipient' business component as noted below:

ObjMgrSqlCursorLog Trace 5 000008565f8d173d:0 2020-10-19 16:11:30 SQL Cursor with ID 167B0ED8 Buscomp: Campaign Recipient, Forward Only: 0, Fetch Rows: 10000, Fetch All Time: 0.186 seconds.

ObjMgrSqlCursorLog Close 5 000008565f8d173d:0 2020-10-19 16:11:30 End: Close Sql Cursor at 167b0ed8

ObjMgrBusCompLog Error 1 000008565f8d173d:0 2020-10-19 16:11:30 There were more rows than could be returned. Please refine your query to bring back fewer rows


Even when setting the BC property 'Maximum Cursor Size = -1' on the business component, the error is still seen.

To reproduce the issue, the following steps were followed:

1. Create a Campaign.

2. Associate more than 10,000 counts to the Campaign. The counts can be from a List or a Segment as it does not matter.

3. Run the Campaign Load and then the Launch, which will result in the error in the task.

Due to this issue, users cannot complete a Campaign if it has more than 10,000 or more counts associated with it.

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
References


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