Query Works When Entered Directly In UI, But Is Too Complex When Used As Saved Query (Doc ID 2266205.1)

Last updated on MAY 15, 2017

Applies to:

Siebel CRM - Version 16.2 [IP2016] and later
Information in this document applies to any platform.

Symptoms

On : 16.2 [IP2016] version, Client Functionality

The user have been created a new query "LookupValue("SR_STATUS","Closed") AND JulianMonth([Updated]) = JulianMonth(Today())" (without double quotes) into search field (e.g. "Description"" and after Select the PDQ "myPDQ" is getting some error message.

ERROR
-----------------------
"Current search specification is too complex to be refined. Please start a new query or refine one that is less complex. (SBL-DAT-00487)"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Log into Siebel application, navigate to Complaints > all Complaints list View
2) Press query symbol
3) enter "[Status] = LookupValue("SR_STATUS","Closed") AND JulianMonth([Updated]) = JulianMonth(Today())" (without double quotes) into search field (e.g. "Description")
4) execute query

-> works fine

5) Save query as "myPDQ" (Menu Query > Save Query As)
6) Select PDQ "*All Complaints) -> OK
7) Select PDQ "myPDQ"

When this is done, Siebel Shows popup with following error:

"Current search specification is too complex to be refined. Please start a new query or refine one that is less complex. (SBL-DAT-00487)"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
PDQ is not working properly and it causing delay and confusion.

Repro Steps:

1. Using Siebel Tools, navigate to Service Request Business Component.
2. Edit Server script - In BusComp_Query, add the following:
function BusComp_Query ()
{
var myString:String;
this.SetSearchExpr("[Status]=LookupValue(\"SR_STATUS\",\"Closed\") AND
JulianMonth([Updated])=JulianMonth(Today())");
myString=this.GetSearchExpr();

// works fine until here, but then....

myString = this.GetSearchSpec("CSN");
// ...this leads to error (SBL-DAT-00487)
}
3. Compile Service Request Business Component.
4. Launch Financial Services Application and navigate to "All Service Requests".
5. Application doesn't display anything, but displays the error message:
We detected an Error which may have occurred for one or more of the following reasons:
Current search specification is too complex to be refined. Please start a new query or refine one that is less complex.(SBL-DAT-00487)

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