FPSBASE.CFG_KNOWN_ERRORS

Data Dictionary

FPSBASE Tables

> FPSBASE.CFG_KNOWN_ERRORS

Table FPSBASE.CFG_KNOWN_ERRORS"

This table allows members of the DWH team to properly inform everyone on the site team about known DWH errors. As soon as anyone on the DWH team starts to investigate an error they should insert a record in this table with stop_alert_until_inst blank. This will add their name and the note to the SYSMNTR email so that everyone knows it is being investigated. Once they fix the error then they should delete this record. Of course it will be stored in the CHGLOG table for historical tracking purposes. If for some reason the error cannot be fixed right away -- for example an MES change is required -- they should populate stop_alert_until_inst which will remove errors on this object from our SYSMNTR email. The errors will still be in the SYSMNTR_ERRORS view. If the errors persists past the stop_alert_until_inst then we will start emailing again. Finally if the object is no longer failing but is still in this table then we will include a message in SYSMNTR_ERRORS that the record should be removed (but we will not email about this).

Schema: FPSBASE
Tablespace: FPSDATA
Primary key: OBJECT_NAME

Column	Type	Nullable	Comment
OBJECT_NAME	VARCHAR2(30)	N	This could be an object name (we will disable loading of that object in the scheduled jobs), a load job (we will disable loading of all objects in that scheduled job), an FPSAPP prefix (we will disable loading of all objects with that prefix), a constraint (we can explain why it is permanently disabled), or a trigger (technically an object so we can get away with omitting this from the column name and also to explain why it is permanently disabled). (* from FPSADMIN.CFG_DISABLED)
INVESTIGATED_BY	VARCHAR2(64)		Name of person who is investigating or did investigate this error.
INVESTIGATED_ON	DATE		Datetime when this error was last investigated.
INVESTIGATION_NOTE	VARCHAR2(512)	N	This is optional if the error is under investigation and stop_alert_until_inst is null. It is required if we are not alerting about this error.