SfdcSqlException: ORA-00920: invalid relational operator

This error is most likely coming from a corrupted formula field

Mar 24, 2021

Knowledge

Answer: "System.UnexpectedException: common.exception.SfdcSqlException: ORA-00920: invalid relational operator"

Gets thrown when a rollup that has a bad formula checkbox field as the source is referenced. Will throw a red error when saving records like this:

Error: Invalid Data.
Review all error messages below to correct your data.
Apex trigger rhx.RHX_Case caused an unexpected exception, contact your administrator: rhx.RHX_Case: execution of AfterUpdate caused by: System.UnexpectedException: common.exception.SfdcSqlException: ORA-00920: invalid relational operator : Class.rh2.AggregateFunctionHelper.queryForChildRecords: line 649, column 1

Here is a Salesforce article about the error:
https://success.salesforce.com/issues_view?id=a1p3A0000001BuEQAU&title=a-formula-field-with-a-result-of-null-causes-soql-retreival-to-fail

This error will happen when a formula checkbox returns a value other than False or True.

No queries will work on that object till that formula checkbox field's logic is fixed so that it always returns either FALSE or TRUE.

URL Name: SfdcSqlException-ORA-00920-invalid-relational-operator-1578080051636