Error Running Data Quality Manager - ORA-00920: invalid relational operator

(Doc ID 2052142.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Universal Customer Master - Version 8.1.1.11 [IP2013] and later
Siebel System Software - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.

Symptoms

SIEBEL VERSION:
Siebel version : 8.1.1.11
Database version :
OS version : RHE 6

ISSUE STATEMENT:
Customer is running incremental Data Quality Manager (DQMgr) job with below parameters :-

Buscomp Name=Account
Business Object Name=Account
Data Quality Setting="'','NO',''"
Object Where Clause="[Name] LIKE 'CUK*'"
Operation Type=DeDuplication

The DQMgr*.log contains following error :-

[0] An error has occurred executing a Sql statement.

Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00105) (0x760069))
GenericLog GenericError 1 000000de55c15f23:0 2015-08-05 07:25:00 Object manager error: ([1] ORA-00920: invalid relational operator
 (0x76006b))
GenericLog GenericError 1 000000de55c15f23:0 2015-08-05 07:25:00 ( (0) err=2818155 sys=7733355) SBL-OMS-00107: Object manager error: ([1] ORA-00920: invalid relational operator
 (0x76006b))
GenericLog GenericError 1 000000de55c15f23:0 2015-08-05 07:25:00 ( (0) err=2818155 sys=7733353) SBL-OMS-00107: Object manager error: ([0] An error has occurred executing a Sql statement.

Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00105) (0x760069))"

When a full DQMgr job is run, without Object Where Clause, it works as expected :-

Buscomp Name=Account
Business Object Name=Account
Data Quality Setting="'','YES','dedupe'"
Operation Type=DeDuplication

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