OUA Errors For Subject Area CCB - Case
(Doc ID 2139150.1)
Last updated on FEBRUARY 26, 2019
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 2.5]
Information in this document applies to any platform.
**Disclaimer:** This KM article may include the following abbreviations:
CCB - Oracle Utilities Customer Care and Billing
OUA - Oracle Utilities Analytics
OBIEE - Oracle Business Intelligence Enterprise Edition
When creating new Analysis from Subject Area CCB - Case (choose Cases, Opened, Case Id from Case Fact and Case Status from Case Type Status Dimension), the following error occurs:
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14020] None of the fact tables are compatible with the query request CF_CASE.SRC_CASE_ID. (HY000)
SQL Issued: SELECT 0 s_0, "CCB - Case"."CD_CASETYPE_STATUS"."CASE_STATUS_DESCR" s_1, "CCB - Case"."CF_CASE"."SRC_CASE_ID" s_2, "CCB - Case"."CF_CASE"."FACT_CNT" s_3, "CCB - Case"."CF_CASE"."NBR_OPEN" s_4 FROM "CCB - Case" FETCH FIRST 65001 ROWS ONLY
How can this be resolved?
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