Oracle Error: ORA-01405: Fetched column value is NULL


This is seen in the Threshold Alerting page for http services. This is caused when the Threshold Alerting configuration form is not filled out completely and then saved causing null values to be inserted into the database. This is a bug and needs better validation at the interface level.

To fix this error remove the offending row from the subperformance table:

SQL> select * from subperformance where subid=1971 and servicecnt=165;

     SUBID SERVICECNT     WINDOW    WARNING      ALERT WARNINGFLAG  ALERTFLAG
---------- ---------- ---------- ---------- ---------- ----------- ----------
WARNINGLIST
--------------------------------------------------------------------------------
ALERTLIST
--------------------------------------------------------------------------------
      1971        165          5       2000       6000           0          0

kurt.sowers@dtn.com


SQL> delete from subperformance where subid=1971 and servicecnt=165;

1 row deleted.

SQL> commit;

Commit complete.

ORA-01405 (last edited 2008-01-18 17:20:44 by Eric)