MDM Operational Dashboard Zones Return Server Error
(Doc ID 2771547.1)
Last updated on APRIL 26, 2021
Applies to:Oracle Utilities Meter Data Management - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 2.3]
Information in this document applies to any platform.
On : 126.96.36.199.0 version, Environment
MDM Operational Dashboard Zones return Server Error
When the MDM Operational Dashboard Portal is viewed, 2 zones (Incomplete IMDs by Status & Incomplete IMDs Trend) are returning the following error:
"The server has encountered a problem. Please contact your system administrator."
The cause of the errors on the two Zones are because the Snapshot Details of the Statistics Snapshot for the Incomplete IMDs have rows that do not have descriptions.
Suspect that due to this, the UI Map is not being rendered properly. The code that captures the Statistics Snapshot includes the following query that is causing this:
select trunc(IMDC.CRE_DTTM) as "DATE",
IMDC.BO_STATUS_CD as "TYPE",
count(IMDC.INIT_MSRMT_DATA_ID) as "CNT",
where /*BUS_OBJ_CD = IMDC.BUS_OBJ_CD
and */BO_STATUS_CD = IMDC.BO_STATUS_CD
and LANGUAGE_CD = :LANGUAGE
and rownum = 1) as "DESCR"
from D1_IMD_CTRL IMDC
/* IMDC.CRE_DTTM > trunc(.EndDate) - .TrendDays */
where IMDC.CRE_DTTM between trunc(:EndDate) - :TrendDays and trunc(:EndDate) + 1
group by trunc(IMDC.CRE_DTTM), IMDC.BO_STATUS_CD
order by "DATE" asc, "CNT" desc
Running this in SQL Developer returns no descriptions for some of the records
It looks like this is happening because the part of the SQL that retrieves the description is not filtering by the BO Code (it has been commented-out in the base script).
So it is possible to retrieve the description from other BOs that have the same status.
BOs that reference Parent BOs do not have descriptions on their Language Table which is why what’s being retrieved is blank, which we believe is causing the error being returned in the zone.
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