My Oracle Support Banner

Apply Targeted List Performance (Doc ID 497963.1)

Last updated on JANUARY 25, 2020

Applies to:

Siebel System Software - Version 7.5.3 SIA [16157] and later
z*OBSOLETE: Microsoft Windows 2000
Version: 7.5.3 [16157] Life Sci

Database: Oracle 9i

Application Server OS: Microsoft Windows 2000 Server SP 4

Database Server OS: HP-UX 11i



This document was previously published as Siebel SR 38-1958319837.

Symptoms

SBL-UIF-00279

We currently have 12,000 contact records in our database. Creating a simple Targeted List of Contacts where Status = “Active” results in approx. 9,000 records in the targeted list. When attempting to apply the saved targeted list to the All Contacts View, the application hangs for 5 minutes and then throws the following error:
“Command InvokeMethod requires a value for argument SWEView (SBL-UIF-00279)”.
Spooling the sql I notice that the underlying sql runs for approx 15-20 minutes.

This is all standard Siebel functionality, we have not added any extra configuration to the apply targeted list functionality. Any help you can give us in improving the performance of this functionality would be greatly appreciated.

Our db and srf are already in the upload folder and should be there until Friday.

This behavior only occurs with Target Lists that contain 5000+ records.

Changes

 

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
Changes
Cause
Solution
 Message 1
 Message 2

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