Hi everyone,
We’re currently experiencing an issue in Oracle BI (OBIEE/OAS) where reports that were previously working are now either spinning indefinitely or returning an error only when filters are applied.
🔍 Issue Summary:
- When we run the report without filters, it returns all data and loads successfully.
- As soon as we apply a filter (e.g., filter by
Interaction Type = 'Complaint' or Receipt_Date = CURRENT_DATE), the report:- Spins for a long time
- csharpCopyEditError Codes: OPR4ONWY:U9IM8TAC:...[nQSError: 10058] A general error has occurred.[nQSError: 46066] Operation cancelled.[nQSError: 43113] Message returned from OBIS.
- The same filter logic runs fine in direct SQL on the database and returns just a few rows.
- The report was working fine on Monday (April 7). The issue started on Tuesday (April 8).
🧪 What We’ve Tried:
- Cleared OBIEE presentation cache
- Tested with different filters and reports (issue affects many dashboards)
- Restored older RPD versions, including backups from January — no change
- Confirmed with IT that there are no server-side performance issues
- Opened a support ticket with Oracle, currently under review
Would appreciate any insights from others who may have faced similar issues — especially around filter-related query expansion or performance regressions.
|
|---|
| View Display Error |
| Error during query processing (SQLExecDirectW). Error Details Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 46066. [nQSError: 46066] Operation cancelled. (HY000) State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000) SQL Issued: SELECT 0 s_0, "Interaction_SQL"."INTERACTION_TOPIC_SUBTOPIC"."City" s_1, "Interaction_SQL"."INTERACTION_TOPIC_SUBTOPIC"."First_Name" s_2, "Interaction_SQL"."INTERACTION_TOPIC_SUBTOPIC"."Interaction Number" s_3, "Interaction_SQL"."INTERACTION_TOPIC_SUBTOPIC"."Last_Name" s_4, "Interaction_SQL"."INTERACTION_TOPIC_SUBTOPIC"."MAIN SUB TOPIC" s_5, "Interaction_SQL"."INTERACTION_TOPIC_SUBTOPIC"."MAIN TOPIC" s_6, "Interaction_SQL"."INTERACTION_TOPIC_SUBTOPIC"."MAINCLASSIFICATION" s_7, "Interaction_SQL"."INTERACTION_TOPIC_SUBTOPIC"."Receipt_Date" s_8 FROM "Interaction_SQL" WHERE (("INTERACTION_TOPIC_SUBTOPIC"."MAINCLASSIFICATION" = 'Ontario Energy Board') AND ("INTERACTION_TOPIC_SUBTOPIC"."MAIN TOPIC" = 'OESP') AND ("INTERACTION_TOPIC_SUBTOPIC"."Receipt_Date" = current_date )) FETCH FIRST 500001 ROWS ONLY |
