Abnormal Devices Report Shows Error On OAS 5.9 (Doc ID 2921597.1)

Last updated on JANUARY 27, 2023

Applies to:

Goal

On: 2.8.0.0.0 version, Customer Analytics

Abnormal Devices report shows an error on OAS 5.9

Getting an error while opening the Abnormal Devices report under "Switching Dashboard"

 Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 14020. [nQSError: 14020] None of the fact tables are compatible with the query request CF_ABNORMAL_DEVICE_LOG.DEACT_DTTM. (HY000)
State: HY000. Code: 14081. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: CD_ALARM_LOG.CURR_STATE, CD_ALARM_LOG.DESCR, CD_ALARM_LOG.DEVICE_ATTRIBUTE_DESCR, CD_ALARM_LOG.NOMINAL_STATE, CD_ALARM_LOG.PHASE, CD_ALARM_LOG.SOURCE, CD_CTRL_ZONE.CTRL_ZONE_NAME, CD_DEVICE.CLS_IDX, CD_DEVICE.DEVICE_NAME, CF_ABNORMAL_DEVICE_LOG.ABNORMAL_DTTM, CF_ABNORMAL_DEVICE_LOG.DEACT_DTTM (HY000)
SQL Issued: SELECT 0 s_0, "NMS - Abnormal Device Log"."CD_ALARM_LOG"."CURR_STATE" s_1, "NMS - Abnormal Device Log"."CD_ALARM_LOG"."DESCR" s_2, "NMS - Abnormal Device Log"."CD_ALARM_LOG"."DEVICE_ATTRIBUTE_DESCR" s_3, "NMS - Abnormal Device Log"."CD_ALARM_LOG"."NOMINAL_STATE" s_4, "NMS - Abnormal Device Log"."CD_ALARM_LOG"."PHASE" s_5, "NMS - Abnormal Device Log"."CD_ALARM_LOG"."SOURCE" s_6, "NMS - Abnormal Device Log"."CD_CTRL_ZONE"."CTRL_ZONE_NAME" s_7, "NMS - Abnormal Device Log"."CD_DEVICE"."CLS_IDX" s_8, "NMS - Abnormal Device Log"."CD_DEVICE"."DEVICE_NAME" s_9, "NMS - Abnormal Device Log"."CF_ABNORMAL_DEVICE_LOG"."ABNORMAL_DTTM" s_10, "NMS - Abnormal Device Log"."CF_ABNORMAL_DEVICE_LOG"."DEACT_DTTM" s_11, "NMS - Abnormal Device Log"."CF_ABNORMAL_DEVICE_LOG"."FACT_CNT" s_12, REPORT_SUM("NMS - Abnormal Device Log"."CF_ABNORMAL_DEVICE_LOG"."FACT_CNT" BY "NMS - Abnormal Device Log"."CD_DEVICE"."CLS_IDX") s_13 FROM "NMS - Abnormal Device Log" WHERE (("CF_ABNORMA
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.