Error Occurs When Running A Workbook In Discoverer 11.1.1.6 Or Earlier "ORA-00920 Invalid Relational Operator" Error Or "ORA-00936 Missing Expression"
(Doc ID 1146155.1)
Last updated on FEBRUARY 18, 2019
Applies to:
Oracle Discoverer - Version 11.1.1.1.0 to 11.1.1.6.0 [Release 11g]Information in this document applies to any platform.
***Checked for relevance on 29-Sep-2016***
Symptoms
Running a workbook in Discoverer Plus or Viewer 11.1.1.6, or earlier, results in an ORA-00920 and/or ORA-00936 error.
Running the same workbook in Discoverer Desktop client 10.1.2.X is fine.
Error Message:
You may encounter the following error for upgraded workbooks from an earlier version:
You may have also noticed that the query generated by Discoverer has something similar to the following in the where condition, which seems to be causing the problem:
AND (SYSDATE BETWEEN (o221437.EFFECTIVE_START_DATE)(+) AND (o221437.EFFECTIVE_END_DATE)(+))
Or you may see incorrect SQL in the log file when viewed in Oracle Application Server/Enterprise Manager (EM) Console:
WHERE o106789.month + 0 = o118113.month + 0
The problem is typically occurring on workbooks that use dates in a condition (where) clause.
Changes
You may have recently upgraded Discoverer 10g to the 11g version.
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 |
| If you are using Discoverer 11.1.1.2 or lower, you must first upgrade to 11.1.1.3. |
| If you are using Discoverer 11.1.1.4 or 11.1.1.6: |
| References |