Troubleshooting
Problem
An alert function that uses calculated metrics as input variables generates alerts for a single entity only.
Resolving The Problem
Add an entity_id column as a unique constraint to table "DM_WIOT_AS_ALERT".
Complete these steps:
- Find the IBM® Maximo® Monitor database connection parameters. For instructions, see Accessing data.
- Connect to the database by using the connection parameters and instructions in Accessing data.
- Run the following SQL statement:
ALTER TABLE BLUADMIN.DM_WIOT_AS_ALERT ADD CONSTRAINT DM_WIOT_AS_ALERT_PK PRIMARY KEY (ENTITY_TYPE_ID,ENTITY_ID,DATA_ITEM_NAME, "TIMESTAMP")
Document Location
Worldwide
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m0z000000cwZDAAY","label":"Maximo Application Suite"},{"code":"a8m0z000000cx3cAAA","label":"Maximo Monitor"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.3.0"}]
Was this topic helpful?
Document Information
Modified date:
02 February 2021
UID
ibm16410466