QuerySpec In CTI Configuration - Error SBL-DAT-00487 (Doc ID 2195189.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 15.3 [IP2015] and later
Information in this document applies to any platform.
Below is the QuerySpec defined in Event Handler of CTI Configuration:
([Name]='169921' AND [MFP UPN]='966741') OR ([Name]='369921' AND [MFP UPN]='966414')

However the queryspec throws an error SBL-DAT-00487: Current search specification is too complex to be refined.

Upon few research, we found multiple query expression with an 'OR' is not handled in Siebel as per Oracle Doc Id 956294.1. So we tried with the solution provided in same Doc Id and modified QuerySpec as below:
NOT (NOT [Name]='169921' AND [MFP UPN]='966741') AND NOT ([Name]='369921' AND [MFP UPN]='966414'). However the error remained the same as SBL-DAT-00487.

Attached OM and SComm Log FINSObjMgrOui_enu_0010_10485785.log and SComm_USWVAL41_tTf.log (error in 50064 line in OM logs and 2989 line in SComm Log) for reference.

Please let us know if we have to define the queryspec differently in CTI configuration event handler.

Symptoms

 error: error SBL-DAT-00487: Current search specification is too complex to be refined.

Changes

 none

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